JPH10312396A - Data base system and computer-readable record medium where data base retrieval program is recorded - Google Patents

Abstract

PROBLEM TO BE SOLVED: To greatly save the time and trouble for data retrieval by automatically extracting even relative data in other data bases by performing retrieval from only one data base. SOLUTION: Each time new data are registered in a patent data base 2 to a drawing data base 4, a management computer 4 extracts relative information among data registered in the patent data base 2, company data base 3, and drawing data base 4 and updates the contents of a relative key information file 7; when a retrieval key is inputted, data corresponding to the retrieval key are read out of a specified data base and on the basis of relative key information registered in the relative key information file 7, data relating to the retrieval key are read out of other data bases.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system for managing patent information, company information, and the like.
By simply searching one database, a computer system that records a database system and a database search program that automatically searches for data related to the data to be searched among data in other databases It relates to a recording medium.

[0002]

2. Description of the Related Art In a database system for managing patent information, company information, and the like, a database in which patent information is registered, a database in which company information and the like are registered, a management computer that manages each of these databases,
A system is constructed by this management computer and an input / output device serving as a man-machine interface between the user and the input / output device is operated, one of the databases is designated, and a search key of data to be searched is input. At this time, the management computer searches the designated database. If there is data corresponding to the search key, the data is read out, displayed on the input / output device, and printed out as necessary.

[0003]

However, such a conventional database system has the following problems.

That is, when retrieving data registered in one database, first, a database in which the contents of a basic ledger (basic ledger) is registered is selected, a search key is entered, and a search key is obtained. The determined data is reviewed to determine whether data related to the data may be included in other databases.

When it is determined that there is a possibility that data related to the data is registered in another database, another database in which related data is likely to be registered is selected. A next search key obtained by examining the data is input, and data related to the data is read from the database.

Hereinafter, for the remaining database,
The above operation is repeated to search for data corresponding to the data obtained by searching the basic ledger, and when these operations are completed, the search results are put together.

[0007] Therefore, it takes too much time and effort to search for necessary data from a large amount of data registered in each database, and the target data is registered in any one of the databases. Even if
In some cases, this could not be found during the search process.

The present invention has been made in view of the above circumstances, and when related data is registered in a plurality of databases, simply searching one database and extracting related data in another database. A database system and a database retrieval program which can greatly reduce the time and labor required for data retrieval and eliminate data withdrawal errors caused by an operator's misjudgment, etc. It is an object of the present invention to provide a computer-readable recording medium.

[0009]

In order to achieve the above-mentioned object, a database system according to the present invention provides a database system which, when data to be registered is inputted, registers the data in a database corresponding to the type of the data. Each time data is registered in the registration unit and each of these databases,
A related key information creation unit that extracts unique data indicating the contents of registered data and updates the contents of a related key information file based on the unique data, and a search key corresponding to the search key when a search key is input. A table search unit for reading data corresponding to the search key from a database, and when a data search function is performed by the table search function unit, the related key information file is searched for unique data corresponding to the search key. And a related table search unit that extracts and searches another database based on the unique data and reads out data corresponding to the unique data.

A computer-readable recording medium on which a database search program according to the present invention is recorded, wherein, when data to be registered is input, data registration means for registering the data in a database corresponding to the type of the data. And a related key information creating means for extracting unique data indicating the content of the registered data each time data is registered in each of these databases, and updating the content of a related key information file based on the unique data. A table search means for reading data corresponding to the search key from a database corresponding to the search key when the search key is input, and the related key information when the table search means searches for data. Search the file and select the unit corresponding to the search key. Kudeta is extracted, based on this unique data, by searching other databases, it is characterized in that a relevant table retrieving means to read out data corresponding to the unique data.

In the above configuration, when data to be registered is input, the data is registered in a database corresponding to the type of the data by a data registration unit, and the data of the data is registered by a related key information creation unit. Extracting unique data indicating the contents, updating the contents of the related key information file based on the unique data, and when a search key is input, the table search unit causes the table search unit to search the search key from the database corresponding to the search key. After reading the data corresponding to, the related table search unit searches the related key information file to extract unique data corresponding to the search key, and then searches another database based on the unique data. By reading data corresponding to the unique data, When related data is registered in one database, simply searching for one database automatically extracts related data in another database, thereby reducing the time and effort required for data search. Is significantly reduced, and a data extraction error caused by an operator's judgment error or the like is eliminated.

According to a second aspect of the present invention, the functions of the respective parts described in the first aspect are programmed and recorded on a recording medium such as a CD-ROM. It can also be realized by loading the program into the program.

[0013]

BEST MODE FOR CARRYING OUT THE INVENTION

<< Structure of Embodiment >> FIG. 1 is a block diagram showing an embodiment of a database system according to the present invention.

The database system 1 shown in FIG.
A patent database 2 in which patent information and the like are registered, a company database 3 in which company information and the like are registered, a drawing database 4 in which drawing information and the like are registered, and these patent databases 2, the company database 3, and the drawing database 4 are managed. A management computer 5 that stores information, an input / output device 6 that serves as a man-machine interface between the management computer 5 and the operator, and information related to each data registered in the patent database 2, the company database 3, and the drawing database 4. And a related key information file 7.

Each time the input / output device 6 is operated to register new data in any of the patent database 2, the company database 3, and the drawing database 4, the patent database 2, the company database 3, and the drawing The related information between the already registered data and the new data is created in the database 4, and the content of the related key information file 7 is updated.

When one of the patent database 2, the company database 3, and the drawing database 4 is specified and a search key of data to be searched is input, the management computer 5 searches the specified database. Based on the contents of the search, the related key information file 7 is searched, and it is determined whether or not data related to the search key is registered in another database. This is read from the registered database and displayed on the input / output device 6.

In this case, the patent database 2 includes a data area 2b for storing data such as patent data supplied from the management computer 5, and a data area 2b.
And a patent table 2a in which key data (unique data) of each patent data stored in the management computer 5 are stored. When patent data is supplied from the management computer 5, this is stored in the data area 2b. When unique data or the like is supplied from the management computer 5, the unique data is stored in the patent table 2a.

The company database 3 includes a data area 3b in which data such as company data supplied from the management computer 5 is stored, and key data (unique data) of each company data stored in the data area 3b. ) Is stored in the data area 3b when company data is supplied from the management computer 5, and when company data is supplied from the management computer 5, This is stored in the company table 3a.

The drawing database 4 includes a data area 4b in which data such as drawing data supplied from the management computer 5 is stored, and key data (unique data) of each drawing data stored in the data area 4b. ) Is stored in the data area 4b when drawing data is supplied from the management computer 5, and when drawing data is supplied from the management computer 5, This is stored in the drawing table 4a.

<< Operation of the Embodiment >> Next, the operation of this embodiment will be described in detail with reference to the block diagram shown in FIG. 1 and the schematic diagrams shown in FIGS. 2, 3 and 4.

<Data Registration Operation> First, the input / output device 6 is operated by the operator, and any one of the patent database 2, the company database 3, and the drawing database 4, for example, the patent database 2, the company database 3,
New data (new patent data, new company data, new drawing data) for all of the drawing database 4
Is input by the management computer 5, these new patent data, new company data, and new drawing data are unique data (the patent numbers, company names, drawing numbers, etc. are unified in the patent database 2 to the drawing database 4). Data, such as patent numbers, company names,
Drawing number, etc.)
If these prerequisites are met, these patent data,
Company data and drawing data are data area 2b of patent database 2, data area 3b of company database 3,
Each is registered in the data area 4b of the drawing database 4.

Thereafter, as shown in FIG. 2, new patent data registered in the data area 2b of the patent database 2 and the data area 3b of the company database 3 by the related key information automatic creation function 8 of the management computer 5. The unique data of the new drawing data registered in the data area 4b of the drawing database 4 is extracted, and the unique data and the unique data are registered. Based on the ledger name (name of the database), the contents of the patent table 2a in the patent database 2, the contents of the company table 3a in the company database 3, and the contents of the drawing table 4a in the drawing database 4 are updated. Is done.

Thus, as shown in FIG. 3, each patent data registered in the data area 2b in the patent database 2 has a patent number as unique data and other keys (related key information) as unique data. Ledger data having a company name, a drawing number, etc., is registered in the patent table 2a.
For each company data registered in the data area 3b, company ledger data having a company name as unique data and a location, a contact and the like as other keys is created, and this is stored in the company table 3a. Each drawing data registered and registered in the data area 4b in the drawing database 4 has a drawing number as unique data, and as other keys (related key information), a drawing name, the name of the company that applied, etc. Is created and registered in the drawing table 4a.

Next, as shown in FIG. 3, the automatic creation of related key information function 8 of the management computer 5 allows the patent table 2a, the company table 3a, and the drawing table 4a of the patent table 2a having related key information to be stored. The contents and contents of the drawing table 4a are accessed, and each patent ledger data registered in these patent tables 2a,
Relevant key information indicating the relation of each unique data is extracted from each drawing ledger data registered in the drawing table 4a.

Thereafter, the related key information automatic creation function 8 of the management computer 5 sorts out the related key information and creates related key information update data. Based on the related key information update data, FIG. As shown, the patent ledger file 9 and the drawing ledger file 10 in the related key information file 7 are updated.

<Data Retrieval Operation> Thereafter, when the operator operates the input / output device 6 to input any of the unique data, for example, a patent number, as a retrieval key, as shown in FIG. The table search function 11 of the management computer 5 searches the patent table 2a, reads out the patent ledger data having the patent number as unique data, and accesses the data area 2b of the patent database 2 based on the patent ledger data. Then, the patent data having the patent number is extracted, displayed on the display of the input / output device 6, and printed out from the printer as required.

Then, the related key information file 7 is retrieved by the related table retrieval function 12 of the management computer 5 based on the patent number and the retrieval result of the patent table 2a.
Is accessed and the patent ledger file 9 corresponding to the patent number is read out. Then, the drawing number, company name, etc. in the patent ledger file 9 are used as search keys, and the company table of the company database 3 is set. 3a, data area 3
b, the drawing table 4a and the data area 4b of the drawing database 4 are accessed, and the company data having the company name as the unique data and the drawing data having the drawing number as the unique data are read out. It is displayed on the top and printed out from the printer as needed.

<< Effect of Embodiment >> As described above, in this embodiment, every time new data is registered in any one of the patent database 2, the company database 3, and the drawing database 4, the management computer 5 The related key information automatic creation function 8 extracts related information between data registered in the patent database 2, the company database 3, and the drawing database 4, updates the contents of the related key information file 7, and updates the search key. When input, the data corresponding to the search key is read out from the designated database among the patent database 2, the company database 3, and the drawing database 4, and the related key information registered in the related key information file 7 is read. Reading data related to the search key from another database based on Therefore, when related data is registered in a plurality of databases, it is possible to retrieve related data in another database only by searching one database, thereby requiring data search. Time and labor can be greatly reduced, and a data extraction error caused by an operator's determination error or the like can be eliminated.

<< Other Embodiments >> In the above-described embodiment, the case where patent-related data is managed is described.
Although described, when managing other data, for example, programs, the database system 1 shown in FIG.
9 may be used.

In the database system 19, when registering a newly created program in the database 17, information on the program, for example, information such as the program name, creation date, creator, and library used is stored in the table 13.
A related table name, a field name, and a program related to the program are registered.
The related information such as the search condition is created, and the related definition file 14 is created.

When a program name or the like is input as a search key, the table search function 15
A program corresponding to the program name in the database 17 is read from the contents of the table 13 in the database 16 and a related table search function 1 is executed.
7, the related definition file 14 is selected based on the contents of the table 13.

Thereafter, related information such as a related table name, a field name, and a search condition related to the program name is read out from the related definition file 14, and another table related to the program name is read based on the related information. The contents of the program 18 are read out, other programs in the database 17 are read out based on the data thus obtained, and these programs are displayed as search results.

Even in this case, as in the above-described embodiment, when a plurality of programs are registered in the database 16, only one program is searched for.
Other programs related to this program can also be extracted, thereby greatly reducing the time and effort required for program search, and eliminating program extraction errors caused by operator's misjudgment. be able to.

Further, the present invention is not limited to the above embodiment.

For example, the function of registering data in the database 2 of the database system shown in FIG. 2, the function of automatically creating related key information 8, the function of searching a table 11, and the function of searching a related table 12 are programmed and programmed in advance in a CD-ROM.
Write it on a recording medium such as a ROM,
By loading the OM into a computer equipped with a CD-ROM driver and loading the program from the CD-ROM, the same functions as those in the above embodiment can be realized.

As a recording medium, the above-mentioned CD-RO
In addition to M, a magnetic tape, DVD-ROM, floppy disk, MO, MD, CD-R, memory card, etc. may be used.

[0037]

As described above, according to the present invention, when related data is registered in a plurality of databases, only searching for one database will cause the related data to be stored in another database. This can significantly reduce the time and effort required for data retrieval, and eliminate data extraction errors caused by an operator's misjudgment and the like.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of a database system according to the present invention.

FIG. 2 is a schematic diagram showing an operation example of the database system shown in FIG. 1;

FIG. 3 is a schematic diagram showing an example of patent ledger data, company ledger data, and drawing ledger data registered in the patent database, company database, and drawing database shown in FIG. 1;

FIG. 4 is a schematic diagram showing an example of a patent ledger file and a drawing ledger file registered in the related key information file shown in FIG. 1;

FIG. 5 is a block diagram showing another embodiment of the database system according to the present invention.

[Explanation of symbols]

1 database system 2 patent database (database) 2a patent table 2b data area 3 company database (database) 3a company table 3b data area 4 drawing database (database) 4a drawing table 4b data area 5 management computer (data registration unit, related key information) Creation unit, table search unit, related table search unit) 6 input / output device 7 related key information file 8 related key information automatic creation function (related key information creation unit) 9 patent ledger file 10 drawing ledger file 11 table search function (table search) 12) Related table search function (related table search unit) 13 Table 14 Related definition file 15 Table search function 16 Database 17 Related table search function 18 Table 19 Database system

Claims (2)

[Claims] 1. A data registration unit for registering data in a database corresponding to the type of the data when data to be registered is input, and for each time data is registered in each of these databases, the registered data A related key information creating unit that extracts unique data indicating the contents of the related key information file and updates the contents of the related key information file based on the unique data. A table search unit that reads data corresponding to the search key, and when a data search function is performed by the table search function unit, the related key information file is searched to extract unique data corresponding to the search key; Based on this unique data, another database is searched and data corresponding to the unique data is searched. And a related table search unit for reading data. 2. When data to be registered is input, data registration means for registering the data in a database corresponding to the type of the data, and each time the data is registered in each of these databases, the data is registered. A related key information creating means for extracting unique data indicating the contents of data and updating the contents of a related key information file based on the unique data, and, when a search key is input, from a database corresponding to the search key. A table search means for reading data corresponding to the search key; and when the table search means performs a data search, the related key information file is searched to extract unique data corresponding to the search key. Based on this unique data, another database is searched and the And a related table search means for reading data corresponding to the network data. A computer-readable storage medium storing a database search program.