JP5469985B2 - Data delivery method and general-purpose data acquisition method - Google Patents

Description

  The present invention relates to a data delivery method for delivering data between systems and between applications.

  Data transfer includes data migration to convert data stored in a database to data that can be used in another database and migrate to another database. For example, when updating a system or changing an application It is necessary to convert data assets constructed by old systems and applications into data that can be used by new systems and applications for migration.

  For this reason, conventionally, there is provided a data migration method for converting data recorded in a database or the like in a predetermined format into another database format so that the data can be used in another database. For example, in Patent Document 1 below, data migration is performed in which the database data is migrated by performing conversion processing after grasping the correspondence relationship between the format of the migration source database and the format of the migration destination database. An apparatus and the like are disclosed.

  In addition, although it is a manual manual method, in the case of data linkage such as transferring records stored in one database between different systems or applications one by one to the other database, both applications Start up at the same time, copy necessary information from the records displayed in the window of the migration source application with the mouse, etc., and then paste it to the specified location in the window of the migration destination application. Data can be linked between different systems and applications by repeating manual operations.

  For example, in Patent Document 2 below, data is linked (transferred) between different applications via a clipboard (information temporary storage) by copying, cutting, and pasting processing using a pointing input device such as a mouse. Is disclosed.

JP 2003-288244 A JP 2003-330733 A

  However, in the data migration method disclosed in the above-mentioned Patent Document 1, if the record structure such as the item name, number of items, size, data format, etc. of the record stored in the source database is not accurately grasped, the data migration Can not do. Therefore, when migrating data, you need to create a migration program with the designer of the source database, or analyze the source code of the source database program to understand the data format. Cannot be performed, and the time and cost of data migration are large.

  If it is a database related to a large-scale system and there is no problem even if it costs a certain amount of migration cost, it is possible to spend this effort and cost, but in the case of a database related to a small-scale and inexpensive system, this It is not realistic to spend such time and effort. For this reason, there are cases where the database migration itself must be given up. In addition, if the source code is not disclosed and cannot be analyzed, data migration may not be performed.

  Further, in the data linkage method disclosed in Patent Document 2, it is not necessary to analyze the source code of the application, and data migration can be easily performed by copy and paste. One manual copy and paste is required. Therefore, it takes a lot of time to convert a large number of records, and this is not a practical method when the number of records is enormous.

  The present invention has been made in view of such problems, and there is no need to analyze software source code, etc., and a general-purpose data acquisition method capable of quickly transferring data between systems with simple processing An object of the present invention is to provide a data linkage method and a data migration method.

  A data delivery method according to the present invention for solving the above-described problem is a data delivery method for converting a delivery source record stored in a delivery source database and storing it in a delivery destination database in a computer including an arithmetic device and a storage device. In the method, the calculation device displays a delivery source record on a display device, and a mask in which the calculation device sets a display area of a predetermined item value in the record display window in association with the item name. The character recognition step of acquiring the text data of the item value by optically recognizing the image data extracted from the image of the display window of the delivery source record, and the computing device masks the text data. Stored in the storage device as general-purpose data associated with the item name of the item value set in Characterized in that it comprises a general-purpose data storage step, the to.

The data delivery program according to the present invention is a data delivery program for causing a computer provided with a storage device to perform a data delivery method for converting a delivery source record stored in a delivery source database and storing it in a delivery destination database. , a record display step of displaying on a display device delivery original record, by a mask that is set in association with the item name display area of the predetermined item values in the record display window, from the image of the display window of the delivery source record Character recognition process for acquiring text data of the item value by optical character recognition of the extracted image data, and general data associating the text data with the item name of the item value set in the mask A general-purpose data storage step for storing in the storage device; Characterized in that to.

The computer system according to the present invention is a computer system including an arithmetic device that performs various arithmetic operations, a storage device that stores a delivery source database and a delivery destination database, and a display device. and a record display control to display the original record to the display device, the mask which is set in association with the item name display area of the predetermined item values in the record display window, extracted from the image of the display window of the delivery source record The character recognition control for acquiring the text data of the item value by optically recognizing the image data, and the general data associating the text data with the item name of the item value set in the mask General-purpose data storage control stored in a storage device;
It is characterized by performing.

The general-purpose data acquisition method according to the present invention is a general-purpose data acquisition method for acquiring general-purpose data from a record displayed on a display in a computer including an arithmetic device and a storage device, and the arithmetic device comprises: and a record display step of displaying the records on the display, the arithmetic unit, the record display mask is set in association with the item name display area of the predetermined item values in the window, the previous sharp code A character recognition step of acquiring text data of the item value by optically recognizing the image data extracted from the image of the record display window, and the arithmetic unit is set with the text data as the mask General-purpose data storage for storing in the storage device as general-purpose data associated with the item name of the item value Characterized in that it comprises a and.

  According to the present invention, it is possible to easily deliver a delivery source record to a delivery destination system or application without having to check the data format of the delivery source. In addition, once the record of the delivery source is converted into general-purpose data, data can be delivered between various applications and systems.

FIG. 1 is a schematic diagram schematically showing the configuration of the data migration system according to the present embodiment. FIG. 2 is a flowchart showing a mask setting procedure according to this embodiment. FIG. 3 is a view showing a display window of records stored in the application A-DB according to the present embodiment. FIG. 4 is a diagram showing the setting contents of the mask X stored in the mask DB according to the present embodiment. FIG. 5 is a flowchart showing the flow of general-purpose data acquisition processing according to this embodiment. FIG. 6 is a diagram showing the contents of general-purpose data stored in the general-purpose data DB.

  Embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a schematic diagram schematically showing the configuration of the data migration system according to the present embodiment. As shown in FIG. 1, the data migration system 1 includes a computer main body 10, a display 20 that is a display device that displays output information from the computer main body 10, and a keyboard and a mouse for inputting information to the computer main body 10. And an input device 22.

The computer main body 10 has a CPU (Central
An arithmetic unit 11 such as a processing unit and an HDD (Hard Disc) for storing various information
And a storage device 12 including a RAM (Random Access Memory) used as a work area for arithmetic processing.

  The storage device 12 includes a program DB (database) 121 that stores applications to be described later and various programs for executing predetermined processing in the computer main body 10, an application A-DB 122 that stores a record of the application A, and will be described later. Are provided with a general-purpose data DB 123 for storing general-purpose data acquired from the record of application A, an application B-DB 124 for storing records of application B, and a mask DB 125 for storing a mask for acquiring general-purpose data. .

  In the present embodiment, data is transferred between different applications (application A and application B) in one computer, that is, records stored in the database A (DB-A) 122 of the application A. Is taken as an example to be transferred to the database (DB-B) 124 of the application B. Applications A and B are both applications for managing the address book database.

  In the present embodiment, a desired item value of a record of application A is converted into text by optical character recognition (OCR: Optical Character Recognition) from image data of a record display window in the display screen, and is thus stored in application B-DB 124. It is characterized by acquiring general-purpose data for migration. At this time, a mask is used to extract a display area of a desired item value from the image of the record display window.

  A procedure for creating this mask will be described with reference to the drawings. FIG. 2 is a flowchart showing a mask creation procedure according to the present embodiment, and FIG. 3 is a diagram showing a display window of one record stored in the application A-DB 122 according to the present embodiment. FIG. 4 is a diagram illustrating the setting contents of the mask X stored in the mask DB 125. In this embodiment, an example is given in which general-purpose data is acquired for the four items “name”, “name reading”, “company name”, and “e-mail” in FIG. explain.

  First, a user who performs data migration starts mask creation in a state where an application A that manages a migration source database and a migration application that performs processing for migration are activated. Programs for executing the application A and the migration application are stored in the program DB 121, and the application device A and the migration application are executed by the arithmetic device 11 executing these programs.

  After the start, in S10, the user operates the input device 22 to instruct the data migration system 1 to display a desired migration source record of the migration source application A-DB 122 as shown in FIG. Receiving the instruction, the computer main body 10 displays the migration source record on the display 20 when the arithmetic device 11 executes the program of the application A.

  In this state, the user activates the mask setting function of the migration application, and the mask setting process is started (S11). In the present embodiment, a case where the record display window is maximized and displayed over the entire display 20 will be described as an example.

  In S12, the migration application prompts the user to input the item name of the item to be migrated to the DB 124 of the application B from the plurality of items included in the displayed record of the application A. This guidance is presented, for example, by voice or display on the display 20. When the user inputs “name” as the item name to be initially set, the setting of the mask X is recorded in the mask DB 125.

  Subsequently, the process proceeds to S13, and the migration application guides the user to designate an area in which the item value of the item “name” is displayed. When the user operates the mouse which is the input device 22 and designates an area 51 (area surrounded by a dotted line in the figure) in which the item value of the item “name” in FIG. 3 is displayed, the designated area is displayed. The coordinate value is associated with the item name “name” and is recorded in the mask DB 125 as the setting of the mask X.

  Subsequently, in S14, the migration application inquires of the user as to whether or not the setting has been completed for all items. Such an inquiry is made, for example, by displaying “YES” and “NO” answer buttons together with the inquiry text on the screen. If the user replies that the process has not been completed yet, the process returns to S12, and S12 and S13 described above are performed again for the next item.

  Setting for all items is completed. In other words, in this embodiment, mask setting (area coordinates of item names and item values) for “name”, “name reading”, “company name”, and “e-mail” items is completed. That is, the area 52 is designated for the remaining item name “name reading”, the area 53 is designated for the item name “company name”, and the area 54 is designated for the item name “e-mail”. If the user replies to END, the process proceeds to S15.

  When the process proceeds to S15, the mask DB 125 stores the setting of the mask X as shown in FIG. Thus, as the item information of the mask X, the item name and the region coordinates are recorded in association with each item number.

  Next, in S15, the feature image in the record display window of the application A-DB 122 is designated. This feature image is data used to issue a warning when a desired item value is not displayed in the display window when performing character recognition, which will be described later, and the record display displayed in the record display window. Characteristic characters and figures that are part of the image and are always displayed on the record display image are stored as the feature image.

  As the feature image, for example, as illustrated in FIG. 3 surrounded by a dotted line, the name display area 61 of the application A, the display area 62 of the character “name” displayed at the upper end of the display column of the name list, A display area 63 of “record information”, a display area 64 in the form of a starting bracket consisting of a plurality of display characters, and the like are designated.

  As described above, if the feature image is set in association with the mask X, the record display window is reduced as compared with the mask setting and the feature image is not displayed on the display screen. By issuing a warning with a sound or the like, the window can be enlarged so that all desired item values are displayed in the record display window on the display screen.

  As shown in FIG. 4B, as feature image information, data of feature images (regions 61, 62, 63, 64) and region coordinates of feature images are recorded in association with each feature image number. As described above, when the feature image is designated in S15, the creation of the mask X is completed, and the setting information of the mask X shown in FIGS. 4A and 4B is stored in the mask DB 125.

  Next, the flow of general-purpose data acquisition processing for acquiring intermediate general-purpose data that can be transferred from the record in the database A to the database B will be described with reference to FIG. FIG. 5 is a flowchart showing the flow of general-purpose data acquisition processing.

  First, the user starts acquisition of general-purpose data after activating the application A and the migration application. After the start, in S20, the application A is executed according to the user's instruction, and the migration source record that the user desires to acquire the general-purpose data is displayed on the display 20. In this state, the user activates the general-purpose data acquisition function of the migration application, and general-purpose data acquisition processing is started (S21).

  In S22, the record display window on the display screen is captured and temporarily recorded in the storage device 12 as image data. Subsequently, in S23, the captured image (transfer source record display window) is confirmed using the feature image set in the mask X, and the window is reduced as compared with the record display window when the mask X is set. If a part of the feature image is not displayed, a warning announcement “Please increase the window size” is issued to the user to request correction such as enlargement of the window. Note that the calculation device 12 may be configured to automatically enlarge the record display window so that all feature images are displayed.

  Subsequently, in S24, for each item set in the mask X, an area coordinate image of each item value is extracted from the captured image and converted into text data by OCR (optical character recognition) processing. The converted text data of the item value is stored in the general data DB 123 of the storage device 12 as general data associated with the corresponding item name (S25).

  FIG. 6 is a diagram showing the contents of general-purpose data stored in the general-purpose data DB 123. The general-purpose data is stored in the general-purpose data DB 123 as tagged data in which each item name is attached as a tag to each item value converted into text. In the present embodiment, as shown in FIG. 6, the item value “trademark Koji” with the item name “name”, the item value “show leopard” with the item name “name reading”, the item name “company name” General-purpose data composed of an item value “B Corporation” with “” and an item value “shouhyou@bcomapny.com” with an item name “e-mail” is stored.

  Prior to storing the general-purpose data in the database, the acquired general-purpose data may be displayed on the display 20 so that the user can check the contents. If there is no correction, it is stored as it is according to the user's instruction. If there is a correction, the corrected general-purpose data manually corrected by the user is stored in the general-purpose data DB 123.

  Subsequently, the process proceeds to S26, where it is determined whether or not there is a next record for which general data is to be acquired. If there is, the process proceeds to S27, and if not, the general data acquisition process is terminated. This determination is automatically made based on whether or not n general-purpose data have been acquired, for example, if the number of records from which general-purpose data is acquired is set to n at the start of the general-purpose data acquisition process. Further, the migration application may make an inquiry to the user.

  In S27, the next transfer source record is displayed on the display 20. This display is realized by the migration application executing an action for displaying the next record in the application A. For example, if the application A is configured to display the next record when the down cursor key is pressed, the migration application outputs a down cursor key pressing signal to the application A in S27. The next record should be displayed.

  When the next transfer source record is displayed in S27, the process returns to S22, S22 to S25 are repeated again, and the general data of the next record is acquired and stored in the general data DB 123.

  The processing flow for acquiring general-purpose data from the record of the app A-DB 122 has been described in detail above, but the functions of the application A and the migration application described above are predetermined programs stored in the program DB 121 by the arithmetic device 11. It is realized by executing.

  Next, a process of converting the general-purpose data acquired from the record of the application A-DB 122 into a record that matches the format of the application B and storing it in the application B-DB 124 as a migration destination record will be described. As shown in FIG. 6, the general-purpose data has a data structure in which item names and item values are listed in a one-to-one relationship. Therefore, when the application B supports such standard data import, By simply importing the general-purpose data into the application B, the general-purpose data is converted into a record for the application B-DB 124 and recorded in the database, and the data migration is completed.

  If the record structure of the application B is known, the general-purpose data may be directly converted into data having the record structure of the application B and stored in the application B-DB 124. Such transfer of the general-purpose data to the application B may be incorporated as a function of the migration application in addition to the user instruction. At this time, the general-purpose data of all the records to be transferred may be acquired and then collectively passed to the application B, or may be configured to be passed to the application B every time the general-purpose data of one record is acquired. good.

  In the case of data linkage in which general-purpose data is transferred to the application B one by one, the application B is activated to display a record input screen, and the general-purpose data is displayed in the corresponding item value input field of the record input screen. What is necessary is just to create the program which inputs each item value of. In this case, item values that are not included in the general-purpose data and are necessary as records of the application B can be replenished and input on the input screen as they are.

  Although the present embodiment has been described in detail above, according to the present embodiment, general-purpose data composed of text data is acquired from the record display screen of the application A by OCR processing, so it is necessary to know the data structure of the application A The record of the application A-DB 122 can be easily transferred to the application B-DB 124.

  In addition, even when data is transferred between different systems, it is not necessary to set up a mask for general-purpose data acquisition. Data can be transferred between systems by simple processing at a low cost.

  In addition, if general-purpose data that can be easily imported into various databases is obtained in this way, data can be easily linked not only between applications A and B but also with other various applications and other systems via networks. It is possible to connect a plurality of systems easily at low cost.

  The embodiment of the present invention is not limited to the above embodiment, and various modifications can be made without departing from the gist of the present invention. For example, the mask setting process procedure and the general-purpose data acquisition process procedure in the above embodiment are merely examples, and it goes without saying that the order can be changed as appropriate.

  In the above-described embodiment, the case where data is transferred between applications running on one computer has been described. However, it is needless to say that the present invention can be applied to a case where data is transferred between systems connected via a network. . In this case, the function of the delivery application described above may be performed on one computer or may be performed in a distributed manner on a plurality of computers.

  Further, by using general-purpose data as in the present embodiment, not only one-to-one, but also data transfer between one-to-many applications and systems, and between many-to-many applications and systems is possible.

  In the above embodiment, the case where the display window of the record is maximized to fill the display screen has been described. However, the present invention can also be applied to the case where the display window is displayed on a part of the display screen.

  In the above embodiment, the case where one record is displayed in one display window has been described as an example. However, even when a plurality of records are displayed in one display window, the mask is not displayed. The present invention can be applied by setting the setting corresponding to a plurality of records.

  In the above-described embodiment, a case has been described in which a record that has been recorded as application A data is transferred to application B. However, even if a record is being input on the record input screen of application A, a record display window being input It is possible to acquire general-purpose data by capturing.

1 Data Migration System 10 Computer Main Body 11 Arithmetic Device 12 Storage Device 121 Program DB
122 Application A-DB
123 General-purpose data DB
124 application B-DB
125 mask DB
20 Display 22 Input device

Claims (6)

In a computer having an arithmetic device and a storage device, in a data delivery method for converting a delivery source record stored in a delivery source database and storing it in a delivery destination database,
The arithmetic unit displays a delivery source record on a display device, a record display step,
The arithmetic unit recognizes optical characters of image data extracted from the display window image of the delivery source record by using a mask in which a display area of a predetermined item value in the record display window is set in association with the item name. Thus, a character recognition process for acquiring text data of the item value,
A general-purpose data storage step in which the arithmetic device stores the text data in the storage device as general-purpose data associated with the item name of the item value set in the mask;
A data delivery method comprising: A transfer destination record storing step of converting the general-purpose data into a record in the format of the transfer destination database, and storing it in the transfer destination database as a transfer destination record;
2. The data delivery according to claim 1, wherein the record display step, the character recognition step, the general-purpose data storage step, and the delivery destination record storage step are repeated to deliver a plurality of delivery source records to the delivery destination database. Method.   In the mask, a feature image that is always displayed in the record display window is further set. Prior to the character recognition step, the arithmetic device may include a part of the feature image in the display window of the delivery source record. 3. The data delivery method according to claim 1, wherein control is performed so as to issue a warning when no is displayed. In a data delivery program for causing a computer equipped with a storage device to perform a data delivery method for converting a delivery source record stored in a delivery source database and storing it in a delivery destination database.
A record display process for displaying the delivery source record on the display device;
By recognizing the image data extracted from the image of the display window of the delivery source record by optical character recognition using the mask that is set in association with the item name of the display area of the predetermined item value in the record display window, the item concerned A character recognition process for obtaining text data of values;
A general-purpose data storage step of storing the text data in the storage device as general-purpose data associated with the item name of the item value set in the mask;
A data delivery program characterized by causing a computer to execute. In a computer system comprising an arithmetic device that performs various calculations, a storage device that stores a delivery source database and a delivery destination database, and a display device,
The arithmetic unit is:
Record display control for displaying a delivery source record on the display device;
By recognizing the image data extracted from the image of the display window of the delivery source record by optical character recognition using the mask that is set in association with the item name of the display area of the predetermined item value in the record display window, the item concerned Character recognition control to obtain the text data of the value,
General-purpose data storage control for storing the text data in the storage device as general-purpose data associated with the item name of the item value set in the mask;
The computer system characterized by performing. A general-purpose data acquisition method for acquiring general-purpose data from a record displayed on a display in a computer including an arithmetic device and a storage device,
The arithmetic unit displays a record on the display, a record display step;
Optical the arithmetic apparatus, the record display mask is set in association with the item name display area of the predetermined item values in the window, the image data extracted from the image of the record display window before sharp code By recognizing characters, a character recognition step of acquiring text data of the item value,
A general-purpose data storage step in which the arithmetic device stores the text data in the storage device as general-purpose data associated with the item name of the item value set in the mask;
A general-purpose data acquisition method comprising:

Images