JP2002108669A - Method for processing data base access - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data base access processing method for managing reference to data from a data base and the addition, update, and erasure processing of the data to the data base in a batch without making it necessary for an application to consider any physical structure defined in the data base. SOLUTION: In a data base access processing method in a system in which a physical structure defined in a data base is different from a logical structure to be used by an application, at the time of referring to or updating the data base from the application, the physical structure defined in the data base is converted into the logical structure to be used by the application, or the logical structure to be used by the application is converted into the physical structure defined in the data base.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for defining a database, which is an important factor in improving processing performance, and a method for processing access to a database in a system operating on a small portable terminal such as a mobile computer. .

[0002]

2. Description of the Related Art In the development of a system using a database, it is indispensable to take measures against the processing time for accessing the database in the process of improving the processing performance of the system. For example, in the screen display processing and the screen end processing, it can be said that the processing time required for accessing the database has a greater specific gravity than the processing time required for screen display. Therefore,
Reducing database access processing time
This is the most effective means for reducing the overall processing time.

In a system using a database, a database model used has advanced functions such as query optimization, parallel processing, and data distribution, in order to speed up computer processing performance. Relational databases are the mainstream. The reason that 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 simple two-dimensional table, SQL can use the non-procedural query language SQL. Easy access to necessary data.

[0004]

A small portable terminal used as a mobile computer or the like has a reduced size of a computer main body in order to make it more portable.
A low-power-consumption CPU is used in order to enable longer battery operation. The result is higher portability and more efficient power management than laptop computers. On the other hand, the processing performance of the low power consumption CPU is slower than that of a CPU mounted on a notebook computer. When using a relational database in the development of a system operating in such an environment, the CP
Since the processing performance of U becomes a bottleneck, in order to secure the performance of database access processing, review the table structure to suppress the number of I / Os and integrate the items to minimize the number of physical columns. It is necessary to design a database, such as reviewing the record structure in order to achieve this.

[0005] In general, an application manufacturing process is started after database design is completed. However, in the development of a system that operates on a portable terminal, it is necessary to always consider the performance of database access processing. There is a problem that a redesign of the database occurs at any time, and every time the table structure is reconsidered, a large number of correction man-hours are required.

If the data structure defined in the database taking into account the performance is different from the data structure suitable for use by the application, the application must be aware of the physical data structure defined in the database. In other words, there is a problem that the advantage of a relational database that the physical structure of the database can be hidden cannot be utilized.

An object of the present invention is to refer to data from a database and add, update, and delete data to and from a database in a batch without the application being aware of the physical structure defined in the database. The object is to provide a database access processing method to manage.

[0008]

According to one aspect of the present invention, there is provided a database access processing in a system in which a physical structure defined in a database differs from a logical structure used by an application. In the method, when referencing or updating the database from the application, the physical structure defined in the database is converted into the logical structure used by the application, or the logical structure used by the application is defined in the database. The method further comprises a step of converting to a physical structure.

According to a second aspect of the present invention, there is provided 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 from each other. Acquiring a table ID and an access key from an application as access information of data to be accessed for the application, searching for target data from a database using the table ID and the access key, and The method includes a step of converting a physical structure defined in a database to a logical structure used by an application, and a step of returning target data having the logical structure to the application.

According to a third aspect of the present invention, in the database access processing method in a system in which the physical structure defined in the database and the logical structure used by the application are different, when data is added from the application to the database, Obtaining a table ID, an access key, and additional data from the application as access information of data to be accessed to the database; and transmitting the additional data to the physical data defined in the database from a logical structure used by the application. And a step of adding target data to a database using the table ID and the access key.

According to a fourth aspect of the present invention, in the database access processing method in a system in which the physical structure defined in the database and the logical structure used by the application are different, when data is updated from the application to the database, A step of obtaining a table ID, an access key, and update data from the application as access information of data to be accessed to the database; and transmitting the update data to the physical data defined in the database from a logical structure used by the application. And a step of updating target data of a database with the update data using the table ID and the access key.

According to a fifth aspect of the present invention, there is provided the database access processing method according to any one of the first to fourth aspects, wherein reference data of the database is returned to the application, or additional / updated data is transmitted from the application to the database. When passing the data, the data is transmitted and received by transmitting and receiving a pointer indicating the storage location of the data.

[0013]

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

FIG. 1 is a block diagram showing a configuration of a portable terminal according to an embodiment of the present invention. As shown in FIG. 1, the mobile terminal includes a CPU 105 and an internal storage device 106.
An external storage device 102 having a database 107 storing business data, a display 103 used as a data display device,
A touch pen 104 used as a data input device.

The CPU 105 and the internal storage device 106 in the processing device 101 are of small size and have low power consumption in order to make the portable terminal more portable. 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 the present embodiment, such a mobile terminal is taken as an example, but a mobile terminal having a display and a keyboard having only a general display function may of course be used.

FIG. 2 is a processing configuration diagram of the database access module and the application. In the portable terminal shown in FIG. 1, the data structure used by each process and the state where the data is converted into a data structure suitable for each process are shown. Hereinafter, the physical structure defined in the database 107 is called a physical structure 205, and the logical structure used by the application is called a logical structure 206.

The internal storage device 106 includes an application 201, a data area 202, a database reference module 203, and a database update module 204.
Is stored or secured. Application 2
No. 01 secures a data area 202 as an area for operating data.

The data structure used in each process can be broadly divided into a process group using the logical structure 206 and a process group using the physical structure 205 as shown by a broken line.
In other words, if the physical structure 205 is changed due to a review of the table definition or the like in the database 107, the modification is made to the physical definition of the database reference module 203 and the physical definition of the database update module 204. It has a processing configuration that enables extremely flexible response to changes.

FIG. 3 is a flowchart showing the processing contents of the database access module and the application. The data obtained from the database 107 is displayed on the display 103, and the input data is
7 will be described using the processing configuration diagram of FIG. 2 as an example.

First, the application 201 starts the database reference module 203 (step 30).
1). At this time, the application 201 passes the pointer of the data area 202 secured.

The activated database reference module 2
03 acquires the target data from the database 107 and stores the acquired data in the data area 202 (Step 302). When the storage processing ends, the database reference module 203 ends, and the processing of the application 201 continues.

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 an input is made on the display 103 with the touch pen 104, the application 201 updates the data area 202 with the input data (step 304). Next, the database update module 204 is started to reflect the input data on the database 107 (step 305). At this time, the pointer of the data area 202 storing the input data is delivered.

The activated database update module 2
04 acquires the target data stored in the data area 202 and updates the database 107 with the acquired data (step 306). When the update processing ends, the database update module 204 ends, and the processing of the application 201 ends.

Next, the database reference module 203
And the details of the processing contents of the database update module 204 will be described with reference to the flowcharts of FIGS.

FIG. 4 shows the database reference module 20.
9 is a flowchart showing the processing contents of Step 3. The database reference module 203 started from the application 201 acquires the access information 408 from the application 201 as an argument (step 401). In the access information 408, a target table ID, an access key of target data, an access method, and a pointer indicating a storage location of reference data are set. Here, “access” is set as the access method.

Next, SQL using the table ID and the 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 processing has failed, and the process jumps to step 407. If the target data exists, the database 107
, The target data is acquired by 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 specified by the pointer (step 4).
06).

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.

FIG. 5 shows the database update module 20
6 is a flowchart showing the contents of processing 4; The database update module 204 started from the application 201 acquires the access information 514 from the application 201 as an argument (step 501). In the access information 514, a target table ID, an access key of target data, an access method, and a pointer indicating a storage location of added / updated 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). Step 50 if the access method is additional
3, the process branches to step 507 in the case of updating, or to step 511 in the case of deletion.

First, the contents of processing when the access method is added will be described. First, it is determined whether the target data exists in the database 107 (step 503). If the target data exists, it is determined that the processing has failed because the key is duplicated, and the process jumps to step 513. If the target data does not exist, additional data of the logical structure 206 is obtained from the data area 202 specified 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, an 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 5).
06).

Next, the processing content 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 processing has failed, and the process jumps to step 513. If the target data exists, the update data of the logical structure 206 is obtained from the data area 202 specified by the pointer (step 50).
8). Further, the acquired update data is converted from the logical structure 206 to the physical structure 205 (Step 509). Then, an 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).

Further, the processing content when the access method is delete 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 processing has failed, and the process jumps to step 513. If the target data exists, SQL using the table ID and the access key is issued, and the target data is deleted from the database 107 (step 512).

Finally, the processing result 515 in the addition, update, and deletion processing is set as a return value, and the
1 is returned (step 513). In the processing result 515, identification information indicating success or failure is set.

Next, the details of the data structure conversion processing in step 405 in FIG. 4 and steps 505 and 509 in FIG. 5 will be described with reference to the explanatory diagram of FIG.

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, a structure of a table group defined in the database 107 is defined as a physical definition 603 and a logical definition 601. Examples of definition of each structure are shown in source code 602 and source code 604. When converting the data structure, the source code 602 and the source code 60
4 is used to perform the conversion process.

Next, a 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.

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 such as performance improvement (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 (Step 703, Step 704). The renovation work is completed by the above procedure. Since only the part using the physical structure 205 is to be corrected, no correction work is performed on the application 201.

FIG. 8 is an explanatory diagram for explaining a modification example of the physical definition. For example, assume that the item X801 and the item Y802 before the review are integrated into the item Z804 after the review. In the database reference module 203 and the database update module 204, the source code 8
03 and the revised source code 804,
Correct the item name and the number of digits defined in the structure. The above is the contents of corrections to the database reference module 203 and the database update module 204. With the change of the physical definition, application 2
No correction work is performed on 01.

[0038]

As described above, according to the present invention,
When referencing or updating a database from an application, the physical structure defined in the database is converted to the logical structure used by the application, or the logical structure used by the application is converted into the physical structure defined in the database. Since the conversion to the structure is performed, if the table structure is reviewed due to the redesign of the database as needed, focus on the modification of the physical definition of the database reference module and the physical definition of the database update module independent of the application. This enables extremely flexible response to database changes. Also, the application does not need to be aware of the physical data structure defined in the database, and only needs to be aware of the data structure that is suitable for use by the application, which hides the physical structure of the database. That it is possible,
It allows you to take advantage of relational databases.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating 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 the processing contents of a database reference module.

FIG. 5 is a flowchart illustrating processing performed by a database update module.

FIG. 6 is an explanatory diagram for explaining a schematic configuration of a physical definition and a logical definition.

FIG. 7 is a flowchart illustrating a repair procedure when a review of the table structure occurs.

FIG. 8 is an explanatory diagram for explaining a modification example of a physical definition.

[Explanation of symbols]

101: processing device, 102: external storage device, 103: display, 104: touch pen, 105: CPU, 1
06: Internal storage device, 107: Database.

Claims (5)

[Claims] In 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, when an application refers to or updates a database, the physical structure defined in the database is changed. Converting a logical structure to a logical structure used by an application, or converting a logical structure used by an application to a physical structure defined in a database. . 2. A database access processing method in a system in which a physical structure defined in a database differs from a logical structure used by an application.
A step of obtaining a table ID and an access key from an application as access information of data to be accessed to the database; a step of searching for target data from the database using the table ID and the access key; Database access comprising converting a physical structure defined in a database into a logical structure used by an application, and returning the logically structured target data to the application. Processing method. 3. In 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, when data is added from the application to the database, the database is accessed. Table ID, access key,
And obtaining additional data from an application; converting the additional data from a logical structure used by the application to a physical structure defined in the database; and a database using the table ID and the access key. And adding target data to the database. 4. In 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, when the data is updated from the application to the database, the database is accessed. Table ID, access key,
And obtaining update data from an application; converting the update data from a logical structure used by the application to a physical structure defined in a database; and using the table ID and an access key. Updating the target data of the database with the update data. 5. The database access processing method according to claim 1, wherein when reference data of the database is returned to the application, or when additional / updated data is passed from the application to the database, the data is returned. A database access processing method for exchanging data by exchanging a pointer indicating a storage location of the database.