JPH04257972A - Data base processing device - Google Patents

Abstract

PURPOSE:To shorten the time for inserting a tuple to a data base and to reduce the cost of the tuple insertion processing. CONSTITUTION:When the tuple insertion processing is requested from a data base processing requesting device 14, a tuple buffering processing device 17 buffers the processing request for each tuple. According to the buffered processing request, a data base managing device 13 stores tuples in the data base one by one.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database processing apparatus that processes one tuple at a time for a database processing requesting apparatus.

0002

[Prior Art] Generally, a relational database has a database management device that manages the database, and a database management device that inserts data into the database management device.
Processing with the database processing requesting device that requests reading is performed one tuple at a time.

[0003] This 1-tuple refers to a collection of related data in one item in a database. FIG. 2 is an explanatory diagram of this tuple. That is, one tuple refers to, for example, a collection of product numbers, names, unit prices, etc. in one line that are related to each other in the illustrated table.

FIG. 3 shows the configuration of a conventional database processing device. The database processing device 1 shown in the figure consists of an interface processing device 2 and a database management device 3, and this database processing device 1 is connected to a database processing requesting device 4. The interface processing device 2 includes a transmission/reception buffer storage device 5 and a buffer management device 6. The transmission/reception buffer storage device 5 is a memory that stores processing requests sent from the database processing request device 4 and processing results from the database management device 3. extracting a request from , and passing a data (hereinafter referred to as tuple) insertion request to the database management device 3;
It has a function of receiving processing results from the database management device 3 and setting them in the transmission/reception buffer storage device 5. The database management device 3 receives the database processing request device 4 via the interface processing device 2.
It has a function of inserting a tuple into the database in accordance with a processing request from the interface processing device 2 and sending the processing result to the interface processing device 2. Database processing request device 4
is a device that requests the database processing device 1 to insert a database, and the request is configured to be made one tuple at a time.

Next, the operation of the database processing apparatus having the above configuration will be explained. FIG. 4 shows the processing sequence. (a) Processing request First, the database processing requesting device 4 sends a processing request for one tuple to the database processing device 1. In this case, the tuples are "Oki Denki", "Okitaro", and "Warabi".
The case of an insert request is shown. (b) Insertion Process As a result, on the database processing device 1 side, the buffer management device 6 takes out the processing request sent to the transmission/reception buffer storage device 5 and issues an insertion request to the database management device 3. When the database management device 3 receives this request, it inserts the tuple into the database. (c) When the tuple is inserted into the processing result database, the database management device 3 transfers the processing result to the interface processing device 2.
Send to. The buffer management device 6 of the interface processing device 2 receives the processing result from the database management device 3, sets it in the transmission/reception buffer storage device 5, and returns the result to the database processing request device 4. After that, the next tuple (in this example, "Oki Electric", "Oki Jiro", "Shibaura")
) processing request (a), insertion processing (b), processing result (c)
Do the same thing.

[0006] In this way, the processes (a) to (c) above are as follows:
This is repeated as many times as the number of tuples you want to insert. That is, in the conventional database processing apparatus, the tuple insertion process is performed in synchronization between the database processing apparatus 1 and the database processing requesting apparatus 4.

[0007]

However, the conventional database processing apparatus described above has the following problems, especially when inserting a large number of tuples into a database. That is, in the conventional database processing apparatus, the processing sequence between the database processing requesting apparatus 4 and the interface processing apparatus 2 in the database processing apparatus 1 is serial, so that the number of times of communication between the database processing requesting apparatus 4 and the interface processing apparatus 2 is the same as that of the database processing apparatus 1. is proportional to the number of tuples inserted into . Therefore, when inserting a large number of tuples, the insertion process takes a lot of time, leading to an increase in processing cost.

The present invention has been made to solve the above conventional problems, and is a database processing method that can shorten processing time even when inserting a large number of tuples, and can reduce costs. The purpose is to provide equipment.

[0009]

[Means for Solving the Problems] A database processing device of the present invention treats a collection of related data in one item in a database as one tuple, and processes the database processing requesting device one tuple at a time. The invention is characterized in that it includes a database management device that manages a database, and a tuple buffering processing device that is interposed between the database management device and the database processing request device and buffers processing of each tuple. That is.

0010

In the apparatus of the present invention, when a request for tuple insertion processing is received from the database processing requesting apparatus, the tuple buffering processing apparatus buffers the processing request for each tuple. The database management device stores each tuple in the database according to the buffered processing requests. Therefore, the processing time for tuple insertion into the database is shortened, and the cost of tuple insertion processing can be reduced.

[0011]

Embodiments Hereinafter, embodiments of the present invention will be explained in detail with reference to the drawings. FIG. 1 is a block diagram showing an embodiment of a database processing apparatus of the present invention. The database processing device 11 shown in the figure includes an interface processing device 12, a database management device 13, and a tuple buffering processing device 17, and a database processing request device 14 is connected to this database processing device 11.

The interface processing device 12 is composed of a transmitting/receiving buffer storage device 15 and a buffer management device 16 as in the prior art, and the database management device 13 and database processing requesting device 14 are also similar to the conventional database management device 3 and database processing device 16. Since they are similar to the requesting device 4, detailed description thereof will be omitted.

The tuple buffering processing device 17 buffers tuple insertion requests from the database processing request device 14 and sends them all together to the interface processing device 12.
This is a device that makes processing requests (batch requests). That is, the tuple buffering processing device 17 buffers the processing request from the database processing requesting device 14, and when the processing request cannot be buffered any longer or the processing request is completed, the tuple buffering processing device 17 buffers the processing request from the database processing requesting device 14. The buffered request is sent to the storage device 15 and the result is waited for. and,
In this state, another buffering storage device buffers the processing request from the database processing requesting device 14. Therefore, there are two buffering storage devices, and they are configured to process processing exchanges with the database processing requesting device 14 and processing exchanges with the interface processing device 12 in parallel.

FIG. 5 shows a tuple buffering processing device 17.
The specific configuration is shown below. That is, the tuple buffering processing device 17 has two buffering storage devices 18, 1
9, a current buffer storage device 20, a position storage device 21, and a tuple buffering control device 22. The buffering storage devices 18 and 19 each include a random access memory or the like, and are storage units having a plurality of tuple storage units to store a plurality of tuples. The current buffer storage device 20 is a storage unit that stores one of the two buffering storage devices 18 and 19 that is buffering processing requests. The position storage device 21 is a storage section that indicates the positions of a plurality of storage sections in the buffering storage devices 18 and 19 in order to buffer processing requests sent from the database processing request device 14 in order. The tuple buffering control device 22 is
It consists of a processor, a program, etc., and has a function of controlling these buffering storage devices 18, 19 to position storage device 21.

Next, the operation of the database processing apparatus having the above configuration will be explained. FIG. 6 shows the sequence of tuple insertion processing in the database processing device. (1) First, the tuple buffering control device 22 of the tuple buffering processing device 17 receives the first tuple insertion processing request (
If a) is received, one of the buffering storage devices 18 and 19 to be buffered is recorded in the current buffer storage device 20. Now, suppose this is the buffering storage device 18, and this buffering storage device 1
Assume that the processing request is stored in 8 (b). It also returns the results of the processing request to the database processing requesting device 14. Furthermore, the position storage device 21 is also initialized. (2) Then, the tuple buffering processing device 17
Every time a tuple insertion processing request is received from the database processing requesting device 14, the request is buffered in the buffering storage device 18 indicated by the current buffer storage device 20, and the result of the processing request is returned to the database processing requesting device 14. do. Furthermore, the storage unit position indicated by the position storage device 21 is changed (c). (3) When the processing requests stored in the buffering storage device 18 become full, that is, when each tuple storage section becomes full, the tuple buffering control device 22 returns the result of the processing request to the database processing request device 14. After that,
The processing requests buffered in the buffering storage device 18 are sent together to the interface processing device 12 (d). Further, the tuple buffering control device 22 changes the current buffer storage device 20 to another buffering storage device 19 to buffer the processing request, initializes the position storage device 21, and also initializes the database processing request device 19. Wait for the next processing request from.

(4) On the other hand, the database management device 13 inserts each tuple-by-tuple processing request passed from the interface processing device 12 into the database (e), and returns the result to the interface processing device 12. The interface processing device 12 stores the transmitted buffering storage device 18.
Return the results to (g). (5) Furthermore, if a tuple insertion request is received from the database processing request device 14 while the buffering storage device 18 is sending out a batch request, the tuple buffering control device 22 stores the buffer in the other buffering storage device 19. (f). If the buffering storage device 19 also becomes full of requests,
The result of the request processing is not returned to the database processing requesting device 14 until the processing result is returned from the interface processing device 12. (6) When the tuple buffering processing device 17 receives the last result from the interface processing device 12, it returns the result to the database processing requesting device 14.

[0017] Also, buffering storage devices 18, 19
If one of the devices is not full,
When the processing request from the database processing requesting device 14 is completed, the tuple buffering control device 22 transmits the processing request buffered in one of the buffering storage devices 18 and 19 to the interface processing device 12. Then, the buffering storage device indicated by the current buffer storage device 20 is changed to the other one, the position storage device 21 is initialized, and the result from the interface processing device 12 is awaited.

In the above embodiment, the tuple buffering processing device 17 has two buffering storage devices 18 and 19, but the number is not limited to this. For example, three or more buffering storage devices may be provided. , the processing requests may be sequentially stored in these.

[0019]

As explained above, according to the database processing device of the present invention, a tuple buffering processing device is provided between the database management device and the database processing request device for buffering processing of one tuple at a time. Therefore, the processing between the database processing requesting device and the database management device can be performed in parallel, and therefore the processing for inserting tuples into the database can be speeded up, which can contribute to reducing the cost of the processing for inserting tuples.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of a database processing device of the present invention.

FIG. 2 is an explanatory diagram of a 1-tuple in the database management system.

FIG. 3 is a block diagram of a conventional database processing device.

FIG. 4 is a sequence chart of a conventional database processing device.

FIG. 5 is a block diagram of a tuple buffering processing device in the database processing device of the present invention.

FIG. 6 is a sequence chart of the database processing device of the present invention.

[Explanation of symbols]

11 Database processing device 12 Interface processing device 13 Database management device 14 Database processing request device

Claims (1)

[Claims] 1. A database management device that manages a database in a database processing device that treats a collection of related data in one item in a database as one tuple and processes one tuple at a time to a database processing request device; A database processing device comprising: a tuple buffering processing device that is interposed between the database management device and the database processing request device and buffers processing of one tuple at a time.