JPH04275675A - Data base processing system - Google Patents

Abstract

PURPOSE:To shorten the time for waiting the access of another input/output device so as to execute a data base processing to a data stored in one input/ output device concerning the external storage device of a computer system. CONSTITUTION:At an input/output sub system 31 composed of input/output devices 33 and 34 and an input/output controller 32 to execute data transfer with a host device 30, the objective data of the data base processing is stored in the first input/output device 33 equipped with a data base processing function 35, a data excepting for the objective data of the data base processing is stored in the second input/output device 34 and after the input/output controller 32 instructs the data base processing to the first input/output device 33, the second input/output device 34 is controlled.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to external storage devices for computer systems, and in particular to database processing in which records requested by a host device are selected from data stored in one input/output device. The present invention relates to a database processing method that reduces the amount of time that other input/output devices have to wait for access.

[0002] In recent years, in order to improve the efficiency of computer systems, from among the data to be processed stored in disk devices,
Database assist (DataB
There is an increasing demand for DBA (hereinafter abbreviated as DBA).

[0003] Generally, data is stored in a disk device in units of pages, one page of data is made up of a plurality of records, and one record is made up of a plurality of columns.

[0004] For example, if each record is made up of multiple columns such as name, age, and address, and a record of a certain age group is to be extracted and processed, the disk control device If the age group column is collated and the central processing unit extracts and transfers only the records of the required age group, the higher-level device does not need to receive transfers of unnecessary records, reducing data transfer time. At the same time, the processing efficiency of the computer system is improved because the time for selecting records is saved.

However, when performing such database processing with a disk control device equipped with a DBA, the DBA transfers a large amount of data from the disk device that stores the data to be processed in the memory in order to process it. One disk unit is occupied for a long time, but during this time,
It is necessary to ensure that access to other disk devices is not made to wait.

[0006]

2. Description of the Related Art FIG. 4 is a block diagram illustrating an example of the prior art, and FIG. 5 is a detailed block diagram of each functional unit.

The disk control device 3 is composed of a plurality of functional units, and the channel adapters 7 and 8 are connected to each other as shown in FIG.
), the processor 17 has a control memory 18
reads out the program stored in the , and receives the start I/O command from channel 1 or 2 through the interface circuit 15 and transfers data between channel 1 or 2, and also operates the common bus control circuit. 16,
Data is transferred to and from other functional units via the common bus 14.

Device adapters 9 and 10 are shown in FIG. 5(A).
In the configuration shown in FIG. 1, the processor 17 reads a program stored in the control memory 18 and operates, sends commands to the disk devices 4 to 6 via the interface circuit 15, and transfers data between the disk devices 4 to 6. It also controls the common bus control circuit 16 to transfer data to and from other functional units via the common bus 14.

The DBA 11 has a configuration as shown in FIG. and channel adapter 7
or 8, the device adapter 10 is instructed to read data within the specified address range from the disk device 5 in which data exclusively for database processing is stored, to the shared memory 13 from the specified channel 1 or 2. Send.

When the data is stored in the shared memory 13, the data is read out via the common bus control circuit 23, stored in the RAM 19, and sent to the comparison circuit 20 for channel 1.
or 2 instructs to select a record having the same column as the designated column, the comparison circuit 20 reads data from the RAM 19 record by record, and stores the selected record in the RAM 19 when it selects a record that has the same column as the designated column.

When the processor 21 completes the selection of data in the specified address range from channel 1 or 2,
The record selected in RAM 19 is stored in shared memory 13.

[0012] The resource manager 12 is shown in FIG. 5(C).
With the configuration as shown in FIG. 1, the processor 25 operates by reading the program stored in the control memory 24, controls the common bus control circuit 26, and controls all starts from channel 1 or 2 via the common bus 14. Receive I/O command and R
The start I/O command is stored in the AM 27 and centrally managed, and data transfer processing instructions are given to the channel adapters 7 and 8 and device adapters 9 and 10 for each start I/O command.

[0013] Furthermore, control information for each received start I/O command, control information for each channel path, and control information for each received start I/O command,
-6 control information is stored in the RAM 27, and other functional units can access this RAM 27 via the RAM access control circuit 28 to read the above information, thereby centrally managing this information.

For example, it is assumed that the disk devices 4 and 6 store normal data, and the disk device 5 stores data to be processed by a database. Here, channel 1 sends a start I/O command to channel adapter 7, and the address of disk device 4, that is, the machine number,
When the cylinder address, head address, and record address are designated to write data, the channel adapter 7 requests the resource manager 12 to use the common bus 14, and if permission is granted, sends the address of the device adapter 9. and join.

[0015] When this coupling is completed, channel adapter 7 causes data to be sent from channel 1 and stores the data in shared memory 13. The device adapter 9 is
The data stored in the shared memory 13 is read out, sent to the disk device 4, and written to a designated address.

When instructed to read data from the channel 1, the channel adapter 7 causes the connected device adapter 9 to read the data from the specified address of the disk device 4, store it in the shared memory 13, and store the data in the shared memory 13. Data stored in shared memory 13 is read and transferred to channel 1.

When the channel adapter 8 is instructed to perform database processing from the channel 2, the channel adapter 8
It requests the resource manager 12 to use the common bus 14, and if it is granted, sends and combines the address of the DBA 11, and notifies the DBA 11 of the specified address range of the disk device 5.

When the DBA 11 obtains permission from the resource manager 12, the DBA 11 connects the device adapter 1 via the common bus 14.
An address of 0 is sent and combined to instruct that data in the specified address range be read from the disk device 5.

Therefore, the device adapter 10 occupies the disk device 5, reads data within the specified address range, and stores it in the shared memory 13. DBA11 is
When data starts to be stored in the shared memory 13, as described above, this data is fetched, a record having the same column as the specified column is selected, and the record selected from the data within the specified address range is stored in the shared memory 13. When it is stored in , the resource manager 12 is notified of the termination.

The resource manager 12 remembers that the channel adapter 8 has been instructed to perform database processing, and instructs the channel adapter 8 to send the record stored in the shared memory 13 to the channel 2.

[0021]

6 is a diagram illustrating the problems of the prior art. As shown in the database processing of FIG. 6, when the address range of the disk device 5 designated by the channel 2 is large, the control time for the device adapter 10 to transfer data from the disk device 5 to the shared memory 13 becomes long.

Therefore, during the time shown in this database processing, as shown by the dotted line in the general processing, general input/output commands to the disk device 6 are sent to the device adapter 10 in order to control data transfer to the disk device 5. There is a problem in that channel 1 or 2 is forced to wait for a long time from the time when channel 10 is unable to accept and becomes busy and sends an input/output command.

In view of these problems, the present invention does not execute database processing in the disk control device 3, but executes it in the disk device 5 where data to be processed is stored, reducing the burden on the device adapter 10. The purpose of this invention is to reduce the waiting time for general input/output commands to the disk device 6.

[0024]

Means for Solving the Problems FIG. 1 is a block diagram illustrating the principle of the present invention. The input/output subsystem 31 is
It is composed of input/output devices 33 and 34 and an input/output control device 32 that transfers data between the host device 30 and the host device 30 .

The data to be processed in the database is transferred to a first input/output device 33 having a database processing function 35.
After storing the data other than the data to be processed in the database in the second input/output device 34, the input/output control device 32 instructs the first input/output device 33 to perform database processing. Control of the second input/output device 34 is executed.

[0026]

[Operation] With the above configuration, when the first input/output device 33 is instructed to perform database processing by the input/output control device 32, the database processing function 35 performs the following operations.
The input/output control device 32 does not need to control the first input/output device 33 because the data to be processed in the database stored therein is read out and the database processing is executed. It becomes possible to control the

[0027] Accordingly, since the host device 30 can transfer data to and from the second input/output device 34 after instructing database processing, general input/output commands are not kept waiting for a long time.

[0028]

Embodiment FIG. 2 is a block diagram of a circuit showing an embodiment of the present invention, and FIG. 3 is a block diagram showing an example of a disk device of the present invention.

The disk control device 36 in FIG. 2 is the same as the disk control device 3 in FIG. 4 except that the DBA 11 is removed. When the resource manager 12 of the disk control device 36 is instructed to perform database processing from the channel 2 via the channel adapter 8, it connects the device adapter 10 with the disk device 37, and connects the device adapter 10 with the disk device 37.
7 to perform database processing, the connection between the device adapter 10 and the disk device 37 is released.

Therefore, after this connection is released, for example, if channel 1 requests data transfer to/from disk device 6 via channel adapter 7, resource manager 12 will approve this request. Then, the device adapter 10 and the disk device 6 can be coupled to perform data transfer.

[0031] When instructing database processing, the resource manager 12 transfers parameters such as an address indicating the range of data to be processed in the database given from the channel 2 and a column serving as a comparison standard.

The disk device 37 has a configuration as shown in FIG. 3, and the DBA 45, which is instructed to perform database processing via the interface circuit 38, has the same configuration as shown in FIG.
Instructs to read data in the address range specified by the parameter.

When the processor 39 controls the servo circuit 43 to position the head 44 at the beginning address of designated data on a disk (not shown), the processor 39 causes the readout circuit 41 to read the data up to the designated last address. The signal is demodulated and stored in the memory 42.

At this time, since the interface circuit 38 is not connected to the device adapter 10, the read data is not transferred to the disk controller 36. When the data is stored in the memory 42, the DBA 45 extracts a record having the same column as the specified column and stores it in the memory 42.

[0035] When the record extraction is completed from the data in the specified address range, the interface circuit 3
8, the device adapter 10 is caused to send an interrupt signal and transfer the completion of database processing to the resource manager 12.

The resource manager 12 checks whether the device adapter 10 is connected to the disk device 6 and is transferring data, and if the device adapter 10 is not transferring data, it immediately completes the data transfer. Waiting for this, the disk device 37 and the device adapter 10 are connected, and the database-processed records are transferred from the memory 42 and written into the shared memory 13.

Then, the database-processed data is transferred from the shared memory 13 to the channel 2 via the channel adapter 8. When writing data to a disk, data input via the interface circuit 38 is modulated by the write circuit 40 and sent to the head 44.
The processor 39 controls the servo circuit 43 to control the head 44.
is written from the address on the disk where it is located.

[0038]

As explained above, the present invention enables the disk control device to transfer data to other disk devices without being occupied with data transfer from one disk device for database processing. Therefore, it is possible to prevent general input/output commands from having to wait for a long time.

[Brief explanation of the drawing]

[Figure 1] Block diagram explaining the principle of the present invention

[Figure 2
] Block diagram of a circuit showing one embodiment of the present invention

[Figure 3
] Block diagram showing an example of a disk device of the present invention

[Figure 4] Block diagram explaining an example of conventional technology

[Figure 5] Detailed block diagram of each functional unit

[Figure 6] Diagram explaining the problems of the conventional technology

[Explanation of symbols]

1, 2 Channels 3, 36 Disk controllers 4, 5, 6, 37 Disk devices 7, 8 Channel adapters 9, 10 Device adapters 11, 45 DBA 12 Resource manager 13 Shared memory 14 Common bus 15, 38 Interface circuits 16, 23 , 26 common bus control circuit 17, 21, 2
5, 39 Processor 18, 22, 24 Control memory 19, 27 RAM 20 Comparison circuit 28 RAM access control circuit 30 Host device 31 Input/output subsystem 32 Input/output control device 33 First input/output device 34 Second input/output device 35 Database processing function 40 Write circuit 41 Read circuit 42 Memory 43 Servo circuit 44 Head

Claims (1)

[Claims] Claim 1: In an input/output subsystem (31) consisting of input/output devices (33), (34), and an input/output control device (32) that transfers data between a host device (30), a database Data to be processed is stored in a first input/output device (33) having a database processing function (35), and data other than the data to be processed in the database is stored in a second input/output device (34), and the input/output control is performed. Device(
32) instructs the first input/output device (33) to perform database processing, and then controls the second input/output device (34).