Query translation for searching complex structures of objects
First Claim
Patent Images
1. A method of searching stored content comprising:
- receiving a search request;
determining whether a full text search is better performed prior to a search of one or more stored relational database tables;
in the event that the full text search is better performed prior to a search of one or more stored relational database tables;
translating the search request to a full text query;
executing the full text query;
translating the search request to a relational database query;
executing the relational database query, wherein the relational database query is executed after executing the full text query; and
in the event that the full text search is not better performed prior to the search of one or more store relational database tables;
translating the search request to the relational database query;
executing the relational database query;
translating the search request to the full text query;
executing the full text query, wherein the full text query is executed after executing the relational database query;
wherein automatically determining whether a parallel query comprising another full text query and another relational database query prior to or after the full text query and the relational database query is employed to respond to the search request, and wherein in the event that the parallel query is employed, executing the parallel query.
9 Assignments
0 Petitions
Accused Products
Abstract
Searching stored content is disclosed. A first mapping is created from an object to one or more stored relational database tables. A second mapping is created from the object to an indexer schema. One or both of the following is done: 1) using the first mapping to translate a search request expressed in an abstract query language to a first query language associated with the relational database; and 2) using the second mapping to translate the search request to a second query language associated with the indexer schema.
-
Citations
23 Claims
-
1. A method of searching stored content comprising:
-
receiving a search request; determining whether a full text search is better performed prior to a search of one or more stored relational database tables; in the event that the full text search is better performed prior to a search of one or more stored relational database tables; translating the search request to a full text query; executing the full text query; translating the search request to a relational database query; executing the relational database query, wherein the relational database query is executed after executing the full text query; and in the event that the full text search is not better performed prior to the search of one or more store relational database tables; translating the search request to the relational database query; executing the relational database query; translating the search request to the full text query; executing the full text query, wherein the full text query is executed after executing the relational database query; wherein automatically determining whether a parallel query comprising another full text query and another relational database query prior to or after the full text query and the relational database query is employed to respond to the search request, and wherein in the event that the parallel query is employed, executing the parallel query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A computer program product for searching stored content, the computer program product being embodied in a computer readable storage medium and comprising computer instructions for:
-
receiving a search request; determining whether a full text search is better performed prior to a search of one or more stored relational database tables; in the event that the full text search is better performed prior to a search of one or more stored relational database tables; translating the search request to a full text query; executing the full text query; translating the search request to a relational database query; executing the relational database query; and in the event that the full text search is not better performed prior to the search of one or more store relational database tables; translating the search request to the relational database query; executing the relational database query; translating the search request to the full text query; executing the full text query; wherein automatically determining whether a parallel query comprising another full text query and another relational database query prior to or after the full text query and the relational database query is employed to respond to the search request, and wherein in the event that the parallel query is employed, executing the parallel query.
-
-
14. A system of searching stored content comprising:
-
a processor; and a memory coupled with the processor, wherein the memory is configured to provide the processor with instructions which when executed cause the processor to; receive a search request; determine whether a full text search is better performed prior to a search of one or more stored relational database tables; in the event that the full text search is better performed prior to a search of one or more stored relational database tables; translate the search request to a full text query; execute the full text query; translate the search request to a relational database query; execute the relational database query; and in the event that the full text search is not better performed prior to the search of one or more store relational database tables; translate the search request to the relational database query; execute the relational database query; translate the search request to the full text query; execute the full text query; automatically determine whether a parallel query comprising another full text query and another relational database query prior to or after the full text query and the relational database query is employed to respond to the search request, and wherein in the event that the parallel query is employed, execute the parallel query. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23)
-
Specification