JPH0773193A - Data base retrieving system - Google Patents

Abstract

PURPOSE:To efficiently execute retrieving operation by automatically connecting between the terminal of a retrieving person and data bases storing desired data, which exist in a wide area, by utilizing an under-communication transfer service or inter-user information information informing service which are provided in ISDN communication. CONSTITUTION:As the terminal 4 and a data base device 1 are under communication, the retrieving operator data-base-retrieves on some retrieving logical condition by way of the terminal 4. Next, when the retrieving operator retrieves data to a data base device 1 on another condition, the data base device 1 refers to summarized information of a pointer table 11 to decide a data base device 2 provided with summarized information meeting the retrieving logical condition of retrieval B. Then, a communication call from the terminal 4 is transferred to the data base device 2 through the use of an under-communication transfer function Namely, the communication call from the terminal 4 is temporarily held and an address table 13 obtains the address of the data base device 2 to set it in SETUP information.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database retrieval system for retrieving actual data between a plurality of database devices existing in a wide area and interconnected by ISDN. The present invention relates to a database search system suitable for conducting efficient searches.

[0002]

2. Description of the Related Art Conventionally, when searching for desired data from a plurality of distributed database devices, a search operator preliminarily investigates and specifies a database device in which desired data is likely to exist. Then, as a result of searching with the specified database device, if the desired data is not obtained,
The search operator connects again to another database device and repeats the search operation such as inputting the search logical condition from the beginning. However, in this conventional technique, the search operator needs to understand in advance the whereabouts of each database device and the data storage contents. Further, if desired data cannot be obtained with the specified database device, it is necessary to change the database device to communicate with and input search conditions and the like again, which is a waste of time and labor.

As a conventional technique for dealing with such a problem, various database systems have been proposed which are interconnected by a local area network (LAN) and are distributed and arranged in a plurality of database devices for each data content. In these techniques, a search condition and a device number of data existing in another database device are written in advance in a database device serving as a standard server. Then, the search operator first accesses the standard server to access the database device in which the data matching the input search condition exists via the LAN. But,
In the case of interconnection of multiple databases by this LAN,
It is difficult to apply to database devices distributed over a wide area.

At present, an ISDN communication network for connecting a plurality of devices distributed over such a wide area at high speed has been constructed. One of the services provided by this ISDN communication is a communication transfer function. This function is a service that can transfer the communication performed using one B channel to a third party. That is, user A and user B
When communicating with the ISDN network, the user A suspends the communication with the user B, calls the user C of a third party, and the user A executes this communication transfer function. Thus, the user B on hold can be transferred to the user C of a third party. As a result, the communication between the users B and C is started, and the communication of the user A ends.

Another service provided by ISDN communication is an inter-user information notification service. By using this service, the user can transmit / receive user information to / from the other user through the D channel at the time of call setup or the like. However, in the conventional technology related to database search, focusing on the in-communication transfer service and the inter-user information notification service provided by these ISDN communication, the search between multiple database devices connected over a wide area is made highly efficient. It was not suggested to do.

[0006]

The problem to be solved is that in the conventional database search technology, the IS
No consideration has been given to the in-communication transfer service or the inter-user information notification service provided by the DN communication, and if the search operator does not have to be aware of the location of each database device and the stored contents, a plurality of databases connected to a wide area can be used. The point is that searches cannot be performed between devices. An object of the present invention is to solve these problems of the prior art, and to search between a plurality of database devices connected in a wide area by an ISDN communication network.
It is to provide a database search system that enables efficient execution.

[0007]

In order to achieve the above object, the database search system of the present invention is such that, in each database device which is connected to each other by ISDN and exists in a plurality of wide areas, all the data of each database device is stored. A pointer table that registers the summary information and the identification information of the database device that stores the actual data corresponding to this summary information, and the address that registers the address information of each database device in association with each identification information of the database device. Based on the table and the search logical condition for the actual data search input by the search operator via the terminal, the pointer table is referred to search the summary information that matches this search logical condition, and the summary information is A pointer part that acquires the identification information of the corresponding database device, and the data acquired by this pointer part. When the identification information of the database device determines whether the identification information indicates the own database device or another database device, and the determination result of the DB determination unit is the own database device, based on the search logical condition , A search unit that searches actual data in its own database device, and when the determination result of the DB determination unit is another database device, based on the identification information of the database device acquired by the pointer unit, the corresponding address from the address table The address part for extracting the information and the address information extracted by this address part are set in the SETUP information, and the search logical condition is set in the user information transmitted by the inter-user information notification service of the ISDN network. With the transfer function during communication, the data is transferred to and sent to the other database device determined by the DB determination unit, End and the database device where the actual data exists are connected, and the connected database device is provided with a connection relay unit for continuing the search of the actual data based on the search logical condition, and once from the search operator via the terminal It is characterized in that each database device connected to each other by ISDN is searched based on the search logic condition inputted only.

[0008]

According to the present invention, when the database device directly accessed from the search operator's terminal does not have the desired data, the accessed database device stores the desired data in the search operator's terminal. It automatically connects to the existing database device via the ISDN network. As a result, the search operator can perform a search operation for each data in each database device existing in a wide area without being aware of the location of each database device or the stored contents. That is, the database device accessed directly from the search operator's terminal determines whether the actual data matching the search logical condition specified by the search operator exists in its own database device or in another database device. , The search logical condition is compared with the summary information of all the database devices to make a determination. If the search logical condition matches the summary information of the own database device currently connected to the search operator terminal, it is determined that actual data that matches the search logical condition exists in the own database device. Then, as in the past, the own database device is searched under the search logical condition,
Send desired data to the search operator's terminal. Further, if the search logical condition matches the summary information of another database device, it is determined that the actual data matching the search logical condition exists in the relevant database device. And SETU
In P information, set the address of the database device,
The in-communication transfer function transfers an in-communication call. At the same time, a search logical condition is set in the user information transmitted by the inter-user information notification service, and the user information is transmitted to the database device in which the actual data exists. The database device that has received the communication call transferred in this way acquires the search logical condition from the user information, performs a database search, extracts the desired data, and sends it to the terminal of the search operator.

[0009]

Embodiments of the present invention will now be described in detail with reference to the drawings. FIG. 1 is a block diagram showing an embodiment of a configuration relating to the present invention of a database search system of the present invention. In the figure, 1 to 3 are database devices (database device 2, which performs the data search operation according to the present invention,
(3 is described as DB in the drawing), 4 is a terminal operated by a search operator, and 5 is an ISDN communication network connecting the database devices 1 to 3 and the terminal 4. Each database device 1 to
Reference numeral 3 denotes a DSU (Digital Service Uni) not shown, as shown in the database device 1.
t, an in-home line terminating device), and an I interface control unit 6 for performing processing relating to communication control in the ISDN communication network 5.
And an actual data storage unit 7 that stores the actual data to be searched
And a data search unit 8 according to the present invention.

The data search unit 8 is used by each database device 1
Pointer table 1 for registering the summary information 9 of all the actual data stored in 3 to 3 and the identification information 10 of the database device storing the actual data corresponding to this summary information 9.
1 and the address table 13 for registering the address information (indicated as an address in the drawing) 12 of each of the database devices 1 to 3 in association with the identification information 10 and the terminal 4
Based on the search logical condition for the actual data search input via the search operator via the, the summary information 9 matching the search logical condition is searched by referring to the pointer table 11 and corresponds to this summary information 9. Database device identification information 1
A pointer unit 14 that acquires 0, and a DB determination unit 15 that determines whether the identification information 10 acquired by the pointer unit 14 indicates the own database device 1 or the other database devices 2 and 3. , This DB discrimination unit 15
When the determination result of No. is the own database device 1, the determination result of the search unit 16 that searches the actual data in the actual data storage unit 7 based on the search logical condition and the determination result of the DB determination unit 15 are those of the other database devices 2 and 3. In this case, an address section 17 for extracting corresponding address information 12 from the address table 13 based on the identification information 10 acquired by the pointer section 14,
The address information 12 extracted by the address part 17 is SE
Another database device which is set in the TUP information and the search logical condition is set in the user information to be transmitted by the inter-user information notification service of the ISDN network, and is discriminated by the DB discriminating unit 15 by the in-communication transfer function of the ISDN network additional service. It is composed of a connection relay unit 18 which transfers and transmits to the terminals 2 and 3 and continues the search operation between the terminal 4 and the database devices 2 and 3 where the actual data exists.

In the database device 1 having such a configuration,
If the search logical condition is input from the search operator via the terminal 4 and the search logical condition matches the database device 2, the database device 1 is communicating with the database device 2 with the terminal 4. Call is automatically transferred.
To transfer this communication call, the transfer function during communication, which is an additional function of the ISDN network, is used. In this way, the terminal 4 is automatically connected to the database device 2 that matches the search logical condition, so that the search operator can obtain actual data that matches the search logical condition without re-inputting the search logical condition. Can be received. Details of such a search operation will be described below with reference to FIG.

FIG. 2 is a communication sequence diagram showing an example of a data search procedure according to the present invention by the database search system in FIG. In this example, the terminal 4 and the database device 1 are in communication, and the search operator performs a database search for the database device 1 via the terminal 4 under a certain search logical condition (search A in the figure). . The database device 1 refers to the summary information in the pointer table 11 to determine the database device having the summary information that matches the search logical condition. In the case of search A, if the search logic condition matches the summary information of the database device 1, the actual data storage unit 7 is searched for data (result A in the figure) that matches the search logic condition. , To the terminal 4.

Next, when the search operator performs a data search on the database device 1 under another condition (search B in the figure), the database device 1 refers to the summary information in the pointer table 11 to perform the search. The database device 2 having the summary information that matches the search logical condition of B is determined. And
The communication call from the terminal 4 is transferred to the database device 2 by using the transfer during communication function. That is, first, the terminal 4
From the address table 13 in FIG. 1 to obtain the address of the database device 2,
Set in the SETUP information. In the ISDN communication network, the calling number (destination address =
Telephone number), calling subaddress (callee's subaddress), called number (caller's address = telephone number), and callee subaddress (caller's subaddress) can be set to make a call. , The address of the database device 2 which is the transfer destination is set. As a result, it is transmitted to the database device 2. The address of the database device 1 is set as the called number.

The database device 2 receives the received SET.
It can be used to identify the source database device 1 by looking at the called number in the UP information. When it is necessary to identify the communication terminal using the subaddress, it is necessary to obtain the subaddress of the transfer destination from the address table or the like and set it as the originating subaddress.
Here, since it is not necessary to identify the communication terminal by using the sub address, the address of the terminal 4 (calling ID,
IDentification, identification information) is set and the information is transmitted to the database device 2.

The database device 1 transmits user information (indicated as UUI in the drawing) to the database device 2 by utilizing the inter-user information communication service at the time of making a call by such a communication transfer function. A search logical condition is set in this user information. If the search logical condition also matches the database device 3 in FIG. 1, that is, a plurality of database devices, the addresses of the second and subsequent database devices are also transmitted in the user information. Also, if the identification information of the search operator is added to the user information and transferred, it is effective in protecting the data from an unauthorized user. That is, since the search operator can be identified, it is possible to limit the database device to which the reference is permitted, corresponding to the search operator. The identification information of the search operator includes, for example, a password added to each search operator.

In this way, the above information is set in the SETUP information and the user information, transmitted to the database device 2, and if the connection is made normally, the database device 1
Transfers the communication call from the terminal 4 to the database device 2 by the transfer during communication function. As a result, the terminal 4 and the database device 2 are in communication. Database device 2
Obtains necessary information from the SETUP information and the user information when the incoming call is received, and stores the actual data storage unit 7 in the own device.
Data matching the search condition is searched from the data of a.
Then, the search result (result B in the figure) is transmitted to the terminal 4.

If the user information describes the addresses of the second and subsequent database devices, for example, the database device 3 in FIG. 1, the transferred database device 2 is the other database device. That is, by using the in-communication transfer function for the database device 3,
Similarly, the communication call from the terminal 4 is transferred. In the case of a call, the address of the second candidate database device (database device 3 in FIG. 1) is set in the SETUP information. Further, in the user information, search logical conditions and, if necessary, addresses of the third and subsequent database devices are set. In this way, the transfer of the communication call from the terminal 4 is repeated until the final candidate.

FIG. 3 is a flow chart showing an example of the processing operation according to the present invention of the database device in FIG. The database device is waiting (step 10
1) Always check incoming calls (step 10)
2). If there is an incoming call, SETUP of the incoming call
Depending on the content of the information and user information, whether it is an incoming call from the terminal,
Alternatively, it is determined whether the call is an incoming call from another database device (step 103). In case of an incoming call from the terminal,
When the search logical condition is input from the terminal and the reception of the search logical condition is detected (step 104), the received search logical condition is collated with the summary information in the pointer table, and the actual data is It is judged whether or not it is in its own database device (step 105).

When it is determined that the received search logical condition does not exist in the actual data storage unit of the own database device but exists in another database device, the address of the database is acquired from the address table (step 10).
6) The transfer destination address is set in the SETUP information (step 107). Then, the call during communication with the terminal is automatically transferred to another database device by the transfer during communication of the additional function of the ISDN network (step 108). After the transfer is completed, the state transits to the standby state of step 101.

When it is determined that the search logical condition received in step 105 exists in the actual data storage section of the own database device, the actual data storage section is searched (step 109) to check whether there is corresponding data. A judgment is made (step 110). If the data corresponding to the search logical condition exists, the corresponding data is transmitted to the terminal (step 111), and if the corresponding data does not exist, the terminal is notified of no corresponding data (step 111). 112). Then, the search logical condition is initialized (step 113). Here, the received search logical condition is
If it exists in another database device (step 11)
4), obtaining the address of another database in step 106. If there is no other database device that matches the received search logical condition, step 104
Transition to waiting for search condition reception.

As described above, when the received search logical condition exists in a plurality of databases, first, the actual data storage section in the own device is searched, and thereafter, a plurality of data determined to exist exists. Perform a database search. In this case, in step 106, all addresses of the plurality of databases determined to have data are read from the pointer table, the first address is set in the SETUP information, and the addresses of the second and subsequent databases are searched. Both logical conditions are set in the user information (step 107). Then, the call is transferred to the first address by transfer during communication (step 10
8), transition to the waiting state of step 101.

In step 103, SET of incoming call
When it is determined that the incoming call is from another database device based on the contents of the UP information and the user information, the search logical condition is acquired from the user information (step 115), and after the search of the actual data storage unit in step 109. Process.
Through such processing, the search operator can obtain data from a plurality of database devices distributed over a wide area only by inputting search logical conditions to one database device via the terminal.

As described above with reference to FIGS. 1 to 3, in the database search system of this embodiment, the ISD
Even if there is no desired data in the database device that is connected using the N network, another database device that manages the data desired by the searcher is transmitted to the other database device via the ISDN network. Data can be given by performing automatic transfer processing. As a result, the search operator does not have to be aware of the location and the contents of storage of the database device in which the desired data is distributed into a plurality of data,
It is possible to search efficiently, and it is possible to support a wide range of users. The present invention is not limited to the embodiment described with reference to FIGS. 1 to 3, and various modifications can be made without departing from the scope of the invention.

[0024]

According to the present invention, by utilizing the in-communication transfer service and the inter-user information notification service provided by the ISDN communication, the search operator's terminal and a wide area for storing desired data exist. The database devices can be automatically connected, and the search operator can perform efficient search operations without being aware of the location and stored contents of each database device, and the operability and performance of the database search system. Can be improved.

[Brief description of drawings]

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

FIG. 2 is a communication sequence diagram showing an example of a data search procedure according to the present invention by the database search system in FIG.

FIG. 3 is a flowchart showing an example of a processing operation according to the present invention of the database device in FIG.

[Explanation of symbols]

 1 to 3 database device 4 terminal 5 ISDN communication network 6 I interface control unit 7, 7a actual data storage unit 8 data retrieval unit 9 summary information 10 identification information 11 pointer table 12 address information 13 address table 14 pointer unit 15 DB determination unit 16 Search part 17 Address part 18 Connection relay part

─────────────────────────────────────────────────── ─── Continuation of the front page (51) Int.Cl. ⁶ Identification code Internal reference number FI Technical display location H04M 3/00 B 8426-5K 3/42 C

Claims (1)

[Claims] 1. Identification of database devices which are connected to each other by ISDN and exist in a plurality of wide areas, and which store summary information of all data of the database devices and actual data corresponding to the summary information. A pointer table for registering information, an address table for registering address information of each database device in association with each identification information of the database device,
Based on the search logical condition for the actual data search inputted from the search operator via the terminal, the pointer table is referred to search the summary information matching the search logical condition, and the summary information corresponding to the summary information is searched. Pointer means for obtaining identification information of the database device, DB discriminating means for discriminating whether the identification information of the database device obtained by the pointer means indicates its own database device or another database device, and the DB When the discrimination result of the discriminating means is the own database device, and when the discriminating result of the DB discriminating means is another database device, and the retrieval means which retrieves the actual data in the own database device based on the retrieval logical condition, Based on the identification information of the database device obtained by the pointer means, the corresponding address information is obtained from the address table. And address means for exiting, the address information extracted by said address means to SETUP information,
The search logical condition is set in each of the user information to be transmitted by the inter-user information notification service of the ISDN network, and by the transfer during communication function of the ISDN network additional service,
Transfer and transmit to another database device determined by the DB determination means, connect the terminal and the database device where the actual data exists, and continue the search of the actual data based on the search logical condition by the connected database device. And a connection relay means for performing the search, and based on the search logical condition inputted only once by the search operator via the terminal, a search for each database apparatus mutually connected by the ISDN is performed. system.