Method and system for retrieving search results from multiple disparate databases

• US 9,767,167 B2
• Filed: 10/19/2004
• Issued: 09/19/2017
• Est. Priority Date: 04/27/2000
• Status: Expired due to Fees

• Current Assignee: Proquest LLC (Clarivate Plc)
• Original Assignee: Proquest LLC (Clarivate Plc)
• Inventors: Miller, Todd, Schelp, Brian, Duncan, Paul
• Primary Examiner(s): Trujillo, James
• Assistant Examiner(s): TESSEMA, AIDA Z
• Application Number:
  US10/969,112
• Publication Number:
  US 20050065922A1
• Time in Patent Office: 4,718 Days
• Field of Search: None
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation

Abstract

The present invention generally relates to a method and system for retrieving search results. More particularly, the present invention relates to a method and system for retrieving search results concurrently from multiple disparate databases, whether such databases be available through the Web, or other proprietary internal networks. In an exemplary embodiment, the system includes a user interface, a control engine, and a number of translators which are used to communicate with a number of corresponding databases. During exemplary operation, a user uses the user interface to enter search term(s) and other pertinent information relating to his/her search and specify which ones of the databases are to be searched. The search term(s) and other pertinent information are then relayed to the control engine which, in turn, forwards them to the appropriate translators which correspond to the specified databases to be searched. These translators then concurrently formulate and issue their respective search requests to the corresponding databases. Concurrent searches are then carried out in the specified databases. Search results from each of the specified databases are then returned and consolidated for display by the user interface.

Claims

1. A computerized searching method for retrieving search results from a plurality of disparate databases via computer software that transparently and without any user interaction manages one or more disparate authorization steps, comprising the steps of:

receiving search information from a user or a user agent;

formulating a plurality of search requests respectively in said plurality of disparate databases in a concurrent manner via a plurality of translators using said search information and each of the plurality of translators using respective database syntax and protocol information specific to a corresponding disparate database, wherein each search request is recognizable by a corresponding disparate database through each corresponding translator;

accessing a central database via an authentication manager to acquire authentication information of a user;

performing one or more authorization procedures respectively in said plurality of disparate databases in a concurrent manner via the plurality of translators, wherein the authentication information is used to gain database access on the user'"'"'s behalf via the plurality of translators each configured to concurrently access a corresponding disparate database, concurrently query the search request to and concurrently retrieve search results from its corresponding one of said plurality of disparate databases respectively based on said search information, by performing a first set of sub-session managements which authenticate by user basis to licensed information resources or to databases, and performing a second set of sub-session managements which authenticate by system basis to licensed information resources or to databases, the one or more user authorization procedures being performed via the plurality of translators using a sequence of page fetches specific to the corresponding databases, cookie management specific to the corresponding databases, and session identifier management specific to the corresponding databases;

executing said plurality of search requests in their corresponding databases in a concurrent manner;

returning search results from said plurality of disparate databases after execution of said plurality of search requests; and

consolidating said search results for display to the user or the user agent.

2. The method of claim 1 further comprising:

communicating said plurality of search requests to their corresponding databases using an interface protocol.

3. The method of claim 2 wherein said interface protocol is selected from a group consisting of HTTP, telnet, Z39.50 and ODBC.

4. The method of claim 1 further comprising:

formatting said consolidated search results using a markup language.

5. The method of claim 4 wherein said markup language is selected from a group consisting of HTML, DHTML and XML.

6. The method of claim 1 further comprising:

performing one or more authorization procedures respectively in each of said plurality of disparate databases in a concurrent manner, wherein the one or more authorization procedures include one or more of userIDs/passwords and IP authentication.

7. The method of claim 1 wherein at least one or more of said plurality of databases are Web-accessible.

8. The method of claim 1 wherein at least one or more of said plurality of databases is locally accessible.

18. The method of claim 1 wherein the one or more user authorization procedures include a series of a plurality of Web page requests utilizing both session identifiers and cookies.

20. The method of claim 1, wherein the translators perform the authentication task using optimizations that ignore nonessential web page elements including graphics and frames.

21. The method of claim 1, wherein the translators perform the authentication task using network transaction optimizations including redirect truncation and persistent connections.

9. A computerized searching method for retrieving search results from a plurality of disparate databases via computer software that transparently and without any user interaction manages one or more disparate authorization steps, comprising the steps of:

receiving search information from a user;

generating a plurality of search requests respectively in said plurality of disparate databases in a concurrent manner via a plurality of translators using said search information and each of the plurality of translators using respective database syntax and protocol information specific to a corresponding disparate database, wherein each search request is tailored to be understood by a corresponding disparate database through each corresponding translator, and further wherein the search requests include authorization and contextual elements to navigate the corresponding disparate database;

accessing a central database via an authentication manager to acquire authentication information of a user;

performing one or more authorization procedures respectively in said plurality of disparate databases in a concurrent manner via the plurality of translators, wherein the authentication information is used to gain database access on the user'"'"'s behalf via the plurality of translators each configured to concurrently access a corresponding disparate database, concurrently query the search request to and concurrently retrieve search results from its corresponding one of said plurality of disparate databases respectively based on said search information, by performing a first set of sub-session managements which authenticate by user basis to licensed information resources or to databases, and performing a second set of sub-session managements which authenticate by system basis to licensed information resources or to databases, the one or more user authorization procedures each being performed via the plurality of translators using a sequence of page fetches specific to the corresponding databases, cookie management specific to the corresponding databases, and session identifier management specific to the corresponding databases;

retrieving search results from said plurality of databases in a concurrent manner pursuant to said plurality of search requests;

generating summary statistics and records from each database from the search performed of the plurality of databases, wherein the summary statistics include a listing of names of the plurality of databases and a corresponding number of search results retrieved from each of the listed databases;

consolidating said search results; and

returning said search results to a user whereby the search results are summarized and displayed to the user in summary statistics in the form of a hyperlink whereby the end user may utilize the hyperlink to display the full record of a chosen search result.

10. The method of claim 9 further comprising:

performing the one or more authorization procedures respectively in each of said plurality of disparate databases in a concurrent manner, wherein the one or more authorization procedures include one or more of userIDs/passwords and IP authentication.

11. The method of claim 9 further comprising:

communicating said plurality of search requests to their corresponding databases using an interface protocol.

12. The method of claim 11 wherein said interface protocol is selected from a group consisting of HTTP, telnet, Z39.50 and ODBC.

13. The method of claim 9 further comprising:

formatting said consolidated search results using a markup language.

14. The method of claim 13 wherein said markup language is selected from a group consisting of HTML, DHTML, and XML.

15. The method of claim 9 further comprising:

presenting the consolidated search results to the user or a user agent.

16. The method of claim 9 wherein at least one or more of said plurality of databases are Web-accessible.

17. The method of claim 16 wherein at least one or more of said plurality of databases are locally accessible.

19. The method of claim 9 wherein the one or more user authorization procedures include a series of a plurality of Web page requests utilizing both session identifiers and cookies.