CONTEXT-SENSITIVE TERM EXPANSION WITH MULTIPLE LEVELS OF EXPANSION
First Claim
1. A computer-readable storage medium containing a program for searching fields of a data repository using multiple levels of term expansion which, when executed, causes one or more computer processors to perform operations comprising:
- receiving, from a user, a relational database query containing a plurality of conditions, wherein at least one condition is a condition for searching at least one field of the data repository, wherein the at least one condition includes at least one base search term providing a keyword to search for in an unstructured text field of the data repository;
providing an interface allowing a user to specify a level of expansion associated with the base search term, the level of expansion selected from the defined plurality of levels of expansions ranging from a lowest level of expansion to a highest level of expansion;
determining one or more parameters specifying at least a credential associated with the user and a role associated with the user;
providing a plurality of sets of expanded search terms for the base search term, each set corresponding to a different level of expansion of the plurality of levels of expansions, and each set comprising all expanded search terms from any lower level of expansion;
obtaining the level of expansion associated with the base search term;
obtaining, based on the base search term, the associated level of expansion, and the one or more parameters, one or more expanded search terms, wherein obtaining the one or more expanded search terms comprises selecting a set of expanded search terms from the plurality of sets of expanded search terms; and
prior to executing the relational database query, modifying the relational database query to contain one or more additional conditions, wherein each additional condition includes one of the one or more expanded search terms.
0 Assignments
0 Petitions
Accused Products
Abstract
Articles of manufacture and systems for searching collections of data using context sensitive expanded term searching are provided. The collection of data may be a relational database, text document, or any other type of searchable collection of data. In either case, a query including a search condition based on a specified search term may be modified to include additional conditions based on a set of expanded (e.g., conceptually-related) search terms. For some embodiments, a user may be given the ability to control the level of expansion and the context in which the terms may be expanded.
-
Citations
21 Claims
-
1. A computer-readable storage medium containing a program for searching fields of a data repository using multiple levels of term expansion which, when executed, causes one or more computer processors to perform operations comprising:
-
receiving, from a user, a relational database query containing a plurality of conditions, wherein at least one condition is a condition for searching at least one field of the data repository, wherein the at least one condition includes at least one base search term providing a keyword to search for in an unstructured text field of the data repository; providing an interface allowing a user to specify a level of expansion associated with the base search term, the level of expansion selected from the defined plurality of levels of expansions ranging from a lowest level of expansion to a highest level of expansion; determining one or more parameters specifying at least a credential associated with the user and a role associated with the user; providing a plurality of sets of expanded search terms for the base search term, each set corresponding to a different level of expansion of the plurality of levels of expansions, and each set comprising all expanded search terms from any lower level of expansion; obtaining the level of expansion associated with the base search term; obtaining, based on the base search term, the associated level of expansion, and the one or more parameters, one or more expanded search terms, wherein obtaining the one or more expanded search terms comprises selecting a set of expanded search terms from the plurality of sets of expanded search terms; and prior to executing the relational database query, modifying the relational database query to contain one or more additional conditions, wherein each additional condition includes one of the one or more expanded search terms. - View Dependent Claims (2, 3, 4)
-
-
5. A computer-readable storage medium containing a program for context-sensitive searching of fields of a data repository which, when executed, causes one or more computer processors to perform operations comprising:
-
receiving, from a user, a relational database query containing at least one condition for searching at least one field of the data repository, wherein the at least one condition includes at least one base search term; determining one or more parameters specifying at least a credential associated with the user and a role associated with the user; providing a plurality of sets of expanded search terms for the base search term, each set corresponding to a different level of expansion of a defined plurality of levels of expansions ranging from a lowest level of expansion to a highest level of expansion, and each set comprising all expanded search terms from any lower level of expansion; obtaining, based on the one or more parameters associated with the base search term, one or more expanded search terms, wherein obtaining the one or more expanded search terms comprises selecting a set of expanded search terms from the plurality of sets of expanded search terms; and prior to executing the relational database query, modifying the relational database query to contain one or more conditions based on the one or more expanded search terms, wherein the one or more parameters associated with the base search term further comprise at least a name of the at least one field and different one or more expanded search terms are obtained for the at least one base search term depending on the name of the at least one field. - View Dependent Claims (6, 7, 8)
-
-
9. A computer-readable storage medium containing a program for context-sensitive searching of fields of a data repository using multiple levels of term expansion, when executed, causes one or more computer processors to perform operations comprising:
-
receiving, from a user, a relational database query containing a plurality of conditions, wherein at least one condition is a condition for searching at least one field of the data repository, wherein the at least one condition includes at least one base search term providing a keyword to search for in an unstructured text field of the data repository; providing a plurality of sets of expanded search terms for the base search term, each set corresponding to a different level of expansion of a plurality of levels of expansions ranging from a lowest level of expansion to a highest level of expansion, and each set comprising all expanded search terms from any lower level of expansion; obtaining one or more parameters associated with the base search term, wherein the one or more parameters associated with the base search term comprise a userspecified level of expansion selected from the defined plurality of levels of expansions and further include at least a credential associated with the user and a role associated with the user; obtaining, based at least in part on the user-specified level of expansion and the credential associated with the user and the role associated with the user, one or more expanded search terms, wherein obtaining the one or more expanded search terms comprises selecting a set of expanded search terms from the plurality of sets of expanded search terms; and prior to executing the relational database query, modifying the relational database query to contain one or more additional conditions based on the one or more expanded search terms. - View Dependent Claims (10, 11, 12)
-
-
13. A data processing system, comprising:
-
a collection of data; at least one expanded term repository; and an executable component configured to; obtain a relational database query containing at least one condition for searching at least one field of the data repository, wherein the at least one condition includes at least one base search term providing a keyword to search for in an unstructured text field of the data repository; determine one or more parameters specifying at least a credential associated with the user and a role associated with the user; provide a plurality of sets of expanded search terms for the base search term, each set corresponding to a different level of expansion of a plurality of levels of expansions ranging from a lowest level of expansion to a highest level of expansion, and each set comprising all expanded search terms from any lower level of expansion; identify, based on the base search term and the one or more parameters, a set of expanded terms associated with the base search term, wherein identifying the set of expanded search terms comprises selecting a set of expanded search terms from the plurality of sets of expanded search terms; generate a pointer to the identified set of expanded search terms; and prior to executing the relational database query, modify the relational database query to contain one or more conditions based on one or more expanded search terms retrieved using the pointer. - View Dependent Claims (14, 15, 16, 17, 18, 20, 21)
-
-
19. The system of claim 19, wherein the at least one parameter indicative of a context of the query comprises a name of a table containing the at least one field.
Specification