Method and system for universal querying of distributed databases
First Claim
Patent Images
1. A method of obtaining information from a plurality of distributed databases, comprising the steps of:
- receiving a first query from a first user;
processing the first query to identify a plurality of key terms in the first query, the plurality of key terms comprising at least one of a first noun and a first noun phrase;
displaying to the first user an expanded query including at least a plurality of returned key terms;
receiving from the first user a plurality of select key terms, the plurality of select key terms being selected from the plurality of returned key terms by the first user;
processing the select key terms to retrieve a plurality of attributes and a plurality of table names, wherein the plurality of attributes corresponds to the plurality of table names, wherein the plurality of table names correspond to a plurality of tables in the plurality of distributed databases;
displaying to the first user the plurality of table names and the plurality of attributes;
receiving from the first user a final query, the final query including a plurality of select tables, the plurality of select tables being selected from the plurality of table names by the first user;
processing the final query to generate a first SQL query corresponding to the final query; and
returning to the first user a first data result set based on the first SQL query.
2 Assignments
0 Petitions
Accused Products
Abstract
A method and system for accessing information or data from distributed databases is disclosed. Generally, the method includes the steps of receiving an unstructured query from a user, generalizing the query to expand the query, receiving from the user selected terms of the expanded query, searching a directory for database tables and/or attributes matching the selected terms, and generating a pictorial query using database tables suggested as relevant by the search. Thereafter, an SQL query may be generated to retrieve the relevant data from the actual distributed databases.
239 Citations
13 Claims
-
1. A method of obtaining information from a plurality of distributed databases, comprising the steps of:
-
receiving a first query from a first user;
processing the first query to identify a plurality of key terms in the first query, the plurality of key terms comprising at least one of a first noun and a first noun phrase;
displaying to the first user an expanded query including at least a plurality of returned key terms;
receiving from the first user a plurality of select key terms, the plurality of select key terms being selected from the plurality of returned key terms by the first user;
processing the select key terms to retrieve a plurality of attributes and a plurality of table names, wherein the plurality of attributes corresponds to the plurality of table names, wherein the plurality of table names correspond to a plurality of tables in the plurality of distributed databases;
displaying to the first user the plurality of table names and the plurality of attributes;
receiving from the first user a final query, the final query including a plurality of select tables, the plurality of select tables being selected from the plurality of table names by the first user;
processing the final query to generate a first SQL query corresponding to the final query; and
returning to the first user a first data result set based on the first SQL query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
ranking at least each of the plurality of select key terms to produce a rank of terms; and
,storing the rank of terms for the first user.
-
-
7. A method as claimed in claim 1, wherein the step of processing the first query comprises the stop of stemming a first of the plurality of key terms.
-
8. A method as claimed in claim 7, wherein the step of processing the first query filter comprises the step of identifying at least a first synonym of a first of the plurality of key terms.
-
9. A method as claimed in claim 7 further comprising the steps of;
-
ranking at least each of the plurality of selected key terms to produce a rank of terms; and
storing the rank of terms for the first user.
-
-
10. A method as claimed in claim 1, wherein the step of processing the first query further comprises the steps of:
-
identifying at least one of a verb and a first data item within the first query; and
identifying at least a first synonym for a first of the plurality of key terms.
-
-
11. A method as claimed in claim 10, wherein the step of processing the first query further comprises the step of stemming a first of the plurality of key terms.
-
12. A method as claimed in claim 10, further comprising the step(s) of;
-
ranking at least each of the plurality of selected key terms to produce a rank of terms; and
storing the rank of terms for the first user.
-
-
13. A method as claimed in claim 1, wherein said step of processing the selected key terms comprises the step of using the selected key terms to search the plurality of distributed databases.
Specification