JPS6058492B2 - Database search method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION Technical Field of the Invention The present invention relates to a database search method that allows desired data to be searched from a plurality of databases of the same type.

Conventional technology and problems In databases that integrate large amounts of data and can handle various tasks, it is common to reserve database space assuming the maximum amount of data. When the data grows, it is necessary to expand the area, so the existing data is temporarily stored, and after securing an area for the amount of data that includes the increased data, the temporarily stored existing data is loaded into the new area. The problem is that the work becomes complicated when the amount of data increases more than expected.

Also, as mentioned above, when the amount of data increases and the reserved space becomes insufficient, there is a method to manage the increased data as a new database.In that case, even if the database is of the same type, The program must be managed as two databases, and if the requested data does not exist in one database, the program will issue a command to the other database, making the program complicated. It was hot. Purpose of the Invention The present invention creates a new database for a database volume larger than the expected database volume, and makes it possible to search for desired data as one type of database group even when the same type of database is distributed over multiple databases. , the overall purpose is to facilitate expansion of the database area.

Examples will be described in detail below. Example 1 of the invention
The figure is a block diagram of main parts of an embodiment of the present invention, where CPU is a processor, MM is a main memory, PM is a control program memory, FO to F2 are files consisting of a large capacity storage device such as a magnetic disk device, and BUS is a bus. It is.

Further, a homogeneous database management table DBM is prepared for management when the same type of database is distributed over a plurality of locations. This table DBM is main memory MM
Although a case is shown in which the tables are configured within one table, it is of course possible to configure them as a single table. FIG. 2 is a functional block diagram of an embodiment of the present invention, and the following explanation will be given by taking as an example a case where various data of an integrated circuit (IC) are managed.

The homogeneous database management table DBM is used to manage multiple distributed homogeneous databases as a group.
Data indicating the database type name, database name, and location where the database exists is registered in correspondence with the database name. For example, if the same type of database is distributed in two, the database type name is IL
LBO, ILBl as Bl database name, data A indicating the location of the database for each database
They are registered in the order in which they were input starting from DO and ADl. This homogeneous database management table DBM is created by inputting data from the database definition data input DBI, and inputs are made to the database definition data input section DBI using a database type designation card and a database definition card. In other words, when the database is distributed to multiple locations as data is added,
The table contents are updated based on the distribution information. Note that in the case of a single database, it goes without saying that the database type name and the database name can be the same. Also, in the LBO database, I
It is identified by IC codes ICOl and ICO2 indicating a set of C data, and IC data such as IC pin data is stored.

Also, in the database of LB1, IC data such as IC pin data is stored, identified by IC codes ICO3 and ICO4 indicating a collection of IC data, as described above. When reading the IC pin data ICPD of IC code ICO3, according to the search request information, the database type name 1L is sent from the program PG as code search instruction information.
B and processing 1C code ICO3 are input to code search section 7 CDS.

This code search unit CDS refers to the homogeneous database management table DBM and starts with data indicating the location of database name 1LB0 from database type name 1LB0.
Based on the DO, the IC codes in the ILBO database are sequentially read to see if there is one that matches the requested C code. In Figure 2, the ILBO database has the IC codes ICOl and ICO2, but the IC code ICO3 does not exist, so the next database name in the database type name of the homogeneous database management table DBM is Based on the data ADl indicating the location of 1LB1, the IC codes in the database of IlBl are sequentially read and the ICO3 of the requested 1C code is read out.
When the code search unit CDS finds a match,
The database name LBl where the request 1C code ICO3 exists in the program K and the code data I of that ICO3
CO3D. Then from program PG to IC
The data manipulation command for reading the IC pin data of code 1C03, the database name ILB1 obtained by the above-mentioned 1C code search, and the processing data instruction ICP are sent to the database manipulation unit DOP.

Based on the data operation command, this database operation unit DOP reads the specified C pin data from the database with the specified database name LBl, sets it in the data table DTB, and writes the IC into the program PG.
Notifies that reading of pin data ICPD is completed. The program PG then performs the next requested process. In the IC code search, if the requested process 1C code does not exist in any database, the program PG is notified of this fact.

Also, when updating or writing new IC data in the database, desired data can be updated or written by searching the IC code using the above-described operations. FIG. 3 is a flowchart for explaining the above-mentioned operation. After the homogeneous database management table is created, data indicating the location of the database is retrieved from the homogeneous database management table in response to a code search instruction, and the data The code is read from the database based on the code and checked to see if it matches the requested processing code. If they match, the data based on the request is read out using a database operation command. In creating the homogeneous database management table DBM, the database definition is input using a card, but other input methods can be used, and the database can also be distributed in more than two locations. Even in this case, the same type of database management table DBM can be used to manage the databases as a group of databases. Also, in the above embodiment, the program PG
This example shows a case where code search instructions and data manipulation instructions using database manipulation commands are issued separately.
It is also possible to issue both as one database operation instruction. Furthermore, any known means can be used as the means for storing data in the database, and similarly, any means such as reading and searching in parallel can be used as the retrieval means. It is. Effects of the Invention As explained above, the present invention provides a homogeneous database management table DBM, stores data indicating the location of the database corresponding to each of a plurality of database names of the same type, and stores desired data. In the search process, databases of the same type are sequentially searched to find the database that contains the desired data, and when it becomes necessary to expand the database area, the existing database is left as it is and the database of the same type is expanded. By creating a new database and using the same type of database management table, there is an advantage that operations when expanding the database area are extremely simple.

Therefore, the present invention can be used for various data searches other than the IC data search of the above-described embodiment. BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram of main parts of an embodiment of the present invention, FIG. 2 is an explanatory diagram of the operation of the embodiment of the present invention, and FIG. 3 is a flowchart for explaining the operation of the embodiment of the present invention. be.

DBM is a homogeneous database management table, PG is a program, CDS is a code search section, DOP is a database operation section, ILB is a database type name, ILBO, ILB
l is the database name, , ADO, ADl are data indicating the location of the database, and ICOl to ICO4 are IC codes.

Claims (1)

[Claims] 1 Having a database in which a set of stored data is identified by a code, and sequentially reading out the codes based on code search instruction information from a program, from the database in which a code that matches the specified code from the program exists. In a database search method for reading desired data, a homogeneous database management table is provided, and data indicating a database type name, a database name, and a database location corresponding to the database name are stored on the homogeneous database management table. , when expanding a database area of the same type, create a new database of the same type, and store the database of the newly created database of the same type in the database type name area on the database management table of the same type that corresponds to the database of the same type. data indicating the name and the location of the database corresponding to the database name are stored, and code search instruction information from the program is input to the code search unit, which refers to the similar database management table and searches the database Codes are sequentially read from the database based on data indicating the location of the database corresponding to the database name from the type name, and it is determined whether or not the code matches the specified code of the program, and if they do not match, the same type database management table is read. Codes are sequentially read from the database based on the data indicating the location of the database corresponding to the next database name in the database type name, and if the code matches the specified code, the database name where the code exists and the corresponding 1. A database search method, characterized in that data of a code is notified to a program, and data is read from a database in which a code matching the specified code exists by inputting a database operation command from the program.