JP3626632B2 - Database access method, method and storage medium - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a database access method, method and storage medium for accessing a database using a database management system, and more particularly to a database access method, method and method for accessing a database using a stored procedure registered in the database management system. The present invention relates to a storage medium.
[0002]
[Prior art]
In a relational database management system (hereinafter abbreviated as RDBMS) which is one of database management systems, a relational database (hereinafter abbreviated as RDB) is managed in a tabular format. Tables include a real table in which data is actually stored and a virtual table (also referred to as a view) that is generated from data of the base table that becomes the original at the time of execution without saving the data. The application acquires necessary data on the RDB via the RDBMS using the SQL language that refers to the table.
[0003]
In a client / server system (hereinafter abbreviated as C / S system), an RDB is connected to a server and an RDBMS is provided, and an application existing on the client side makes an RDB access request to the RDBMS using the SQL language. The access result is received from the RDBMS.
[0004]
In other words, when a client application searches for necessary data, the application issues a search condition expression adapted to the SQL language format to the server RDBMS, and the RDBMS searches the RDB data and matches the search condition given. Select the data to be returned and return the search results to the client application. At this time, in the RDBMS, a high-speed access technique such as creation of a search index is used.
[0005]
However, the index created by the RDBMS is not always created in a form optimal for the application.
[0006]
For example, let us consider an application for obtaining the latest price for each product in an RDB composed of a base table A and a base table B as shown in FIGS.
[0007]
The application performs the following processing.
(1) In the base table B, a row including the latest product date and time is selected from the same product number.
(2) The base table A and the result of the above (1) are related with each product number.
(3) A table composed of a product number, a product name, and a price is generated based on the relationship in (2) above.
(4) Access the table which is the result of (3) above, and acquire the product number, product name and price data.
[0008]
In this case, an index of date and time is created in the RDBMS, but an index is not created for the same product number with the latest date and time. For this reason, the application must describe the processing procedure for selecting the latest product date and time among the same product numbers in (1) above. Thus, the index created by the RDBMS is not optimal for each application.
[0009]
Further, since the above-described application processing is executed by each client, request information from each client and result information from the server frequently pass between the server and the client via the network.
[0010]
[Problems to be solved by the invention]
In the conventional technique described above, the index created by the RDBMS is a simple index of the data item, and there is a problem that the data required particularly on the application side does not have the index format and the creation of the application becomes complicated. For this reason, there is also a problem that traffic between the RDBMS and the application increases.
[0011]
An object of the present invention is to provide means for creating a necessary index for each application using a stored procedure registered in an RDBMS, simplifying application creation, and improving the performance of the entire system.
[0012]
[Means for Solving the Problems]
The database access method of the first invention of this application is: A first virtual table (unique table) is defined by defining a configuration of a relational database including one or more base tables accessed from a server and storing data, and a first virtual table associated with the base table name and item name. A stored procedure for creating a key table) and the stored procedure is activated if the stored procedure has not yet been activated or executed, or if the stored procedure has already been activated and then the relational database has been updated. Stored procedure starting means for executing the first virtual table and the name of the item constituting the first virtual table are specified in the configuration of the second virtual table defined by the application. The first virtual table (unique key) is used for processing related to the name of the virtual table and the item names constituting the first virtual table. And a server having a relational database management system that accesses the relational database based on processing requested by an application and returns a processing result to the application, and a name of the base table. Request to access the relational database by defining the name of the first virtual table defined by the stored procedure and the name of the first virtual table defined by the stored procedure and the structure of the second virtual table associated with the name of the item constituting the first virtual table A client having an application that issues a request result to the relational database management system and receives a request result from the relational database management system; Is provided.
[0013]
Database access of the second invention of the present application Method Is A method for accessing a database of a system having a server including a relational database management system, a client including an application, and a relational database, wherein the relational database management system includes names of base tables and item names included in the relational database. A stored procedure that defines the configuration of the first virtual table related to the first virtual table is registered, and the stored procedure is started and executed to create a first virtual table (table of unique key). And the structure of the second virtual table related to the name and item name of the base table included in the table and the name of the first virtual table defined by the stored procedure and the item name constituting the first virtual table; A request to access the relational database is sent to the relational database management system. The relational database management system accesses the relational database based on processing requested by the application, and the name of the first virtual table and the configuration of the second virtual table defined by the application When an item name constituting the first virtual table is designated, the first virtual table (in the processing related to the name of the first virtual table and the item name constituting the first virtual table) The relational database is accessed using a unique key table), and a processing result is returned to the application. The application receives a request result from the relational database management system. .
[0014]
Of the third invention of the present application recoding media Is The relational database management system registers a stored procedure that defines the configuration of the first virtual table associated with the name of the base table and the item name included in the relational database, and executes the stored procedure to execute the first Process of creating a virtual table (unique key table) of the base table and the application, the name and item name of the base table included in the relational database and the name and first virtual table of the first virtual table defined by the stored procedure A process of defining a configuration of a second virtual table related to an item name constituting the table and issuing a request to access the relational database to the relational database management system, and the relational database management system from the application Accessing the relational database based on the requested process; and When the name of the first virtual table and the item name constituting the first virtual table are specified in the configuration of the second virtual table defined by the application, the name of the first virtual table and A process of accessing the relational database using the first virtual table (unique key table) for a process related to an item name constituting the first virtual table, a process of returning a process result to the application, The application records a program for causing a computer to execute a process of receiving a request result from the relational database management system. .
[0019]
DETAILED DESCRIPTION OF THE INVENTION
The database access system of the present invention will be described with reference to FIG.
[0020]
Referring to FIG. 1, the database access system of the present invention comprises a database 4, a database management system 5, stored procedure execution means 6, and database access request means 7.
[0021]
The database 4 is a database that stores and accumulates data.
[0022]
The database management system 5 manages the database 4, accesses the database 4 based on a request from the database access request unit 7, and returns an access result to the database access request unit 7.
[0023]
The stored procedure execution means 6 executes a stored procedure registered in the database management system 5. The stored procedure includes a process of creating a unique key table (index) used by the database access request means 7.
[0024]
The database access request unit 7 executes the stored procedure execution unit 6 and requests the database management system 5 to access the database 4 using the execution result, and receives the request result from the database management system 5.
[0025]
The operation of the present invention will be described. It is assumed that the stored procedure used by the database access request means 7 is registered in the database management system 5 by a known method in advance.
[0026]
First, the database access request means 7 designates a table (index) of a unique key created by the stored procedure and sends an access request for the database 4 to the database management system 5.
[0027]
The database management system 5 executes the specified stored request using the stored procedure execution means 6 and creates a unique key table (index) to be used by the database access request means 7, and performs the specified access request processing. The processing result is returned to the database access request means 7.
[0028]
The database access request means 7 receives the processing result from the database management system 5.
[0029]
In this way, by creating a table (index) of the unique key used by the database access requesting means 7 in the stored procedure registered in the database management system 5, the database access requesting means 7 can obtain the requested data from the database 4 at high speed. Can be acquired.
[0030]
An embodiment of the present invention to which the database access method of the present invention is applied will be described.
[0031]
A first embodiment of the present invention will be described in detail with reference to the drawings. The first embodiment relates to a system that searches an RDB that manages the latest price of a product consisting of two base tables, acquires the latest price of the product, and processes it.
[0032]
FIG. 2 is a diagram illustrating the configuration of the first embodiment.
[0033]
Referring to FIG. 2, in the first embodiment, a server 1 and a client 2 are connected via a network 3. The server 1 is connected to the RDB 11 and includes an RDBMS 12. The RDBMS 12 includes a stored procedure 13 and stored procedure starting means 14. The client 2 includes an application 21.
[0034]
The RDB 11 is a relational database that stores and accumulates data, and includes a base table A111 and a base table B112. The base table A111 is basic data, and the base table B112 holds a history of basic data.
[0035]
The base table A111 is one of the tables constituting the RDB11. The configuration of the real table A111 is shown in FIG. The base table A111 includes a product number and a product name, and each row is uniquely distinguished by a product number that is a primary key.
[0036]
The base table B112 is one of the tables constituting the RDB11. The configuration of the base table B112 is shown in FIG. A real table B112 includes a product number, a date time, and a price, and indicates the latest price of the product. Each time the price of a product is changed, a line indicating the changed date and time and a new price is registered. The product number corresponds to the product number of the base table A111, and thereby the base table A111 and base table B112 are related. The date and time is the date and time when the price is registered, and indicates the registration order of the price within the same product number. A serial number may be used instead of the date and time. Each line is uniquely distinguished by concatenating the product number and date time (hereinafter referred to as “product number + date time”).
[0037]
The RDBMS 12 manages and accesses the RDB 11. A request issued from the application 21 is processed, and a processing result corresponding to the issued request is returned to the application 21.
[0038]
The stored procedure 13 performs a process of selecting and creating a data set by defining and generating a virtual table A131 based on the base table A111 and the base table B112. Stored procedure 13 is activated by stored procedure activation means 14. The name of the virtual table A 131 is determined when the stored procedure 13 is registered in the RDBMS 12. The application 21 can refer to the virtual table A 131 generated by the stored procedure 13 by designating this name. The method for registering the stored procedure 13 in the RDBMS 12 is a known method.
[0039]
The virtual table A131 is a virtual table including a unique key of the latest history. The stored procedure 13 is defined and generated based on the base table A111 and base table B112, and a selection condition for combining the product number of the base table A111 and the latest (maximum) date / time within the corresponding product number of the base table B112 is designated. It is. The configuration of the virtual table A131 is shown in FIG. The virtual table A131 consists of a product number and a date / time. The product number corresponds to the product number in the base table A111, and the date / time corresponds to the latest (maximum) date / time in the same product number in the base table B112. Yes. The virtual table A 131 always serves as an index reflecting the latest state of the RDB 11 when viewed from the application 21, and is referenced from the application 21.
[0040]
The stored procedure activation unit 14 activates the stored procedure 13 when the application 21 makes a request to the RDBMS 12 to use the virtual table A 131 generated by the stored procedure 13. If the specified stored procedure 13 has already been activated and executed, and the RDB 11 has not been updated thereafter, the stored procedure 13 is not activated. In this case, the processing result of the stored procedure 13 already executed is used.
[0041]
The application 21 defines the virtual table B211 associated with the virtual table A131 defined and generated by the stored procedure 13 and issues an access request to the RDBMS 12 in order to acquire the latest data of the RDB11. A processing result corresponding to the issued request is returned from the RDBMS 12, and data processing is performed based on the acquired data.
[0042]
The virtual table B211 is a virtual table that is defined and generated by the application 21 based on the virtual table A131, the base table A111, and the base table B112, and includes data required by the application 21. The configuration of the virtual table B211 is shown in FIG. The virtual table B211 includes a product number, a product name, and a price. The product number is the product number of the base table A111 corresponding to the product number of the virtual table A131, and the product name is the base table A111 corresponding to the product number of the virtual table A131. The price corresponds to the price of the real table B112 corresponding to “product number + date time” of the virtual table A131.
[0043]
The operation of the first exemplary embodiment of the present invention will be described in detail with reference to FIGS.
[0044]
FIG. 4 is a diagram for explaining the operation of the first embodiment. (A) is a specific example of the base table A111, (b) is a specific example of the base table B112, and (c) is a specific example of the virtual table A131. For example, (d) shows a specific example of the virtual table B211. From (a) and (b), it can be seen that the latest price of the product name “AA” is “190” set at the date time “05261800”. FIG. 5 is a diagram showing an operation flow of the first embodiment.
[0045]
Referring to FIG. 5, the application 21 associates the product number of the base table A111 with the product number of the virtual table A131, and “product number + date time” of the base table B112 and “product number + date time” of the virtual table A131. ”, A virtual table B211 including a product number, a product name, and a price is defined, and access to the RDB 11 is requested to the RDBMS 12 (steps A11 to A12).
[0046]
The RDBMS 12 analyzes an access request to the RDB 11 from the application 21 (step M11). When the virtual table A131 defined and generated by the stored procedure 13 is specified, whether or not the stored procedure 13 needs to be started and executed. The stored procedure 13 is activated when it is recognized that the stored procedure 13 needs to be activated (steps M12 to M14). If the specified stored procedure 13 has already been activated and executed, and the RDB 11 has not been updated thereafter, the stored procedure 13 is not activated. In this case, the processing result of the stored procedure 13 already executed is used.
[0047]
The activated stored procedure 13 executes the following processing.
(1) For each product number in the base table B112, a row including the latest product in the same product number is selected (step S11).
(2) The product number of the base table A111 is associated with the product number of the result of the above (1) (step S12).
(3) A data set of the virtual table A131 composed of the product number of the real table A111 and the date and time of the result of the above (1) is created (step S13). The output result of the stored procedure 13 is shown in FIG.
[0048]
Subsequently, the RDBMS 12 performs processing based on the virtual table B211 (step M15). The processing result of the RDBMS 12 is shown in FIG.
[0049]
Thereafter, the RDBMS 12 returns the processing result to the application 21 (step M16).
[0050]
The application 21 receives the processing result from the RDBMS 12 and performs application processing (step A13).
[0051]
In this way, the application 21 can obtain the latest data of the requested RDB 11 at high speed by using the virtual table A131 that is the output result of the stored procedure 13 instead of the index.
[0052]
Next, a second embodiment of the present invention will be described in detail with reference to the drawings. The second embodiment relates to a system that searches an RDB that manages the failure content of a product consisting of three base tables, acquires the latest failure content of the product, and processes it.
[0053]
FIG. 6 is a diagram illustrating the configuration of the second embodiment.
[0054]
Referring to FIG. 6, in the second embodiment, a server 1 and a client 2 are connected by a network 3, and the server 1 includes an RDBMS 16 connected to an RDB 15 and including a stored procedure 17 and a stored procedure starting means 14. 2 includes an application 22, and the RDB 11, RDBMS 12, stored procedure 13, and application 21 of the first embodiment are replaced with RDB 15, RDBMS 16, stored procedure 17, and application 22.
[0055]
Here, the RDB 15, the RDBMS 16, the stored procedure 17, and the application 22 that are different from the first embodiment will be described.
[0056]
The RDB 15 is a relational database that stores and accumulates data, and includes a base table A 151, a base table B 152, and a base table C 153. The base table A151 is basic data, and the base table B152 and base table C153 hold a history of basic data.
[0057]
The base table A151 is one of the tables constituting the RDB15. FIG. 7A shows the configuration of the real table A151. The base table A151 includes product numbers and product names, and each row is uniquely distinguished by a product number which is a primary key.
[0058]
The base table B152 is one of the tables that make up the RDB15. FIG. 7B shows the configuration of the base table B152. The base table B152 includes a product number, a branch number A, a reception number, and a deletion. The product number corresponds to the product number of the base table A151, and thereby the base table B152 and the base table A151 are related to each other. Branch number A indicates the order of receipt numbers within the same product number, and may be a serial number or a date / time. Each line is uniquely identified by “product number + branch number A”. The reception number is a serial number assigned through the product, and the reception number is registered every time a failure of the product is received. The contents of the failure are registered in the base table C153. If there is a new failure reception for the same product, branch number A is increased and a new reception number is registered. Deletion indicates whether or not the reception number is once deleted, and is indicated as “DEL” when the reception number is deleted.
[0059]
The base table C153 is one of the tables that make up the RDB15. The configuration of the real table C153 is shown in FIG. The base table C153 includes a product number, a branch number A, a branch number B, and a failure content. “Product number + branch number A” corresponds to “product number + branch number A” in the base table B152, and thereby the base table C153 and base table B152 are related. Branch number B indicates the order of failure contents within the same “product number + branch number A”, and may be a serial number or a date / time. Each line is uniquely identified by “product number + branch number A + branch number B”. In the failure content, the failure content corresponding to the reception number is registered. When the failure content for the received reception number is updated, the updated failure content is registered by increasing the branch number B, and history management is performed as another data.
[0060]
The RDBMS 16 manages and accesses the RDB 15. A request issued from the application 22 is processed, and a processing result corresponding to the issued request is returned to the application 22.
[0061]
The stored procedure 17 performs a process of defining and generating a virtual table A171 based on the base table A151, base table B152, and base table C153, and selecting and creating a data set. The stored procedure 17 is activated by the stored procedure activation means 14. The name of the virtual table A 171 is determined when the stored procedure 17 is registered in the RDBMS 16. The application 22 can refer to the virtual table A 171 generated by the stored procedure 17 by designating this name. The method for registering the stored procedure 17 in the RDBMS 16 is a known method.
[0062]
The virtual table A 171 is a virtual table including a unique key of the latest history. Based on the base table A151, base table B152, and base table C153, the stored procedure 17 defines and generates the product number of the base table A151 and the same branch number A and base table C153 within the same product number of the base table B152. A selection condition for combining the largest branch number B in “product number + branch number A” is designated. The configuration of the virtual table A 171 is shown in FIG. The virtual table A171 is composed of a product number, a branch number A, and a branch number B. The product number is the product number of the base table A151, and the branch number A is the branch number A within the same product number of the base table B152. The number B corresponds to the largest branch number B in the same “product number + branch number A” of the base table C153. The virtual table A 171 always serves as an index reflecting the latest state of the RDB 15 when viewed from the application 22, and is referenced from the application 22.
[0063]
In order to acquire the latest data in the RDB 15, the application 22 defines a virtual table B 221 associated with the virtual table A 171 defined and generated by the stored procedure 17 and issues an access request to the RDBMS 16. A processing result corresponding to the issued request is returned from the RDBMS 16 and data processing is performed based on the acquired data.
[0064]
The virtual table B221 is a virtual table defined and generated by the application 22 based on the virtual table A171, the base table A151, the base table B152, and the base table C153, and includes data required by the application 22. The configuration of the virtual table B221 is shown in FIG. The virtual table B221 includes a product number, a product name, a reception number, and a failure content. The product number corresponds to the product number of the base table A151 corresponding to the product number of the virtual table A171, and the product name corresponds to the product number of the virtual table A171. To the product name of the base table A151, the reception number is the reception number of the base table B152 corresponding to “product number + branch number A” of the virtual table A171, and the failure content is “product number + branch number A + branch” of the virtual table A171. This corresponds to the failure contents of the base table C153 corresponding to “No. B”.
[0065]
The operation of the second exemplary embodiment of the present invention will be described in detail with reference to FIGS.
[0066]
FIG. 8 is a diagram for explaining the operation of the second embodiment. (A) is a specific example of the base table A151, (b) is a specific example of the base table B152, and (c) is a specific example of the base table C153. For example, (d) shows a specific example of the virtual table A171, and (e) shows a specific example of the virtual table B221. In (b), the reception numbers “002” and “003” are once received but then deleted, and are therefore indicated as “DEL” for deletion. FIG. 9 is a diagram illustrating a flow of operations according to the second embodiment.
[0067]
Referring to FIG. 9, the application 22 associates the product number of the base table A151 with the product number of the virtual table A171, and “product number + branch number A” of the base table B152 and “product number + branch” of the virtual table A171. No. A ”,“ product number + branch number A + branch number B ”in the base table C153 and“ product number + branch number A + branch number B ”in the virtual table A171, and the product number and product name A virtual table B221 composed of the receipt number and the failure content is defined, and access to the RDB15 is requested to the RDBMS 16 (steps A21 to A22).
[0068]
The RDBMS 16 analyzes the access request to the RDB 15 from the application 22 (step M21). When the virtual table A171 defined and generated by the stored procedure 17 is specified, whether or not the stored procedure 17 needs to be started and executed is determined. The stored procedure 17 is activated when it is recognized that activation of the stored procedure 17 is necessary (steps M22 to M24). If the specified stored procedure 17 has already been started and executed and the RDB 15 has not been updated thereafter, the stored procedure 17 is not started. In this case, the processing result of the stored procedure 17 already executed is used.
[0069]
The activated stored procedure 17 executes the following processing.
(1) For each “product number + branch number A” in the base table C153, a row including the largest branch number B in the same “product number + branch number A” is selected (step S21). In this example, a line with a circle at the right end in FIG. 8C is selected.
(2) The “product number + branch number A” in the base table B152 is associated with the “product number + branch number A” as a result of the above (1) (step S22). At this time, “product number + branch number A” of the base table B152 in which “DEL” is set for deletion of the base table B152 is excluded. In this example, the lines with the receipt numbers “002” and “003” are excluded because “DEL” is set for deletion, and are related to the right end of FIGS. 8B and 8C. It is a line with.
(3) A data set of the virtual table A171 is created, which includes the product number of the real table A151, the branch number A resulting from the above (2), and the branch number B resulting from the above (2) (step S23). The output result of the stored procedure 17 is shown in FIG.
[0070]
Subsequently, the RDBMS 16 performs processing based on the virtual table B221 (step M25). The processing result of the RDBMS 16 is shown in FIG.
[0071]
Thereafter, the RDBMS 16 returns the processing result to the application 22 (step M26).
[0072]
The application 22 receives the processing result from the RDBMS 16 and performs application processing (step A23).
[0073]
In this way, the application 22 can obtain the latest data of the requested RDB 15 at high speed by using the virtual table A 171 as the output result of the stored procedure 17 instead of the index. That is, the application 22 can perform processing by acquiring the latest reception number and the failure content for the product number without performing complicated processing.
[0074]
In the above-described embodiment according to the present invention, a program or the like for executing the processing operation of the database access method is stored as data in a storage device (not shown) such as a magnetic disk or an optical disk, and the stored data Is used to operate the database access method. As described above, data for operating the database access method according to the present invention is stored in the storage medium, and the function of the database access method can be realized by installing this storage medium.
[0075]
【The invention's effect】
The first effect is that the latest data can always be referred to from the application at high speed only by referring to the necessary stored procedure. The reason is that a means for configuring a function for generating an index for an application in a stored procedure is provided.
[0076]
The second effect is that the load on the client is reduced and the network traffic is also reduced. The reason is that the stored procedure is executed on the server side, so there is no need to issue a complex SQL from the application, and the application can construct the process simply by describing the data manipulation process based on the table of unique keys. This is because there is less interaction between the client application and the server RDBMS.
[0077]
A third effect is that no special recovery procedure such as re-creating a physical index table for an application index is required in the event of a database failure. This is because the application index uses a stored procedure as a virtual table.
[Brief description of the drawings]
FIG. 1 illustrates the present invention
FIG. 2 is a diagram showing a configuration of the first exemplary embodiment
FIG. 3 is a diagram showing a configuration of (a) base table A (b) base table B (c) virtual table A (d) virtual table B in the first embodiment.
4A and 4B are diagrams for explaining the operation of the first embodiment: (a) base table A (b) base table B (c) virtual table A (d) virtual table B
FIG. 5 is a diagram showing an operation flow of the first embodiment;
FIG. 6 is a diagram showing a configuration of the second exemplary embodiment.
FIG. 7 is a diagram showing a configuration of (a) base table A (b) base table B (c) base table C (d) virtual table A (e) virtual table B in the second embodiment.
FIG. 8 is a diagram for explaining the operation of the second embodiment: (a) base table A (b) base table B (c) base table C (d) virtual table A (e) virtual table B
FIG. 9 is a diagram showing a flow of operations according to the second embodiment.
FIG. 10 illustrates a conventional operation; (a) base table A (b) base table B (c) result diagram
[Explanation of symbols]
1 server
2 clients
3 network
4 Database
5 Database management system
6 Stored procedure execution means
7 Database access request means
11 RDB
12 RDBMS
13 Stored Procedure
14 Stored procedure activation means
15 RDB
16 RDBMS
17 Stored Procedure
21 Application
22 Application
111 Base table A
112 Base table B
131 Virtual table A
151 Base table A
152 Base Table B
153 Base table C
171 Virtual table A
211 Virtual table B
221 Virtual table B

Claims (3)

A relational database accessed from a server, storing and accumulating data and including one or more base tables;
A stored procedure that defines the configuration of the first virtual table associated with the base table name and the item name and creates the first virtual table (unique key table), and the stored procedure has not yet been started and executed Or the stored procedure starting means for starting the stored procedure when the stored procedure has already been started and executed and the relational database has been updated thereafter, and the second virtual table defined by the application includes When the name of one virtual table and the name of an item constituting the first virtual table are specified, the processing related to the name of the first virtual table and the name of the item constituting the first virtual table Means for accessing the relational database using the first virtual table (unique key table), from an application A server having a relational database management system that returns accessing the relational database based on the determined have been processed the processing result to the application,
The relationship is defined by defining the name and item name of the base table and the name of the first virtual table defined by the stored procedure and the structure of the second virtual table associated with the item name constituting the first virtual table. A client having an application that issues a request to access a database to the relational database management system and receives a request result from the relational database management system;
A database access method characterized by comprising: A method for accessing a database of a system having a server including a relational database management system, a client including an application, and a relational database,
The relational database management system includes:
Registering a stored procedure that defines the configuration of the first virtual table associated with the name and item name of the base table included in the relational database;
Launch and execute the stored procedure to create a first virtual table (unique key table),
The application is
The structure of the second virtual table associated with the name and item name of the base table included in the relational database and the name of the first virtual table defined by the stored procedure and the item name constituting the first virtual table. Issue a request to the relational database management system to define and access the relational database;
The relational database management system includes:
Accessing the relational database based on processing requested by the application;
When the name of the first virtual table and the item name constituting the first virtual table are specified in the configuration of the second virtual table defined by the application, the name of the first virtual table and Accessing the relational database using the first virtual table (unique key table) for processing related to the item names constituting the first virtual table;
Return the processing result to the application,
The application is
Receiving a request result from the relational database management system;
A database access method characterized by the above . Relational database management system
Registering a stored procedure that defines the structure of the first virtual table associated with the name and item name of the base table included in the relational database;
Processing to start and execute the stored procedure to create a first virtual table (table of unique key);
Application
The structure of the second virtual table associated with the name and item name of the base table included in the relational database and the name of the first virtual table defined by the stored procedure and the item name constituting the first virtual table. Processing to define and issue a request to access the relational database to the relational database management system;
The relational database management system is
A process of accessing the relational database based on a process requested by the application;
When the name of the first virtual table and the item name constituting the first virtual table are specified in the configuration of the second virtual table defined by the application, the name of the first virtual table and A process for accessing the relational database using the first virtual table (unique key table) for a process related to an item name constituting the first virtual table;
Processing to return a processing result to the application;
The application
Receiving a request result from the relational database management system;
A recording medium on which a program for causing a computer to execute is recorded .

Images