Relational database extender that supports user-defined index types and user-defined search
First Claim
1. A system for managing data, comprising:
- a database management system, executed by a computer, for managing a database storing at least one table and an associated index that is related to search results returned by an external search engine that supports content-specific search operations against an external database, wherein the database management system interfaces to the external search engine, the database management system retrieves one or more object identifiers from the external search engine, the database management system uses the retrieved object identifiers to retrieve one or more row identifiers from the index stored in the database managed by the database management system, and the database management system uses the retrieved row identifiers to retrieve one or more rows from the table stored in the database managed by the database management system.
1 Assignment
0 Petitions
Accused Products
Abstract
A new approach to indexing semi-structured, non-traditional data uses an external search engine accessible to a database engine through a standardized interface. An external index managed by an external search engine maps object identifiers associated with the non-traditional data to row identifiers for a table stored in the relational database. In response to a query, one or more of the object identifiers are retrieved from the external index by the external search engine. The object identifiers returned by the external search engine are then used by the database engine to retrieve one or more row identifiers from an index in the relational database. The row identifiers are then used to retrieve one or more rows from the table in the relational database.
-
Citations
24 Claims
-
1. A system for managing data, comprising:
a database management system, executed by a computer, for managing a database storing at least one table and an associated index that is related to search results returned by an external search engine that supports content-specific search operations against an external database, wherein the database management system interfaces to the external search engine, the database management system retrieves one or more object identifiers from the external search engine, the database management system uses the retrieved object identifiers to retrieve one or more row identifiers from the index stored in the database managed by the database management system, and the database management system uses the retrieved row identifiers to retrieve one or more rows from the table stored in the database managed by the database management system. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
9. A method of managing data in a computer-implemented database management system, comprising:
-
retrieving one or more object identifiers from an external index managed by an external search engine that supports content-specific search operations against an external database, using the retrieved object identifiers to retrieve one or more tow identifiers from an index stored in a database managed by a database management system that is related to search results returned by the external search engine, and using the retrieved tow identifiers to retrieve one or more tows from a table stored in the database managed by the database management system. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. An article of manufacture embodying logic for a method of managing data in a computer-implemented database management system, the method comprising:
-
retrieving one or mote object identifiers from an external index managed by an external search engine that supports content-specific search operations against an external database, using the retrieved object identifiers to retrieve one or more row identifiers from an index stored in a database managed by a database management system that is related to search results returned by the external search engine, and using the retrieved row identifiers to retrieve one or more rows from a table stored in the database managed by the database management system. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24)
-
Specification