JP2010123017A - Database apparatus - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To obtain a database apparatus capable of improving development efficiency of a new system, a remodeled system, or the like by enabling the new system that is newly developed to obtain data of a data providing device that continues update in a general purpose query language. <P>SOLUTION: The database apparatus includes: a data acquiring part 31 for managing data in a flat data file 11, acquiring data of a data query language A being a form unique to the data providing device 1 from the data providing device 1 which can notify the outside of data update, and converting the obtained data into a form in which the obtained data can be provided in a data query language SQL; a relational database part 32 for storing data converted by the data acquiring part 31; and an update notification receiving part 33 for receiving the notification of data update notified by the data providing device 1 to be able to control timing when the data acquiring part 31 obtains data. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a database apparatus for improving development efficiency in the development of a new system using a data providing apparatus that provides data in a unique data inquiry language installed on a computer network.

  Systems on a computer network often require modifications such as adding functions and linking with other systems even after the system has been installed.

  However, in a system existing on such a network, particularly an old system, there is a data providing apparatus that accumulates data in a flat data file and provides the data in a unique data inquiry language. When developing a new system that cooperates with such an old system, it is necessary to develop a new system or modify the old system in accordance with a unique data query language.

  For example, in a new system in which data is acquired using a query language SQL (Structured Query Language) widely used for accessing a relational database management system (RDBMS: Relational Data Base Management System), the old system has SQL. A method of installing a data processing system that converts to a unique data query language is disclosed. (For example, see Patent Document 1)

  In addition, a data conversion method and a data file conversion apparatus are disclosed in which data is efficiently transferred to an RDBMS when an obsolete database server is replaced. (For example, see Patent Document 2)

JP 2001-350656 A (pages 6 to 11, FIGS. 1 to 6) JP 2000-347907 A (page 3 to page 7, FIGS. 1 to 5)

  However, in the new system of the above-mentioned Patent Document 1, converting the SQL to the original query language of the old system so as to support all the functions provided by SQL increases the development scale of the data processing system. However, there was a problem that the development efficiency deteriorated.

  In addition, the data conversion method and data file conversion apparatus disclosed in Patent Document 2 have a conversion capability, but do not have an RDBMS and cannot respond to an inquiry by SQL from outside. In addition, since it is necessary for the user to give an execution instruction when exchanging the database server, there is a problem that it is difficult to continuously execute data conversion at regular intervals or every update of the database server.

  The present invention has been made in order to solve the above-described problems. A newly developed new system or a modified system can acquire data of a data providing apparatus that is continuously updated by using an inquiry language SQL. An object of the present invention is to obtain a database device that can improve the development efficiency of a system or a modified system.

A database apparatus according to the present invention is a database apparatus connected to a data providing apparatus that provides data in a data inquiry language that is in a unique format,
A data acquisition unit that acquires data from the data providing device in a data query language that is in the unique format, and converts the acquired data into a format in a general-purpose data query language;
A database unit that stores the data converted by the data acquisition unit and can acquire data by the general-purpose data inquiry language;
The data acquisition unit includes a data acquisition control unit that controls the timing of acquiring data.

The database device according to the present invention is a database device connected to a data providing device that provides data in a data query language that is in a unique format,
A data acquisition unit that acquires data from the data providing device in a data query language that is in the unique format, and converts the acquired data into a format in a general-purpose data query language;
A database unit that stores the data converted by the data acquisition unit and can acquire data by the general-purpose data inquiry language;
A data providing apparatus for providing data in a data inquiry language in which the new system or the remodeling system has a unique format by including a data acquisition control unit that controls the timing at which the data acquisition unit acquires data. Since data can be acquired using a general-purpose data query language, the development efficiency of a new system or a modified system can be improved.

  Embodiments of the present invention will be described below with reference to the drawings.

Embodiment 1 FIG.
1 is a block diagram of a system including a database apparatus according to Embodiment 1 of the present invention.
In FIG. 1, the data providing apparatus 1 includes a flat data file 11 that is a data file for storing data, a data providing unit 12 for providing the contents to the outside, and data collection for updating the flat data file 11. It has part 13. The data providing unit 12 provides data to the outside of the apparatus using the data inquiry language A that is a unique format. The data collection unit 13 is connected to the external system 2, collects data from the external system 2 at the processing end timing of the external system 2 and at regular intervals, and updates the flat data file 11. Further, the data collection unit 13 has a function of notifying a data update process outside the apparatus at a timing when the flat data file 11 is updated.

  The database device 3 which is a part according to the present invention acquires data from the data providing device 1 by the data query language A, converts the acquired data into a format provided by the data query language SQL, The relational database unit 32 that is a database unit that stores the data converted by the acquisition unit 31 and the update notification reception that is a timing control unit that controls the timing of operating the data acquisition unit 31 by acquiring the data update notification of the data providing apparatus 1 The unit 33 is provided.

  The data acquisition unit 31 makes a data inquiry to the data providing unit 12 when there is an operation request from the update notification receiving unit 33, converts the acquired data to match the table structure of the RDBMS unit 32, and converts the RDBMS unit 32. The RDBMS unit 32 provides the stored data in the data inquiry language SQL to the accessed new system 4. In the first embodiment, a table structure such as a primary key and column contents is determined in advance, and the data acquisition unit 31 is designed.

Next, the operation will be described.
FIG. 2 is a flowchart showing a process flow of the database apparatus according to the first embodiment of the present invention.
First, the data collection unit 13 collects data of the external system 2 and updates the flat data file 11. When the flat data file 11 is updated, the data update apparatus 1 is notified of the data update. In the database device 3, the update notification receiving unit 33 notified of the data update from the data providing device 1 makes an operation request to the data acquisition unit 31 in step ST <b> 11.

Next, in step ST12, the data acquisition unit 31 that has received the request makes a data inquiry to the data providing unit 12 using the data inquiry language A, and acquires the contents of the flat data file 11 collectively. In step ST13, the acquired data is converted into a format provided by the data query language SQL and stored in the RDBMS unit 32. As a result, the contents of the RDBMS unit 32 are equivalent to the flat data file 11.
Then, the new system 4 can use the data query language SQL to access the RDBMS unit 32 of the database device 3 and acquire data equivalent to the content recorded in the flat data file 11 from the database device 3. it can.

As described above, according to the first embodiment, the RDBMS unit 32 is provided in the database device 3, and the data acquisition unit 31 converts the old system data into a format that can be provided in the data query language SQL. Since the data is stored, the data query language SQL widely used can provide data equivalent to the data of the old system via the database device 3, and the data of the data providing device 1 of the old system is used. The development efficiency of the new system 4 can be improved.
The new system 4 that accesses the database device 3 may not be a newly developed system, but can also be applied to a system that uses data managed by the data providing device 1 by modifying an existing system. The data providing apparatus 1 may store data in a format other than a flat data file. A general-purpose data inquiry language other than SQL may be used. The general-purpose data inquiry language is a standard data inquiry language that is often used without limiting the database to be used.

  In addition, an update notification receiving unit 33 that receives an update notification of the data providing apparatus 1 that continues to update data is provided, and the update notification receiving unit 33 makes an operation request to the data acquisition unit 31 when the data update is notified. As a result, the data of the old system can be converted and stored in the RDBMS unit 32 so that it can be accessed by SQL without human intervention.

  Further, when the data access frequency required by the new system 4 is larger than the data access frequency assumed by the data providing device 1 which is an old system, the database device 3 makes a data inquiry from the new system 4. Therefore, the problem that the processing performance of the data providing device 1 is insufficient can be avoided.

Embodiment 2. FIG.
FIG. 3 is a block diagram of a system including a database apparatus according to Embodiment 2 of the present invention.
In the first embodiment, the example in which the contents of the flat data file 11 are acquired at once has been described. In the second embodiment, the update data portion 111 such as addition, change, or deletion in the flat data file 11 can be specified by the data update time, the data ID, or the like. In this case, only the specified update data portion 111 is acquired. For example, as shown in FIG. 3, a difference data acquisition unit 34 is provided. After the data acquisition unit 31 acquires from the data providing device 1 and stores the acquired data in the RDBMS unit 32, the difference data acquisition unit 34 acquires the data acquisition unit 31 at the time of data update of the data providing device 1. The difference between the data and the data that the data acquisition unit 31 has at that time is acquired by the data query language that is a unique format, and the update data portion 111 is acquired and stored in the RDBMS unit 32.

  According to the second embodiment, when the update data portion 111 in the flat data file 11 can be specified by the data update time or the data ID, only the specified update data portion 111 is acquired. The data to be processed is limited, and the processing load for data acquisition can be reduced.

Embodiment 3 FIG.
FIG. 4 is a block diagram of a system including a database apparatus showing Embodiment 3 of the present invention.
In the second embodiment, the RDBMS unit calculates the difference between the data acquired by the data acquisition unit 31 at the time of data update of the data providing device 1 by the differential data acquisition unit 34 and the data included in the data acquisition unit 31 at that time. As shown in FIG. 4, the addition / change data for storing only the data added to the flat data file 11 and the changed data in the RDBMS unit 32 as shown in FIG. An acquisition unit 39 may be provided so that data deleted from the flat file data 11 is not deleted from the RDBMS unit 32. The addition / change data acquisition unit 39 is a kind of difference data acquisition unit.

  According to the third embodiment, the database device 3 holds the data deleted in the data providing device 1 due to the limitation of the data capacity that can be recorded, and more data is stored in the new system 4. There is an effect that it can be provided.

Embodiment 4 FIG.
In the fourth embodiment, the data providing apparatus 1 updates data at a predetermined cycle, and the data acquisition control obtaining unit 31 grasps the data update timing in the data providing apparatus 1, and the data providing apparatus The data acquisition unit 31 is activated to acquire data in synchronization with the data update cycle 1.

FIG. 5 is a block diagram of a system including a database apparatus showing Embodiment 4 of the present invention.
In the first to third embodiments, the example in which the data acquisition unit 31 is operated by the data update notification provided to the outside from the data providing apparatus 1 has been described. However, in FIG. In order to do so, a timer unit 35 is provided in the database device 3, and the timer unit 35 operates the data acquisition unit 31 in synchronization with the operation of the data collection unit 13. The timer unit 35 is a kind of data acquisition control unit.

  According to the fourth embodiment, when the data collection unit 13 operates at a regular cycle, the data acquisition unit 31 operates at a regular cycle by the timer unit 35, so that the database device 3 delays the data of the data providing device 2 It can be updated without.

Embodiment 5 FIG.
FIG. 6 is a block diagram of a system including a database apparatus according to Embodiment 5 of the present invention.
In the first to fourth embodiments, the case where the flat data file 11 is updated only by the data collection unit 13 has been described. In the fifth embodiment, as shown in FIG. 6, the data providing apparatus 1 includes a data change processing unit 14 that receives a data change request from the outside such as the new system 4 and updates the flat data file 11. is there. In this case, when the database device 3 includes the data change detection unit 36, for example, when there is a data change request from the outside such as the new system 4 that notices that correct data is not obtained due to a failure of the external system 2. When the database device 3 receives an external data change request, the data change detection unit 36 detects the database trigger or the like, updates the RDBMS unit 32, and updates the updated content from the data change detection unit 36 through the data change processing unit 14. It can transmit to the provision apparatus 1 and the content of the RDBMS part 32 and the flat data file 11 can be synchronized.

  As described above, according to the fourth embodiment, the database apparatus 3 can provide the new system 4 with a data update function based on SQL, and can transmit changes in the RDBMS unit 32 to the data providing apparatus 1. FIG. 6 shows an example in which the data change processing unit 14 is provided in FIG. 1 (the first embodiment), but in FIGS. 3 to 5 (the second to fourth embodiments), the data change processing unit 14 is provided. Can be provided.

Embodiment 6 FIG.
7 and 8 are block diagrams of a system including a database apparatus according to Embodiment 6 of the present invention.
In the first to third embodiments, when the data acquisition unit 31 is operated by the data update notification provided from the data providing apparatus 1 to the outside, the fourth embodiment is synchronized with the update period of the data providing apparatus 1. In the sixth embodiment, as shown in FIG. 7, the restart processing of the database device 3 is further detected and an operation request is made to the data acquisition unit 31. A recovery processing unit 37 is provided, and the RDBMS unit 32 is updated without waiting for an update notification from the data collection unit 13.

  Further, as shown in FIG. 8, when the difference data or the update data portion 111 between the RDBMS unit 32 and the flat data file 11 during the period when the database device 3 is stopped can be determined, in addition to the recovery processing unit 37 By providing the recovery data acquisition unit 38 and reflecting only the update data portion in the RDBMS unit 32, the time until the database device 3 is recovered can be further shortened.

  As described above, according to the sixth embodiment, when the database device 3 that has been temporarily stopped due to a failure or the like is restarted and the data update is restarted, the data update notification is performed. Since the update process of the RDBMS unit 32 can be started without waiting, the time until the database device 3 is restored can be shortened.

  In the sixth embodiment, an example in which the restoration processing unit 37 is provided in FIGS. 1 to 4 (Embodiments 1 to 3) is shown, but the restoration process is shown in FIGS. 5 and 6 (Embodiments 4 and 5). The part 37 can also be provided.

1 is a block diagram of a system including a database device according to Embodiment 1 of the present invention. It is a flowchart which shows the flow of a process of the database apparatus by Embodiment 1 of this invention. It is a block diagram of the system containing the database apparatus which shows Embodiment 2 of this invention. It is a block diagram of the system containing the database apparatus which shows Embodiment 3 of this invention. It is a block diagram of the system containing the database apparatus which shows Embodiment 4 of this invention. It is a block diagram of the system containing the database apparatus which shows Embodiment 5 of this invention. It is a block diagram of the system containing the database apparatus which shows Embodiment 6 of this invention. It is a block diagram of the system containing the database apparatus which shows Embodiment 6 of this invention.

Explanation of symbols

1 data provision device, 2 external system, 3 database device, 4 new system,
11 flat data file, 12 data provider, 13 data collector,
31 data acquisition unit, 32 relational database unit, 33 update notification receiving unit,
34 difference data acquisition unit, 35 timer unit, 36 data change detection unit,
37 recovery processing unit, 38 recovery data acquisition unit, 39 addition / change data acquisition unit.

Claims (8)

A database device connected to a data providing device that provides data in an original format data query language,
A data acquisition unit that acquires data from the data providing device in a data query language that is in the unique format, and converts the acquired data into a format in a general-purpose data query language;
A database unit that stores the data converted by the data acquisition unit and can acquire data by the general-purpose data inquiry language;
A database apparatus comprising: a data acquisition control unit that controls a timing at which the data acquisition unit acquires data. The data providing device can notify the outside of data update,
The data acquisition control unit activates the data acquisition unit to acquire data when the data acquisition control unit receives a data update notification notified by the data providing device. The database device described in 1. After the data acquisition unit acquires data, when the data acquisition control acquisition unit receives a data update notification notified by the data providing device, the data acquired by the data acquisition unit, and the data acquired at that time The difference between the data provided by the data providing device is acquired by a data query language that is the above unique format, and the difference data acquisition unit that converts the acquired difference data into a format in a general-purpose data query language,
The database apparatus according to claim 2, wherein the database unit stores data converted by the difference data acquisition unit. The database apparatus according to claim 3, wherein the difference data acquisition unit acquires only additional data and change data among update data of the data providing apparatus. 5. The database device according to claim 3, further comprising a recovery processing unit that makes an operation request for the difference data acquisition unit when a startup process of the database device is detected. The data providing apparatus updates data at a predetermined cycle,
The data acquisition control unit grasps the data update timing in the data providing device, and activates the data acquisition unit to acquire data in synchronization with the data update cycle of the data providing device. The database apparatus according to claim 1. 7. The database device according to claim 2, further comprising a recovery processing unit that makes an operation request for the data acquisition unit when a startup process of the database device is detected. The data providing apparatus includes a data change processing unit that processes a data change request from the outside,
A data change detection unit that enables updating of the database unit from the outside, detects an update from the outside of the database unit, and transmits the detected update content to the data providing device. The database device according to any one of claims 1 to 7.

Images