JPH07141230A - Managing method for data base - Google Patents

Abstract

PURPOSE:To lighten the load on a system and obtain a managing method for data base which facilitates system management by dividing data which exceed a specific frequency of use into plural data and storing them in different data files respectively. CONSTITUTION:The data base system consists of a computer 1, a storage means 2, a display means 3, an input means 4, a printing means 5, etc. In this constitution, the data exceeding the specific frequency of use are divided into plural data, which are stored in the different data files respectively, and, the divided data files are managed relatedly by using common attributes. And, when there are data which are high in frequency of access by the system and large in frequency use and data which are small in access frequency and small in frequency of use, the related data are divided into plural data corresponding to the frequencies of past access to lighten the load of the system management.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database management method, and more particularly to a file management method in a database.

[0002]

2. Description of the Related Art Conventionally, when a database is managed by a computer, for example, all data related to a certain data is stored in one data file in the database, for example, a master file. An example of such database management is the PATOLIS database. This PATOLIS database has a master file in which all data is recorded, and an inverted file (search file) in which accumulated data serving as a search key necessary for searching data in the master file is recorded. There is.

[0003]

However, in the method of storing and managing all the data in the master file as described above, when performing data management such as data editing, storing or searching for this master file, You need to read or update all relevant data. For this reason, when the amount of information of each data in the master file is large, the load on the system for managing this increases, that is, the system becomes heavy. As a result, there is a problem that the system response takes time and the system processing becomes slow.

Further, when the number of related data increases, it may be difficult to store all of them in a storage medium at once, and there is a problem that the management of the data itself becomes difficult.

Therefore, it is an object of the present invention to provide a database management method that reduces system load and facilitates system management.

[0006]

In order to solve the above-mentioned problems, according to the present invention, data that is used differently or is divided into separate data in the system is easier to manage by the system and is managed separately. I did it.

That is, in the database management method of the first invention, in a database having a data file for storing a plurality of data, data having a predetermined frequency of use or more is divided into a plurality of data, and each data file is divided into different data files. In addition to storing, these divided multiple data files are managed by associating them with a common attribute.

In the database management method of the second invention, in a database having a data file for storing a plurality of data, data having a predetermined record length or more is divided into a plurality of data, and each data file is divided into different data files. In addition to storing, these divided multiple data files are managed by associating them with a common attribute.

[0009]

Among related data, there are data that is accessed frequently by the system and used frequently, and data that is accessed less and used less frequently. In such a case, as in the first aspect of the present invention, the related data is divided into a plurality of pieces according to, for example, the number of past accesses, thereby reducing the burden of system management.

Further, a large amount of related data or a large amount of data imposes a heavy burden on system management. In such a case, as in the second invention, by dividing the data having a predetermined record length or more into a plurality of pieces, the burden of system management is reduced. In this case, the data division standard may be such that data management is easy, for example, data that are highly related to each other, or data that are preferably combined in handling the data are collected.

Further, in the first and second inventions, by associating the divided data as one common keyword of the attribute, the data retrieval time can be shortened and the data management can be facilitated.

[0012]

EXAMPLES Examples of the present invention will be described. It should be noted that this embodiment is an embodiment corresponding to the first invention and the second invention, respectively, and is an embodiment described by combining both.

FIG. 1 shows the configuration of the database system of the embodiment, which comprises a computer 1, a storage means 2, a display means 3, an input means 4, a printing means 5 and the like. The computer 1 performs system processing such as data editing and retrieval of this database system. The storage unit 2 is a magnetic recording device, the display unit 3 is a CRT, the input unit 4 is a keyboard, and the printing unit 5 is a laser printer. The storage means 2 stores a plurality of partial master files. Incidentally, the partial master file is for storing data obtained by dividing the data forming the master file into a plurality of pieces. As the file format, an appropriate format such as a sequential organization file, a relative organization file, a search sequential organization file, and a multiple search structure file is used.

Next, an example will be described in which the database system of the embodiment manages the part data having the application of the product. This part data consists of part number, part name,
It is composed of related data such as use (use) classification, abolition classification, or new / old abolition classification. Then, in the database system of the embodiment, this part data is divided into two data files (partial master files) by the following two methods and stored in the storage means 2, respectively, and these partial data files are “Part number” is associated and managed as a common keyword.

(1) Parts data is divided into two data files and stored according to the frequency of use. For example, a part number mainly for data that is frequently used,
Parts attribute data file consisting of parts name, usage classification, obsolete classification, old / new product number, etc., and parts composed mainly of data with low usage frequency, such as part number, applicable product, specification, obsolete classification With the applied product data file,
To divide.

(2) Data is divided for ease of management.
For example, part numbers, part names,
A part attribute data file consisting of data such as usage classification, abolition classification, old / new product number, etc., and a part applied product data file consisting of parts numbers, applicable products, specifications, abolition classification, etc., which are less related To split.

In the database of the embodiment configured as described above, when searching for a part number corresponding to these, for example, from data such as applied products and specifications, the parts applied product data file is searched for. Processing such as search may be performed. Therefore, it becomes possible to quickly perform processing such as search. Conversely, it is also possible to quickly search for applicable products and specifications from the part numbers.

[0018]

According to the database management method of the present invention, the system management is facilitated by dividing the data rather than by dividing the data. As a result, the burden on the system is reduced, the management is improved, and the response of the system is prevented from being deteriorated.

[Brief description of drawings]

FIG. 1 is an explanatory diagram showing a configuration of an exemplary embodiment of the present invention.

[Explanation of symbols]

 1 computer, 2 storage means, 3 display means, 4 input means, 5 printing means.

Claims (2)

[Claims] 1. A database comprising data files for storing a plurality of data, wherein data having a predetermined frequency of use or higher is divided into a plurality of data, each of which is stored in a separate data file. A method for managing a database, characterized in that the data files are managed in association with each other by a common attribute. 2. A database having a data file for storing a plurality of data, wherein data having a predetermined record length or more is divided into a plurality of data, each of which is stored in a different data file. A database management method characterized by managing data files by associating them with common attributes.