JPH0635769A - Data base system - Google Patents

Abstract

PURPOSE:To improve processing efficiency at the time of inserting records to a data base. CONSTITUTION:This data base system finds a record insertion position with a record position decision means 1 and then discriminates whether or not a block which the record belongs to is held at a temporary storage means 4 by a file input/output discrimination means 2. When the block is not held, the block found by a file read means 3 is read and the block is held at the temporary storage means 4. To the held block, record insertion processing is executed at a record insertion means 5 and the whether or not writing the block to a file is required, is discriminated at the file input/output discrimination means 2. When the writing the block to the file is required, the held block is written by a file write means 6.

Description

Detailed Description of the Invention

[0001]

The present invention relates to a database system,
In particular, it relates to a database system that stores data in order for files.

[0002]

2. Description of the Related Art Generally, a database system is used for efficiently managing and effectively utilizing accumulated data, and is used for data processing in sales management, inventory management and the like.

An example of a conventional database system is shown in FIG.
Shown in. FIG. 2 is a block diagram of a database system showing an example of a conventional technique. A record position determination means 1 for obtaining a record position to be processed and a block to which a record belongs from a file based on the obtained position. File reading means 3 for reading, temporary storage means 4 for holding the read block until processing is completed, record inserting means 5 for inserting a record into the held block, and the held block for the file It is composed of a file writing means 6 for writing.

When inserting a certain record in the database system of FIG. 2, first, the relative position in the file of the block to which the record to be processed belongs and the position of the record in the block are determined as the record position. Determined through the judging means 1. The record position judging means 1 transmits the obtained position to the file reading means 3 and gives an instruction to read it from the file. The file reading means 3 reads the target block from the file based on the transmitted relative position information in the file. The blocks thus read from the file are temporarily stored in the work area on the main memory by the temporary storage means 4 until the processing is completed. After holding the block to be processed in the work area, the record insertion unit 5 writes the record at the record position in the block determined by the record position determination unit 1 of the held block. After the record insertion processing for the temporarily stored block is completed, the temporarily stored block is written to the file by the file writing means 6, and the one-record insertion processing for the database file is completed.

[0005]

In the above conventional database system, when one record is inserted,
Every time, the block to which the record belongs is read from the file, the record is inserted, and the block to which the record belongs is always written to the file.

This record insertion is a process of writing a record at a record position within a block, and is not affected by the record before the record writing position. Therefore, when the processing for the same block continues, it is not necessary to execute the processing of reading the block from the file and the processing of writing the block to the file every time. That is, when the same block is used, it is possible to perform the processing while holding the block until the use of the block is completed.

Therefore, in the conventional method of reading and writing blocks from a file every time, unnecessary blocks are read from the same block and unnecessary blocks are written into the same block, resulting in a decrease in the processing capacity of the system. It was connected.

[0008]

A record position determining means, a file reading means, a temporary storage means, a record inserting means, and a file writing means are provided, and the relative position in a file of a block into which a record is inserted and the above-mentioned The relative position within the block of the record is obtained by the record position determination means, the block is read from the file by the file reading means, the read block is held by the temporary storage means, and the held block is stored in the block. On the other hand, in the database system for writing the block held after the record is inserted by the record inserting means to the file by the file writing means, the block transmitted by the record position judging means is read from the file. Only when necessary, after the record insertion processing by the record insertion means for the block read and read from the file through the file reading means, and when the processing for writing the block after the record insertion into the file is necessary. Only the file input / output determining means for writing to the file via the file writing means is provided.

[0009]

Embodiments of the present invention will now be described with reference to the drawings. FIG. 1 is a configuration diagram showing a database system according to an embodiment of the present invention.

The record position determining means 1, the file reading means 3, the temporary storage means 4, the record inserting means 5 and the file writing means 6 of this embodiment have the same functions as those of the conventional database system. The judging means 2 is newly added.

Next, the operation of this database system will be described.

When the record to be inserted is input, the record position judging means 1 obtains the relative position within the file of the block into which the record is to be inserted and the relative position within the block of the file, and the relative position information within the file of the obtained block. Is output to the file input / output determination means 2.

The file input / output judging means 2 confirms whether or not the read block from the file is already held in the temporary storage means 4.

If this block is already stored in the temporary storage means 4, the file reading process is omitted,
Control is passed to the record insertion means 5.

On the other hand, if this block is not held in the temporary storage means 4, the relative position information within the file of the block from the record position determination means 1 is output to the file reading means 3 to instruct the file reading. give. The file reading means 3 reads the block existing at the designated position from the file. The read block is held by the temporary storage means 4. After holding the block, control is passed to the record inserting means 5.

The record inserting means 5 executes the record inserting processing, and after the record inserting processing is completed, requests the file input / output judging means 2 to write the block in which the record is inserted into the file. File input / output determination means 2
Checks the necessity of writing the requested block to a file, and gives a file writing instruction to the file writing / writing means 6 only when necessary. Upon receiving the instruction, the file writing means 6 writes the block to the file. If the file input / output determination unit 2 determines that writing to the file is not necessary, the writing process to the file is omitted.

As described above, by eliminating the re-reading of the already read block and by not writing out the same block each time a record is inserted, extra processing is omitted and the database system is saved. The processing capacity can be improved.

[0018]

As is apparent from the above description, the present invention has the effect of improving the record insertion processing efficiency of the database system.

[Brief description of drawings]

FIG. 1 is a configuration diagram of a database system of the present invention.

FIG. 2 is a configuration diagram of a conventional database system.

[Explanation of symbols]

 1 record position judging means 2 file input / output judging means 3 file reading means 4 temporary storage means 5 record inserting means 6 file writing / writing means

Claims (1)

[Claims] 1. A record position determination means, a file reading means, a temporary storage means, a record insertion means, and a file writing means, and a relative position in a file of a block into which a record is inserted and the block of the record. The inner relative position is obtained by the record position determination means, the block is read from the file by the file reading means, the read block is held by the temporary storage means, and the record is stored for the held block. In a database system in which the block held after inserting the record by the inserting unit is written to the file by the file writing unit, when the block transmitted by the record position determining unit needs to be read from the file Only after the record insertion processing by the record insertion means for the block read and read from the file through the file reading means, the block writing after the record insertion into the file is necessary. A database system comprising a file input / output judging means for writing the file to the file via a means.