JP2013037490A - Information processor, data acquisition method, data acquisition program, and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information processor for easily acquiring necessary data without increasing loads on a database of a production environment.SOLUTION: The information processor for moving data stored to a first database to a second database, includes: a storage part for storing an inter-table dependency table for associating an original table including original data to be moved with an associated table, and a dependency table between table columns for associating the original table with associated data included in the associated table or key information; an input reception part for receiving input of key information; a data acquisition part for acquiring data of the original table from the first database on the basis of the key information; and an associated data acquisition part for identifying a corresponding associated table on the basis of the original table and acquiring associated data on the basis of the associated table and the original table; and a data insertion part for inserting data of the original table and the associated data in the second database.

Description

  The present invention relates to an information processing apparatus capable of acquiring data stored in a database, a data acquisition method, a data acquisition program, and a recording medium.

  Generally, when investigating production data in response to a request from a customer, or when reproducing an accident event that occurred in the production environment of a system in a test environment, simulated environment, or inspection environment, In many cases, it is necessary to acquire various data for investigation and move the acquired data to a test environment, a pseudo environment, or an inspection environment. Conventional methods include, for example, taking a backup of a database in a production environment and restoring it, using a utility that exports and imports a database in a production environment, or obtaining data using a query tool. There are ways to do it. Further, as disclosed in Patent Document 1, there is a method of extracting and processing necessary data from a database using an ETL (Extract Transform Load) tool.

Special table 2009-509271 gazette

  With the above-described conventional technology, it is possible to perform processing of acquiring and inserting data to be investigated from a database in a production environment. However, in the method of acquiring a backup of the database and then restoring it, a heavy load is applied to the system in the production environment, and data other than the data to be extracted is also acquired. For example, in the export / import utility, as with backup restoration, a large load is applied to the database, and data other than the data to be retrieved is acquired, and the database is unnecessarily burdened. In the query tool, since the user creates a SQL (Structured Query Language) statement by himself, it is necessary to use the table after understanding the structure of the table, and the necessary data cannot be easily acquired. Further, in the technique disclosed in the above-described patent document, necessary data is extracted from the database in the production environment and processed, so that many accesses to the database occur and a load is imposed on the database.

  The present invention has been made in view of the above, and an information processing apparatus, a data acquisition method, and a data acquisition that can easily acquire necessary data without increasing a load on a database in a production environment It is an object to provide a program and a recording medium.

  In order to achieve the above-described object, an information processing apparatus according to the present invention performs information processing for performing processing for moving data stored in a first database to a second database different from the first database. A table, an inter-table dependency relation table in which an original table including original data to be moved is associated with a related table related to the original table, and related data included in the original table and the related table, or A storage unit that stores a table-column dependency relation table that associates key information for moving data stored in the first database; an input reception unit that receives input of the key information; and Based on the key information received by the input receiving unit and the key information included in the inter-table dependency relation table, the input receiving unit has received A data acquisition unit for acquiring data of the original table directly related to information from the first database, the original table acquired by the data acquisition unit, and an original table stored in the inter-table dependency relationship table; Based on the table, the related table corresponding to the original table is identified, and the table-column dependency relationship table is determined based on the identified related table and the original table having the data acquired by the data acquisition unit. The related data acquisition unit for acquiring the related data included in the data, the data of the original table acquired by the data acquisition unit, and the related data acquired by the related data acquisition unit are inserted into the second database And a data insertion unit.

  The present invention also provides a data acquisition method, a data acquisition program, and a recording medium performed by the information processing apparatus.

  According to the present invention, it is possible to provide an information processing apparatus, a data acquisition method, a data acquisition program, and a recording medium that can easily acquire necessary data without increasing the load on a production environment database. Can do.

It is a figure which shows the outline | summary of a process of the data acquisition method which the information processing apparatus in this Embodiment performs. It is a figure which shows the example of a functional structure of information processing apparatus. It is a figure which shows the specific example of a dependency table between tables. It is a figure which shows the specific example of the dependency table between table columns. It is a flowchart which shows the process sequence of the data acquisition process performed with information processing apparatus. It is a flowchart which shows the process sequence of the data acquisition process performed with information processing apparatus. It is a flowchart which shows the process sequence of the data acquisition process performed with information processing apparatus. It is a conceptual diagram until it acquires the data of the related table after key information is input.

  Exemplary embodiments of an information processing apparatus, a data acquisition method, a data acquisition program, and a recording medium according to the present invention will be described below in detail with reference to the accompanying drawings.

  FIG. 1A is a diagram illustrating an outline of processing of a data acquisition method performed by the information processing apparatus 100 according to the present embodiment. As shown in FIG. 1, when input key information 1 to input key information n, which are data to be acquired from the production environment database, are input, the information processing apparatus 100 determines in advance using the input key information as a key. An SQL (Structured Query Language) statement for acquiring data having input key information from the production environment database is generated by referring to the inter-table dependency relationship table and the inter-table column dependency relationship table (both described later).

  Then, the information processing apparatus 100 executes the SQL statement after checking whether or not the generated SQL statement is duplicated, and acquires the data of the table having the input key information stored in the production environment database, An SQL statement for inserting the acquired data into a database in an environment different from the production environment such as a test environment database, a pseudo environment database, or an inspection environment database is generated and executed. By performing such a process, only necessary data related to the input key information can be acquired. In addition, input key information is various information which comprises personal information, such as a name, an address, age, sex, etc., when the data used as acquisition object are data relevant to personal information, for example.

  The information processing apparatus 100 is, for example, a server or a PC (Personal Computer). FIG. 1B is a diagram illustrating an example of a functional configuration of the information processing apparatus 100. As illustrated in FIG. 1B, the information processing apparatus 100 functionally includes a storage unit 101, a data acquisition unit 102, a related data acquisition unit 103, a data insertion unit 104, and an input reception unit 105. It is configured. The information processing apparatus 100 is connected to a production environment database, a test environment database, a pseudo environment database, an inspection environment database, or the like through a network such as a LAN (Local Area Network) or a WAN (Wide Area Network). It shall be.

  The storage unit 101 is a storage device such as an HDD (Hard Disk Drive), for example, and stores an inter-table dependency relationship table and an inter-table dependency relationship table.

  FIG. 2 is a diagram illustrating a specific example of the inter-table dependency relationship table. As shown in FIG. 2, the inter-table dependency relationship table stores a table (original table) having input key information and a table (related table) related to the original table in association with each other. In FIG. 2, for example, the original table “A” has no association table with other tables, indicating that it does not have an association table. Further, the original table “B” indicates that there is a relationship with the other tables “H”, “I”, “J”, “K”, and “L”. Here, the relationship between tables is that, for example, when another table has the same items as the items that a certain table has, the other tables are related to a certain table. In addition, if a table has a value derived from a given formula as an item in another table, these tables are also related. It shall be. Such relationships between the tables are registered in advance in the inter-table dependency relationship table shown in FIG.

  As will be described later, for example, when the table acquired from the input key information includes the table “A” and the table “B”, the related data acquisition unit 103 sets the table “A” and the table “B”. In order to obtain the table information related to the table, the column of the related table 1 related to the table is referred to, and since there is no value, it is determined that there is no related table. Next, the related data acquisition unit 103 refers to the column of the related table 1 related to the table “B”, and since the table “H” is registered, the related data acquisition unit 103 holds the table name “H” as the related table. Further, similarly, the related data acquisition unit 103 refers to the column of the related table 2 and stores the table name “I” because the table “I” is registered. As described above, the related data acquisition unit 103 refers to the dependency table between tables and holds information on the table name.

  FIG. 3 is a diagram showing a specific example of the inter-table column dependency relationship table. As shown in FIG. 3, the inter-table column dependency relationship table includes a certain table (current table), items that the current table has (current table items), a table that is referenced by the current table (reference table), Items stored in the reference table (reference table items) are stored in association with each other. In FIG. 3, for example, among the current table items of the current table “H”, the first column item (col1) is the second column item (col2) of the reference table “B”. Indicates that the value is set. Also, among the original table items of the original table “A”, the first column item (col1) has no preset reference table and reference table item, and the input key received by the input receiving unit 105. Information 1 is set as a reference table item. In this way, the relationship between the table columns is registered in advance in the inter-table column dependency table shown in FIG. Next, returning to FIG. 1B, the data acquisition unit 102 will be described.

  As will be described later, for example, the data acquisition unit 102 indicates that the second column (col2) of the table “B” refers to the first column (col1) of the table “H”. Using this information, the data acquisition unit 102 can extract data further related to the data obtained from the input key information. When the table to be referred to is “Null”, it indicates that the table is not referenced from any column of the table. By using the inter-table dependency relationship table shown in FIG. 2 and the inter-column dependency relationship table shown in FIG. 3, it is possible to acquire data related to the input key information.

  The data acquisition unit 102 generates an SQL statement for acquiring data from a table of the production environment database based on input key information (for example, input key information 1 to input key information n) received by the input reception unit 105 described later. Create and execute. The data acquisition unit 102 refers to a table that can be directly accessed from the input key information, and extracts data specified by the input key information. Specific processing performed by the data acquisition unit 102 will be described later using a flowchart.

  The related data acquisition unit 103 acquires related data from a table that is related to the table having the data extracted by the data acquisition unit 102. The related data acquisition unit 103 adds an SQL statement for acquiring data from a related table to the SQL statement created by the data acquisition unit 102, and executes the SQL statement again. Specific processing performed by the related data acquisition unit 103 will be described later with reference to a flowchart.

  The data insertion unit 104 inserts data into a test environment database, a pseudo environment database, a test environment database, or the like using the SQL statement created by the data acquisition unit 102 and the related data acquisition unit 103. The data insertion unit 104 uses the SQL statements created by the data acquisition unit 102 and the related data acquisition unit 103 to generate and execute an SQL statement for insertion so that the data acquisition unit 102 and the related data acquisition unit 103 The acquired data is inserted into a test environment database, a pseudo environment database, or an inspection environment database. Specific processing performed by the data insertion unit 104 will be described later with reference to a flowchart.

  The input reception unit 105 is an input device such as a keyboard or a mouse, for example, and receives input of the above-described input key information.

  Each unit included in the information processing apparatus 100 is executed by a program for realizing the functions of the data acquisition unit 102, the related data acquisition unit 103, and the data insertion unit 104. These programs have, for example, a module configuration including the above-described units. As actual hardware, a control unit such as a CPU reads out and executes these programs from a recording device such as an HDD, Each unit is loaded on the main storage device, and the data acquisition unit 102, the related data acquisition unit 103, and the data insertion unit 104 are generated on the main storage device.

  The above-mentioned program is recorded in a computer-readable recording medium such as a CD-ROM, a flexible disk (FD), a CD-R, and a DVD (Digital Versatile Disc) as a file in an installable or executable format. Can also be provided. Furthermore, these programs may be configured to be provided or distributed by being downloaded via a network. Next, a process (data acquisition process) from the input key information performed by the information processing apparatus 100 to the acquisition and insertion of related data will be described.

  4A to 4C are flowcharts illustrating a processing procedure of data acquisition processing performed by the information processing apparatus 100. As illustrated in FIG. 4A, in the information processing apparatus 100, first, when the input reception unit 105 receives input of input key information (step S401), the data acquisition unit 102 displays the inter-table-column dependency relationship table illustrated in FIG. The processing for extracting data from the data whose reference table is “null”, that is, the table directly accessible from the key information (steps S402 to S411).

  Specifically, the data acquisition unit 102 groups the original table of the inter-column dependency table shown in FIG. 3 as a key (step S402), and acquires the total number of records in the grouped current table (step S402). S403). In the example illustrated in FIG. 3, the data acquisition unit 102 groups the total 19 original tables from the current table A to S.

  Then, the data acquisition unit 102 defines an integer M for counting the number of rows in the grouped current table as “M = 1” (step S404), and the value of the integer M is the value of the record acquired in step S403. It is determined whether or not it is greater than the total number, that is, whether or not the subsequent processing has been completed for all grouped current tables (step S405). For example, in FIG. 3, since the total number of tables from the current table A to S is 19, the data acquisition unit 102 increments the integer M described above until the processing for all these current tables is completed. The processes from step S406 to S411 are repeated.

  If the data acquisition unit 102 determines that the value of the integer M is not larger than the total number of records acquired in step S403 (step S405; No), the data acquisition unit 102 acquires the table name of the Mth row from the grouped table (step S405). S406). Then, the data acquisition unit 102 refers to the inter-column dependency relation table shown in FIG. 3, and the table name of the Mth row acquired in step S406 and the reference table corresponding to the table name is “null”. A record is acquired (step S407).

  In the example shown in FIG. 3, when the integer M = 1, the current table is “A”, and the reference table corresponding to the current table “A” is “null”. To get. When the integer M = 8, the current table is “H”, and the reference table corresponding to the current table “H” is “B”. Therefore, the data acquisition unit 102 does not acquire the record and The process will proceed. Thus, in step S407, the data acquisition unit 102 directly relates to the input key information when the reference table corresponding to the current table is “null”, that is, there is no reference table related to the current table. A record including the current table is obtained from the inter-column dependency table shown in FIG.

  Thereafter, the data acquisition unit 102 determines whether or not there is a record acquired in step S407 (step S408). If it is determined that there is a record acquired in step S407 (step S408; Yes), the data acquisition unit 102 includes the record acquired in step S407. Using the input key information to be generated as a key, an SQL sentence for acquiring data from the original table is generated (step S409).

  For example, in FIG. 3, when the record acquired in step S407 is a record including the original table “A”, the data acquisition unit 102 acquires data from the original table “A” using the input key information 1 as a key. Generate an SQL statement. In the following description, it is assumed that all data of the original table “A” is acquired using the input key information 1 as a key. For example, data of the current table item corresponding to the original table “A” (for example, , Col1) may be generated as an SQL statement.

  And the data acquisition part 102 writes the produced | generated SQL sentence in a batch file (step S410), adds 1 to the value of the integer M (step S411), returns to step S405, and performs subsequent processing (steps S406-S411). ) Repeatedly. In step S408, when the data acquisition unit 102 determines that there is no record acquired in step S407 (step S408; No), the data acquisition unit 102 proceeds to step S411 without doing anything.

  If the data acquisition unit 102 determines in step S405 that the value of the integer M is greater than the total number of records acquired in step S403, that is, determines that the subsequent processing has been completed for all grouped original tables. In the case (step S405; Yes), the value of the integer M is reset to “1” (step S412). When the process in step S412 is completed, the process for extracting data from the directly accessible table from the input key information is completed.

  Subsequently, as in the case of step S406, the related data acquisition unit 103 acquires the table name of the Mth row from the grouped table (step S413). The processing from step S413 to S426 is processing for acquiring data from a table related to the original table. For example, immediately after being reset to integer M = 1 in step S <b> 412, the related data acquisition unit 103 acquires the table name “A”.

  The related data acquisition unit 103 determines whether there is a table name acquired in step S413 with reference to the inter-table dependency relationship table shown in FIG. 2 (step S414), and there is the table name acquired in step S413. (Step S414; Yes), the integer N for counting the number of columns in the inter-table dependency relationship table shown in FIG. 2 is defined as N = 2 (that is, the column of the related table 1) (step S415). .

  Then, the related data acquisition unit 103 accesses the inter-table dependency relationship table shown in FIG. 2, refers to the row including the table name of the original table acquired in step S413, and acquires the table name of the Nth column. (Step S416). In FIG. 2, for example, when the table name acquired in step S413 is “B” (that is, integer M = 2), the related data acquisition unit 103 refers to the row including the table name “B” of the original table. The table name “H” of the column of the related table 1 which is the second column is acquired.

  The related data acquisition unit 103 determines whether there is a table name acquired in step S416 (step S417), and determines that there is no table name acquired in step S416 (step S417; No), the integer M 1 is added to the value (step S418), the process returns to step S413, and the subsequent processing is repeated. In the example illustrated in FIG. 2, when the related data acquisition unit 103 refers to the row including the table name “A” of the original table, the related data acquisition unit 103 attempts to acquire the table name of the column of the related table 1 that is the second column. Since the table related to the original table “A” is not registered, 1 is added to the value of the integer M = 1 to set M = 2, the process returns to step S413, and the subsequent processing is repeated.

  On the other hand, if the related data acquisition unit 103 determines that there is a table name acquired in step S416 (step S417; Yes), the batch phrase written in step S410 is referred to, and the FROM phrase is the table name acquired in step S413. The SQL statement (for example, table name “B”) is acquired (step S419), and the acquired SQL statement is executed (step S420).

  Then, the related data acquisition unit 103 accesses the inter-column dependency relation table shown in FIG. 3, the reference table is the table name acquired in step S413, and the current table is the table name acquired in step S416. A record is acquired (step S421). For example, in FIG. 3, if the table name acquired in step S413 is “B” and the table name acquired in step S416 is “H”, the table column dependency table shown in FIG. A record corresponding to the 12th line is acquired.

  The related data acquisition unit 103 acquires column information described in the reference table item from the records acquired in step S421 (step S422). In the example illustrated in FIG. 3, the related data acquisition unit 103 acquires the column information “col2” of the reference table item included in the record of the 12th row in the inter-column dependency relationship table.

  And the related data acquisition part 103 acquires only the data of the column acquired by step S422 among the acquired tables as a result of the SQL sentence performed by step S420 (step S423). For example, when the table acquired in step S420 is “B”, the related data acquisition unit 103 acquires data in the column of the reference table item “col2”.

  The related data acquisition unit 103 generates an SQL statement for acquiring the data acquired in step S423 (step S424), and writes the generated SQL statement in the batch file created by the data acquisition unit 102 in step S410 (step S424). S425). For example, when the table acquired in step S420 is “B”, the related data acquisition unit 103 generates an SQL statement for acquiring the data of the column of the reference table item “col2”, and stores it in the batch file described above. Write the SQL statement.

  Thereafter, the related data acquisition unit 103 adds 1 to the integer M (step S426), returns to step S416, and repeats the subsequent processing. In step S414, there is no table name acquired in step S413, that is, all tables. When it is determined that the processing has been completed for the name (step S414; No), the data insertion unit 104 checks whether the SQL sentence written in the batch file generated so far is described in duplicate (step S41). S427).

  If it is determined that there is a duplicate SQL sentence (step S427; Yes), the data insertion unit 104 deletes the duplicate SQL sentence from the SQL sentence (step S428). On the other hand, if the data insertion unit 104 determines that there is no duplicate SQL sentence (step S427; No), the data insertion unit 104 proceeds to the next processing without doing anything.

  Then, the data insertion unit 104 generates an SQL statement for executing each SQL statement after checking for the presence or absence of the duplicate SQL statement (step S429), and generates a test environment database, a pseudo environment database, or an inspection environment database. The data is inserted into the data etc. (step S430). When the process of step S430 ends, all the data acquisition processes shown in FIGS.

  And by performing each process mentioned above, not only the data relevant to input key information but the data relevant to the input key information can be acquired. FIG. 5 is a conceptual diagram from the input of key information to the acquisition of related table data. As shown in FIG. 5, for example, in the processing from step S <b> 401 to S <b> 430 shown in FIG. 4, the original table data including the input key information 1 to the input key information 6 using the input key information 1 to the input key information 6 as keys. Is generated, and an SQL statement for acquiring data related to the input key information is generated from the tables “A” to “G”. Thereafter, an SQL statement for acquiring data from the table “H” to the table “L” related to the table “B” is generated. Next, similarly, an SQL statement for acquiring the data of the table “P” from the table “M” related to the table “C” is generated, and further, the table “Q” related to the table “K” is generated. SQL statements for acquiring the data of the table “S” are generated. In this way, data related to the input key information can be acquired.

  As described above, in the information processing apparatus 100 that performs processing for moving the data stored in the production environment database to a test environment database, a pseudo environment database, or an inspection environment database different from the production environment database, the storage unit 101 includes: , An inter-table dependency related table in which an original table including original data to be moved and a related table related to the original table are associated, and related data or production environment database included in the original table (current table) and the related table And the inter-table dependency relation table associated with the key information for moving the data stored in the table, the input reception unit 105 receives the input of the key information, and the data acquisition unit 102 receives the input Key information received by the unit 105 and keys included in the inter-table column dependency relationship table Based on the information, the data of the original table directly related to the key information received by the input receiving unit 105 is acquired from the production environment database, and the related data acquiring unit 103 acquires the original table and the table acquired by the data acquiring unit 102 Based on the original table stored in the inter-dependency relationship table, the related table corresponding to the original table is identified, and based on the identified related table and the original table having the data acquired by the data acquisition unit 102, The related data included in the inter-column dependency table is acquired, and the data insertion unit 104 determines the original environment data acquired by the data acquisition unit 102 and the related data acquired by the related data acquisition unit 103 as the production environment database. Is inserted into a different test environment database, simulated environment database, inspection environment database, etc. Without increasing the load on the database of the production, it is possible to obtain easily the necessary data. Specifically, it is possible to minimize the load on the production environment and move to a database different from the production environment.

  Further, in advance what the table dependency relationship table between table that defines whether the reference to which table, depending association table between table columns that define whether the reference to the columns of which table columns in which tables Create a SQL statement that acquires the relevant data for each table from the information of these tables and the given key information, and execute to collect the relevant data at once, and acquire the data for each table Since the SQL statement is used, it is possible to minimize the load on the database without performing complicated table join processing, and to move necessary data at once without increasing the load on the database. Is possible.

  It should be noted that the present invention is not limited to the above-described embodiment as it is, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage. For example, when the number of input key information and related tables is large and the processing load is large, all the components shown in the embodiment, such as physically dividing a plurality of functions of the information processing apparatus into two or more servers Some of the constituent elements may be changed or the constituent elements may be appropriately combined.

100 Information processing apparatus 101 Storage unit 102 Data acquisition unit 103 Related data acquisition unit 104 Data insertion unit 105 Input reception unit

Claims (9)

An information processing apparatus for performing processing for moving data stored in a first database to a second database different from the first database,
An inter-table dependency relation table in which an original table including original data to be moved is associated with a related table related to the original table, related data included in the original table and the related table, or the first database. A storage unit that stores a table-column dependency relation table that associates key information for moving data stored in the table, and
An input receiving unit for receiving input of the key information;
Based on the key information received by the input receiving unit and the key information included in the inter-table-column dependency relationship table, the data of the original table directly related to the key information received by the input receiving unit is stored in the first table. A data acquisition unit to acquire from the database of
Based on the original table acquired by the data acquisition unit and the original table stored in the inter-table dependency relationship table, the related table corresponding to the original table is specified, the specified related table, Based on the original table having the data acquired by the data acquisition unit, a related data acquisition unit that acquires the related data included in the inter-table column dependency relationship table;
A data insertion unit for inserting the data of the original table acquired by the data acquisition unit and the related data acquired by the related data acquisition unit into the second database;
An information processing apparatus comprising: The inter-table column dependency relationship table further stores the original data included in the original table in association with each other,
The data acquisition unit includes the original table directly related to the key information received by the input receiving unit based on the key information received by the input receiving unit and the key information included in the inter-table column dependency relationship table. Obtaining the original data of the first database;
The information processing apparatus according to claim 1. The data acquisition unit acquires SQL (Structured Query Language) for acquiring the original table data directly related to the key information received by the input reception unit from the first database and inserting it into the second database. Produces
The related data acquisition unit acquires the related data included in the inter-table column dependency relationship table based on the specified related table and the original table having the data acquired by the data acquisition unit. Generating SQL for insertion into the second database;
The information processing apparatus according to claim 1, wherein the information processing apparatus is an information processing apparatus. The data acquisition unit and the related data acquisition unit write and execute the created SQL in a predetermined batch file,
The information processing apparatus according to claim 3. The data acquisition unit and the related data acquisition unit write the same batch file SQL.
The information processing apparatus according to claim 4. The data insertion unit checks whether or not the SQL written in the batch file is duplicated, and then the data of the original table acquired by the data acquisition unit and the data acquired by the related data acquisition unit Inserting relevant data into the second database;
The information processing apparatus according to claim 5. A data acquisition method performed by an information processing apparatus that performs processing for moving data stored in a first database to a second database different from the first database,
An input receiving step for receiving input of key information for moving data stored in the first database;
Move the key information received in the input receiving step, the original table including the original data to be moved, the related data included in the related table related to the original table, or the data stored in the first database Data of the original table directly related to the key information received by the input receiving unit based on the key information included in the inter-table column dependency relationship table in which the key information is associated with the first database. A data acquisition step to acquire from
Based on the original table acquired in the data acquisition step and the original table stored in the inter-table dependency relation table in which the original table and the related table are associated with each other, the related table corresponding to the original table is A related data acquisition step of acquiring the related data included in the inter-table column dependency relationship table based on the specified related table specified and the original table having the data acquired by the data acquisition unit; ,
A data insertion step of inserting the data of the original table acquired in the data acquisition step and the related data acquired in the related data acquisition step into the second database;
The data acquisition method characterized by including. On the computer,
An input receiving step for receiving input of key information for moving data stored in the first database to a second database different from the first database;
Move the key information received in the input receiving step, the original table including the original data to be moved, the related data included in the related table related to the original table, or the data stored in the first database Data of the original table directly related to the key information received by the input receiving unit based on the key information included in the inter-table column dependency relationship table in which the key information is associated with the first database. A data acquisition step to acquire from
Based on the original table acquired in the data acquisition step and the original table stored in the inter-table dependency relation table in which the original table and the related table are associated with each other, the related table corresponding to the original table is A related data acquisition step of acquiring the related data included in the inter-table column dependency relationship table based on the specified related table specified and the original table having the data acquired by the data acquisition unit; ,
A data insertion step of inserting the data of the original table acquired in the data acquisition step and the related data acquired in the related data acquisition step into the second database;
A data acquisition program for executing   A computer-readable recording medium storing the data acquisition program according to claim 8.

Images