JPH10254887A - Data base system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To greatly reduce time and labor for retrieving data and the load of CPU by automatically drawing related data in the other data bases by the minimum number of retrieving times only by retrieving a first data base when related data are registered in plural data bases. SOLUTION: When a sales data base 4 or a stock data base 5 is designated and the first retrieving condition of retrieving object data is inputted, a managing computer 3 retrieves the designated data base to find data corresponding to the first retrieving condition and reverse-generate a second retrieving condition based on this data, and accesses to the other data bases through the use of this second retrieving condition or ID included in the data to find data corresponding to the first retrieving condition.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to a method for searching for one of a plurality of databases, automatically searching for another database, and registering the search target in each database. The present invention relates to a database system for reliably detecting changed data.

[0002]

2. Description of the Related Art In a database system for performing product sales management, inventory management, and the like, a database in which product sales management data is registered, a database in which product inventory management data is registered, and these databases are managed. A system is constructed by the management computer and the input / output device serving as a man-machine interface between the management computer and the user, and the input / output device is operated.
When any one of the databases is specified and the search condition of the data to be searched is input, the management computer searches the specified database and reads out the data corresponding to the search condition if it exists. The information is displayed on the input / output device and printed out as necessary.

[0003]

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

[0004] That is, when searching for data registered in one database, first, the first database is selected, search conditions are input, and data obtained thereby is examined. Determine if the relevant data is likely to be included in another database.

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. Enter each ID such as employee number and product number included in each data obtained by searching the first database, and search this database repeatedly for the number of IDs, Read related data.

[0006] Thereafter, when these search operations are completed, the search results obtained by searching each database are put together to create a list or the like.

Therefore, when the number of pieces of data obtained by searching the first database is large, the second database is searched by the same number of times as the number of IDs included in each piece of data. It has to be searched, so that it takes too much time and effort to search the second and subsequent databases, and there is a problem that the CPU (load) / disk increases.

The present invention has been made in view of the above circumstances, and in claim 1, when related data is registered in a plurality of databases, only the first database is searched.
Relevant data in other databases can be automatically retrieved with the least number of searches, thereby greatly reducing the time, labor, and CPU load required for data search. It is another object of the present invention to provide a database system that can eliminate data withdrawal errors or the like caused by an operator's mistake or the like.

According to another aspect of the present invention, a search using an ID included in a search result obtained by searching a first database (first database) and a search condition reversely generated from the search result And choose the best one,
It is possible to search other databases, thereby greatly reducing the time, labor, and load on the CPU required for data search, and to prevent data extraction errors caused by operator's misjudgment. The purpose is to provide a database system that can be eliminated.

According to the third aspect of the present invention, the first database (the search condition reversely generated from the search result obtained by searching the first database) can be made more accurate, thereby enabling the data search The time and effort required,
It is an object of the present invention to provide a database system that can significantly reduce the load on a CPU and eliminate a data extraction error or the like caused by an operator's judgment error or the like.

[0011]

In order to achieve the above object, according to the present invention, when a first search condition is input, a specified database is searched from a plurality of databases. In a database system for extracting data corresponding to the first search condition, another database is searched based on attribute data of each data obtained by searching a first database based on the first search condition. A search condition reverse generation mechanism for reversely generating a second search condition required for performing the search, and searching for another database based on the second search condition generated by the search condition reverse generation mechanism, And a search mechanism for extracting data corresponding to the first search condition from among the data searched by the search mechanism. For data, the search mechanism is re-operated, and characterized in that a result of determination mechanism to perform the ID search for other databases to extract the missing data.

According to a second aspect of the present invention, in the database system according to the first aspect, based on each data obtained by searching the first database based on the first search condition, another database is created. Estimate the search time required for performing an ID search and the search time required for searching another database using the second search condition reversely generated by the search condition reverse generation mechanism. , The search method that shortens the search time,
An ID search / reverse generation search determination mechanism for operating the search mechanism to search another database is provided.

According to a third aspect, in the database system according to the first or second aspect, the second search condition reversely generated by the search condition reverse generation mechanism;
It is characterized in that an editing mechanism is provided which edits the first search condition and the first search condition used when searching the second database for another database, and causes the search mechanism to search the other database.

In the above configuration, the first aspect of the present invention is the first aspect.
When a search condition is input, a database system that searches a specified database from among a plurality of databases and extracts data corresponding to the first search condition, based on the first search condition, Based on the attribute data of each data obtained by searching the database, a second search condition required for searching another database is reversely generated by a search condition reverse generation mechanism.
Based on the search condition, another database is searched by a search mechanism, and data corresponding to the second search condition is extracted. Then, the first data among the data searched by the search mechanism is searched by a result determination mechanism. The data corresponding to the search condition is selected, and for the missing data, the search mechanism is operated again, and the I
By performing the D search and extracting the missing data, when related data is registered in a plurality of databases, simply searching the first database and searching for the other data in the other databases. Relevant data is automatically extracted with the least number of searches, thereby significantly reducing the time required for data search, time and effort, and the load on the CPU. And so on.

According to a second aspect of the present invention, in the database system according to the first aspect, based on each data obtained by searching the first database based on the first search condition, another database is identified. The search time required for searching and the search time required for searching another database using the second search condition reversely generated by the search condition reverse generation mechanism are estimated, and each of these search times is estimated. In comparison, the first database (the first database) is provided by providing the ID search / reverse generation search determining mechanism that operates the search mechanism and searches another database in the search method that shortens the search time. A search using the ID included in the search results obtained by searching the database;
Of the search conditions inversely generated from the search results, the optimum one is selected, and another database is searched, thereby significantly reducing the time, labor, and CPU load required for data search. In addition, it is possible to eliminate data withdrawal errors or the like caused by an operator's determination error or the like.

According to a third aspect, in the database system according to the first or second aspect, the second search condition reversely generated by the search condition reverse generation mechanism and the first database (the first database is searched). By editing the first search condition used when performing the search for another database and providing the search mechanism with an editing mechanism for searching the other database, the first database (the first database is searched and searched). The search conditions inversely generated from the obtained search results are made more accurate, thereby significantly reducing the time, labor, and load on the CPU required for data search, and resulting from operator's misjudgment. Eliminate data withdrawal errors.

[0017]

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 sales database 4 in which sales data of products are registered in a record format, a stock database 5 in which inventory data of products is registered in a record format, a management computer 3 for managing the sales database 4 and the stock database 5, An input / output device 2 serving as a man-machine interface between the management computer 3 and an operator is provided.

Each time the input / output device 2 is operated to input sales data or inventory data of a product, the management computer 3 fetches the sales data or inventory data, and the sales database 4, Each is registered in the stock database 5.

When one of the sales database 4 and the inventory database 5 is specified, and a search condition (first search condition) of data to be searched is input, the management computer 3 specifies the specified database, for example, The sales database 4 is searched to find sales data corresponding to the first search condition, and the inventory database 5 is searched based on attribute data (data such as item data) of each sales data obtained by the search. , An optimal search condition (second search condition) is inversely generated, and the most appropriate one of the second search condition or the product number (ID) which is one of the attribute data of the sales data is used. , And searches the inventory database 5 to find data corresponding to the first search condition.

<< Operation of 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 diagram shown in FIG.

<Data Registration Operation> First, each time the operator operates the input / output device 2 to input new sales data to any one of the sales database 4 and the inventory database 5, for example, the sales database 4. ,
The management computer 3 fetches the sales data, registers it in the sales database 4 in a record format, and operates the input / output device 2 to input update data for the already registered sales data.
The management computer 3 fetches the update data, and among the sales data registered in the sales database 4, the content of the sales data specified by the update data is updated.

Similarly, every time the operator operates the input / output device 2 to input new stock data to one of the sales database 4 and the stock database 5, for example, the stock database 5, the management computer 3
Each time the input / output device 2 is operated and the update data for the already registered inventory data is input, the management computer 3
Thus, the update data is taken in, and among the inventory data registered in the inventory database 5, the content of the inventory data specified by the update data is updated.

<Data Search Operation> After that, when the operator operates the input / output device 2 to input search conditions (first search conditions) for searching for sold products, etc.
The sales computer 4 is accessed by the management computer 3 to extract a plurality of sales data satisfying the first search condition, and this is displayed on the display (result display mechanism 11) of the input / output device 2 and becomes necessary. Accordingly, the printout is performed from a printer (not shown).

Next, each item data included in each of the sales data (in this case, the number of items and the I
D, item data such as type, release date, price, etc.) and item data of each item of stock data registered in the inventory database 5 (in this case, ID indicating the number of items, product number, type, registration date, wholesale price, storage) Based on the relationship between the sales data and the inventory data, as shown in FIG. 2, the ID search / reverse generation search determination mechanism 6 of the management computer 3 determines the relationship between the sales data and the stock data. Based on this relation, which of the search using the ID or the search using the second search condition is used in the stock database 5, the number of searches is smaller, and the search time is shorter. Is determined.

In this case, if the number of sales data obtained by searching the sales database 4 using the first search condition is only one or two, each sales data included in the sales data is It is determined that searching the inventory database 5 using the ID reduces the number of searches and can shorten the search time. Based on the determination result, the product number (ID indicating the product) is used as a search key. Then, the stock database 5 is searched by the search mechanism 9 of the management computer 3 to extract stock data having the product number, and this is used as a stock table as a display of the input / output device 2 (result display mechanism 11). It is displayed on the top and printed out from the printer as needed.

The number of sales data obtained by searching the sales database 4 using the first search condition is larger than a preset number as shown in the example of FIG. If the number is seven, the I
The D search / reverse generation search judging mechanism 6 uses the respective IDs of the sales data to search the inventory database 5, rather than searching the inventory database 5 by setting new search conditions. Is reduced, and it is determined that the search time can be shortened. Based on the determination result, the generation of the second search condition by the search condition reverse generation mechanism 8 is started.

At this time, each item data contained in each of the sales data (in this case, I
D, item data such as type, release date, and price) and item data of each item of inventory data registered in the inventory database 5 (in this case, the number of items, ID indicating product number, type, registration date, wholesale price, storage) The same item contents, for example, the following item contents are noticed based on the relation relationship with the item data such as a place), and the relations of (a) to (c) are put together, and the related information 7 is created. You.

(A) The type of the product in the sales database 4 has the same content as the type of the product in the inventory database 5. (B) The price of the product in the sales database 4 is twice the price of the product in the inventory database 5. (C) The release date of the product in the sales database 4 is close to the registration date of the product in the inventory database 5.

Then, based on the related information 7, the search condition reverse generation mechanism 8 of the management computer uses the first search condition among the inventory data registered in the inventory database 5 to generate the sales database 4 using the first search condition. For each product number (I) included in each sales data obtained by searching for
D) and the like, a search condition most suitable for extracting inventory data including the same product number (ID), for example, a second search condition shown below is inversely generated.

(1) Kind = “soft”, and (2) “93.3” <registration date <“93.6”, and (3) 40,000 yen ≦ wholesale price ≦ 80,000 yen In this case, the condition of the wholesale price About sales database 4
Among the sales data obtained by searching for the first search condition, there are 6 cases where the price is from 80,000 yen to 160,000 yen and 1 case where the price is 1 million yen, but the wholesale price is 40,000 yen. If the price is set to ≦ whole price ≦ 80,000 yen, the number of hits may be too large when searching the inventory database 5.
The condition that the wholesale price is 80,000 yen is adopted.

Thereafter, when the reverse generation of the second search condition is completed, the stock database 5 is searched by the search mechanism 9 of the management computer 3 based on the second search condition, and each of the inventory databases 5 satisfying the second search condition is searched. Inventory data is extracted, and among these inventory data, an extra ID
Is deleted, and a stock list 12 indicating the relationship between the product number (ID) and the storage location is created based on the remaining stock data, and this is stored in the memory 14 of the management computer 3.

Next, the result judging mechanism 10 of the management computer 3 uses the first search condition to search the sales database 4 for the product number (ID) of each sales data and the inventory list 12 Is compared with the item number (ID) of each item of inventory data, and all the item numbers included in each item of sales data obtained by searching the sales database 4 are included in the inventory list 12. Is checked.

In the case shown in FIG. 2, the second search condition includes, for each sales data obtained by searching the sales database 4 under the first search condition, the sales data having a price of 1,000,000 yen. For example, the product number (I) of each sales data obtained by searching the sales database 4
In D), the inventory data of the product number “B09” has not been searched.

Therefore, in such a case, based on the result of the judgment by the result judgment mechanism 10, the search mechanism 9 of the management computer 3 performs an ID search directly using the product number "B09" to thereby store the inventory database 5 in the inventory database 5. The inventory data including the product number “B09” is extracted again, and the product number “B09” is extracted based on the stock data.
And an inventory list 13 showing the relationship between the inventory list and the storage location, and these inventory lists 12 and 13 are displayed on the display (result display mechanism 11) of the input / output device 2.

The ID of each stock data obtained by searching the stock database 5 using the second search condition.
When the number is significantly smaller than the number of IDs of each sales data obtained by searching the sales database 4 using the first search condition, the search mechanism 9 searches the inventory database 5 using the ID. Is performed, the search process using the ID is skipped because the number of searches becomes too large, the ID search / reverse generation search determination mechanism 6 is activated again, and the ID search / reverse generation search determination mechanism 6 Under the control, the search condition reverse generating mechanism 8 searches the inventory database 5 using the second search condition to find a third search condition that is optimal for searching inventory data that could not be extracted. Generated.

Based on the third search condition, the search mechanism 9 of the management computer 3 searches the inventory database 5 and the result determination mechanism 1 of the management computer 3
0, a search result determination process is performed, and each stock data item that could not be searched under the second search condition is searched from the stock database 5, and among the respective stock data items obtained by this search process, Unnecessary items are deleted, and an inventory list is created based on the remaining inventory data.

Thereafter, the product number (ID) of each sales data obtained by searching the sales database 4 using the first search condition, and the product number (ID) obtained by the search process using the second search condition. The product number (ID) of each stock data in the stock list 12 obtained is compared with the product number (ID) of each stock data in the stock list obtained by the search process using the third search condition. Then, it is checked whether or not all of the product numbers included in each sales data obtained by searching the sales database 4 are included in the stock list and the stock list 12.

Then, among the product numbers (ID) of each sales data obtained by searching the sales database 4 using the first search condition, the inventory list and the inventory list 1
If there is a product number (ID) that is missing from 2, the above-described ID search or reverse generation of the next search condition is executed,
When all the inventory data having the product number (ID) of each sales data is obtained, the obtained inventory list and the previous inventory list 12 are put together and displayed on the display of the input / output device 2 (results). It is displayed on the display mechanism 11).

When the number of inventory data obtained by searching the inventory database 5 using the second search condition and the third search condition is larger than a preset number,
The ID is determined by the result determination mechanism 10 of the management computer 3.
After the search / inverse generation search judging mechanism 6 is restarted and the second search condition and the third search condition are narrowed down, the search database 9 is searched again by the search mechanism 9 and the stock data obtained by the search is performed. , An inventory list is created.

Thereafter, the above-described ID search or the reverse generation process of the next search condition is executed, and when all the stock data having the product number (ID) of each of the sales data is obtained, this is obtained. The inventory list and the previous inventory list 12 are put together and displayed on the display (result display mechanism 11) of the input / output device 2.

<< Effects of Embodiment >> As described above, in this embodiment, when either the sales database 4 or the inventory database 5 is specified and the first search condition of the data to be searched is input, The management computer 3 searches the designated database and retrieves the first
In addition to finding data corresponding to the search condition, a second search condition is inversely generated based on the data to obtain the second search condition.
Since another database is accessed using a search condition or an ID included in the data to find data corresponding to the first search condition, related data is registered in a plurality of databases. In this case, by simply searching the first database, the related data in the other databases can be automatically extracted with the minimum number of searches, thereby reducing the time required for data search and the time and effort. In addition, the load on the CPU can be greatly reduced, and a data extraction error or the like due to an operator's determination error or the like can be eliminated.

Also, in this embodiment, after the sales database 4 is searched using the first search condition, the inventory database 5 is searched by the ID search / reverse generation search judgment mechanism 6.
In response to this, it is determined whether to execute an ID search or reversely generate the second search condition to execute the search. Therefore, the first database (the search result obtained by searching the first database) Out of the search using the ID included in the search result and the search condition reversely generated from the search result, the other database can be searched. In addition, it is possible to greatly reduce the labor and the load on the CPU, and it is also possible to eliminate a data extraction error or the like caused by an operator's determination error or the like.

<< Other Embodiments >> In the above-described embodiment, the contents of each item included in each sales data obtained by searching the sales database 4 using the first search condition. Is used to generate a second search condition, and the inventory database 5 is searched using the second search condition. As shown in FIG. An editing mechanism 15 is provided between the second search condition and the second search condition generated by the search condition reverse generation mechanism 8, and the first search condition used when searching the sales database 4. May be edited to optimize the second search condition, and the inventory database 5 may be searched using the second search condition.

By doing so, it is possible to further improve the search accuracy as compared with the above-described embodiment, and to further reduce the search time by the amount by which the second search condition is optimized.

[0046]

As described above, according to the present invention, according to the first aspect, when related data is registered in a plurality of databases, only the first database is searched and another database is searched. Automatically retrieve relevant data within the site with the least number of searches,
As a result, the time required for data retrieval, labor, and CP
It is possible to greatly reduce the load on U, and to eliminate a data extraction error caused by an operator's determination error or the like.

In the present invention, the first database (a search using an ID included in a search result obtained by searching the first database, and a search condition reversely generated from the search result) The most suitable one can be selected and another database can be searched. As a result, the time required for data search, the labor and the load on the CPU can be significantly reduced, and the operator's judgment can be made. It is possible to eliminate a data extraction error or the like caused by an error or the like.

According to the third aspect of the present invention, the first database (the search condition reversely generated from the search result obtained by searching the first database) can be made more accurate, thereby enabling the data search to be performed. The time and effort required,
The load on the CPU can be significantly reduced, and a data extraction error or the like caused by an operator's determination error or the like can be eliminated.

[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 block diagram showing another embodiment of the database system according to the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Database system 2 I / O device 3 Management computer 4 Sales database 5 Inventory database 6 ID search / reverse generation search judgment mechanism 7 Related information 8 Search condition reverse generation mechanism 9 Search mechanism 10 Result judgment mechanism 11 Result display mechanism 12 Inventory list 13 Inventory list 14 Memory 15 Editing mechanism

Claims (3)

[Claims] 1. A database system for searching a specified database among a plurality of databases when a first search condition is input and extracting data corresponding to the first search condition, wherein the first search A search condition reverse generation mechanism for reversely generating a second search condition required for searching another database based on attribute data of each data obtained by searching the first database based on the condition; A search mechanism for searching another database based on the second search condition generated by the search condition reverse generation mechanism to extract data corresponding to the second search condition; Of these, data corresponding to the first search condition is selected, and for missing data, the search mechanism is operated again,
And a result determination mechanism for performing an ID search with respect to another database and extracting missing data. 2. The database system according to claim 1, wherein an ID search of another database is performed based on each data obtained by searching the first database based on the first search condition. Estimate the required search time and the search time required to search another database using the second search condition reversely generated by the search condition reverse generation mechanism, compare these search times, A database system comprising: an ID search / reverse generation search determination mechanism that operates the search mechanism and searches another database by a search method that shortens the search time. 3. The database system according to claim 1, wherein the second search condition reversely generated by the search condition reverse generation mechanism and a first search used when searching the first database. Edit the conditions and for other databases,
A database system, comprising: an editing mechanism for causing the search mechanism to search another database.