JP3865197B2 - Database access processing method - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a database definition method and a database access processing method that are important factors in improving processing performance in a system that operates on a small portable terminal such as a mobile computer.
[0002]
[Prior art]
In system development using a database, it is indispensable to take measures against database access processing time in the process of improving the processing performance of the system. For example, in the screen display process and the screen end process, it can be said that the processing time required to access the database has a greater specific gravity than the processing time required for screen display. Therefore, reducing the access processing time to the database is the most effective means for reducing the overall processing time.
[0003]
In addition, in a database-based system, the database model used is a relational database with advanced functions such as high-speed computer processing performance, query optimization, parallel processing, and data distribution. It has become mainstream. The reason why relational databases have been widely supported is that the physical structure of the database is hidden, and if the application is only aware of the logical structure as a two-dimensional simple table, the non-procedural query language called SQL is used. The necessary data can be easily accessed.
[0004]
[Problems to be solved by the invention]
A small portable terminal used as a mobile computer or the like uses a CPU with low power consumption to reduce the size of the computer main body in order to make it easier to carry, and to enable battery operation for a longer time. As a result, higher portability and more efficient power management are realized compared to notebook computers. On the other hand, the processing performance of the low power consumption CPU is weak compared to the CPU mounted on the notebook computer. When a relational database is used in system development that operates in such an environment, the processing performance of the CPU becomes a bottleneck. Therefore, to secure the performance of access processing to the database, a table structure for suppressing the number of I / Os And database design such as reviewing the record structure to minimize the number of physical columns by integrating items.
[0005]
The application manufacturing process is generally started after the database design is completed. However, in the development of a system that runs on a mobile terminal, the database access processing performance must always be taken into account. There is a problem in that a design occurs at any time, and a large number of man-hours are required each time a review of the table structure occurs.
[0006]
In addition, if the data structure considering the performance defined in the database is different from the data structure suitable for use by the application, the application will be aware of the physical data structure defined in the database. There is a problem that the advantage of the relational database that it is possible to hide the physical structure of the database cannot be utilized.
[0007]
An object of the present invention is to provide a database that collectively manages reference of data from the database and addition, update, and deletion of data to the database without the application being aware of the physical structure defined in the database. It is to provide an access processing method.
[0008]
[Means for Solving the Problems]
To achieve the above object, the invention according to claim 1, in the database access processing method in a system logical structure different physical structures and applications defined in the database uses the logical structure The data structure defines logical items used by the application as data items, and the physical structure can arbitrarily integrate the logical items to reduce the number of items and the number of I / Os. a possible data structure, when referring or updating the database from the application, the said converted into logical structures or the application, which the physical structure defined in the database the application uses uses to the physical structure defined a logical structure in the database Characterized by comprising a step of conversion.
[0009]
The invention according to claim 2 is a database access processing method in a system in which a physical structure defined in a database and a logical structure used by an application are different, wherein the logical structure is a logical used by the application. The physical structure is a data structure in which the logical items are arbitrarily integrated and the number of items can be reduced to reduce the number of I / Os. when referring to the database, as the access information of the data to be accessed to the database, obtaining a table ID and the access key from the application, the target data from the database using the table ID and access key Steps to search for The target data, and converting from the physical structure defined in the database to the logical structure of the application uses, the steps of returning the target data with the logical structure to the application It is provided with.
[0010]
The invention according to claim 3 is a database access processing method in a system in which a physical structure defined in a database and a logical structure used by an application are different, and the logical structure is a logical used by the application. The physical structure is a data structure in which the logical items are arbitrarily integrated and the number of items can be reduced to reduce the number of I / Os. when adding data to the database, as the access information of the data to be access to said database, table ID, access key, and acquiring additional data from said application, the additional data, the application wherein from the logical structure used And converting into the physical structure defined database, characterized by comprising the step of adding the target data in the database using the table ID and the access key.
[0011]
The invention according to claim 4 is a database access processing method in a system in which a physical structure defined in a database and a logical structure used by an application are different, and the logical structure is a logical used by the application. The physical structure is a data structure in which the logical items are arbitrarily integrated and the number of items can be reduced to reduce the number of I / Os. when updating the data of the database, as the access information of the data to be access to said database, table ID, a step of acquiring the access key, and the update data from the application, the update data, the application wherein from the logical structure used And converting into the physical structure defined database, characterized by comprising the step of updating the target data of the database in the update data by using the table ID and the access key.
[0012]
Invention, the database access processing method according to any one of claims 1 4, when returning a reference data of the database to the application or the database Add / Update data from the application according to claim 5 When the data is transferred to the network, data is exchanged by exchanging pointers indicating the storage locations of the data.
[0013]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[0014]
FIG. 1 is a block diagram showing a configuration of a mobile terminal according to an embodiment of the present invention. As shown in FIG. 1, the portable terminal includes a processing device 101 having a CPU 105 and an internal storage device 106, an external storage device 102 having a database 107 storing business data, and a display used as a data display device. 103 and a touch pen 104 used as a data input device.
[0015]
The CPU 105 and the internal storage device 106 in the processing apparatus 101 are small and have low power consumption so that the portable terminal can be carried more easily. In addition, since the display 103 enables input by a tap operation using the touch pen 104, a keyboard is not used as an input device here. In this embodiment, such a portable terminal is taken as an example, but of course, a portable terminal having a display and a keyboard having only a general display function may be used.
[0016]
FIG. 2 is a processing configuration diagram of the database access module and the application. In the portable terminal of FIG. 1, the data structure used by each process and the state converted to a data structure suitable for each process are shown. Hereinafter, a physical structure defined in the database 107 is referred to as a physical structure 205, and a logical structure used by an application is referred to as a logical structure 206.
[0017]
In the internal storage device 106, an application 201, a data area 202, a database reference module 203, and a database update module 204 are stored or secured. The application 201 reserves a data area 202 as an area for manipulating data.
[0018]
The data structure used in each process can be roughly divided into a process group that uses the logical structure 206 and a process group that uses the physical structure 205 as shown by broken lines. That is, when the physical structure 205 is changed due to a review of the table definition for the database 107, the database 107 is limited to the physical definition of the database reference module 203 and the physical definition of the database update module 204. The processing configuration enables extremely flexible responses to changes.
[0019]
FIG. 3 is a flowchart showing the processing contents of the database access module and the application. An example of an update process in which data acquired from the database 107 is displayed on the display 103 and input data is reflected in the database 107 will be described with reference to the process configuration diagram of FIG.
[0020]
First, the application 201 activates the database reference module 203 (step 301). At this time, the pointer of the data area 202 secured by the application 201 is handed over.
[0021]
The activated database reference module 203 acquires the target data from the database 107 and stores the acquired data in the data area 202 (step 302). When the storage process is completed, the database reference module 203 is terminated and the process of the application 201 is continued.
[0022]
When displaying data on the display 103, the application 201 uses the data of the logical structure 206 stored in the data area 202 (step 303). When there is an input from the touch pen 104 on the display 103, the application 201 updates the data area 202 with the input data (step 304). Next, the database update module 204 is activated to reflect the input data to the database 107 (step 305). At this time, the pointer of the data area 202 storing the input data is handed over.
[0023]
The activated database update module 204 acquires the target data stored in the data area 202, and updates the database 107 with the acquired data (step 306). When the update process is completed, the database update module 204 is terminated and the process of the application 201 is completed.
[0024]
Next, details of processing contents of the database reference module 203 and the database update module 204 will be described with reference to the flowcharts of FIGS.
[0025]
FIG. 4 is a flowchart showing the processing contents of the database reference module 203. The database reference module 203 activated from the application 201 acquires the access information 408 as an argument from the application 201 (step 401). In the access information 408, a target table ID, an access key of the target data, an access method, and a pointer indicating the storage location of the reference data are set. Here, “reference” is set as the access method.
[0026]
Next, SQL using the table ID and access key is issued, and the target data is searched from the database 107 (step 402). Here, it is determined whether the target data exists in the database 107 (step 403). If the target data does not exist, it is determined that the process has failed, and the process jumps to step 407. If the target data exists, the target data is acquired from the database 107 as the physical structure 205 (step 404). Further, the acquired data is converted from the physical structure 205 to the logical structure 206 (step 405). Then, the acquired data converted into the logical structure 206 is stored in the data area 202 designated by the pointer (step 406).
[0027]
Finally, the processing result 409 is returned to the application 201 as a return value (step 407). In the processing result 409, identification information indicating success or failure is set.
[0028]
FIG. 5 is a flowchart showing the processing contents of the database update module 204. The database update module 204 activated from the application 201 acquires the access information 514 as an argument from the application 201 (step 501). In the access information 514, a target table ID, an access key of the target data, an access method, and a pointer indicating the storage location of the addition / update data are set. Information such as addition, update, and deletion is set in the access method. Next, the process branches depending on the determination result of the access method (step 502). The process branches to step 503 if the access method is added, to step 507 if it is updated, or to step 511 if it is deleted.
[0029]
First, processing contents when an access method is added will be described. First, it is determined whether target data exists in the database 107 (step 503). If the target data exists, it is determined that the process has failed because the keys overlap, and the process jumps to step 513. If the target data does not exist, the additional data of the logical structure 206 is acquired from the data area 202 designated by the pointer (step 504). Further, the acquired additional data is converted from the logical structure 206 to the physical structure 205 (step 505). Then, the SQL using the table ID and the access key is issued, and the additional data converted into the physical structure 205 is added to the database 107 (step 506).
[0030]
Next, processing contents when the access method is update will be described. First, it is determined whether the target data exists in the database 107 (step 507). If the target data does not exist, it is determined that the process has failed, and the process jumps to step 513. If the target data exists, update data of the logical structure 206 is acquired from the data area 202 designated by the pointer (step 508). Further, the obtained update data is converted from the logical structure 206 to the physical structure 205 (step 509). Then, the SQL using the table ID and the access key is issued, and the database 107 is updated with the update data converted into the physical structure 205 (step 510).
[0031]
Furthermore, processing contents when the access method is deletion will be described. First, it is determined whether the target data exists in the database 107 (step 511). If the target data does not exist, it is determined that the process has failed, and the process jumps to step 513. If the target data exists, an SQL using the table ID and the access key is issued, and the target data is deleted from the database 107 (step 512).
[0032]
Finally, the processing result 515 in the addition, update, and deletion processing is returned to the application 201 as a return value (step 513). In the processing result 515, identification information indicating success or failure is set.
[0033]
Next, details of the data structure conversion processing in step 405 in FIG. 4, step 505 in FIG. 5 and step 509 will be described using the explanatory diagram in FIG.
[0034]
FIG. 6 is an explanatory diagram for explaining a schematic configuration of the physical definition and the logical definition. In the database reference module 203 and the database update module 204, the structure of the table group defined in the database 107 is defined as a physical definition 603 and a logical definition 601. A definition example of each structure is shown in the source code 602 and the source code 604. When converting the data structure, the source code 602 and the source code 604 are used to perform the conversion process.
[0035]
Next, the repair procedure when the table structure is reviewed will be described with reference to the flowchart of FIG. 7 and the explanatory diagram of FIG.
[0036]
FIG. 7 is a flowchart showing a repair procedure when a review of the table structure occurs. The review of the table structure is considered to occur as a measure for improving the performance (step 701). First, the review result of the table structure is reflected in the table definition of the database 107 (step 702). Next, the physical definition 603 of the database reference module 203 and the database update module 204 is corrected (steps 703 and 704). The repair work is completed by the above procedure. Since only the part using the physical structure 205 is the target of correction, the correction work for the application 201 does not occur.
[0037]
FIG. 8 is an explanatory diagram for explaining an example of changing the physical definition. For example, it is assumed that the item X801 and the item Y802 before review are integrated into the item Z804 after review. In the database reference module 203 and the database update module 204, as shown in the source code 803 before review and the source code 804 after review, the item name and the number of digits defined in the structure are respectively corrected. The above is the correction contents for the database reference module 203 and the database update module 204. Along with the change of the physical definition, the correction work for the application 201 does not occur.
[0038]
【The invention's effect】
As described above, according to the present invention, when referring to or updating a database from an application, the physical structure defined in the database is converted into a logical structure used by the application, or the logic used by the application is changed. Since the database structure is converted to the physical structure defined in the database, if the table structure is revised due to the redesign of the database, the physical structure of the database reference module independent of the application By focusing on the modifications to the definition and the physical definition of the database update module, it is possible to respond very flexibly to changes in the database. In addition, the application does not need to be aware of the physical data structure defined in the database, only the data structure suitable for use by the application needs to be considered, and the physical structure of the database is hidden. This makes it possible to take advantage of the advantages of relational databases.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of a mobile terminal according to an embodiment of the present invention.
FIG. 2 is a processing configuration diagram of a database access module and an application.
FIG. 3 is a flowchart showing processing contents of a database access module and an application.
FIG. 4 is a flowchart showing processing contents of a database reference module.
FIG. 5 is a flowchart showing processing contents of a database update module.
FIG. 6 is an explanatory diagram for explaining an outline configuration of a physical definition and a logical definition.
FIG. 7 is a flowchart showing a repair procedure when a review of the table structure occurs.
FIG. 8 is an explanatory diagram for explaining an example of changing a physical definition;
[Explanation of symbols]
DESCRIPTION OF SYMBOLS 101 ... Processing apparatus, 102 ... External storage device, 103 ... Display, 104 ... Touch pen, 105 ... CPU, 106 ... Internal storage device, 107 ... Database.

Claims (5)

In the database access processing method in a system where the physical structure defined in the database and the logical structure used by the application are different,
The logical structure is a data structure in which logical items used by the application are defined as data items, and the physical structure is an I / O that arbitrarily integrates the logical items and reduces the number of items. A data structure that can reduce the number of O,
When referring or updating the database from the application, the logical structure the is converted into a logical structure, or the application uses to the physical structure defined in the database the application uses database access processing method characterized by comprising the step of converting into the physical structure defined in the database. In the database access processing method in a system where the physical structure defined in the database and the logical structure used by the application are different,
The logical structure is a data structure in which logical items used by the application are defined as data items, and the physical structure is an I / O that arbitrarily integrates the logical items and reduces the number of items. A data structure that can reduce the number of O,
When referring to the database from the application, as the access information of the data to be accessed to the database, obtaining a table ID and the access key from the application,
Retrieving the object data from the database using the table ID and the access key,
The retrieved target data, and converting from the physical structure defined in the database to the logical structure of the application uses,
Database access processing method characterized by comprising the step of returning the target data with the logical structure to the application. In the database access processing method in a system where the physical structure defined in the database and the logical structure used by the application are different,
The logical structure is a data structure in which logical items used by the application are defined as data items, and the physical structure is an I / O that arbitrarily integrates the logical items and reduces the number of items. A data structure that can reduce the number of O,
When adding data to the database from the application, as the access information of the data to be accessed to the database, and obtaining table ID, access key, and additional data from the application,
And converting the additional data, to the physical structure of the defined from a logical structure in the database that the application uses,
Database access processing method characterized by comprising the step of adding the target data in the database using the table ID and the access key. In the database access processing method in a system where the physical structure defined in the database and the logical structure used by the application are different,
The logical structure is a data structure in which logical items used by the application are defined as data items, and the physical structure is an I / O that arbitrarily integrates the logical items and reduces the number of items. A data structure that can reduce the number of O,
When updating the data of the database from the application, as the access information of the data to be accessed to the database, and obtaining table ID, access key, and the update data from the application,
And converting the updated data, to the physical structure of the defined from a logical structure in the database that the application uses,
Database access processing method characterized by comprising the step of updating the target data of the database in the update data by using the table ID and the access key. In the database access processing method according to any one of claims 1 to 4,
When returning a reference data of the database to the application, or when passing in the database Add / Update data from the application, and wherein the transmit and receive data by exchanging the pointer indicating the storage location of those data Database access processing method.

Images