JPH0822469A - Retrieving method for data base - Google Patents

Abstract

PURPOSE:To efficiently remove a waste of repeated access to the same data as to a system which can access a remote data base. CONSTITUTION:When a request to access a main DB is made, it is judged whether or not a mode of direct access to the main DB is entered (step S1) and when not, a local DB is retrieved (step S2), so that the retrieval result is displayed (step S3). When a desired result is not obtained (step S4), a line is connected to the main DB (step S5) and the main DB is retrieved (step S6), so that the retrieval result is displayed (step S7). Then the result obtained from the main DB desired to be registered in the local DB (step S8), this retrieval result is registered in the local DB as well (step S9).

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database search method, and more particularly to a search method in a system capable of selectively storing data obtained by accessing a main database in a local database. .

[0002]

2. Description of the Related Art Conventionally, using a telephone line or the like, a main database existing in a remote place of an information providing company or the like is accessed and searched to obtain necessary data. The data retrieved in this way was used individually by those who accessed it individually.

[0003]

By the way, in recent years, a system capable of accessing a local database from each of a plurality of terminal devices has been constructed by a corporate LAN or the like. Even with such a system, conventionally, only the operator registered in the local database knows the fact that the operator has registered and the registration position (drive, directory), so even if it is the data registered in the local database. However, another operator is accessing the main database of the information provider company to obtain necessary data.

The present invention has been made in view of the above points, and provides a database search method capable of efficiently eliminating the waste of repeatedly accessing the same data in a system that can access a distant database. With the goal.

[0005]

In order to achieve the above-mentioned object, a database search method according to the present invention has a main database in which data obtained by accessing a main database is selectively stored in a local database. When accessing the main database, if it is not in the mode to directly access the main database, it is checked whether the data obtained by accessing already is stored in the local database, and it is stored in the local database. If stored, the data is read from the local database.

[0006] Here, whether or not the data obtained by the above-mentioned access is stored in the local database is checked by searching the index stored when the data is registered in the local database. It is characterized by

Alternatively, it is characterized in that the check as to whether or not the data obtained by the above-mentioned access is stored in the local database is performed by searching the data itself registered in the local database. .

[0008]

That is, according to the database retrieval method of the present invention, the data obtained by accessing the main database is selectively stored in the local database, and the main database is not accessed when the next main database is accessed. If the mode in which the database is directly accessed is not set and the data obtained by the access is already stored in the local database, the data is read from the local database.

Here, whether or not the data obtained by the above access is stored in the local database is checked by searching the index stored when the data is registered in the local database, or , Is performed by retrieving itself registered in the local database.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. FIG. 2 is a diagram showing a configuration of a database search system to which an embodiment of the present invention is applied, and reference numeral 10 in the figure denotes an information providing company. The information providing company 10 has a general-purpose computer 12 and a main database (DB) 14 so that a plurality of subscribers connected via a public line 20 can access the main DB 14 and retrieve necessary information. ing. A plurality of subscribers of a company, a store, a business establishment, etc., that is, a subscriber “A” 30A, a subscriber “B” 30B, ..., A subscriber “n” 30n are representative of the subscriber “A” 30A in FIG. As shown in FIG. 3, the local DB 32 has a plurality of terminals 34 connected to each other by a LAN, and a specific or all of the terminals 34 are connected to the local DB 3
2 and the public line 20 to access the main DB 14 of the information providing company 10 to retrieve necessary information.

Next, the operation in such a configuration will be described with reference to FIG.
This will be described with reference to the flowchart in FIG. That is, when the operator performs a predetermined operation on the terminal 34 to generate an access request to the main DB 14, the terminal 34
First, in step S1, it is determined whether or not the mode is a mode in which the main DB 14 is directly accessed. If it is such a mode, the process proceeds to step S5 described later, and if not, the process proceeds to the next step S2.

The mode check in step S1 is
The operator directly accesses the main DB 14 in advance or accesses the local DB 32 and then the main DB 1
4 is checked by checking the mode setting state of whether to access 4 or not.

If the mode for directly accessing the main DB 14 is not set, the local DB 32 is searched in the next step S2, and the search result is displayed in step S3. The search method is to search the index attached when the information is registered in the local DB 32, or
If the information registered in the local DB 32 is text data, it is performed by searching the specified or predetermined directory of the local DB 32 for the corresponding character and displaying the data having the corresponding character. .

Then, in step S4, when the operator's keyboard or mouse input instruction is judged to obtain the desired result, that is, when the processing end is instructed, the processing of this flowchart is ended.
On the other hand, when the desired result is not obtained even when the local DB 32 is searched, that is, when a further search is instructed, the process proceeds to the next step S5.

In step S5, the line is connected to the main DB 14 of the information providing company 10 via the public line 20, the main DB 14 is searched in the next step S6, and the search result is displayed in step S7. Then, in the next step S8, when the operator does not desire to register the result obtained from the main DB 14 in the local DB 32 by judging the operator's keyboard or mouse input instruction, that is, the processing end is instructed. At times, the processing of this flowchart is terminated. On the other hand, when registration is desired, that is, when registration is instructed, the process proceeds to the next step S9.

In step S9, the result obtained from the main DB 14 is registered in a predetermined directory by adding an index to the local DB 32 or as text data. Then, the process of this flowchart is ended.

Further, the above embodiment will be described with reference to the display example of FIG. That is, as shown in FIG. 3A, if the operator makes an access request to the main DB 14 (if the “Y” key is pressed), the main DB 1
When the mode for directly accessing 4 is set, a search menu is displayed as shown in FIG. here,
For example, if an instruction to search the business partner company information is given (if the "2" key is pressed), the input of the company name to be searched, that is, the search condition, as shown in FIG. Then, when the search condition is input, the main DB 14 is searched according to the condition and the result is displayed as shown in FIG. After that, (E) in the figure
As shown in, the operator selects whether or not to register the search result in the local DB 32. Here, if the "Y" key is pressed, the search condition, that is, the company name is registered as an index in the local DB 32.

Further, when the access request for the main DB 14 is made and the mode is such that the main DB 14 is not directly accessed but the local DB 32 is accessed, the search condition input screen is immediately displayed, and the entered search conditions are Search for a matching index. And
When there is no matching index, that fact is displayed and the main DB 14 is automatically accessed. When accessing the local DB 32, the main DB
As in the case of access to 14,
The local DB 32 may be searched by the procedure as shown in (C).

The present invention is not limited to the above embodiment. For example, in the above embodiment, each subscriber has a plurality of terminals that can access the local DB, but the number of terminals may be one. Also, the case of the subscribers and the information providing company connected by the public line has been described, but in the corporate system connected by LAN, the main DB configured in the main computer and the local D configured in each terminal.
It is also possible to implement B as well.

Therefore, according to the above embodiment of the present invention, the following configuration can be obtained. (1) If the data obtained by accessing the main database is selectively stored in the local database and the main database is not directly accessed when the main database is accessed,
Check whether the data obtained by accessing already is stored in the local database, and if it is stored in the local database,
A database search method characterized by reading the data from the local database.

(2) Checking whether the data obtained by the above access is stored in the local database is performed by searching the index stored when the data is registered in the local database. The database search method according to (1) above, which is characterized in that

(3) It is characterized in that the check whether or not the data obtained by the above-mentioned access is stored in the local database is performed by searching the data registered in the local database. The database search method according to (1) above.

(4) Means for selectively storing the data obtained by accessing the main database in the local database, and whether the mode is such that the main database is directly accessed when the main database is accessed. Check whether or not, and if it is in the mode to access the local database first,
Means for checking whether or not the data already obtained by accessing is stored in the local database;
A database retrieval device comprising: means for reading the data from the local database when the data is stored in the local database.

(5) The database search device according to (4), wherein the checking means performs the check by searching an index stored when the data is registered in the local database.

(6) The database retrieving apparatus according to (4), wherein the checking means performs the checking by retrieving itself registered in the local database.

[0026]

As described in detail above, according to the present invention,
It is possible to provide a database search method capable of efficiently eliminating the waste of repeatedly accessing the same data in a system that can access a database located at a distant place.

[Brief description of drawings]

FIG. 1 is a diagram showing an operation flowchart of an embodiment of the present invention.

FIG. 2 is a block configuration diagram of a database search system to which an embodiment of the present invention is applied.

3A to 3E are diagrams showing display examples for explaining the operation of one embodiment of the present invention.

[Explanation of symbols]

 10 ... Information provider 12 ... General-purpose computer 14 ... Main database (main DB) 20 ... Public line 30A, 30B, ..., 30n ... Subscriber 32 ... Local database (local DB) 34 ... Terminal

Claims (3)

[Claims] 1. The data obtained by accessing the main database is selectively stored in a local database, and when the main database is accessed, the main database is not directly accessed. It is checked whether or not the data obtained by accessing is stored in the local database, and if it is stored in the local database, the data is read from the local database. How to search the database. 2. The check as to whether or not the data already obtained by the access is stored in the local database is performed by searching an index stored when the data is registered in the local database. The database search method according to claim 1, wherein: 3. The check as to whether or not the data obtained by the access is stored in the local database is performed by searching the data registered in the local database. The database search method according to claim 1.