JPS62281038A - Data base constituting method - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

[Detailed Description of the Invention] 3. Detailed Description of the Invention [Summary] A database configuration method that combines high-speed and low-speed external storage devices and stores frequently accessed data in the high-speed external storage device. The aim is to shorten the time required to access the entire system.

[Industrial application field]

The present invention relates to a database configuration method. There are two methods for storing data: files and databases.

Generally, a file is a collection of records that is maintained by data management, and access to the file is in units of records.

A database, on the other hand, generally has at least one
A collection of data consisting of two files that satisfies a given data processing system.

This database is a DBMS (Data Ba5e M
managementSystem) and allows a number of accesses such that logical operations can be performed on relationships between records and fields within records.

Databases were developed out of the need to centrally manage data in view of the fact that huge amounts of data cannot be managed properly as files.

As part of this centralized management, databases need to process huge amounts of data at high speed.

The present invention relates to a method for configuring such a database.

[Conventional technology]

Traditionally, when configuring a database in a computing system, an external storage device, that is, a storage device in which the central processing unit can read and write data via an input/output channel, was used, especially a high-speed external storage device with short access time. .

[Problem that the invention seeks to solve]

Conventionally, as mentioned above, high-speed external storage devices have mainly been used.

However, when the amount of data increases, there is a limit to the capacity of high-speed external storage devices, so the scale of the database must be reduced.

As a solution to this problem, it has been proposed to use a low-speed external storage device that has a large capacity and can store an enormous amount of data.

However, this low-speed external storage device has a problem that the data processing efficiency of the computer system decreases because the access time is long.

[Failure to solve the problem]

An object of the present invention is to improve data processing efficiency by solving problem 1 and shortening access time in a database.

As shown in FIG. 1, the means for this purpose is to provide the computer system with a high-speed external storage device 1 and a low-speed external storage device 2, and to provide the high-speed external storage device 1 with an active data section 11 that stores frequently accessed data. , the low-speed external storage device 2 is configured with an inactive data section 21 that stores data that is accessed infrequently, and the active data section 11 is first accessed (■), and if data exists, it is updated; If not, the inactive data section 21 is accessed (■) The inactive data is stored in the active data section 11 as active data (■).

[For production]

As described above, the present invention focuses on the fact that data is generally divided into active data that is accessed frequently and inactive data that is accessed infrequently. Additionally, inactive data can be routed to slower external storage.

Therefore, the access time of the entire computing system can be reduced as much as possible, and data processing efficiency has improved.

〔Example〕

The invention will now be explained by way of example with reference to the accompanying drawings.

FIG. 2 is a diagram showing an embodiment of the present invention.

The embodiment of FIG. 2 consists of a high-speed external storage device 1, such as a semiconductor memory, and a low-speed external storage device 2, such as a magnetic disk, the former comprising an active data section 11, an inactive data section 12,
The latter are each constituted by an inactive data section 21.

The active data section 11 of the high-speed external storage device 1 stores frequently accessed data and consists of an index section 111 and a data section 112.

The index section 111 stores reference information when accessing active data, and the data section 112 stores the active data itself.

The other inactive data section 12 is a low-speed external storage device 2.
It consists only of an index section 121 for inactive data to be stored in the index section 121.

On the other hand, the inactive data section 212 of the low-speed external storage device consists only of the data section 211 that stores inactive data itself.

Hereinafter, the operation of the configuration method of the database having the above configuration will be explained.

(1) Processing performed simultaneously with access operation (■) First, the index section 111 of the active data section 11 of the high-speed external storage device 1 is accessed (■).

(2) If active data exists by referring to the index, the data is referred to in the data section 112, a predetermined read/write operation is performed, and the access date in the index section 111 is updated (■).

■ If no data exists in the data section 112 of the active data section 11, the index section 1 of the inactive data section 12
．． Access 21 (■).

(2) Access and refer to predetermined inactive data in the data section 211 of the inactive data section 21 of the low-speed external storage device 2 by referring to this index section 1.21 (
■).

(2) The accessed inactive data is stored as active data in the data section 112 of the high-speed external storage device 1, and the index section 111 is updated with, for example, the access date as new active data.

■ As a result, new data is stored as active data7), so the original information in the index section 121 is no longer needed, so it is deleted (■).

(2) Processing performed periodically independent of access operations ■ As mentioned above, the original inactive data newly stored in the high-speed external storage device as active data is no longer needed. Therefore, the index section 121 of the high-speed external storage device 1 is compared with the data section 211 of the low-speed external storage device 2, and inactive data that does not exist in the index section 121 is removed from the data section 21.
Delete from 1 (■).

■ Also, by referring to the index section 111 of the data stored in the data section 112 of the active data section 11, if the access date is old, the data itself is transferred to the data section 212 of the low-speed external storage device 2 as inactive data. Then, the index sections are stored in the index section 121 of the high-speed external storage device 1 (■).

〔Effect of the invention〕

As described above, the present invention focuses on the fact that data is generally divided into active data that is accessed frequently and inactive data that is accessed infrequently. Additionally, inactive data can be routed to slower external storage.

Therefore, the access time of the entire computing system can be reduced as much as possible, and data processing efficiency has improved.

[Brief explanation of the drawing]

FIG. 1 is a diagram showing the principle of the present invention, and FIG. 2 is a diagram showing an embodiment of the present invention. DESCRIPTION OF SYMBOLS 1... High-speed external storage device, 2... Low-speed external storage device, 11... Active data section, 12... Inactive data section, 21... Inactive data section, 111... Index section , 112...data section, 121...
Index section, 211...data section. Principle diagram of the present invention Fig. 1 1...High speed external storage device 2°°°Low luck external storage device 11°°Active data section 21...Inactive data section

Claims (1)

[Scope of Claims] An active data section for storing frequently accessed active data in a high-speed external storage device and an inactive data section for storing inactive data for infrequently accessed in a low-speed external storage device are respectively provided. , First, the active data section of the high-speed external storage device is accessed, and if active data exists, a predetermined read/write operation is performed on the active data, and then, if no active data exists, the active data section of the low-speed external storage device is accessed. A database configuration method, comprising: accessing an inactive data section, performing predetermined read/write operations on the inactive data, and storing the inactive data as active data in the active data section of the high-speed external storage device.