JPS63269224A - Data base access system - Google Patents

Abstract

PURPOSE:To facilitate generation of an application program which accesses a data base, by storing information of the data structure related to the data base and information of the processing process of the application program to the data base. CONSTITUTION:The data structure of a constituting element or the like of a data base 1-2 is stored in a data structure storage part 1-4, and records or the like processed by an application program 1-1 till then are stored in a processing process storage part 1-42. A data structure retrieving part 1-52 retrieves a storage part 1-41 on the basis of request information from a request data input means 1-3 by the function of a flat access control part 1-51 and reads out information of the data structure of the base 1-2 related to request information. A processing process storage retrieving part 1-53 checks contents of the storage part 1-42 and reads out information of the processing process executed till then of the base 1-2 related to request information. Thus, the control part 1-51 assembles a series of instruction execution procedures by which the data base can be accessed.

Description

[Detailed description of the invention] [Industrial application field] The present invention relates to a database access method.

[Conventional technology]

In conventional database access methods, a business program that accesses a database must be written in a language such as Kobol, with a series of data manipulation instructions arranged in a logical order according to the data structure used by the database. There is. Particularly in the case of a hierarchical database, a series of data manipulation instructions must be written in an orderly manner from the upper hierarchy to the lower hierarchy according to the hierarchical structure of the database.

FIG. 2 is a block diagram showing an example of a conventional database access method.

In FIG. 2, a business program 2-1 that creates a transaction history table accesses and utilizes a database 2-2. The database 2-2 is composed of a database management system 2-21 that manages file information using software and a database disk file 2-22 that stores file information in a large-capacity magnetic disk device.

The database disk file 2-22 has a hierarchical structure of customer records, ledger records related by customer sets in customer records, transaction history records related by ledger sets in ledger records, etc. Filed.

In this case, the record access path in the database is such that the customer set is obtained only by accessing the customer records filed in the first layer, so the ledger records in the second layer can be accessed, and then the ledger records in the second layer can be accessed. Since the ledger set can only be obtained by accessing the ledger records in the hierarchy, the structure is such that the transaction history records in the third hierarchy can be accessed, so the business program 2-1 follows this hierarchical data structure. , each data manipulation instruction must be written in an orderly and logical arrangement.

[Problem that the invention seeks to solve]

In the conventional database access method described above, (A) when writing a business program, the data structure of the database must be considered and each item must be logically written in the correct order, making the business program complex. Difficult. (B) Creating business programs requires expert knowledge of databases, making it difficult to educate and train the staff who create business programs. (C) Because there are a large number of data manipulation instructions. The problem is that it takes a lot of man-hours to create 10 grams of work.

SUMMARY OF THE INVENTION An object of the present invention is to provide a database access method that allows even a person with little knowledge of databases to easily create a business program that accesses a database, and that requires less man-hours to create the business program.

[Means for solving problems]

The database access method of the present invention is a database access method for a system that includes a business program and a database used by the business program. request/data input means for receiving requests and data necessary for these; storage means for storing information on a data structure regarding the database and information on a processing process for the database by the business program; and the request/data input means. flat access control means for assembling a series of command execution procedures for the database that satisfies a request from the business program based on input information from the storage means and stored information from the storage means; command processing means for instructing the execution of data manipulation requested by the business program by sending a series of commands to the business program; and data output means for outputting information on the execution results according to the instructions of the command processing means to the business program. It is composed of:

〔Example〕

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

FIG. 1 is a block diagram showing an embodiment of the database access method of the present invention.

In FIG. 1, a business program 1-1 is a program that processes a business that accesses and uses a database 1-2. The database 1-2 includes a database management system 1-21 that manages file information using software, and a database disk file 1-22 that stores file information in a large-capacity magnetic disk device.

Regardless of the data structure of the database 1-2, the business program 1-1 makes various requests and associated parameters regarding records to be processed and their operations in order to access the database 1-2.
Request data to be written to -2/Data input means 1-3
send to The request/data input means 1-3 receives these and checks whether the information for accessing the database 1-2 is available, and if the information is not available, it informs the business program 1-1, and if the information is available, it informs the business program 1-1. Move to the following access operation.

The storage means 1-4 includes a data structure storage unit 1-41 that stores data structures such as constituent elements of the database 1-2.
and a processing process storage unit 1-42 that stores records processed so far by the business program 1-1 and their key values.

The flat access control means 1-5 uses the function of the flat access control section 1-51 to input request data input means 1-5.
Based on the request information from 3, the data structure search unit 1-5
2 to search the data structure storage section 1-41 and read data structure information of the database 1-2 related to the request information. , and reads out the information on the processing progress so far in the database 1-2 regarding the request information.

Based on the information from these storage means 1-4, the flat access control unit 1-51 executes a series of instructions that can satisfy the requested information from the business program 1-1 and access the database as easily as possible. Assemble the steps.

In addition, the flat access control unit 1-51 activates the processing process storage unit updating unit 1-54 to store information such as the record to be processed this time and its key value in the processing process storage unit 1-54 in these series of command execution procedures. 1-42.

The instruction processing means 1-6 sends a series of instructions to the database 1-2 in accordance with these series of instruction execution procedures, and operates the database management system 1-21 to execute data operations on the database disk file 1-22. As a result, necessary information such as read data is obtained.

The data output means 1-7 obtains information obtained as the execution results such as these read data from the instruction processing means 1-6, and outputs them to the business program 1-1.

FIG. 3 is an explanatory diagram showing an example of the stored contents of the data structure storage section 1-41 representing the data structure of the database 1-2.

In FIG. 3, route information 3-1 is database 1-
The record information 3-2 is located at the storage location indicated by the record address of the A route, and the key information 3-3 is located at the storage location indicated by the key address 1 to A route 1. It is shown that.

The contents of the record information 3-2 can be accessed via the customer record in the first layer of the database 1-2 that can be indexed as the main index using the customer index, and the customer set in the customer record in the first layer in the second layer. This shows that transaction history records that can be accessed via the ledger set in the ledger record in the second layer are respectively filed in the ledger record and the third layer.

Further, the contents of the key information 3-3 indicate that each of the above records has a 6-digit X attribute (indicating that it is an alphanumeric character) read out by a customer number.

On the other hand, FIG. 4 is an explanatory diagram showing an example of the storage contents of the process storage section 1-42.

In FIG. 4, processing process information 4-1 includes records processed so far by the business program 1-1, including the customer record of customer number oooooot that was read immediately before, and the consecutive position (NEXT) that was read immediately before. Ledger record that was in the previous sequential position (NEXT)
This indicates that the information of the transaction history record corresponding to the previous transaction history record is stored. Since requests from the business program 1-1 often request the same operations as those processed so far, this information is often used in subsequent requests.

In this way, the information regarding the data structure shown in FIG. 3 and the information regarding the processing process shown in FIG. 4 are stored in the storage means 1.
-4, the flat access control means 1-5 can assemble a series of instruction execution procedures that can satisfy the requirements of the business program 1-1.

〔Effect of the invention〕

As explained above, the database access method of the present invention has the following advantages: (A) When writing a business program, records to be processed and their operations can be described regardless of the data structure of the database; (B) Creating a business program does not require expert knowledge of databases, so it is easy to educate and train business program creators. (C) The amount of data manipulation instructions written is small. This has the effect of reducing the number of man-hours required to create business programs.

That is, the database access method of the present invention has the advantage that even if one has little knowledge about databases, it is possible to easily create a business program that accesses a database, and the number of man-hours required to create the business program can be reduced.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing an embodiment of the database access method of the present invention, FIG. 2 is a block diagram showing an example of the conventional database access method, and FIG. 3 is an example of the storage contents of the data structure storage section. Explanatory diagram, FIG. 4 is an explanatory diagram showing an example of the storage contents of the processing process storage section. 1-1.2-1...Business program, 1-2゜2-2
...Database, 1-21.2-21...Database management system, 1-22.2-22...Database disk file, 1-3...Request/data input means, ■-4... - Storage means, 1-41... Data structure storage unit, 1-42... Processing process storage unit, 1-5.
... flat access control means, 1-51 ... flat access control section, 1-52 ... data structure search section,
1-53... Processing process search unit, 1-54... Processing process updating unit, 1-6... Command processing means, 1-7... Data outputting unit, 3-1... Route information , 3-2...
Record information, 3-3...Key information, 4-1...Processing process information.

Claims (1)

[Claims] In a database access method for a system that includes a business program and a database used by the business program, requests issued by the business program to perform various data operations such as writing and reading from the database, and the data necessary for these operations. a request/data input means for receiving the request/data input means; a storage means for storing information on a data structure regarding the database and information on a process of processing the database by the business program; and input information from the request/data input means and the storage means. flat access control means for assembling a series of instruction execution procedures for the database that satisfies a request from the business program based on stored information from the computer; and sending a series of instructions for the database in accordance with the series of instruction execution procedures. A database comprising: an instruction processing means for instructing the execution of a data operation requested by the business program; and a data output means for outputting information on the execution result according to the instructions of the instruction processing means to the business program. Access method.