JP4326303B2 - Database migration apparatus and program thereof - Google Patents

Description

  The present invention relates to a database migration device that migrates a database between different database management systems, for example.

Conventionally, database migration between different database management systems has been performed as follows. First, one or more data stored in a migration source database (hereinafter referred to as “DB”) is separated by commas, and the data is recorded in a file. For example, there is a so-called CSV format in which data in one record is separated into commas and arranged in one line and recorded in a file. Next, the data recorded in the CSV format is stored in the migration destination DB. Here, the data migrated from the migration source DB to the migration destination DB does not include the data of the table definition information that defines the table structure. Here, “table definition information” is information indicating the attribute value, data type, byte length, and the like of data constituting a field in the case of RDB, for example. The “table definition information” is also called schema information. Next, the user has newly defined the table structure of the database manually on the migration destination DB (see Non-Patent Document 1).
Software Partner Co., Ltd. [Search September 22, 2003] Internet <URL: http: // www. sp-inc. co. jp / product. htm? para = DC>

  Database migration between conventional database management systems (DBMS) requires the above complicated processing, and it is very time-consuming to define a new table structure on the migration destination DBMS. there were. The database migration apparatus and the like of the present invention are made to solve such a problem. Database migration between DBMSs eliminates complicated processing and performs database migration by simple processing such as designating a database to be migrated. In addition, the object of the present invention is to make it possible not to manually define the table structure on the migration destination DBMS.

  The database migration apparatus of the present invention includes a first database structure information acquisition unit that acquires first database structure information that is information related to a database structure of one or more databases defined by the first database management system, and one or more databases. A data group acquisition unit that acquires a data group constituting a record, a database structure definition unit that defines one or more database structures based on the first database structure information, and a data group acquisition unit in the second database management system And a data insertion unit for inserting the data group into the database structure defined by the database structure definition unit.

  With this configuration, the database migration process can be performed easily, and the table structure does not have to be manually defined on the migration destination DBMS. There is no need for manual input for defining such a table structure, and the work time for the process of migrating the database is shortened. Therefore, there is an effect that the work of the DB administrator can be reduced.

  In another database migration apparatus of the present invention, the first database structure information includes index information that is information related to indexes of one or more databases, an index information acquisition unit that acquires index information of one or more databases, and an index An index construction unit for constructing indexes for all or part of the data group inserted by the data insertion unit based on the index information acquired by the information acquisition unit is further provided.

  With this configuration, the index information constructed in the migration source DBMS can be migrated to the migration destination DBMS. Therefore, it is not necessary to construct the index information manually on the migration destination DBMS. There is an effect that it is possible to eliminate the trouble of manual input for the construction, thereby reducing the work of the DB administrator.

  Another database migration apparatus according to the present invention is characterized in that the structure of the index indicated by the index information is different from the structure of the index constructed by the index construction unit.

  With this configuration, even if the structure of the index of the migration source DBMS and that of the migration destination DBMS are different, the index can be constructed based on the index information of the migration source and conforming to the structure specification of the index of the migration destination DBMS. . For example, when the migration source index is a hash structure index and the migration destination index is a Btree structure index, index information is acquired from the migration destination hash structure index, and based on the acquired index information, An index having a Btree structure can be constructed. That is, a DB conforming to the specifications of the migration destination DBMS can be constructed. Further, index information that is not constructed on the migration source DBMS can be constructed on the migration destination DBMS. Therefore, it is not necessary to manually construct index information having a different structure from the index information constructed on the migration source DBMS on the migration destination DBMS. There is no need for such construction, and there is an effect that the work of the DBMS administrator can be reduced.

  Another database migration apparatus of the present invention is first database structure acquisition command information which is information indicating a command for acquiring first database structure information of the first database management system, and information indicating a command for acquiring a data group. Data group acquisition instruction information, second database structure definition instruction information indicating information for defining a database structure in the second database management system, and an instruction for inserting a data group into the database structure defined by the database structure definition unit A database operation information holding unit that holds data group insertion instruction information that is information indicating the first database structure information acquisition unit based on the first database structure acquisition command information; The data group acquisition unit acquires one or more data groups based on the data group acquisition command information. The database structure definition unit defines one or more database structures based on the second database structure definition command information and the first database structure information, and the data insertion unit Based on the group insertion command information, the data group acquired by the data group acquiring unit is inserted into the database structure defined by the database structure defining unit.

  With this configuration, DBs can be migrated between various DBMSs. Therefore, DBs can be migrated between DBMSs without worrying about the data structure, database language, etc. adopted by each DBMS management system.

Another database migration apparatus of the present invention is first database structure acquisition command information which is information indicating a command for acquiring first database structure information of the first database management system, and information indicating a command for acquiring a data group. Data group acquisition instruction information, second database structure definition instruction information indicating information for defining a database structure in the second database management system, and an instruction for inserting a data group into the database structure defined by the database structure definition unit Data group insertion instruction information which is information indicating, index information acquisition instruction information which is information indicating an instruction for acquiring index information of one or more databases, and an index for all or part of the data group inserted by the data insertion unit Index building instruction information that is information indicating the instruction to be built Is further provided with a database operation information holding unit, the first database structure information acquisition unit acquires the first database structure information based on the first database structure acquisition command information, the data group acquisition unit, A data group constituting one or more database records is acquired based on the data group acquisition command information, and the database structure definition unit is configured to acquire one or more databases based on the second database structure definition command information and the first database structure information. Based on the data group insertion instruction information, the data insertion unit inserts the data group acquired by the data group acquisition unit into the database structure defined by the database structure definition unit, and the index information acquisition unit Based on the information acquisition command information, acquire index information of one or more databases, Box construction unit, based on the index built command information and the index information, is characterized in that to construct an index for all or part of the data group data insertion unit is inserted.
With this configuration, DBs can be migrated between various DBMSs. An index can be constructed between various DBMSs.

  According to the database migration apparatus and the like according to the present invention, a database can be automatically migrated between different DBMSs.

  Embodiments of the present invention will be described below in detail with reference to the drawings. Note that in this embodiment, components using the same reference numerals and steps in the flowcharts perform the same function, and thus description of what has been described once may be omitted.

(Embodiment 1)
The following describes how the database migration apparatus automatically migrates a database between different DBMSs in the present embodiment.
FIG. 1 is a block diagram showing the configuration of the database migration apparatus 100 in the present embodiment. The database migration apparatus 100 includes an input reception unit 101, a first database management system 102, a first database structure information acquisition unit 103, a data group acquisition unit 104, a database structure definition unit 105, a data insertion unit 106, and a second database management system 107. Have The first database management system 102 has a first database storage unit 1021. The second database management system 107 includes an instruction execution unit 1071 and a second database storage unit 1072.

  The database migration apparatus 100 includes a CPU, a main memory, a hardware resource such as a recording medium (for example, ROM, EPROM, etc.), and peripheral devices (for example, an input device such as a keyboard and a mouse, a display) Etc.) (not shown). The same applies to other embodiments below.

  The input receiving unit 101 receives an input of an application activation instruction. Further, the input receiving unit 101 receives an input of an instruction to migrate the database. The “instruction to migrate the database” is, for example, an instruction to specify the migration source DBMS and the migration destination DBMS. The input receiving unit 101 can be realized by a device driver of an input unit such as a numeric keypad or a keyboard, control software for an application display screen, or the like. The input means may be anything such as a numeric keypad, a keyboard, a mouse, or an application display screen.

  The first database management system 102 can be realized by including a recording medium storing a database, software for processing the database, and the like. A “database” refers to a file or a set of files that are stored and organized in large quantities so that the computer can easily process them. Examples of the database include a network database, a hierarchical database, an RDB, and an object-oriented database.

  The first database storage unit 1021 stores a database. The first database storage unit 1021 is preferably a non-volatile recording medium, but may be a volatile recording medium.

  The first database structure information acquisition unit 103 acquires first database structure information that is information related to the database structure of one or more databases defined by the first database management system 102. The first database structure information acquisition unit 103 acquires the first database structure information of the database instructed to migrate. “First database structure information” is information such as table definition information, for example. The “table definition information” is, for example, information such as a table name, a field name of a table field, a data type, and a byte length in the case of RDB. There may be a plurality of fields. The first database structure information acquisition unit 103 can be usually realized by an MPU, a memory, or the like. The processing procedure for “acquiring” is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The data group acquisition unit 104 acquires data (data group) constituting all the records of one or more databases. The data group acquisition unit 104 acquires the data group of the database instructed to migrate. When acquiring a data group, the data group acquisition unit 104 may acquire the data in a CSV format in which data is separated by commas, or may acquire the data group in another format (for example, DIF format, SYLK format, etc.). The data group acquisition unit 104 can usually be realized by an MPU, a memory, or the like. The processing procedure for “acquiring” is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The database structure definition unit 105 defines one or more database structures based on the first database structure information in the second database management system 107. “Defining one or more database structures based on the first database structure information” means configuring an instruction for defining a database structure (schema). Details of this processing will be described later. The database structure definition unit 105 can usually be realized by an MPU, a memory, or the like. The processing procedure for “defining” is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

The data insertion unit 106 constitutes an instruction with a content for inserting the data group acquired by the data group acquisition unit 104 into the database structure defined by the database structure definition unit 105. A specific method of such processing will be described later. The data insertion unit 106 can be usually realized by an MPU, a memory, or the like. The processing procedure for “inserting” is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).
The second database management system 107 can be realized by including a recording medium storing a database, software for processing the database, and the like.

  The instruction execution unit 1071 executes an instruction for defining the database structure configured by the database structure definition unit 105. The execution constitutes one or more database structures. In addition, the instruction execution unit 1071 executes an instruction for inserting the data configured by the data insertion unit 106. By this execution, the data group acquired by the data group acquisition unit 104 is inserted into the configured database structure.

The second database storage unit 1072 stores a database obtained as a result of the instruction execution unit 1071 executing the instruction. “Accumulating” is a concept including temporary accumulation. The second database storage unit 1072 is preferably a non-volatile recording medium, but may be a volatile recording medium.
Hereinafter, the operation of the database migration apparatus 100 according to the present embodiment will be described with reference to the flowchart of FIG.

  (Step S201) The input receiving unit 101 determines whether an input has been received. When receiving the input, the input reception unit 101 goes to step S202, and otherwise returns to step S201.

  (Step S202) The input receiving unit 101 determines whether or not an input of an instruction for starting an application has been received. When receiving the input, the input receiving unit 101 goes to step S203, and if not, goes to step S204. “Inputting an instruction to start an application” means, for example, clicking an application icon.

  (Step S203) The database migration apparatus 100 starts an application. A screen configuration display means (not shown) configures an initial screen, and displays the configured initial screen on the display. The process returns to step S201.

  (Step S204) The input receiving unit 104 determines whether or not the input of the instruction received in step S201 is an input of an instruction to move to the database. The input receiving unit 104 goes to step S205 when receiving an input of an instruction to migrate the database, and goes to step S211 otherwise. “Instruction to migrate database” is, for example, instructing a migration source DBMS and a migration destination DBMS.

(Step S205) The first database structure information acquisition unit 103 acquires the database structure information from the migration source first database storage unit 1021 specified in step S204. If the specified database is 1, the first database structure information acquisition unit 103 acquires database structure information of the specified database. When there are a plurality of designated databases, the first database structure information acquisition unit 103 acquires database structure information of the designated databases.
(Step S206) The data group acquisition unit 104 acquires a data group from the migration source first database storage unit 1021 instructed in step S204.

  (Step S207) The database structure definition unit 105 configures a command for defining the database structure based on the database structure information acquired in step S205.

  (Step S208) The instruction execution unit 1071 executes the database structure definition instruction configured in step S207. As a result of execution, a database structure is constructed. The configured database structure is stored in the second database storage unit 1072.

  (Step S209) The data insertion unit 106 configures an instruction to insert the data group acquired in step S206 into the database structure configured in step S208.

  (Step S210) The instruction execution unit 1071 executes the “instruction to be inserted” configured in step S209. A data group is inserted into the database structure configured in step S208 to configure a database. The configured database is stored in the second database storage unit 1072. In addition, when the DB table is a DBMS including a plurality of tables, a plurality of tables may be acquired, and one DB may be configured based on the plurality of tables, or a DB may be configured for each of the plurality of tables. Also good.

  (Step S211) The input receiving unit 101 determines whether or not an input of an instruction to end the operation has been received. If the input is accepted, the process ends. If not, the process returns to step S201. The “instruction to end the operation” is, for example, an instruction by pressing an end button or the like that the database migration apparatus 100 has.

The specific operation of the database migration apparatus in this embodiment will be described below.
In the following, processing related to input of an instruction to migrate a database will be described. FIG. 3 is a diagram illustrating a display example of the display of the database migration apparatus 100. In FIG. 3, an initial screen of the application “ABC program” is displayed. The “ABC program” is application software that controls the operation of the database migration apparatus 100. When the menu button “DBMS” is pressed, a mark indicating the database management system is displayed in the window as shown in FIG. Next, “DBMS01” is designated as the migration source DBMS from within the migration source DBMS window. Further, “DBMS11” is designated as the migration destination DBMS from the migration destination window. “Specify” means, for example, left-clicking on the part of “DBMS01” or “DBMS11” with a mouse and specifying it by highlighting such as shaded display as shown in FIG. The designation method is not limited to the above, and other designation methods may be used.

  Next, the designated “DBMS01” or “DBMS11” is displayed in the window shown in FIG. In FIG. 4, one or more databases constituting “DBMS01” are displayed in the window of the migration source DBMS01. One or more databases constituting “DBMS11” are displayed in the window of the migration destination DBMS11. Next, the database to be migrated is selected from the file “DBMS01”. Now, when “HR management DB” is selected, a new database is created in the window of the migration destination DBMS 11 (in FIG. 4, it is shown with diagonal lines in a rectangular frame). The command for creating the database is described in SQL, for example, “CREATE DATABASE HR management”.

  The “selection method” is, for example, left-clicking on the “HR management DB” portion with a mouse, highlighting by shading as shown in FIG. 4, and clicking the “select button”. The “selecting method” is not limited to the above, and may be selected by other methods. The file name may be input by a separate process, or may automatically specify “HR management DB” having the same name as “DBMS01”.

  In the present embodiment, the “HR management DB” is selected from the database of the DBMS “DBMS01” and is transferred to the DBMS “DBMS11”. However, all the databases of the DBMS “DBMS01” are transferred to the DBMS “DBMS11”. Or one or more databases may be selected and transferred to the DBMS “DBMS11”.

  Next, processing for migrating a specified database will be described. Clicking the “Execute” button starts migration of the specified database. FIG. 5 is a diagram illustrating that the “execution” button is clicked and the database “HR management DB” is being migrated. FIG. 6 is a diagram illustrating a data example of the database “HR management DB”. In FIG. 6, the data of the database “HR management DB” is composed of RDB. The field includes “employee number”, “name”, “address”, and the like. “ID” is a system field provided by the DBMS for table management. FIG. 7 is a diagram illustrating an example of database structure information of the database “HR management DB”. In FIG. 7, the database structure information has an attribute name, a data type, and a byte length. The first database structure information acquisition unit 103 acquires the database structure information of the “HR management DB” data shown in FIG. Next, the data group acquisition unit 104 acquires the data group of the “HR management DB” in a CSV format in which data is separated by commas in record units. FIG. 8 is a diagram illustrating an example of data group information. Next, the database structure definition unit 105 configures a command for defining the database structure in SQL (not shown) based on the database structure information (see FIG. 7) acquired by the first database structure information acquisition unit 103. Such an instruction is described in SQL, for example, “CREATE TABLE personnel management table (employee number INT, name CHAR (18), address CHAR (50))”. A table having three fields (employee number, name, and address) is created by the SQL statement. Needless to say, the definition is not limited to SQL, but may be defined outside SQL. Next, the instruction execution unit 1071 executes an instruction that defines the configured database structure. An example of the database structure constructed as a result of the execution is shown in FIG. Next, the data group insertion unit 106 configures an instruction to insert the acquired data group (see FIG. 8) into the configured database structure (see FIG. 9). The command is described in SQL, for example, “INSERT INTO HR management table SELECT * FROM HR management DB”. With the SQL statement, all the data of the personnel management DB is inserted into the personnel management table. The instruction execution unit 1071 executes the instruction. FIG. 10 is a diagram illustrating an example of a database configured as a result of instruction execution. The configured database is stored in the second database storage unit 1072. FIG. 11 is a diagram illustrating a display example of the display screen. In FIG. 11, “completed” means that the database migration is completed.

  In the present embodiment, the database migration apparatus 100 is configured to include the first database management system 101 and the second database management system 107. However, the database migration apparatus 100 may be the first database management system 101 or / and / or A configuration without the second database management system 107 is also possible. In such a case, the database migration apparatus 400 further includes a transmission / reception unit 401. The transmission / reception unit 401 transmits a command for acquiring the database structure information configured by the first database structure information acquisition unit 103, and receives the database structure information from the first database storage unit 1021 based on the command. In addition, the transmission / reception unit 401 transmits a command for acquiring the data group configured by the data group acquisition unit 104, and receives the data group from the first database storage unit 1021 based on the command. In addition, the transmission / reception unit 401 transmits information on the database structure definition defined by the database structure definition unit 105. In addition, the transmission / reception unit 401 transmits an instruction to insert the data group formed by the data insertion unit 106 into the database structure. The instruction includes a data group. The first database management system 500 further includes a first transmission / reception unit 501. The first transmission / reception unit 501 receives a command for acquiring database structure information, acquires database structure information from the first database storage unit 1021 based on the command, and transmits the database structure information. Also, the first transmission / reception unit 501 receives a command for acquiring a data group, acquires the data group from the first database storage unit 1021 based on the command, and transmits the data group. The second database management system 600 further includes a second receiving unit 601. The second receiving unit 601 receives the database structure definition information defined by the database structure defining unit 105. The second receiving unit 601 receives a command for inserting the data group formed by the data inserting unit 106 into the database structure. FIG. 12 is a block diagram showing an example of the configuration of the database migration device 400, the first database management system 500, and the second database management system 500. The database migration device 400, the first database management system 500, and the second database management system 600 are each connected via a network. The first database management system 500 and the second database management system 600 include a CPU, a main memory, a hardware resource such as a recording medium (for example, ROM, EPROM, etc.) and a peripheral device (for example, a normal computer). (Input devices such as a keyboard and a mouse, output devices such as a display) (not shown). FIG. 13 is a diagram showing an example of the appearance of the database migration device 400, the first database management system 500, and the second database management system 600.

  As described above, according to the present embodiment, the database migration process can be easily performed, and the table structure does not need to be manually defined on the migration destination DBMS. The manual input time for defining such a table structure is not necessary, and the DB maintenance time of the DB administrator can be shortened.

  Furthermore, the operation of the database migration apparatus 100 described in the present embodiment may be realized by software, the software may be placed on, for example, a server, and the software may be distributed by software download. Further, the software may be recorded on a recording medium such as a CD-ROM and distributed. This is the same in all other embodiments. The program when the operation in the present embodiment is realized by software is as follows. First database structure information acquisition step for acquiring first database structure information, which is information related to the database structure of one or more databases defined by the first database management system, and data constituting one or more database records A data group acquisition step for acquiring a group; a database structure definition step for defining one or more database structures based on the first database structure information in the second database management system; and a data group acquired in the data group acquisition step. This is a program for executing a data insertion step to be inserted into the database structure defined in the database structure definition step.

(Embodiment 2)
In the present embodiment, the following describes how the database migration apparatus migrates information about indexes between different DBMSs.
FIG. 14 is a block diagram showing a configuration of the database migration apparatus 200 in the present embodiment. The database migration apparatus 200 includes an input reception unit 101, a first database management system 102, a first database structure information acquisition unit 103, a data group acquisition unit 104, a database structure definition unit 105, a data insertion unit 106, and a second database management system 107. The index information acquisition unit 201 and the index construction unit 202 are included. The first database management system 102 has a first database storage unit 1021. The second database management system 107 includes an instruction execution unit 1071 and a second database storage unit 1072.

  The index information acquisition unit 201 acquires index information of one or more databases from the database structure information. The database structure information includes index information that is information related to one or more database indexes. The “index information” is information related to the index of the database, for example, information such as a flag set for an attribute used for the index (usually an attribute serving as a search key), an attribute name to be indexed, and the like. “Index” refers to a table for searching for addresses where records and data are stored based on keys. For example, a hash table based on a hash method, a sorted data group, and a data group of a Btree structure Etc. The index information acquisition unit 201 can usually be realized by an MPU, a memory, or the like. The processing procedure for “acquiring” is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The index construction unit 201 constructs an index for all or part of the data group inserted by the data insertion unit 106 based on the index information acquired by the index information acquisition unit 108. Further, the index construction unit 201 may construct an index different from the index structure indicated by the index information. The index construction unit 201 can be usually realized by an MPU, a memory, or the like. The processing procedure for “building” is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  Hereinafter, the operation of the database migration apparatus 200 in the present embodiment will be described with reference to the flowchart of FIG. The same step numbers are the same as those in FIG.

  (Step S1501) The index information acquisition unit 201 acquires database index information from the database structure information acquired in step S205. The acquired index information may be two or more pieces of index information.

  (Step S1502) The index construction unit 201 configures an instruction to construct an index for all or part of the data group inserted by the data insertion unit 106, based on the index information acquired in step S1501. An instruction for constructing an index different from the index structure indicated by the index information may be configured.

  (Step S1503) The instruction execution unit 1071 executes the “instruction to build an index” configured in step S1502. As a result of execution, an index is constructed. The constructed index may be an index that the first database management system 102 that is the migration source has, or an index that the migration source first database management system 102 does not have. The process returns to step S201.

  Hereinafter, a specific operation of the database migration apparatus 200 in the present embodiment will be described. The database structure information has index information. FIG. 16 is a diagram illustrating a data example of database structure information having index information. In FIG. 16, a flag “1” of “INDEX” means that “employee number” is an indexed attribute (search key attribute). 17 and 18 are diagrams showing examples of table structures of indexes. In FIG. 17, the table structure of the index is composed of employee number data sorted in one column. Sorted by attribute value, the data is a set of “attribute value” and “record ID”. The “employee number data” is, for example, employee number data in the “HR management DB” shown in FIG. In FIG. 18, the index table is configured by a hash table. The data in each bucket of the hash table is a set of “attribute value” and “record ID”.

  Below, the process which builds an index is demonstrated. Note that the processing relating to the input of the instruction to migrate the database and the processing of migrating the designated database are the same as those in the first embodiment, and thus description thereof is omitted.

  The index information acquisition unit 201 acquires index information from the database structure information acquired by the first database structure information acquisition unit 103. Next, the index construction unit 202 configures an instruction to construct an index based on the acquired index information. The command for constructing the configured index is, for example, “CREATE INDEX idx1 ON personnel management table (employee number)” in the case of SQL. The meaning of the SQL sentence means that the index of the “employee number” column in the “HR management table” table is constructed with the name “idx1”. “Building an index based on index information” means building the same index as the index indicated by the acquired index information or / and building an index different from the index indicated by the acquired index information It is. The index construction unit 202 may be configured by describing an instruction for constructing an index in, for example, SQL, or may be configured by another database language or the like (not shown). Next, the instruction execution unit 1071 executes an instruction for constructing the index. As a result of execution, an index is constructed (see FIGS. 17 and 18). The constructed index is stored in the second database storage unit 1072. The constructed index has the same structure as the index that the migration source DBMS had. The index construction unit 202 can construct an index having a structure different from the index indicated by the acquired index information. For example, the index shown in FIG. 19 is constructed. In FIG. 19, the index indicates that the index has a Btree structure. Needless to say, the index construction unit 202 is not limited to constructing an index having a Btree structure, but may construct an index having another structure.

  As described above, according to the present embodiment, the index information constructed in the migration source DBMS can be migrated to the migration destination DBMS. Furthermore, even if the index structure of the migration source DBMS and that of the migration destination DBMS are different, an index can be constructed based on the index information of the migration source DBMS and adapted to the structure of the migration destination index. . For example, when the migration source DB has only a hash structure index and the migration destination DB has only a Btree structure index, an index of the Btree structure can be constructed from the hash structure index information.

  Furthermore, the program when the operation in the present embodiment is realized by software is as follows. First database structure information acquisition step for acquiring first database structure information, which is information related to the database structure of one or more databases defined by the first database management system, and data constituting one or more database records A data group acquisition step for acquiring a group, a database structure definition step for defining one or more database structures based on the first database structure information in the second database management system, and a data group acquired in the data group acquisition step, A data insertion step for inserting into the database structure defined in the database structure definition step, an index information acquisition step for acquiring index information that is information relating to one or more database indexes, and index information acquisition Based on the index information obtained in step a program for executing the index construction step of constructing an index to any or all of the inserted data group by the data insertion step.

  Also, an index information acquisition step for acquiring index information, which is information relating to an index of one or more databases defined by the first database management system, on the computer, and an index acquired in the index information acquisition step in the second database management system This is a program for executing an index construction step for constructing indexes for all or part of the data group inserted in the data insertion step based on the information.

  In the present embodiment, the database migration apparatus 200 has a configuration including the first database management system 101 and the second database management system 107. However, the database migration apparatus 200 may be the first database management system 101 or / and / or A configuration without the second database management system 107 may be used (see FIG. 12). In such a case, the database migration apparatus 100 includes a transmission / reception unit as in the first embodiment. In addition to the processing described in the first embodiment, the transmission / reception unit transmits a command for constructing the index configured by the index construction unit 202. The instruction may include index information. The second database management system further includes a receiving unit. The receiving unit receives an instruction to build an index configured by the index building unit 202.

(Embodiment 3)
In the present embodiment, the database migration device migrates a database between different DBMSs based on information held by the database operation information holding unit 301, and migrates information related to indexes between different DBMSs. This will be described below.

  FIG. 20 is a block diagram showing a configuration of the database migration apparatus 300 in the present embodiment. The database migration apparatus 300 includes an input reception unit 101, a first database management system 102, a first database structure information acquisition unit 103, a data group acquisition unit 104, a database structure definition unit 105, a data insertion unit 106, and a second database management system 107. An index information acquisition unit 201, an index construction unit 202, and a database operation information holding unit 301. The first database management system 102 has a first database storage unit 1021. The second database management system 107 includes an instruction execution unit 1071 and a second database storage unit 1072.

The database operation information holding unit 301 includes first database structure acquisition command information that is information indicating a command for acquiring first database structure information of the first database management system, and data group that is information indicating a command for acquiring a data group. Acquisition command information, second database structure definition command information that is a command that defines a database structure in the second database management system, and information that indicates a command to insert a data group into the database structure defined by the database structure definition unit Data group insertion instruction information, index information acquisition instruction information indicating information for acquiring one or more database index information, and an index for all or part of the data group inserted by the data insertion unit Index building instruction information, which is information indicating the instruction It holds. The database operation information holding unit 301 is preferably a non-volatile recording medium, but may be a volatile recording medium.
Hereinafter, the operation of the database migration apparatus 300 in the present embodiment will be described with reference to the flowchart of FIG.

  (Step S2101) The first database structure information acquisition unit 103 acquires first database structure acquisition command information from the database operation information holding unit 301. “Obtain first database structure acquisition command information” means that the interface adopted by the first database management system that is the migration source is taken out, and the interface for acquiring the first database structure information is taken out. Yes. (Step S2102) The first database structure information acquisition unit 103 acquires database structure information from the instructed first database storage unit 1021 based on the first database structure acquisition command information acquired in step S2102. To do. “Acquire based on the first database structure acquisition command information” means that the first database structure acquisition command is executed and the first database structure information, which is a result of the command execution, is acquired.

  (Step S2103) The data group acquisition unit 104 acquires data group acquisition command information from the database operation information holding unit 301. “Obtain data group acquisition command information” means to take out an interface that is adopted by the database management system that is the migration source and that acquires the data group acquisition command information.

  (Step S2104) The data group acquisition unit 104 acquires a data group from the migration source first database storage unit 1021 based on the data group acquisition command information acquired in step S2103. “Acquire based on data group acquisition command information” means to execute a data group acquisition command and acquire a data group as a result of the command execution.

  (Step S 2105) The database structure definition unit 105 acquires second database structure definition command information from the database operation information holding unit 301. “Obtain the second database structure definition command information” means that the interface used by the second database management system, which is the migration destination, is taken out and acquires the second database structure definition command. ing.

  (Step S2106) The database structure definition unit 105 defines a database structure based on the second database structure definition command information acquired in step S2106. “Defining the database structure based on the second database structure definition instruction information” is to instruct the instruction execution unit 1072 to execute the second database structure definition instruction.

  (Step S2107) The instruction execution unit 1071 executes the second database structure definition instruction specified in step S1906. As a result of the instruction execution, a database structure is constructed.

  (Step S 2108) The data insertion unit 106 acquires data insertion command information from the database operation information holding unit 301. “Obtain data insertion instruction information” means to take out an interface that is adopted by the database management system that is the migration destination and that acquires the data insertion instruction.

  (Step S2109) The data insertion unit 106 inserts the data group into the database structure configured in step S2107 based on the data insertion instruction information acquired in step S2108. “Inserting into the database structure based on the data insertion instruction information” is to instruct the instruction execution unit 1072 to execute the data insertion instruction.

  (Step S2110) The instruction execution unit 1071 executes the data insertion instruction instructed in step S2109. As a result of the execution of the instruction, a data group is inserted into the database structure, and the database is configured.

  (Step S2111) The index information acquisition unit 201 acquires index information acquisition command information from the database operation information holding unit 301. “Acquire index information acquisition command information” means to take out an interface that is adopted by the database management system that is the migration source and that acquires the index information acquisition command information.

  (Step S2112) The index information acquisition unit 201 acquires index information from the database structure information based on the index information acquisition command information acquired in step S2111. “Acquiring based on index information acquisition command information” means executing an index information acquisition command and acquiring index information that is a result of the command execution. Note that the acquired index information may be one or more pieces of index information.

  (Step S2113) The index construction unit 201 acquires index construction command information from the database operation information holding unit 301. “Obtain index construction instruction information” means to take out an interface that is adopted by the database management system that is the migration destination and that obtains index construction instruction information.

  (Step S2114) The index construction unit 201 constructs an index for all or part of the data group inserted by the data insertion unit 106 based on the index construction instruction information acquired in step S2113. An index different from the index structure indicated by the index information may be constructed. “Building an index for all or part of the data group inserted by the data insertion unit 106 based on the index construction command information” is to instruct the command execution unit 1072 to execute the index construction command. is there.

  (Step S2115) The instruction execution unit 1071 executes the “index construction instruction” instructed in step S2114. As a result of execution, an index is constructed. The process returns to step S201.

  Hereinafter, a specific operation of the database migration apparatus 300 in this embodiment will be described. FIG. 22 is a diagram illustrating an example of information included in the database operation information holding unit 301. In FIG. 22, “DBMS” means a database management system, and “DBMS1”, “DBMS2”, and “DBMS3” are different database management systems. “DBMS1”, “DBMS2”, and “DBMS3” use different database languages.

  Below, the process which acquires database structure information is demonstrated. Note that the processing related to the input of the instruction to migrate the database is the same as that in the first embodiment, and thus the description thereof is omitted. First, the first database structure information acquisition unit 103 acquires first database structure acquisition command information from the database operation information holding unit 301. In such “acquisition”, the database language describing the designated migration source DBMS may be determined to obtain the corresponding first database structure acquisition command information, and the designated database storage format (for example, The database language may be determined based on the extension of the file storing the database, and the corresponding first database structure acquisition command information may be acquired. In FIG. 22, the first database structure acquisition command information is, for example, “tablename [] = get table (); attribute [] = get schema (tablename);” for “DBMS1”. If the database language of the first database management system 102 that is the migration source is the same as the database language of “DBMS1,” for example, the first database structure information acquisition unit 103 sets “tablename [] = get table (); [] = Get schema (tablename); If the database language of the first database management system 102 that is the migration source is the same as “DBMS2” or “DBMS3”, for example, unlike the database language of “DBMS1,” the first database structure information acquisition unit 103 “ The command described in the database language “DBMS2” or “DBMS3” is acquired. Next, the first database structure information acquisition unit 103 executes, for example, the acquired “tablename [] = get table (); attribute [] = get schema (tablename);”. The meaning of the instruction is as follows. The name of the table indicated by “table ()” is acquired and set as “tablename []”. Then, the table structure “scheme (tablename)” of “tablename” is acquired and set as “attribute []”. As a result of the execution, the first database structure information acquisition unit 103 acquires first database structure information (see FIG. 7). When there are a plurality of tables in the database, the command is repeated a plurality of times, and the table structures of the plurality of tables are acquired.

  Below, the process which acquires a data group is demonstrated. For example, if the database language of the first database management system 102 that is the migration source is the same as the database language of “DBMS1,” the data group acquisition unit 104 acquires “record [] = get record (tablename);”. To do. If the database language of the first database management system 102 that is the migration source is the same as “DBMS2” or “DBMS3”, for example, unlike the database language of “DBMS1,” the data group acquisition unit 104 selects “DBMS2” or “DBMS2”. An instruction described in any database language of “DBMS3” is acquired. Next, the data group acquisition unit 104 executes, for example, the acquired “record [] = get record (tablename);”. The meaning of the instruction is as follows. “Record (tablename)”, which is data of the record in the table indicated by “tablename”, is acquired and set as “record []”. As a result of the execution, the data group acquisition unit 104 acquires a data group (see FIG. 8).

  In the following, the process of configuring the database structure in the migration destination second database management system 107 will be described. If the database language of the second database management system 107 that is the migration destination is the same as the database language of “DBMS3”, for example, the database structure definition unit 105 will create “CREATE TABLE table_name1 (column1 type1 column2 type2...); Is obtained. If the database language of the second database management system 107 that is the migration destination is the same as “DBMS1” or “DBMS2”, for example, different from the database language of “DBMS3”, the database structure definition unit 105 selects “DBMS1” or “DBMS1”. An instruction described in any database language of “DBMS2” is acquired. Next, the database structure definition unit 105 instructs the instruction execution unit 1071 to execute the acquired second database structure definition command “CREATE TABLE table_name1 (column1 type1 column2 type2...);”. Next, the instruction execution unit 1071 executes a second database structure definition instruction “CREATE TABLE table_name1 (column1 type1 column2 type2...);”. The meaning of the instruction is as follows. A table structure of a table named “table_name1” is created. The field is defined by “column1 type1 column2 type2...”. “Column” indicates the name of the field. “Type” indicates a data type. “Column1 type1 column2 type2...” Is the same as the information included in “attribute []”. As a result of instruction execution, a database structure is constructed (see FIG. 9).

  In the following, a process of configuring a database in the migration destination second database management system 107 will be described. For example, if the database language of the second database management system 107 that is the migration destination is the same as the database language of “DBMS3”, the data insertion unit 106 acquires “INSERT INTO table_name1 SELECT * FROM table_name;”. Now, “table_name” is “record []”. If the database language of the second database management system 107 that is the migration destination is the same as “DBMS1” or “DBMS2”, for example, unlike the database language of “DBMS3”, the data insertion unit 106 selects “DBMS1” or “DBMS1”. The command described in any database language of “DBMS2” is acquired. Next, the data insertion unit 106 instructs the instruction execution unit 1071 to execute the acquired data insertion instruction “INSERT INTO table_name1 SELECT * FROM record [];”. Next, the instruction execution unit 1071 executes the data insertion instruction “INSERT INTO table_name1 SELECT * FROM record [];”. The meaning of the instruction is as follows. All data indicated by “record []” is acquired. Then, all of the data is inserted into the table indicated by “table_name1”. As a result of the instruction execution, a database is constructed (see FIG. 10).

  Below, the process which acquires index information is demonstrated. If the database language of the first database management system 102 that is the migration source is the same as the database language of “DBMS1,” for example, the index information acquisition unit 201 acquires “attributename [] = get index (tablename)”. . If the database language of the first database management system 102 that is the migration source is the same as “DBMS2” or “DBMS3”, for example, unlike the database language of “DBMS1”, the index information acquisition unit 201 sets “DBMS2” or “DBMS2” An instruction described in any database language of “DBMS3” is acquired. Next, the index information acquisition unit 201 executes, for example, the acquired “attributename [] = get index (tablename)”. The meaning of the instruction is as follows. Information on the index of the table indicated by “tablename” is acquired, and the information on the index is set to “attributename []”. As a result of the execution, the index information acquisition unit 201 acquires index information from the database structure information (see FIG. 16).

  Hereinafter, a process for constructing an index in the second database management system 107 at the migration destination will be described. If the database language of the second database management system 107 that is the migration destination is the same as the database language of “DBMS3”, for example, the index construction unit 202 acquires “CREATE INDEX index_name ON table_name1 (column_name);”. Now, “column_name” is “attributename []”. If the database language of the second database management system 107 that is the migration destination is the same as “DBMS1” or “DBMS2”, for example, different from the database language of “DBMS3”, the index construction unit 202 selects “DBMS1” or “DBMS1”. The command described in any database language of “DBMS2” is acquired. Next, the index construction unit 201 instructs the instruction execution unit 1071 to execute the acquired index information “CREATE INDEX index_name ON table_name1 (attributename []);”. Next, the instruction execution unit 1071 executes an index construction instruction “CREATE INDEX index_name ON table_name1 (attributename []);”. The meaning of the instruction is as follows. An index indicated by “index_name” is created in the table of “table_name1”. As a result of the instruction execution, an index is created and constructed (see FIGS. 17, 18, and 19).

In the present embodiment, the database operation information holding unit 301 acquires first database structure acquisition command information, data group acquisition command information, second database structure definition command information, data group insertion command information, and index information acquisition. The database operation information holding unit 301 may be configured not to have the index information acquisition command information and the index construction command information. In such a case, the database migration apparatus 300 may be configured not to include the index information acquisition unit 201 and the index construction unit 202.
As described above, according to the present embodiment, DBs can be migrated between various DBMSs. An index can be constructed between various DBMSs.

  Furthermore, the program when the operation in the present embodiment is realized by software is as follows. A first database structure information acquiring step for acquiring first database structure information based on first database structure acquisition command information, which is information indicating a command for acquiring first database structure information of the first database management system in a computer; A data group acquisition step for acquiring a data group constituting one or more database records based on data group acquisition command information, which is information indicating a command for acquiring a data group, and a database structure in the second database management system A database structure definition step for defining one or more database structures based on the second database structure definition command information indicating information to be defined, and an instruction for inserting a data group into the database structure defined in the database structure definition step Data group insertion which is information to show Based on the instruction information, a program for executing the acquired data group in the data group acquiring step and the data insertion step of inserting the database structure defined in the database structure definition step.

  Also, the first database structure information acquisition for acquiring the first database structure information based on the first database structure acquisition command information which is information indicating the command for acquiring the first database structure information of the first database management system in the computer A data group acquisition step for acquiring a data group constituting a record of one or more databases based on a step, data group acquisition command information which is information indicating a command for acquiring the data group, and a database in the second database management system A database structure definition step for defining one or more database structures based on the second database structure definition command information, which is information indicating instructions for defining the structure, and the first database structure information, and the database structure defined in the database structure definition step. Insert data group A data insertion step for inserting the data group acquired in the data group acquisition step into the database structure defined in the database structure definition step based on data group insertion instruction information which is information indicating an instruction, and index information of one or more databases An index information acquisition step for acquiring index information of one or more databases based on index information acquisition command information that is information indicating an instruction for acquiring data, and an index for all or part of the data group inserted in the data insertion step This is a program for executing an index construction step for constructing indexes for all or a part of the data group inserted in the data insertion step based on index construction instruction information and index information which are information indicating construction instructions.

  As described above, according to the present invention, database migration processing can be easily performed, and the table structure need not be manually defined on the migration destination DBMS. In addition, there is no need for manual input time for defining such a table structure, which has the effect of shortening the DB maintenance time of the DB administrator, for example, data migration for processing database migration between different DBMSs. Useful for devices and the like.

Block diagram showing the configuration of the database migration apparatus 100 according to the first embodiment The flowchart which shows operation | movement of the database transfer apparatus 100 in Embodiment 1. The figure which shows the example of a display of the database migration apparatus 100 in Embodiment 1. The figure which shows the example of a display of the database migration apparatus 100 in Embodiment 1. The figure which shows the example of a display of the database migration apparatus 100 in Embodiment 1. The figure which shows the example of data of "HR management DB" in Embodiment 1. The figure which shows the example of the database structure information of the data of "HR management DB" in Embodiment 1 The figure which shows the example of the information of the data group in Embodiment 1 The figure which shows the example of the database structure in Embodiment 1 The figure which shows the example of the database in Embodiment 1 FIG. 6 shows a display example of a display screen in the first embodiment. The block diagram which shows the structure of the database transfer apparatus in Embodiment 1, a 1st database management system, and a 2nd database management system The figure which shows the example of the external appearance of the database transfer apparatus in Embodiment 1, a 1st database management system, and a 2nd database management system Block diagram showing the configuration of the database migration apparatus 200 in the second embodiment The flowchart which shows operation | movement of the database transfer apparatus 200 in Embodiment 2. The figure which shows the example of data of the database structure information in Embodiment 2 The figure which shows the example of the index in Embodiment 2. The figure which shows the example of the index in Embodiment 2. The figure which shows the example of the index in Embodiment 2. Block diagram showing the configuration of the database migration apparatus 300 according to the third embodiment The flowchart which shows operation | movement of the database transfer apparatus 300 in Embodiment 3. The figure which shows the example of the information which the database operation information holding | maintenance part 301 in Embodiment 3 has

Explanation of symbols

100, 200, 300, 400 Database migration device 101 Input accepting unit 102, 500 First database management system 1021 First database storage unit 103 First database structure information acquisition unit 104 Data group acquisition unit 105 Database structure definition unit 106 Data insertion unit 107, 600 Second database management system 1071 Instruction execution unit 1071 Second database storage unit 201 Index information acquisition unit 202 Index construction unit 301 Database operation information holding unit 401 Transmission / reception unit 501 First transmission / reception unit 601 Second reception unit

Claims (9)

Ri Information der about the database structure of one or more database defined by the first database management system, the one or more first database structure Ru information der with index information including information specifying the attributes to be indexed in the database A first database structure information acquisition unit for acquiring information;
A data group acquisition unit for acquiring a data group constituting a record of the one or more databases;
In the second database management system, a database structure definition unit that defines one or more database structures based on the first database structure information;
A data insertion unit for inserting the data group acquired by the data group acquisition unit into the database structure defined by the database structure definition unit ;
An index information acquisition unit for acquiring index information of the one or more databases;
The index for all or part of the data group inserted by the data insertion unit is constructed using the attribute specified by the information specifying the attribute to be indexed included in the index information acquired by the index information acquisition unit as a key. A database migration apparatus comprising an index construction unit . The index building unit
An instruction for constructing an index is configured with the attribute specified by the information specifying the attribute to be indexed included in the index information acquired by the index information acquisition unit as a key,
The database migration according to claim 1, wherein an index is accumulated in a second database storage unit of the second database management system by an instruction execution unit included in the second database management system executing an instruction to construct the index. apparatus. The index information includes information for specifying an attribute to be indexed and information indicating a structure of the index,
The database migration apparatus according to claim 1 or 2 , wherein an index structure indicated by the index information is different from an index structure constructed by the index construction unit. The structure of the index indicated by the index information and the structure of the index constructed by the index construction unit are:
The structure of an index having a plurality of attribute values sorted with the attribute specified by the information specifying the indexed attribute as a key, or
An index structure of a hash structure with the attribute specified by the information specifying the indexed attribute as a key, or
4. The database migration apparatus according to claim 1, wherein the database migration apparatus has a Btree structure with an attribute specified by information specifying the indexed attribute as a key. First database structure acquisition command information which is information indicating a command for acquiring first database structure information of the first database management system; data group acquisition command information which is information indicating a command for acquiring the data group; A second database structure definition command information which is information indicating a command for defining a database structure in the two database management system, and a data group which is information indicating a command for inserting the data group into the database structure defined by the database structure definition unit Insertion instruction information, index information acquisition instruction information indicating information for acquiring index information of the one or more databases, and an instruction for constructing an index for all or part of the data group inserted by the data insertion unit Holding index building instruction information which is the information to show Further comprising a database operation information holding section that,
The first database structure information acquisition unit
Based on the first database structure acquisition command information, obtain first database structure information,
The data group acquisition unit
Based on the data group acquisition command information, acquiring a data group constituting a record of the one or more databases,
The database structure definition unit includes:
Defining one or more database structures based on the second database structure definition instruction information and the first database structure information;
The data insertion unit is
Based on the data group insertion instruction information, the data group acquired by the data group acquisition unit is inserted into the database structure defined by the database structure definition unit,
The index information acquisition unit
Based on the index information acquisition command information, acquiring index information of the one or more databases,
The index building unit
Using the index construction command information and the index information, all or one of the data groups inserted by the data insertion unit using the attribute specified by the information specifying the attribute to be indexed included in the index information as a key. The database migration apparatus according to claim 1, wherein an index for a section is constructed. On the computer,
A first database structure information acquisition step for acquiring first database structure information that is information related to a database structure of one or more databases defined by the first database management system;
A data group acquisition step of acquiring a data group constituting a record of the one or more databases;
A database structure defining step for defining one or more database structures based on the first database structure information;
A data insertion step of inserting the data group acquired in the data group acquisition step into the database structure defined in the database structure definition step;
An index information acquisition step of acquiring index information of the one or more databases;
Indexes for all or part of the data group inserted in the data insertion step are used with the attribute specified by the information specifying the attribute to be indexed included in the index information acquired in the index information acquisition step as a key. A program for executing an index construction step for construction . In the index building step,
An instruction for constructing an index is configured with the attribute specified by the information specifying the attribute to be indexed included in the index information acquired in the index information acquisition step as a key,
In the instruction execution step of the second database management system,
The program according to claim 6, wherein an index is accumulated in a second database storage unit of the second database management system by executing an instruction for constructing the index. The index information includes information for specifying an attribute to be indexed and information indicating a structure of the index,
The program according to claim 6 or 7, wherein an index structure indicated by the index information is different from an index structure constructed by the index construction unit. On the storage medium,
First database structure acquisition command information which is information indicating a command for acquiring first database structure information of the first database management system; data group acquisition command information which is information indicating a command for acquiring the data group; A second database structure definition command information which is information indicating a command for defining a database structure in the two database management system, and a data group which is information indicating a command for inserting the data group into the database structure defined by the database structure definition unit Insertion instruction information, index information acquisition instruction information indicating information for acquiring index information of the one or more databases, and an instruction for constructing an index for all or part of the data group inserted by the data insertion unit Holding index building instruction information which is the information to show Ri,
In the first database structure information acquisition step,
Based on the first database structure acquisition command information, obtain first database structure information,
In the data group acquisition step,
Based on the data group acquisition command information, acquiring a data group constituting a record of the one or more databases,
In the database structure defining step,
Defining one or more database structures based on the second database structure definition instruction information and the first database structure information;
In the data insertion step,
Based on the data group insertion instruction information, the data group acquired in the data group acquisition step is inserted into the database structure defined in the database structure definition step,
In the index information acquisition step,
Based on the index information acquisition command information, acquiring index information of the one or more databases,
In the index building step,
Using the index construction command information and the index information, all of the data group inserted in the data insertion step using the attribute specified by the information specifying the attribute to be indexed included in the index information as a key, or 9. The program according to claim 6, wherein an index for a part is constructed.

Images