JP5483970B2 - Data migration apparatus, data migration method, and program - Google Patents

Description

  The present invention relates to a data migration device used for data migration between tables.

  For example, when migrating a system used in business processing, etc., change the table used for managing the data used in the migration source system to a table corresponding to the migration destination system. Must be migrated. As a system for migrating such data, for example, a byte pattern set definition body that defines a byte pattern of a migration source database, and a record length candidate selection that selects a record length candidate of a database based on the byte pattern set definition body information Means, and an appearance frequency calculating means for calculating an appearance frequency for each offset position in the record of the byte pattern in the record based on the record length selected as a candidate and the byte pattern set definition body (for example, patent document) 1) etc. were known.

JP-A-8-190479 (first page, FIG. 1 etc.)

  When data is transferred between tables, for example, if correspondence between items is specified in advance between tables before and after the transfer, it is considered that the transfer can be performed relatively easily. However, in a table such as a database used to manage data, even if the application software using the database is the same, each user can customize the table item name to a user's own name. Many. Therefore, it is difficult to prepare information indicating the correspondence between items between tables in advance. For this reason, when data migration is performed, it is necessary for the user to define a correspondence relationship between items in the migration source table and the migration destination table, and there is a problem that data migration cannot be performed easily.

  The data migration apparatus according to the present invention includes one or more first item names, one or more first item codes that are codes for identifying the first item names, and one or more first item names associated with one or more first item names. 1st table storage part in which one or more 1st tables which have the above data can be stored, 1 or more 2nd item names, and 1 or more 2nd item codes which are codes which specify the 2nd item name, A second table storage unit capable of storing one or more second tables, which are tables migrated from the first table, having one or more data associated with one or more second item names; An item code correspondence information storage unit that can store one or more item code correspondence information, which is information indicating a correspondence relationship between each first item code included in the table and each second item code included in the second table; The data in the first table is A data migration unit that migrates to the data of the second table corresponding to the second item code associated with the first item code corresponding to the data by the correspondence information, acquires the second table, and accumulates it in the second table storage unit And a data migration device.

  With this configuration, the data included in the table can be easily migrated. In particular, even when the user changes the first item name or the second item name, appropriate data migration can be realized.

  In the data migration apparatus of the present invention, in the data migration apparatus, one or more table correspondence information that is information indicating a correspondence relationship between one or more first tables and one or more second tables can be stored. An information storage unit, a table code correspondence information storage unit that can store table code correspondence information that is information indicating a correspondence relationship between the table correspondence information and the item code correspondence information, and the data migration unit includes a first table Is a data migration device that performs migration using the item code correspondence information associated with the table correspondence information by the table code correspondence information when migrating to the second table associated with the first table and the table correspondence information is there.

  With this configuration, data migration can be performed using appropriate item code correspondence information according to the combination of the first table and the second table.

  The data migration apparatus according to the present invention is the data migration apparatus according to the data migration apparatus, wherein at least part of the table correspondence information is information associating one first table with a plurality of second tables.

  With this configuration, a transition from one first table to a plurality of second tables can be performed.

  In the data migration apparatus according to the present invention, in the data migration apparatus, at least a part of the table correspondence information is information that associates a plurality of first tables with one second table.

  With this configuration, it is possible to shift from a plurality of first tables to one second table.

  According to the data migration apparatus and the like according to the present invention, the data contained in the table can be easily migrated.

1 is a block diagram of a data migration apparatus according to an embodiment of the present invention. Flow chart for explaining the operation of the data migration device The figure which shows an example of a menu screen for demonstrating operation | movement of the data migration apparatus. The figure which shows an example of the 1st table for demonstrating operation | movement of the data migration apparatus. The figure which shows an example of the 2nd table for demonstrating operation | movement of the data migration apparatus. The figure which shows an example of table corresponding | compatible information for demonstrating operation | movement of the data migration apparatus. The figure which shows an example of the table code corresponding | compatible information for demonstrating operation | movement of the data migration apparatus. The figure which shows an example of the item code corresponding | compatible information for demonstrating operation | movement of the same data transfer apparatus. The figure which shows the 2nd table after transfer for demonstrating operation | movement of the data transfer apparatus. The figure which shows the example of a display for demonstrating operation | movement of the data transfer apparatus The figure which shows the modification of table corresponding | compatible information for demonstrating operation | movement of the data migration apparatus. Schematic diagram showing an example of the appearance of a computer that implements the data migration device according to the embodiment of the present invention Schematic diagram showing an example of the internal configuration of a computer that implements the data migration device according to the embodiment

  Hereinafter, embodiments of a data migration apparatus and the like will be described with reference to the drawings. In addition, since the component which attached | subjected the same code | symbol in embodiment performs the same operation | movement, description may be abbreviate | omitted again.

(Embodiment)
FIG. 1 is a block diagram of a data migration apparatus 1 in the present embodiment.
The data migration apparatus 1 includes a first table storage unit 101, a second table storage unit 102, an item code correspondence information storage unit 103, a table correspondence information storage unit 104, a table code correspondence information storage unit 105, a migration designation reception unit 106, and A data migration unit 107 is provided.

  The first table storage unit 101 is associated with one or more first item names, one or more first item codes that are codes for identifying each first item name, and one or more first item names. One or more first tables having one or more data may be stored. Specifically, the first table is a table that becomes a migration source when the table is migrated. The table migration means, for example, accumulating the data of the table before migration in the second table as the data of the item name of the table after migration corresponding to the item name of the data. Specifically, the table described here is table information. Specifically, the table is information having one or more records in which one or more items are associated with data. The data format of the table does not matter. For example, it may be CSV format data, item names, item codes, text data separated by tabs by data, or the like. Alternatively, it may be data in a table-dedicated format used in database management software. The table is, for example, a table used by application software (hereinafter referred to as an application). The application using the table is, for example, business software that is software used for business purposes (hereinafter referred to as software). The business software is, for example, accounting software, sales management software, salary management software, personnel management software, or the like. Also, business integration software that integrates a plurality of business software and can use the functions of the plurality of business software by switching may be used.

  The item name such as the first item name described in the present embodiment is identification information that can identify an item, for example, a field name or an attribute name. The item name is information that can be freely changed by the user. For example, the user can change the item name “name” to the item name “user name” or the like as necessary. The item code such as the first item code in the present embodiment is, for example, a code associated with the item name on a one-to-one basis for specifying the item name. The item code is composed of one or more numbers, letters, symbols, and the like. The item code is, for example, a code defined in advance by an application using a table, for example, and is usually a code in which the user cannot change the value. Further, for example, the item code is usually invisible to the user in many cases. The item code is, for example, a code defined in advance by an application that uses a table.

  The one or more data included in the first table is, for example, data to be migrated in the first table. The format of the 1 or more data which a 1st table has is not ask | required. For example, it may be text data composed of character strings including letters and numbers, image data such as moving images and still images, audio data, and the like. In the case of text data, the display format or format is not limited. Further, the first table may have information for specifying the file format, format, display format, format, etc. of this data. In addition, information specifying these formats and the like may be associated with the first table and managed by a storage unit or the like (not shown).

  In the first table storage unit, the first item name, the first item code, and the data may be stored in direct association with each other, or may be stored in association with each other indirectly. Indirect association means, for example, that identification information corresponding to each is associated with each other, identification information of one information is associated with identification information of the other information, and the like. To do. Further, the first item name, the first item code, and the data may be stored in the physically same storage medium, or may be stored in a physically different storage medium. In the present embodiment, storing a plurality of pieces of data in association with each other means, for example, storing a plurality of pieces of data as values of different items constituting one record.

  There is no limitation on the process or timing at which the information of the first table is stored in the first table storage unit 101. For example, one or more first tables may be stored in the first table storage unit 101 via a recording medium, and one or more first tables transmitted via a communication line or the like may be stored in the first table. It may be stored in the storage unit 101, or one or more first tables input via an input device (not shown) are received by a receiving unit (not shown) and the first table received by the receiving unit. The table may be accumulated in the first table storage unit 101. Note that the storage described here is a concept including temporarily storing the first table received by the receiving unit or the like.

  In the present embodiment, as an example, the first table is stored in the first table storage unit 101 in association with the first table identification information that is information for identifying the first table. explain. The first table identification information is, for example, a first table name, an identification symbol of the first table, or the like.

  The first table storage unit 101 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium.

  The second table storage unit 102 includes one or more second item names, one or more second item codes that are codes specifying the second item names, and one associated with one or more second item names. One or more second tables, which are tables migrated from the first table, having the above data can be stored. Specifically, the second table is a table that becomes the migration destination after the migration of the first table. For example, the second table is a table used in an application different from the application using the first table. Since the second item name, the second item code, and the like are the same as the first item name, the second item code, and the like described above, detailed description thereof is omitted here.

  Data included in the second table is, for example, data after migration of data included in the first table. The data that the second table has is, for example, the data that was included in the first table has been moved or duplicated, or the format, display format, format, etc., match the format of the second table at the time of movement or duplication. Converted. Note that one or more pieces of data need only be finally stored in the second table. For example, one or more pieces of data may not be stored until the first table is transferred. Alternatively, data other than the migrated data may be stored in advance in the second table. Further, the second table may have information for specifying the file format, format, display format, format, etc. of the stored data. Also, information specifying these formats and the like may be associated with the second table and managed by a storage unit (not shown) or the like.

  There is no limitation on the process, timing, or the like of the second table stored in the second table storage unit 102. For example, when migrating the first table, information specifying the format of the second table stored in a storage unit such as a storage medium (not shown), such as the second item name and the second item code, is stored. A new second table or the like in which no data is stored may be created using information specifying the data format or the like. Alternatively, the second table may be stored in advance. Further, an application or the like using the second table may create and store the second table as appropriate. Note that the storage described here is a concept including temporarily storing a second table migrated by the data migration unit 107 described later.

  In the present embodiment, as an example, a case where the second table is stored in the second table storage unit 102 in association with the second table identification information will be described in the same manner as the first table.

  The second table storage unit 102 is preferably a nonvolatile recording medium, but can also be realized by a volatile recording medium.

  The item code correspondence information storage unit 103 includes one or more item code correspondence information that is information indicating a correspondence relationship between each first item code included in the first table and each second item code included in the second table. Can be stored. For example, in the item code correspondence information storage unit 103, the corresponding first item code and second item code are stored as values of different items constituting one record. The item code correspondence information is stored in the item code correspondence information storage unit 103 in advance, for example. Further, the item code correspondence information created by the user or the like may be received and stored by a reception unit (not shown) or the like. The item code correspondence information includes information that specifies conversion of a format, a display format, a format, and the like performed when converting one or more data of the first table into one or more data of the second table. Also good.

  Here, as an example, the item code correspondence information is associated with item code correspondence information identification information that is identification information for identifying the item code correspondence information, like the first table identification information and the like. Will be described.

  The item code correspondence information storage unit 103 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium.

  In the table correspondence information storage unit 104, a correspondence relationship between one or more first tables stored in the first table storage unit 101 and one or more second tables stored in the second table storage unit 102 is displayed. One or more table correspondence information, which is information to be shown, can be stored. Specifically, the table correspondence information is information indicating a correspondence relationship between a first table that is one or more migration sources and a second table obtained by migrating the first table. The table correspondence information is information having first table identification information of the corresponding first table and second table identification information of the second table in association with each other, for example. For example, it is information having corresponding first table identification information and second table identification information as different items of one record. The table correspondence information may be stored in advance, or table correspondence information created by a user or the like may be accumulated.

  At least a part of the table correspondence information stored in the table correspondence information storage unit 104 includes a first table of one or more first tables stored in the first table storage unit 101 and a second table. Information that associates a plurality of second tables among the two or more second tables stored in the storage unit 102 may be used. In addition, at least a part of the table correspondence information stored in the table correspondence information storage unit 104 includes a plurality of first tables out of two or more first tables stored in the first table storage unit 101, and Information that associates one second table among one or more second tables stored in the two-table storage unit 102 may be used. Further, the table correspondence information as described above may be mixed.

  Here, as an example, a case will be described in which table correspondence information is associated with table correspondence information identification information, which is identification information for identifying table correspondence information, as in the case of first table identification information and the like. .

  The table correspondence information storage unit 104 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium.

  The table code correspondence information storage unit 105 is information indicating a correspondence relationship between table correspondence information stored in the table correspondence information storage unit 104 and item code correspondence information stored in the item code correspondence information storage unit 103. Table code correspondence information may be stored. Specifically, the table code correspondence information is information specifying item code correspondence information used when converting one first table into a second table associated with the first table by the table correspondence information. It is. The table code correspondence information is, for example, information that associates table correspondence information identification information with item code correspondence information identification information. For example, it is information having corresponding table correspondence information identification information and item code correspondence information identification information as different items of one record. The table code correspondence information may be stored in advance, or the table code correspondence information created by the user or the like may be accumulated.

  The table code correspondence information storage unit 105 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium.

  The migration designation receiving unit 106 receives migration designation information that is information for designating the first table that is the migration source and the second table that is the migration destination. For example, the migration designation information having the first table identification information of the first table as the migration source input by the user and the second table identification information of the second table as the migration destination is received. The input means for the migration designation information may be anything such as a numeric keypad, keyboard, mouse or menu screen. The migration designation receiving unit 106 can be realized by a device driver for input means such as a numeric keypad or a keyboard, control software for a menu screen, and the like.

  The data migration unit 107 corresponds to the data of the first table stored in the first table storage unit 101 with the second item code associated with the first item code corresponding to the data by the item code correspondence information. The second table is acquired by moving to the data of the second table and accumulated in the second table storage unit 102. In particular, when the data migration unit 107 migrates the first table stored in the first table storage unit 101 to the second table associated with the first table by the table correspondence information, the table code correspondence information Thus, migration is performed using the item code correspondence information associated with the table correspondence information.

  For example, when the migration designation receiving unit 106 has received the migration designation information, the data migration unit 107 uses the migration designation information to convert the first table designated as the migration source by the migration designation information received by the migration designation receiving unit 106. Migrate to the second table specified as the migration destination.

  Further, when there is no migration designation receiving unit 106 or when no migration designation information is received, the table correspondence information among the tables stored in the first table storage unit 101 and the second table storage unit 102 is associated. All of the table pairs corresponding to the table pairs formed of the first table and the second table may be converted. For example, a set of the first table and the second table associated with each table correspondence information stored in the table correspondence information storage unit 104 is obtained from the first table storage unit 101 and the second table storage unit 102. Further, the item code correspondence information associated with the table correspondence information associated with this set is obtained using the table code correspondence information. Then, the acquired first table is transferred to the second table using the acquired item code correspondence information. This process is repeated for all table correspondence information. Thereby, the set of the 1st table and 2nd table matched by table correspondence information can be moved.

  Hereinafter, as an example, the case where one first table is designated as the conversion source and one second table is designated as the conversion destination by the migration designation information will be specifically described as an example. Here, as an example, the designated first table is called a designated first table, and the designated second table is called a designated second table.

  1) First, a process for acquiring item code correspondence information corresponding to a specified set of conversion source and conversion destination tables will be described.

  The data migration unit 107 matches the first table and the second table that match the designated first table and the designated second table from the table correspondence information stored in the table correspondence information storage unit 104. Information is detected by searching or the like. Specifically, the first table identification information that matches the identification information of the designated first table, and the second table identification information that matches the identification information of the designated second table, and the second table identification information Table correspondence information having table identification information is detected, and table correspondence information identification information which is identification information of the detected table correspondence information is acquired.

  Next, the data migration unit 107 detects the code correspondence information associated with the table correspondence information detected above from the table code correspondence information stored in the table code correspondence information storage unit 105 by searching or the like. To do. Specifically, using the table correspondence information identification information detected above as a search key, table code correspondence information having table correspondence information identification information that matches the table correspondence information identification information is detected, and the detected table code correspondence is detected. Acquires item code correspondence information included in the information.

  2) Next, a process of shifting using the item code correspondence information will be described. Here, as an example, a case will be described in which the item code correspondence information acquired by the above processing is used.

  The data migration unit 107 acquires one first item code corresponding to one first item name from the designated first table. Then, using the acquired first item code as a search key, a second item code associated with the first item code that matches the acquired first item code is detected and acquired from the item code correspondence information. To do. Then, one data corresponding to the above-mentioned one first item name in the designated first table (that is, data corresponding to one first item code) is acquired, and the acquired data is acquired as described above. The second item code that matches the two item codes is stored in the designated second table in association with the second item code. That is, it is stored in the designated second table in association with the second item name corresponding to the second item code. When acquiring data from the designated first table, the original data may be deleted or left. By repeating such processing for all the data in the designated first table, the processing for transferring the data in the designated first table to the designated second table is completed.

  Here, a case has been described in which the data migration is simple movement or accumulation of duplication. However, when the data migration unit 107 accumulates the data of the first table in the second table, The data acquired from the first table may be converted and stored in accordance with the format specified in the second item name in which data is stored, information indicating the data format, or the like. For example, convert the display format of date data from the Christian era to the Japanese era, store numbers after a predetermined number of digits, for example, numbers after the decimal point, or store numbers by rounding off numbers. May be. Moreover, you may perform conversion of a character code etc. Since such a change is a well-known technique in database software, spreadsheet software using a spreadsheet, and the like, description thereof is omitted here.

  Here, the case where the item code correspondence information acquired in the above processing is used as the migration processing using the item code correspondence information has been described, but any item code correspondence information may be used. . For example, item code correspondence information designated by the user or the like may be used. Further, for example, when there is only one item code correspondence information used for a set of tables to be converted, this item code correspondence information may be used. In particular, in such a case, table correspondence information and table code correspondence information are unnecessary, and the process of obtaining the item code correspondence information can be omitted.

  The data migration unit 107 can usually be realized by an MPU, a memory, or the like. The processing procedure of the data migration unit 107 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  Although not shown in the present embodiment, an output unit (not shown) for outputting the second table migrated and accumulated by the data migration unit 107 may be provided. The output in this case is a concept including display on a display, printing on paper by a printer, transmission to an external device, and the like. Such an output unit may or may not include an output device such as a display or a printer. The output unit may be realized by output device driver software, or output device driver software and an output device.

  Next, the operation of the data migration apparatus 1 will be described using the flowchart of FIG. Here, a case will be described in which the first table designated by the migration designation information received by the migration designation accepting unit 106 is migrated to the second table designated by the same migration designation information. Here, a case where only one record of the first table is transferred will be described.

  (Step S101) The migration designation receiving unit 106 determines whether or not migration designation information has been received. If accepted, the process proceeds to step S102. If not accepted, the process returns to step S101.

  (Step S102) The data migration unit 107 displays table correspondence information in which the first table and the second table that match the first table and the second table specified by the migration designation information received in Step S101 are associated with each other. The correspondence information storage unit 104 detects this. Specifically, the table correspondence information identification information in which the first table identification information and the second table identification information matching the first table identification information and the second table identification information designated by the migration designation information are associated with each other in the table. It is detected and acquired from the table correspondence information stored in the correspondence information storage unit 104.

  (Step S103) The data migration unit 107 detects item code correspondence information associated with the table correspondence information detected in step S102. Specifically, using the table correspondence information identification information acquired in step S102 as a search key, the item code correspondence information identification information associated with the table correspondence information identification information is detected in the table code correspondence information storage unit. get.

  (Step S104) The data migration unit 107 assigns 1 to the counter n.

  (Step S105) The data migration unit 107 acquires the nth first item code from the first table designated by the migration designation information received in step S101.

  (Step S106) The data migration unit 107 uses the first item code acquired in step S105 as a search key, and uses the item code correspondence information (step S103) to detect the second item code corresponding to the first item code ( Specifically, it is acquired by searching from the item code correspondence information indicated by the item code correspondence information identification information obtained in step S103.

  (Step S107) The data migration unit 107 associates the data associated with the nth first item code in the first table with the second item code retrieved in step S106, and accepts it in step S101. Accumulate in the second table specified by the migration specification information. When storing, the data may be converted in accordance with the format of the second table.

  (Step S108) The data migration unit 107 increments the value of the counter n by 1.

  (Step S109) The data migration unit 107 determines whether or not there is an nth first item code in the first table designated by the migration designation information received in step S101. If there is, the process proceeds to step S105, and if not, the migration process ends.

  In the above flowchart, the case where only one record of the first table is transferred has been described, but it is needless to say that the present invention can also be applied to a case where a plurality of records are transferred. For example, after repeating the above-described processing from step S104 to step S109 for one record, the same processing is repeated for the next record, and the processing is finished when all the records have been transferred. You may do it.

  Or you may make it transfer all the data of the 1st item code of one record of a 1st table as data corresponding to the 2nd item code | cord | chord corresponding to a 2nd table at once.

  Hereinafter, a specific operation of the data migration apparatus 1 in the present embodiment will be described.

  FIG. 3 is a diagram illustrating an example of a menu screen for accepting designation of the first table to be migrated by the data migration apparatus 1 and designation of the second table to be the migration destination.

  First, the user displays a menu as shown in FIG. 3, operates the data migration apparatus 1 with an input device such as a mouse (not shown), etc., and displays the first table whose table name is “order reception table”. Assume that the data migration apparatus 1 is instructed to convert to a second table whose table name is “order management”. The table name here is assumed to be identification information of the first table and the second table. In response to this operation, the migration designation accepting unit 106 accepts migration designation information for migrating the “order reception table” that is the first table to the “order management” that is the second table.

  FIG. 4 is a diagram showing a first table stored in the first table storage unit 101 and whose table name is “order reception table”. The “order reception table” is a table used in the business application A, for example. In the figure, the first line shows the first item name. The second row shows the first item code corresponding to the first item name in the same column. Also, each row after the third row shows each record stored in the “order reception table”.

  FIG. 5 is a diagram showing a second table stored in the second table storage unit 102 and whose table name is “order management”. The “order reception table” is a table used in the business application B, for example. In the figure, the first line shows the second item name. The second row shows a second item code corresponding to the second item name in the same column. Also, each row after the third row shows each record stored in “order management”. However, here, it is assumed that no record is stored in the second table.

  FIG. 6 is a diagram illustrating an example of table correspondence information stored in the table correspondence information storage unit 104. The table correspondence information includes items of “table correspondence information ID”, “first table name”, and “second table name”. “Table correspondence information ID” is identification information of table correspondence information. The “first table name” is first table identification information and corresponds to the above-described first table name. The “second table name” is second table identification information and corresponds to the above-described second table name.

  The data migration unit 107 uses the migration designation information received by the migration designation acceptance unit 106 as the value of “first table name” from the table correspondence information illustrated in FIG. 6 stored in the table correspondence information storage unit 104. Is detected, and the value of the “second table name” matches the “order management” that is the second table name indicated by the migration designation information. Here, a record whose “table correspondence information ID” is “T002” is detected as such a record. Then, the data migration unit 107 acquires “T002” that is the value of the “table correspondence information ID” of this record.

  FIG. 7 is a diagram illustrating an example of table code correspondence information stored in the table code correspondence information storage unit 105. The table code correspondence information has items of “table correspondence information ID” and “item code correspondence information ID”. The “table correspondence information ID” is table correspondence information identification information and corresponds to the “table correspondence information ID” in FIG. “Item code correspondence information ID” is item code correspondence information identification information, and here, the file name of the item code correspondence information is shown as an example.

  Next, from the table code correspondence information as shown in FIG. 7, the data migration unit 107 sets the value of “table correspondence information ID” to “T002”, which is the “table correspondence information ID” acquired by the data migration unit 107. A matching record is detected, and the value of “item code correspondence information ID” of the detected record is acquired. Here, “item code correspondence information ID” “C102” is acquired from the record whose “table correspondence information ID” of the table code correspondence information is “T002” as shown in FIG.

  Next, the data migration unit 107 acquires item code correspondence information whose file name is “C102” from the item code correspondence information storage unit 103.

  FIG. 8 is a diagram showing item code correspondence information whose file name is “C102”. The item code correspondence information includes items “first item code” that is a first item code and “second item code” that is a second item code.

  The data migration unit 107 uses the item code correspondence information whose file name is “C102” shown in FIG. 8 to migrate the “order reception table” which is the first table shown in FIG.

  First, the data migration unit 107 has a first item corresponding to “April 1, 2009” that is the first data from the left stored in the first record of the “order reception table” that is the first table. The code “A001” is acquired. Here, in the item code correspondence information whose file name is “C102”, a record in which the value of “first item code” matches the first item code “A001” acquired from the “order table” is detected. The value of “second item code” of the detected record is acquired. Here, “B1002” is acquired.

  Then, the data migration unit 107, in the second table shown in FIG. 5, the item whose value of the second item code matches the value “B1002” of the “second item code” acquired from the item code correspondence information (Field) is detected. Then, the first data “April 1, 2009” of the first record stored in the first table “order receiving table” is read, and the read data is stored in the first record of the second table. , The data of the item that matches the value “B1002” of the “second item code” is stored. Here, the data is stored as the data of the second item from the left of the first record. In this specific example, this item in the second table is set to display the year, month, and day in advance in the Christian era, and the data migration unit 107 acquires the value when accumulating the value in this item. The converted value “April 1, 2009” is converted according to this setting and stored. Thereby, the data of the first item of the first record of the second table becomes “April 1, 2009”.

  Next, the data migration unit 107 is a first item code corresponding to “April 2, 2009” which is the second data stored in the first record of the first table “Order received table”. “A002” is acquired. In the item code correspondence information “C102”, a record in which the value of the “first item code” matches the first item code “A002” is detected, and the value of the “second item code” of the detected record is detected. “B1003” is acquired.

  Then, the data migration unit 107 detects the third item from the left in the second table shown in FIG. 5, the item whose value of the second item code matches “B1003”. Then, the second data “April 2, 2009” of the first record stored in the first table “order reception table” is read, and the third record from the left of the first record of the second table is read. Accumulate as item data.

  Thereafter, the same processing is repeated for data of other items in the first record of the first table. When the processing is completed for all items, the same processing is sequentially repeated for the second and subsequent records.

  FIG. 9 is a diagram illustrating the migrated second table accumulated in the second table storage unit 102 as a result of the above repetition.

  In the specific example, when the data migration unit 107 acquires the item code correspondence information, the first item names respectively corresponding to the “first item code” and the “second item code” associated with the item code correspondence information. And the second item name are obtained by searching from the first table and the second table that are to be migrated, and the corresponding first item name and second item name in the item code correspondence information corresponding to “first Confirmation information, which is information obtained by replacing the “item code” and “second item code”, is created. Using this confirmation information, an image as shown in FIG. You may make it ask | require confirmation of whether a data transfer may be performed by the correspondence between item names as shown in this information for confirmation. By such display, it is possible to reduce problems in data migration.

  In the above specific example, as shown in FIG. 11, the table correspondence information may be associated with one first table and a plurality of second tables, or a plurality of first tables and one table. May be associated with the second table.

  For example, in the record having the table correspondence information ID “T002” in FIG. 11, the first table having the table name “order received table” has two table names “order received management” and “order received slip”. It is a record associated with two second tables. This is because, for example, at least part of data associated with a plurality of first item names of one first table whose table name is “order table” is a second table whose table name is “order management”. In addition, at least part of the data associated with a plurality of first item names in the “order table” can be transferred to the second table whose table name is “order slip”. It shows that there is. By using such table conversion information, in the above specific example, for example, a transition from one first table to two second tables can be performed.

  In addition, the records with the table correspondence information IDs “T004” and “T005” in FIG. 11 include a first table whose table name is “shipping table”, and a first table whose table name is “shipping table”. Is a record associated with one second table whose table name is “shipment management”. For example, the data of the first table whose table name is “shipping table” and the data of the first table whose table name is “shipping table”, respectively, It shows that it can be transferred to two tables. By using such table conversion information, in the above specific example, for example, it is possible to shift from two first tables to one second table, and for example, to reduce item code correspondence information Can do.

  As described above, according to the present embodiment, the item code indicating the correspondence between the first item code corresponding to the first item name of the first table and the second item code corresponding to the second item name of the second table. Using the correspondence information, the data in the first table can be transferred to the second table. Thereby, the data contained in the table can be easily migrated. In particular, even when the user changes the first item name or the second item name, appropriate data migration can be realized.

  In each of the above embodiments, each process (each function) may be realized by centralized processing by a single device (system), or by distributed processing by a plurality of devices. May be.

  Further, in each of the above embodiments, it goes without saying that two or more communication means (such as an information transmission unit) existing in one apparatus may be physically realized by one medium.

  In the above embodiment, information related to processing executed by each component, for example, information received, acquired, selected, generated, transmitted, and received by each component. In addition, information such as threshold values, mathematical formulas, addresses, etc. used by each component in processing is retained temporarily or over a long period of time on a recording medium (not shown) even when not explicitly stated in the above description. It may be. Further, the storage of information in the recording medium (not shown) may be performed by each component or a storage unit (not shown). Further, reading of information from the recording medium (not shown) may be performed by each component or a reading unit (not shown).

  Further, although cases have been described with the above embodiments where the data migration device is a stand-alone device, the data migration device may be a stand-alone device or a server device in a server / client system. In the latter case, the output unit or the reception unit receives an input or outputs a screen via a communication line.

  In each of the above embodiments, each component may be configured by dedicated hardware, or a component that can be realized by software may be realized by executing a program. For example, each component can be realized by a program execution unit such as a CPU reading and executing a software program recorded on a recording medium such as a hard disk or a semiconductor memory.

  Note that the software that implements the data migration apparatus in each of the above embodiments is the following program. That is, the program associates a computer with one or more first item names, one or more first item codes that are codes for identifying the first item names, and one or more first item names. The data of the first table stored in the first table storage unit in which one or more first tables having one or more data can be stored, each first item code included in the first table, and one or more Migrating from the first table having a second item name, one or more second item codes that are codes specifying the second item name, and one or more data associated with the one or more second item names One or more item codes that are information indicating the correspondence with each second item code included in the second table stored in the second table storage unit in which one or more second tables that are stored tables can be stored Correspondence information is stored The item code correspondence information stored in the item code correspondence information storage unit shifts to the data in the second table corresponding to the second item code associated with the first item code corresponding to the data by moving the second table. This is a program for acquiring and functioning as a data migration unit that accumulates in the second table storage unit.

  In the program, the functions realized by the program do not include functions that can be realized only by hardware. For example, a function that can be realized only by hardware such as a modem or an interface card in an acquisition unit that acquires information or an output unit that outputs information is not included in the function realized by the program.

  Further, the computer that executes this program may be singular or plural. That is, centralized processing may be performed, or distributed processing may be performed.

  FIG. 12 is a schematic diagram showing an example of the appearance of a computer that executes the program and realizes the data migration apparatus according to the embodiment. The above-described embodiment can be realized by computer hardware and a computer program executed on the computer hardware.

  In FIG. 12, a computer system 900 includes a computer 901 including a CD-ROM (Compact Disk Read Only Memory) drive 905 and an FD (Floppy (registered trademark) Disk) drive 906, a keyboard 902, a mouse 903, a monitor 904, and the like. Is provided.

  FIG. 13 is a diagram showing an internal configuration of the computer system 900. In FIG. 13, in addition to the CD-ROM drive 905 and the FD drive 906, a computer 901 is connected to an MPU (Micro Processing Unit) 911, a ROM 912 for storing a program such as a bootup program, and the MPU 911. A RAM (Random Access Memory) 913 that temporarily stores program instructions and provides a temporary storage space, a hard disk 914 that stores application programs, system programs, and data, and an MPU 911 and a ROM 912 are interconnected. And a bus 915. The computer 901 may include a network card (not shown) that provides connection to the LAN.

  A program that causes the computer system 900 to execute the functions of the data migration device according to the above-described embodiment is stored in the CD-ROM 921 or FD 922, inserted into the CD-ROM drive 905 or FD drive 906, and stored in the hard disk 914. May be forwarded. Instead, the program may be transmitted to the computer 901 via a network (not shown) and stored in the hard disk 914. The program is loaded into the RAM 913 when executed. The program may be loaded directly from the CD-ROM 921, the FD 922, or the network.

The program does not necessarily include an operating system (OS) or a third-party program that causes the computer 901 to execute the functions of the data migration apparatus according to the above-described embodiment. The program may include only a part of an instruction that calls an appropriate function (module) in a controlled manner and obtains a desired result. How the computer system 900 operates is well known and will not be described in detail.
The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the data migration apparatus according to the present invention is suitable as an apparatus for migrating table data, and is particularly useful as an apparatus for migrating table data whose items can be changed.

DESCRIPTION OF SYMBOLS 1 Data transfer apparatus 101 1st table storage part 102 2nd table storage part 103 Item code corresponding | compatible information storage part 104 Table corresponding | compatible information storage part 105 Table code corresponding | compatible information storage part 106 Migration designation | designated reception part 107 Data transfer part

Claims (6)

One or more first item names which are information whose values can be changed by the user, and one or more first item codes which are codes for specifying the respective first item names and which cannot be changed by the user A first table storage unit that can store one or more first tables having one or more data associated with the one or more first item names;
One or more second item names that are information whose values can be changed by the user, a code that identifies the second item names, and one or more second item codes that are codes that the user cannot change the values ; A second table storage unit that can store one or more second tables, which are tables migrated from the first table, having one or more data associated with the one or more second item names;
An item code correspondence information storage unit in which one or more item code correspondence information, which is information indicating a correspondence relationship between each first item code included in the first table and each second item code included in the second table, can be stored. When,
The data of the first table is transferred to the data of the second table corresponding to the second item code associated with the first item code corresponding to the data by the item code correspondence information, and the second table is acquired. A data migration apparatus comprising: a data migration unit that accumulates in the second table storage unit. A table correspondence information storage unit capable of storing one or more table correspondence information, which is information indicating a correspondence relationship between the one or more first tables and the one or more second tables;
A table code correspondence information storage unit that can store table code correspondence information that is information indicating a correspondence relationship between the table correspondence information and the item code correspondence information;
The data migration unit is associated with the table correspondence information by the table code correspondence information when the first table is migrated to the second table associated with the first table and the table correspondence information. The data migration apparatus according to claim 1, wherein migration is performed using the item code correspondence information. The data migration apparatus according to claim 2, wherein at least a part of the table correspondence information is information associating one of the first tables with a plurality of the second tables. 4. The data migration apparatus according to claim 2, wherein at least a part of the table correspondence information is information associating a plurality of the first tables with one second table. One or more first item names which are information whose values can be changed by the user, and one or more first item codes which are codes for specifying the respective first item names and which cannot be changed by the user , A first table storage unit that can store one or more first tables having one or more data associated with the one or more first item names, and one or more information that allows a user to change the value Are associated with the one or more second item names and the one or more second item names, which are codes that specify the second item name and the user cannot change the value. A second table storage unit that can store one or more second tables that are migrated from the first table, and each first item code included in the first table; Each second included in the second table And item code correspondence information storage unit in which one or more item codes corresponding information is information indicating the correspondence between the eyes codes may be stored, a data migration method performed by using the data migration unit,
The data migration unit migrates the data of the first table to the data of the second table corresponding to the second item code associated with the first item code corresponding to the data by the item code correspondence information. A data migration method comprising a data migration step of acquiring two tables and storing them in the second table storage unit. Computer
One or more first item names which are information whose values can be changed by the user, and one or more first item codes which are codes for specifying the respective first item names and which cannot be changed by the user The data of the first table stored in the first table storage unit in which one or more first tables having one or more data associated with the one or more first item names can be stored, each first item code included in the first table, 1 or more and the second item name the user is changeable information values, a code for specifying the second item name, the user changes the value One or more second item codes that are migrated from the first table, having one or more second item codes that are not allowed codes and one or more data associated with the one or more second item names The second table on which the table can be stored Stored in the item code correspondence information storage unit in which one or more item code correspondence information, which is information indicating the correspondence relationship with each second item code included in the second table stored in the bull storage unit, can be stored. The second table is acquired by moving to the data of the second table corresponding to the second item code associated with the first item code corresponding to the data by the item code correspondence information, and stored in the second table storage unit. A program for functioning as an accumulated data migration unit.

Images