JPH06149636A - Conversion system for data base using program - Google Patents

Abstract

PURPOSE:To automatically change a program for using an objective data base (DB) by providing this conversion system with a means for detecting a DB operating instruction sentence, a parameter extracting means, a means for allowing the system to correspond to the parameter format of a data base to be newly operated, and a means for rewriting a data base using program based upon the correspondence. CONSTITUTION:A DB operating instruction detecting part 1 monitors an instruction sentence to be executed next by a main control part 7 during the execution of processing in the control part 7, and at the time of detecting a DB operating instruction sentence, transfers the detected sentence to a table name/item name extracting part 2. Extracted table and item names are applied to a DB using program rewriting part 3. The rewriting part 3 refers to a table name/item name correspondence table 4 and substitutes the table name and respective item names so as match them with the data base. The control part 7 outputs a command to a DB management system 9 in accordance with the rewritten DB operating instruction sentence.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database for making database utilization programs of various database systems available to other database systems without depending on the tables and items of the databases handled by the database system. The present invention relates to an automatic conversion system for use programs.

[0002]

2. Description of the Related Art Conventionally, a program for using a database system is described assuming a target database, and the item name and table name of the database are described in the program. For example, SQL, a standard relational database search language
When using, the database search part of the database usage program describes select name from automobile where vehicle body weight> 2000. Here, "car" is the table name of the database, and "name" and "body weight" are
It is an item name of the table "car". The database utilization program executes this statement, searches the database to extract the necessary data, substitutes it into the variables in the program, and performs the processing using the data. If the parameter format of the target database, that is, the table name, item name, table configuration, etc., is different, a database utilization program is required for each. Regarding this, for example, informix-E
SQL / C Programmer's Manual (ASCII, Inc., 1)
The description in 991) can be referred to.

[0003]

Since the databases are constructed individually as necessary, the table names and item names are different between the databases, and the table structures are also different. Therefore, even if an application program of another database is applied to a certain database, at present, the database application program largely depends on the database to be used, and therefore the program must be manually modified. For example, the above SQL statement "select name from car where body weight>2000" cannot be executed unless the table "car" exists in the target database and "name" and "body weight" are the items of the table. . Therefore, even if data that means the same is written in the target database in the items “vehicle type” and “weight” of the table “car”, the table name and the item name of the SQL statement parameters Due to the difference, this database usage program cannot be used. Therefore, it is necessary for a person to read the program and rewrite the relevant part such as select vehicle type from vehicle where weight> 2000. As the size of the program grows, this task becomes cumbersome and inaccurate. The present invention has been made in view of the above circumstances, and an object of the present invention is to solve the above-mentioned problems in the related art and to automatically change a database use program according to a target database. It is to provide an automatic conversion system of a used program.

[0004]

The above objects of the present invention are as follows:
A database usage program conversion system for enabling a database usage program to be shared between a plurality of databases, a means for detecting a database operation statement in an arbitrary database usage program, and a database operation instruction detected by the means. Parameter extraction means for extracting a database-specific parameter that the database utilization program has operated from the statement, and the parameter format extracted by the means is associated with the parameter format of the database that the database utilization program is about to newly operate. And a means for rewriting the database using program based on the correspondence by the means.

[0005]

In the automatic conversion system for the database using program according to the present invention, the terms used in various databases as table names and item names are associated with synonyms (for example, "automobile" and "car" are synonymous). And
Can be replaced) or an alternative relationship based on the meaning of the value of each item (for example, the value of the item "width" is the product of the values of the items "depth", "width", and "height"). To replace the database usage program by appropriately rewriting the parameters in the command statement for operating the database in the database usage program based on that knowledge to match the database being handled. Has been realized.

[0006]

Embodiments of the present invention will now be described in detail with reference to the drawings. FIG. 1 is a block configuration diagram of a database system including a database (hereinafter, also referred to as “DB”) use program automatic conversion system according to an embodiment of the present invention. In the figure, reference numeral 1 denotes a DB operation command statement detection unit that detects a command statement portion for operating a database from a database utilization program stored in the storage device 8. In the DB operation command statement in the database utilization program, for example, in the ANSI standard, as shown in FIG. 5, a keyword "EXEC SQL" is written at the beginning of the statement. The DB operation command statement detection unit 1 detects the DB operation command statement by discriminating this keyword. Reference numeral 2 is a table name / item name extraction unit that extracts a table name or an item name that is a parameter from the command sentence detected by the DB operation command sentence detection unit 1. The table name / item name extraction unit 2 has information about reserved words of DB operation command statements and parameter delimiters such as “,”, and extracts table names / item names by extracting other information. Three
Is a DB use program rewriting unit that rewrites an executable program by replacing the table name or item name extracted by the table name / item name extraction unit 2 so as to match the target database.

Reference numeral 4 is a table name / item name correspondence table showing the correspondence between table names and item names in the program. In the present embodiment, this table name / item name correspondence table 4 is given in advance. It is assumed that The above table name / item name correspondence table 4 is created in the following procedure. First, a word used as a table name or an item name in the program is extracted from the DB use program by a method similar to that of the DB operation command statement detection unit 1 and the table name / item name extraction unit 2 described above. Next, the table name and item name of the database are extracted from the schema information of the database. Mutual correspondence is performed by using a thesaurus. For items that cannot be related only by a thesaurus, such as when a certain item is substituted by multiple items, the relationship is manually established. By the above operation,
A table name / item name correspondence table 4 as shown in FIG. 4 is created. The DB use program automatic conversion system according to the present embodiment includes the above-described four blocks.

Reference numeral 5 is an input device for the user to operate the system, 6 is an output device for presenting necessary information to the user, and the result of the operation is output, and 7 is for controlling the operation of the entire system. A main control unit, 8 is a storage device for storing programs and information input by the user, 9 is a database management system (hereinafter referred to as “DBMS”) for operating a database in accordance with an instruction from the main control unit,
Reference numeral 10 is a database that stores various data. FIG. 2 shows one of the tables of the database assumed when describing the program stored in the storage device 8 shown in FIG. The table name is "passenger car", and has items such as "vehicle type", "interior area", "weight", "price", and the like. Further, FIG. 3 shows one of the tables stored in the database 10 in FIG. The table name is "car" and has items such as "name", "indoor length", "indoor width", "indoor height", "body weight", "price", and the like. FIG. 4 shows an example of the table name / item name correspondence table 4 in FIG. 1, and describes the correspondence relationship between the table names and item names between the database tables shown in FIGS. There is something.

Further, FIG. 5 shows a part of a program stored in the storage device 8 in FIG. 1, particularly a part of an instruction for operating a database. FIG. 6 is an operation flowchart of the database use program automatic conversion system according to the present embodiment. The DB operation command statement detection unit 1 of the DB use program automatic conversion system according to the present embodiment
Reads the command statement to be executed next by the main control unit 7 from the DB use program stored in the storage device 8 (step 101), and determines whether or not there is a DB operation command statement (step 102). If it is not a DB operation command statement, the main control unit 7 is instructed to execute the command as it is.
(Step 106). If it is a DB operation command statement, the table name / item name extraction unit 2 extracts the table name or item name from the command statement (step 103). Then D
The B use program rewriting unit 3 uses the table name / item name correspondence table 4 to associate the table name in the program with the item name in the database 10 (step 104). A DB operation command statement that is replaced with the item name is created, and the main control unit 7
Then, the main control unit 7 is prompted to execute the statement (step 106). If the program is not finished, read the next statement to be executed.
(Step 107).

In the following, regarding the database system provided with the automatic database use program conversion system according to the present embodiment shown in FIG. 1, a system for outputting information on vehicles satisfying a user's desired condition will be described as an example. The operation will be described. First, when the system is activated, the main control unit 7 starts processing according to the program stored in the storage device 8. Next, the output device 6 prompts the user to input conditions. The user inputs the condition using the input device 5. When the input is completed, the main control unit 7 continues the process. The DB operation command statement detecting unit 1 monitors the command statement to be executed next by the main control 7 while the main control unit is executing the process. When the DB operation command statement is detected, the DB operation command statement is detected. , Table name / item name extraction unit 2. In the program illustrated in FIG. 5, "EXEC SQL select vehicle type from passenger car where price <: yosan" and "EXEC SQL select vehicle type from passenger vehicle where room size <: hirosa" are passed. The table name / item name extraction unit 2 extracts the table name and item name in the DB operation command statement. Here, "vehicle type", "passenger car", "price", "indoor size", etc. are extracted.

Since the program illustrated in FIG. 5 is written assuming the database in FIG. 2, the table names and item names extracted here are those in the database in FIG. The database 10 is different from the database shown in FIG. For this reason,
Even if this statement is given to the DBMS 9, the database search is not successful. Here, the extracted table name and item name are given to the DB use program rewriting unit 3.
The DB use program rewriting unit 3 refers to the table name / item name correspondence table 4 shown in FIG. 4, and replaces the table name and each item name so as to match the database of FIG. Here, the table name "passenger car" is replaced with "automobile", and the item name "vehicle type" is replaced with "name" showing the same content. Also, the item showing the same content as the item "indoor size" in Fig. 2 is not in the database in Fig. 3, but in contrast to this, "indoor length * indoor width * indoor height * ^10-9 , “Indoor length”, “indoor width”, and “indoor height”. Here, the unit conversion is also performed by multiplying by 10 ^-9 .

As a result, by the DB use program rewriting unit 3, the above-mentioned DB operation command statements are executed as follows: EXEC SQL select name from car where price <: yosan or EXEC SQL select name from car where room length * room width * Indoor height * ^10-9 <Rewritten as: hirosa. The rewritten DB operation command statement is passed to the main control unit 7, and the main control unit 7 continues the processing. The main control unit 7 follows D according to the rewritten DB operation command statement.
A command is issued to the BMS 9, and the DBMS 9 uses the database 10
Is operated to return necessary data to the main control unit 7. The main controller 7 stores the data in the storage device 8 and continues the process. When the series of processing is completed, the result is provided to the user by the output device 6. As described above, according to this embodiment, a database use program written for another database can be easily transferred to a system having another database.

It is needless to say that the above embodiment shows one example of the present invention, and the present invention is not limited to this. For example, in the description of the above embodiment, the table name / item name correspondence table is given in advance. However, this is to detect the table name / item name in the program at the time of processing execution, and at any time to create a synonym dictionary. It is also possible to create it dynamically while referring to it. If the synonym dictionary alone cannot be used for the matching, the morphological analysis is used to divide the “body weight” into “body” and “weight”, and a method such as searching for a synonym of “weight” is used. It is also possible to do so. Furthermore, instead of the table name / item name correspondence table shown in the above embodiment, an intelligent system that can understand more general synonyms and synonyms and can understand the relationship between various items can be used. It goes without saying that the same effect can be obtained.

[0014]

As described above in detail, according to the present invention, it is possible to realize a database conversion program automatic conversion system for automatically changing a database usage program according to a target database. Is played.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of a database system including a database utilization program automatic conversion system according to an embodiment of the present invention.

FIG. 2 is an example of a database table assumed when describing a program stored in a storage device 8 shown in FIG.

FIG. 3 is an example of a table stored in a database 10 in FIG.

FIG. 4 is an example of a table name / item name correspondence table 4 shown in FIG.

5 is a part of a program provided to the system shown in FIG.

FIG. 6 is a flowchart showing an operation of a part related to the present invention in the system shown in FIG.

[Explanation of symbols]

1: DB operation command statement detection unit, 2: Table name / item name extraction unit, 3: DB use program rewriting unit, 4: Table name / item name correspondence table, 5: Input device, 6: Output device, 7: Main Control unit, 8: storage device, 9: DBMS, 1
0: database.

Claims (2)

[Claims] 1. A database utilization program conversion system for sharing a database utilization program among a plurality of databases, comprising means for detecting a database operation command statement in an arbitrary database utilization program, and said means. Parameter extracting means for extracting a database-specific parameter that the database using program has operated from the detected database operating command statement, and a database for which the database using program newly intends to operate the parameter format extracted by the means. And a means for associating the database use program with the parameter format, and a means for rewriting the database use program based on the correspondence by the means. 2. A means for associating the parameter format extracted by the parameter extracting means with the parameter format of the target database, uses the table name / item name which is the parameter in the database operation command statement and the table name / item name in the program. The database utilization program conversion system according to claim 1, wherein the conversion system is provided as a table showing a correspondence relationship.