JPH044438A - System for utilizing data base buffer - Google Patents

Abstract

PURPOSE:To reduce the number of reading times by changing the storing unit from a data base to a system buffer when storing units in close vicinity are continuously retrieved in the data base by additionally providing a system buffer number indicating means. CONSTITUTION:System buffers 2a-2m store storing units to be retrieved by data base processing programs 1a-1l and a system buffer inputting means 3 reads the storing units into the system buffers 2a-2m from a data base 5 on the basis of retrieval processing requests from the programs 1a-1l. In addition, a system buffer releasing means 4 releases the buffers 2a-2m so that the buffers 2a-2m can be reutilized and a system buffer number indicating means 6 instructs the system releasing means 4 for the number of system buffers 2a-2m to be suppressed from releasing in connection with one time of retrieval processing request from the data base processing programs 1a-1l. Therefore, the storing unit can be changed from the data base to the system buffers and the number of reading times can be reduced.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database buffer usage method, and particularly to a database buffer in an information processing system that reads storage units into a system buffer from a database divided into a plurality of parts called storage units. Regarding usage method.

[Conventional technology]

It is an external storage medium for storing data as data records, and includes a database that is divided into storage units, a system buffer that stores the storage units in which data processing such as search processing is performed by the database processing program, and a data processing instruction ( instructions indicating a request for search processing, etc.)
system buffer input means (1) that reads a storage unit from the database based on the
(one storage unit is stored in one system buffer)
Information processing systems that perform database search processing using a system buffer release means that releases a system buffer and makes it possible to reuse the system buffer are conventionally known.

FIG. 3 is a block diagram showing the configuration of an example of a conventional database buffer usage method in such an information processing system. This database buffer usage method is
The system includes database processing programs lla to 11p, system buffers 12a to 12m, system buffer input means 13, system buffer release means 14, and database 15.

This database buffer usage method operated as shown below.

Search processing for storage units that do not exist in the system buffers 12a to 12m is performed by the data heath processing program lla.
117i (for example, the database processing program lla), the system buffer input means 13 reads the storage unit group (
A series of storage units (starting with the requested storage unit and following that storage unit) are read and stored in system buffer 1.
2a to 12m (in the order in which they are stored in the database 15 with the requested storage unit at the beginning). This allows the database processing program lla to access the requested storage unit.

Database processing program for that storage unit
When the search processing by a is completed, the system buffer release means 14 releases the system buffers 12a to 12m to enable reuse of the system buffers 12a to 12m.

[Problem to be solved by the invention]

In the conventional database buffer usage method described above, when the search process (referred to as search process A) of any database processing program for the storage unit read into the system buffer is completed, all system buffers are released by the system buffer release means. Therefore, if the system buffer is reused for a search process for a storage unit other than the storage unit read into the system buffer in search process A, then in search process A When a database processing program requests a search process for a storage unit read into the system buffer, the same storage unit read in search process A must be read from the database into the system buffer again. be.

In view of the above points, an object of the present invention is to eliminate the above-mentioned conventional drawbacks and reduce the number of times a storage unit is read from a database into a system buffer by additionally providing a means for indicating the number of system buffers. The purpose of this invention is to provide a database buffer usage method that can be used.

[Means to solve the problem]

The database buffer usage method of the present invention is such that, in an information processing system that performs database search processing, there is a system buffer that stores storage units in which search processing is performed by a database processing program, and a database buffer that stores a storage unit in which a search processing is performed by a database processing program. system buffer input means for reading a storage unit into the system buffer from a system buffer, and system buffer release means for releasing the system buffer to enable its reuse;
system buffer number instructing means for instructing the system buffer release means how many of the system buffers are to be suppressed from being released in response to one search processing request from a database processing program;

[Effect]

In the database buffer usage method of the present invention, the system buffer stores the storage unit in which the search process is performed by the database processing program, and the system buffer input means transfers the storage unit from the database to the system buffer based on the search process request from the database processing program. The system buffer release means releases the system buffer to enable its reuse, and the system buffer number indicating means reads one from the database processing program.
Instructs the system buffer release means how many system buffers to suppress from being released for each search processing request.

〔Example〕

Next, the present invention will be explained in detail with reference to the drawings.

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

The database buffer usage method of this embodiment is the database processing programs 1a to 17! (When any one of the database processing programs 1a to 1β is indicated, it is indicated as "database processing program 1") and the storage unit 7 searched by the database processing program 1
(See Figure 2) A system buffer 2a for storing...
・, 2g, ..., 2m (system buffer 2a to 2m
"System buffer 2" to indicate any one of them.
), a system buffer input means 3 that reads a storage unit 7 from the database 5 and stores it in the system buffer 2 based on a data processing instruction (such as an instruction indicating a request for search processing) from the database processing program 1;
Free system buffer 2 and release system buffer 2.
system buffer release means 4 that enables reuse of the
A database 5 that is an external storage medium for storing data as data records, and a system buffer number instruction that instructs the system buffer release means 4 how many system buffers 2 are to be suppressed from being released for one search processing request. means 6.

FIG. 2 is a diagram showing an example of the structure of the database 5. As shown in FIG. As shown in the figure, the database 5 is composed of a plurality of storage units 7a, 7b, 7c, . . . (when indicating any one of the storage units 7a, 7b, 7c, . (shown as “storage unit 7”).

Next, the operation of the database buffer utilization method of this embodiment configured as described above will be explained.

A database processing program 1 (for example, a database processing program la) is a system buffer 2.
Storage unit 7 that does not exist in a to 2m (for example, storage unit 7
Assume that a search process is requested for (a).

When this request is made, the system buffer input means 3 extracts a group of storage units starting from the requested storage unit 7a from the database 5 into the storage unit 7a.

7b, 7c, . . . are read in the order and stored in the system buffers 2a to 2m in that order. This allows the database processing program 1a to access the requested storage unit 7a.

Database processing program 1a for storage unit 7a
When the search process is completed, the system buffer number instructing means 6 instructs the system buffer releasing means 4 how many system buffers 2 out of the system buffers 2a to 2m are to be suppressed from being released (the number of system buffers to be suppressed from being released is (The number of system buffers is given to the system buffer number indicating means 6 in advance).

The system buffer release means 4 selects one of the system buffers 2a to 2m based on the number of system buffers 2 to be suppressed from being released as instructed by the system buffer number instruction means 6 upon completion of the search process by the database processing program 1a. The release of the system buffers 2a to 2g is suppressed.

Therefore, after the search process by the database processing program 1a described above is completed, the system buffers 2a to 2g are no longer reused, and each of the system buffers 2a to 2g (for example, system buffer 2b) is The stored storage unit 7 (for example, 7b in the system buffer 2b)
), the database processing program 1 can immediately access the storage unit 7b. (It becomes unnecessary to read the storage unit 7b into 2m).

〔Effect of the invention〕

As explained above, in the present invention, by additionally providing a system buffer number indicating means, etc., storage units are read from the database into the system buffer when adjacent storage units in the database are successively searched. This has the effect of reducing the number of times.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention, FIG. 2 is a diagram showing an example of the structure of the database in FIG. 1, and FIG. 3 is an example of a conventional data storage spa usage method. FIG. 2 is a block diagram showing the configuration. In the figure, 1a-11... database processing program, 2a-2
m...System buffer, 3...System buffer input means, 4...
... System buffer release means, 5 ... Database, 6 ... System buffer number indication means, 7a,
7b, 7c, --- It is a storage unit.

Claims (1)

[Scope of Claim] An information processing system that performs a database search process, comprising: a system buffer that stores a storage unit in which a search process is performed by a database processing program; and a system buffer that stores a storage unit in which a search process is performed by a database processing program; system buffer input means for reading a storage unit into a buffer; system buffer release means for freeing the system buffer to enable its reuse; and system buffer number instructing means for instructing the system buffer release means whether to suppress release of the database buffers.