KR940001879B1 - Apparatus for database access - Google Patents

Abstract

No content.

Description

Database Query Processing Unit

1 is a block diagram showing an embodiment of a database query processing apparatus according to the present invention.

2 is a block diagram showing an example of a conventional database inquiry processing apparatus.

3 is a diagram showing an example of the contents of a relational database.

4 is a diagram showing an example of the configuration of an object for database access.

5 is an inquiry processing procedure of the database inquiry processing apparatus of FIG.

* Explanation of symbols for main parts of the drawings

10, 110: input device 20, 120: database inquiry processing device

30, 130: inquiry interpretation means 31: inquiry comparison means

32: object selection means 33, 131: inquiry interpretation means

34, 132: object generation means 40, 140: object conversion means

50, 150: database access means 60, 160: database

The present invention relates to a database inquiry processing apparatus which receives an inquiry into a database and executes the analysis, execution, and response of the inquiry as a series of processes.

In an information processing apparatus, an operator inputs an inquiry command from a terminal device, or a program inputs an inquiry command stored on a magnetic disk, so that specific data in a database can be directly searched for and read or updated. There is a case.

In this way, an apparatus for inputting a database inquiry command, directly executing an inquiry, and immediately responding to the result of the inquiry is referred to as a "database inquiry processing apparatus".

2 is a block diagram showing an example of the configuration of a conventional database inquiry processing apparatus.

In the figure, when a database inquiry command is input from an input device 110 such as a terminal device, the database inquiry processing apparatus 120 receives the database inquiry command and accesses the database 160. Device. The database inquiry processing apparatus 120 includes an inquiry analyzing means 130 as the inquiry analyzing means 131 and an object generating means 132, an object changing means 140, and a database access means 150. It is comprised by.

Here, the inquiry analyzing means 131 analyzes the inquiry about the database inquiry command from the input device 110 and performs a syntax check. The object generating means 132 generates an object from the inquiry analyzed by the inquiry analyzing means 131. The object converting means 140 converts the object generated by the object generating means 132 into an executable object while referring to database definition information, data structure information, and the like. The data access means 150 accesses the database 160 in accordance with the executable object from the object converting means 140.

The configuration of the input database query command and the objects created therefrom will be described taking a relational database as an example. Here, the relational database is a database in which a plurality of tabular data can be searched and updated using various keys, and the data set to be accessed can be identified by the table name or column name. As an example of this relational database, table data called an employee management table is shown in FIG. This table is composed of the names, employees' numbers, ages, affiliations of employees, and data of various employees corresponding to respective columns.

For example, to search a relational database of this type, enter the following inquiry command:

SELECT statement

FROM Employee Management Table

WHERE age <30

By inputting the above inquiry command into the database inquiry processing apparatus 120 and executing an inquiry command as this database inquiry processing apparatus 120, the name data of the employee whose age is less than 30 years old is taken out.

Next, Fig. 4 shows the configuration of the object for relational database access.

The object 70 includes an object type 71 for identifying whether it is executable, an access target column information 72 for searching and updating, and a table for identifying the tables and columns referred to in the query. Identification information 73, column identification information 74, inquiry condition 75, data conversion information 76 referenced to perform data conversion, and access path information used for determining the access order of the table; It is comprised as 77.

In the conventional database inquiry processing apparatus 120, each time an inquiry is received, the inquiry is interpreted by the inquiry analyzing means 130 and the object is converted by the object converting means 140, regardless of the inquiry executed previously. The conversion process is performed, and the database is being accessed.

However, in such database inquiry processing, the following inquiry is often executed by changing a part of the immediately preceding inquiry.

For example, consider a case where the database inquiry command as shown below is sequentially executed to the employee management table described above.

Database query command 1

SELECT COUNT (*)

FROM Employee Management Table

WHERE age <30

Database Lookup Command 2

SELECT statement

FROM Employee Management Table

WHERE age <30

The database inquiry command 1 is an inquiry for knowing how many employees are under 30 years old, and the database inquiry command 2 is an inquiry for knowing the names of employees who are under 30 years old. The operator checks how many data are retrieved using the database inquiry command 1, determines the display form and output order of the corresponding data, executes the database inquiry command 2, and retrieves the actual data. . At this time, in the database inquiry command 2, although the part of "FROM assertion, WHERE age <30" is completely the same content as that of the database inquiry command 1, the inquiry analysis process by the inquiry analysis means 130, and The object conversion process by the object conversion means 140 is executed.

In this similar data inquiry processing, since the processing is repeatedly performed from the beginning even if the parts of the same contents are the same, the inquiry processing takes time, and the response performance of the database inquiry processing requiring high responsiveness is degraded. I'm making it.

It is therefore an object of the present invention to provide a database inquiry processing apparatus having a high speed database inquiry processing capability.

The present invention provides a database inquiry processing apparatus for inputting a database inquiry command from an input device, interpreting the inquiry command to generate an executable object, and accessing a database using the executable object. A query comparison means for inputting a database inquiry command and comparing it with a previously executed inquiry command; and as a result of the comparison by this inquiry comparison means, the entire database inquiry command is compared with the previously executed inquiry command. If it is the same, the already created executable object is selected in the late accumulation means, and if the above database inquiry command and the part of the previously executed inquiry command are the same, the object corresponding to the same part is later described. The object selecting means selected from the accumulating means, Inquiry analysis means for parsing all or part of the above-mentioned inquiries of the database inquiry command that are relatively inconsistent by the inquiry time comparison means, and checking grammatical errors and the like. Object generating means for generating or synthesizing the object selected by the object selecting means described above with this object to generate a new object, object converting means for converting the object generated as the object generating means into an executable object, and data Storage means for associating and storing the base inquiry command with the object generated by the object generating means and the executable object generated by the object converting means, the executable object selected by the object selecting means, or the object change described above. To the use the executable object generation means and equipped with a database means for accessing the database.

A database inquiry command is input from the input device to the inquiry comparison means. In the inquiry comparing means, a database inquiry command executed previously is compared with a database inquiry command to be executed this time. In the case of similar or identical inquiry (similar inquiry refers to the case where the constituent parts (query parts) of the database inquiry command match), the object already created or the executable object can be used in the present invention. With respect to these already generated objects or executable objects, the inquiry analysis by the inquiry analyzing means and the object generation process by the object generating means can be omitted. In particular, as a result of the comparison by the inquiry comparison means, in the case of the same inquiry described above, the executable object can be taken out from the accumulation means in the object selection means, and therefore the processing by the inquiry analysis means, the object generation means, and the object conversion means is omitted. can do. In creating (constructing) the executable object required by the database access means, a previously generated object (executable object) can be used, so that the query is executed after accepting the query. The processing to the following can be simplified. Therefore, the database inquiry processing can be performed, and thus, a high processing response performance can be realized in the database inquiry processing.

EXAMPLE

Next, embodiments of the present invention will be described with reference to the drawings.

1 is a block diagram showing an embodiment of a database query processing apparatus according to the present invention.

In the figure, the database inquiry processing apparatus 20 executes inquiry analyzing means 30 having a function of generating an object in consideration of an inquiry executed previously, and an object generated by the inquiry analyzing means 30. Object converting means 40 having a function of converting the object into a feasible object, an object generated by the input database query command 11 and the query interpreting means 30, and an executable object generated by the object converting means 40; It is comprised as the accumulating means 70 which manages in association and the database access means 50 which has a function which performs the access of the database 60 using an executable object.

Here, the inquiry analyzing means 30 is a query comparison means 31 for comparing the previously executed database inquiry command with the current database inquiry command, and the inquiry comparison means 31 compares the database inquiry. The object selecting means 32 for selecting an object already generated based on the result, the inquiry analyzing means 33 for analyzing the inquiry to perform a syntax check, and the inquiry analyzing means 33 It is comprised as the object generation means 34 which produces | generates an object by one inquiry.

The inquiry comparison means 31 took out the database inquiry command 11 received by the input device 10 from the inquiry accumulation means 71 of the accumulation means 70. The database inquiry command executed previously is compared with the object shown in FIG. In this case, the inquiry comparison means 31 performs the comparison for each corresponding portion constituting the object shown in FIG. For example, in the following command example, the "access target column information part" indicating what is to be accessed (e.g., the SELECT statement of the command example below) corresponding to the object of FIG. 4, and which table is accessed (FORM employee management table) The comparison is made by dividing the &quot; table identification information section &quot;, which is shown, and the &quot; query conditional section &quot;, which indicates what conditions are to be accessed (WHERE age &lt; 30).

SELECT statement… … … … … … … … … … … Access target column information part

FROM employee management table… … … … … … … … Marker Information Department

WHERE age <30... … … … … … … … … … … … … Lookup conditional

The object selecting means 32 accumulates the executable object that has already been generated when the entire database inquiry command is the same as the inquiry command that was previously executed as a result of the comparison by the inquiry comparison means 31. An object corresponding to the same portion when the executable object accumulating means 73 selects it, supplies it to the database access means 60, and the database command and a part of the previously executed inquiry command are the same. Is selected from the object accumulating means 72 of the accumulating means 70 and supplied to the object generating means 34.

In addition, the inquiry analyzing means 33 performs a syntax check on the entire inquiry or a part of the inquiry which was not equivalent as a result of the inquiry comparison as the inquiry comparison means 31.

The object generating means 34 combines the object selected in the previous inquiry and the newly generated object accumulated in the object accumulating means 72 by the object selecting means 32, and generates an object corresponding to this inquiry. Create

The accumulating means 70 is configured as the inquiry accumulating means 71, the object accumulating means 72, and the executable object accumulating means 73, and accumulates the objects accumulated in the object accumulating means 72 and the executable object. The executable object accumulated in the means 73 is stored in association with the corresponding inquiry accumulated in the inquiry accumulation means 71 described above. In the inquiry accumulating means 71, the inquiry checking means 33 stores the syntax-checked inquiry, and makes the state available to the inquiry comparison means 31 in the subsequent inquiry. In addition, the object accumulating means 72 stores an object generated by the object generating means 34 in association with the corresponding inquiry, and makes it possible to use the object selecting means 32. In addition, in the executable object accumulating means 73, the executable object generated by the executable object generating means 41 is stored in association with the corresponding inquiry, thereby enabling the use by the object selecting means 32. FIG.

The object selecting means 32 responds to the inquiry generated and accumulated in the previous inquiry processing by the executable object accumulating means 73 when all the parts of the inquiry are interpreted as equal in the inquiry comparing means 31. An executable object is selected and supplied to the database access means 50 to access the database 60.

In addition, the object converting means 40 converts the object received by the inquiry analyzing means 30 into an executable form to generate an executable object. The executable object generated by this object converting means 40 is stored in the executable object accumulating means 73 in association with the inquiry. The object converting means 40 supplies the generated executable object to the database access means 50 and accesses the database 60 by the database access means 50.

Next, the operation of FIG. 1 will be described with reference to the flowchart of FIG. 5 is a flowchart art of inquiry processing of the database inquiry processing apparatus of FIG. As a database, for example, a relational database is used. For example, database inquiry commands (commands such as SELECT name, FROM employee management table, and WHERE age <30) are inputted from the input device 10 to the database inquiry device 20, for example. Will be explained.

First, when a database inquiry command is input from the input device 10 to the inquiry analyzing means 30 of the database inquiry processing apparatus 20, each part constituting the database inquiry command in the inquiry comparison means 31. Is compared with the previously executed inquiry data stored in the accumulation means 71 (step S1). As a result of this comparison, when the entire inquiry (all database inquiry commands) is equivalent to a previously executed inquiry (previously executed inquiry command), the object selecting means 32 accumulates the executable objects of the storing means 70. The corresponding executable object is taken out from the means 73, supplied to the database access means 50, and the database 60 is accessed with the number of database accesses 50 (steps S2, S14, S15). . If the result of the inquiry comparison by the inquiry comparison means 31 is that the entire database inquiry (the whole database inquiry command) is not equivalent to the inquiry executed previously (the inquiry command executed previously), the comparison result. Is sent to the object selecting means 32, and in the object selecting means 32, the inquiry portion is identical to each of the access target column information portion, the marker identification information portion, and the inquiry condition portion based on the comparison result. Is taken out from the corresponding object accumulating means 72 (steps S2 to S8). Here, the case where the same command as the above example is used is taken as an example. Therefore, in the object configuration of FIG. 4, the access target column information unit, the table identification information unit, and the inquiry condition unit may be compared with each other. Thereafter, in the inquiry analyzing means 33, it was not equivalent as a result of the inquiry comparison. When the selection check of the inquiry portion or the entire inquiry is executed (step S9), and when it is confirmed that there is no grammatical error or the like, the inquiry accumulation which stores the inquiry in the inquiry accumulation means 71 is executed (step S10). .

Thereafter, in the object generating means 34, the object taken out in steps S4, S6, and S8 and the object for the new inquiry portion (the inquiry portion which did not match with the query comparison means 31) generated here are combined this time. Create (combine) an object for the conference query (if the part that makes up the database query command matches the part of the database query command that was executed previously), or create a new object for this query (When the configuration part of the database inquiry command does not coincide with the configuration part of the database inquiry command executed previously) (step S11). Again, the object created in step S11 is stored in the object storing means 72 of the storing means 70 in association with the inquiry (step S12). Next, the object converting means 40 converts the object generated by the object generating means 34 into an executable form (generates an executable object) (step S13). Next, the database access means 50 executes the access to the database 60 by using the executable object generated by the object converting means 34 (step S15).

As can be seen from the above description, the previously executed database inquiry command and the inquiry command between databases to be executed this time are compared with the inquiry comparison means 31, and the case is similar or identical (in case of similar inquiry, In the case where the constituent parts (query parts) of the database inquiry command are matched), an already generated object or an executable object can be used, and an inquiry analyzing means can be used for these already generated objects or executable objects. In (33), the process of generating the object by the inquiry analysis and the object generating means 34 can be omitted. In particular, in the case of the same inquiry as a result of the comparison by the inquiry comparison means 31, in the object selection means 32, the executable object corresponding to the executable object accumulation means 73 of the accumulation means 70 is selected. It can take out immediately, and therefore, the process by the inquiry analysis means 33 and the object converting means 40 can be skipped.

In this way, part or all of the inquiry analysis by the inquiry analyzing means 33 and the object (including the executable object) generation process by the object generating means 34 or the object converting means 40 can be omitted. In creating (constructing) the executable object required by the database access means 50, the previously generated object or the executable object can be used. However, if the previously created executable object is used, it is an executable object for database access. It is possible to simplify the processing from the database inquiry processing apparatus 20 to accepting the inquiry and executing the inquiry to the database 60 as compared with the prior art. Therefore, the high speed database inquiry processing can be performed, and therefore, high processing response performance can be realized in the data inquiry processing.

The present invention is not limited to this embodiment, and various applications and modifications can be made without departing from the gist of the present invention. For example, in the present embodiment, as the accumulating means 70, a memory such as a dynamic RAM is used, and therefore, the inquiry accumulating means 71 and the object accumulating means 72 constituting the accumulating means 70 are executable. The object accumulating means 73 may use a separate memory, but may comprise one memory.

As described above, when the database inquiry processing apparatus according to the present invention is used, the database inquiry command previously executed and the database inquiry command to be executed this time are compared by an inquiry comparison means, and in the case of similar or identical inquiry, The inquiry analysis by the inquiry analyzing means and the object generation process by the object generating means can be omitted for the object or executable object already created. In particular, as a result of the comparison by the inquiry comparison means, in the case of the same inquiry described above, the executable object can be taken out from the accumulation means in the object selection means, and therefore the processing by the inquiry analysis means, the object generation means, and the object conversion means is omitted. can do. In creating (constructing) an executable object required by the database access means, a previously generated object or executable object can be used, so that after receiving the query, executing the query against the database. The processing up to this can be simplified. Therefore, a high speed database inquiry processing can be performed, and thus, a high processing response performance can be realized in the database inquiry processing.

Claims (1)

A database inquiry processing apparatus for inputting a database inquiry command at an input device, interpreting the inquiry to generate an executable object, and accessing a database using the executable object, wherein the database inquiry command is executed. A query comparison means for inputting and comparing this to a previously executed inquiry command, and if the entirety of the database inquiry command is the same as the previously executed inquiry command as a result of the comparison by the inquiry comparison means, If the generated executable object is selected in the late accumulation means, and if the database inquiry command and a part of the previously executed inquiry command are the same, an object corresponding to the same part is selected in the late accumulation means. Object selection means and the inquiry comparison means described above. A query analyzing means for analyzing all or part of the above-mentioned inquiries of the database query command which did not match as a result of the comparison, and checking an grammatical error, etc., and generating an object from the checked query with this query interpreting means, Or object generating means for synthesizing the object selected by the object selecting means described above with this object to generate a new object, object converting means for converting the object generated by the object generating means into an executable object, and a database inquiry command Accumulating means for associating and storing the object generated by the object generating means and the executable object generated by the object converting means, the executable object selected by the object selecting means, or the object converting means. Run Database query processing apparatus using a function object that is characterized by having a database access means for accessing the database.