Keyword searches of structured databases
First Claim
1. A method supporting keyword searches of data items in a structured database, the method comprising the computer-implemented steps of:
- selecting at least one data item in the structured database, each selected item containing data and each selected item having a corresponding location identifier which identifies the item'"'"'s location within the structured database;
documenting the selected data items by creating at least one document outside the structured database which contains a textual representation of each selected item'"'"'s data; and
indexing the documents by creating an index outside the database, the index associating keywords in the textual representation of each selected item'"'"'s data with that item'"'"'s location identifier,wherein the structured database includes data items organized as records in relations according to a data dictionary, the selecting step includes the step of providing a supplemental data dictionary which identifies selected records or tables, and the indexing step only indexes records and tables that are identified by the supplemental data dictionary.
7 Assignments
0 Petitions
Accused Products
Abstract
Methods and systems are provided for supporting keyword searches of data items in a structured database, such as a relational database. Selected data items are retrieved using an SQL query or other mechanism. The retrieved data values are documented using a markup language such as HTML. The documents are indexed using a web crawler or other indexing agent. Data items may be selected for indexing by identifying them in a data dictionary. The indexing agent produces an index that associates keywords with resource locators such as URLs, hot links, file paths, or distinguished names. After a user provides a keyword to a search engine interface, the index is used to obtain a resource locator that is associated with the keyword. The resource locator is used to retrieve the item'"'"'s current data from the structured database. A document containing the retrieved data is then generated and provided to the user.
867 Citations
45 Claims
-
1. A method supporting keyword searches of data items in a structured database, the method comprising the computer-implemented steps of:
-
selecting at least one data item in the structured database, each selected item containing data and each selected item having a corresponding location identifier which identifies the item'"'"'s location within the structured database; documenting the selected data items by creating at least one document outside the structured database which contains a textual representation of each selected item'"'"'s data; and indexing the documents by creating an index outside the database, the index associating keywords in the textual representation of each selected item'"'"'s data with that item'"'"'s location identifier, wherein the structured database includes data items organized as records in relations according to a data dictionary, the selecting step includes the step of providing a supplemental data dictionary which identifies selected records or tables, and the indexing step only indexes records and tables that are identified by the supplemental data dictionary. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method supporting keyword searches of data items in a structured database, the method comprising the computer-implemented steps of:
-
selecting at least one data item in the structured database, each selected item containing data and each selected item having a corresponding location identifier which identifies the item'"'"'s location within the structured database; documenting the selected data items by creating at least one document outside the structured database which contains a textual representation of each selected item'"'"'s data; and indexing the documents by creating an index outside the database, the index associating keywords in the textual representation of each selected item'"'"'s data with that item'"'"'s location identifier, wherein the indexing step includes providing to a keyword search engine indexing agent both the textual representation of each selected item'"'"'s data and the selected item'"'"'s location identifier, the indexing agent produces an index that associates keywords with resource locators, each resource locator includes a textual representation of a data item location identifier, and the resource locator includes a distinguished name.
-
-
10. A method supporting keyword searches of data items in a structured database, the method comprising the computer-implemented steps of:
-
selecting at least one data item in the structured database, each selected item containing data and each selected item having a corresponding location identifier which identifies the item'"'"'s location within the structured database; documenting the selected data items by creating at least one document outside the structured database which contains a textual representation of each selected item'"'"'s data; and indexing the documents by creating an index outside the database, the index associating keywords in the textual representation of each selected item'"'"'s data with that item'"'"'s location identifier, wherein the creating step creates an index containing keywords that are textual representations of data in the selected data items and also containing every keyword that is a textual representation of data in the selected data items.
-
-
11. A method supporting keyword searches of data items in a structured database, the method comprising the computer-implemented steps of:
-
selecting at least one data item in the structured database, each selected item containing data and each selected item having a corresponding location identifier which identifies the item'"'"'s location within the structured database; documenting the selected data items by creating at least one document outside the structured database which contains a textual representation of each selected item'"'"'s data; indexing the documents by creating an index outside the database, the index associating keywords in the textual representation of each selected item'"'"'s data with that item'"'"'s location identifier; and logging changes that are made to data items after the creating step and then updating the index to reflect at least some of the changes.
-
-
12. A method supporting keyword searches of data items in a structured database, the method comprising the computer-implemented steps of:
-
selecting at least one data item in the structured database, each selected item containing data and each selected item having a corresponding location identifier which identifies the item'"'"'s location in the structured database; allowing a network-roaming indexing agent to create an index which associates keywords with resource locators, each keyword being a textual representation of data from a selected data item and each resource locator containing a textual representation of the corresponding selected item'"'"'s location identifier; obtaining a keyword from a search engine interface; using the index to obtain a resource locator associated with the keyword; and
thenusing the resource locator to retrieve the item'"'"'s current data from the structured database. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28)
-
-
29. A computer system comprising:
-
selecting means for selecting data items in a structured database; retrieving means for retrieving from the database the current data of a selected data item; and exposing means for exposing to an indexing agent information about a data item'"'"'s location in the database together with information about the data item'"'"'s retrieved data, wherein the structured database includes a relational database, the data items include relational database records or tables, and the selecting means includes a selection data dictionary which specifies only selected relational database records or tables. - View Dependent Claims (30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43)
-
-
44. A computer system comprising:
-
selecting means for selecting data items in a structured database; retrieving means for retrieving from the database the current data of a selected data item; and exposing means for exposing to an indexing anent information about a data item'"'"'s location in the database together with information about the data item'"'"'s retrieved data, wherein the exposing means includes a page generator capable of generating a textual document containing the retrieved data. - View Dependent Claims (45)
-
Specification