Query translation for searching complex structures of objects
First Claim
Patent Images
1. A system for searching stored content comprising:
- a processor, wherein the processor is configured to;
receive a search request from a user;
select, transparent to the user, whether a full text search is performed prior to a search of one or more stored relational database tables, after a search of one or more stored relational database tables, or in parallel with a search of one or more stored relational database tables, wherein the full text search and the search of the one or more stored relational database tables are both associated with a search request, wherein the select operation includes;
determine whether the search request includes an object identifier;
in the event that the search request includes the object identifier, determine whether the search request includes a term associated with the object identifier; and
in the event that the search request includes the object identifier and the term associated with the object identifier, select that the full text search is performed after the search of one or more stored relational database tables;
in the event that the full text search is selected to be performed prior to a search of one or more stored relational database tables, execute the full text search prior to executing the search of one or more stored relational database tables;
in the event that the full text search is selected to be performed after the search of one or more stored relational database tables, execute the full text search after executing the search of one or more stored relational database tables, wherein the executing of the full text search is performed only on the results on the executing of the search of the one or more stored relational database tables;
andin the event that the full text search is selected to be performed in parallel with the search of one or more stored relational database tables, execute the full text search in parallel with executing the search of one or more stored relational database tables; and
a memory coupled to the processor and configured to provide the processor with instructions.
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.
3 Citations
19 Claims
-
1. A system for searching stored content comprising:
a processor, wherein the processor is configured to; receive a search request from a user; select, transparent to the user, whether a full text search is performed prior to a search of one or more stored relational database tables, after a search of one or more stored relational database tables, or in parallel with a search of one or more stored relational database tables, wherein the full text search and the search of the one or more stored relational database tables are both associated with a search request, wherein the select operation includes; determine whether the search request includes an object identifier; in the event that the search request includes the object identifier, determine whether the search request includes a term associated with the object identifier; and in the event that the search request includes the object identifier and the term associated with the object identifier, select that the full text search is performed after the search of one or more stored relational database tables; in the event that the full text search is selected to be performed prior to a search of one or more stored relational database tables, execute the full text search prior to executing the search of one or more stored relational database tables; in the event that the full text search is selected to be performed after the search of one or more stored relational database tables, execute the full text search after executing the search of one or more stored relational database tables, wherein the executing of the full text search is performed only on the results on the executing of the search of the one or more stored relational database tables; and in the event that the full text search is selected to be performed in parallel with the search of one or more stored relational database tables, execute the full text search in parallel with executing the search of one or more stored relational database tables; and a memory coupled to the processor and configured to provide the processor with instructions. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
11. A method for searching stored content comprising:
-
receiving a search request from a user; selecting, transparent to the user, whether a full text search is performed prior to a search of one or more stored relational database tables, after a search of one or more stored relational database tables, or in parallel with a search of one or more stored relational database tables, wherein the full text search and the search of the one or more stored relational database tables are both associated with a search request, wherein the selecting operation includes; determining whether the search request includes an object identifier; in the event that the search request includes the object identifier, determining whether the search request includes a term associated with the object identifier; and in the event that the search request includes the object identifier and the term associated with the object identifier, selecting that the full text search is performed after the search of one or more stored relational database tables; in the event that the full text search is selected to be performed prior to a search of one or more stored relational database tables; executing the full text search prior to executing the search of one or more stored relational database tables; and in the event that the full text search is selected to be performed after the search of one or more stored relational database tables; executing the full text search after executing the search of one or more stored relational database tables, wherein the executing of the full text search is performed only on the results on the executing of the search of the one or more stored relational database tables; and in the event that the full text search is selected to be performed in parallel with the search of one or more stored relational database tables; executing the full text search in parallel with executing the search of one or more stored relational database tables. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18)
-
-
19. A computer program product for searching stored content, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
-
receiving a search request from a user; selecting, transparent to the user, whether a full text search is performed prior to a search of one or more stored relational database tables, after a search of one or more stored relational database tables, or in parallel with a search of one or more stored relational database tables, wherein the full text search and the search of the one or more stored relational database tables are both associated with a search request, wherein the selecting operation includes; determining whether the search request includes an object identifier; in the event that the search request includes the object identifier, determining whether the search request includes a term associated with the object identifier; and in the event that the search request includes the object identifier and the term associated with the object identifier, selecting that the full text search is performed after the search of one or more stored relational database tables; in the event that the full text search is selected to be performed prior to a search of one or more stored relational database tables; executing the full text search prior to executing the search of one or more stored relational database tables; and in the event that the full text search is selected to be performed after the search of one or more stored relational database tables; executing the full text search after executing the search of one or more stored relational database tables, wherein the executing of the full text search is performed only on the results on the executing of the search of the one or more stored relational database tables; and in the event that the full text search is selected to be performed in parallel with the search of one or more stored relational database tables; executing the full text search in parallel with executing the search of one or more stored relational database tables.
-
Specification