RETRIEVING INFORMATION FROM A RELATIONAL DATABASE USING USER DEFINED FACETS IN A FACETED QUERY
First Claim
1. A method for retrieving information from a relational database using user defined facets in a faceted query, the method comprising:
- receiving, by a processing device, a faceted query;
receiving, by the processing device, at least one user defined facet group query;
filtering out, by the processing device, facets in the faceted query that relate to metadata in the relational database;
associating, by the processing device, each remaining facet in the faceted query with a corresponding user defined facet group query of the at least one user defined facet group query to provide a set of user defined facet groups;
generating, by the processing device, an SQL query for the faceted query using the set of user defined facet groups; and
retrieving, by the processing device, the information from the relational database responsive to the SQL query.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, system and computer program product for retrieving information from a relational database using user defined facets in a faceted query may include receiving a faceted query and receiving at least one user defined facet group query. The method may also include filtering out facets in the faceted query that relate to metadata in the relational database. The method may additionally include associating each remaining facet in the faceted query with a corresponding user defined facet group query of the at least one user defined facet group query to provide a set of user defined facet groups. An SQL query may be generated for the faceted query using the set of user defined facet groups Information from the relational database may be retrieved responsive to the SQL query.
-
Citations
20 Claims
-
1. A method for retrieving information from a relational database using user defined facets in a faceted query, the method comprising:
-
receiving, by a processing device, a faceted query; receiving, by the processing device, at least one user defined facet group query; filtering out, by the processing device, facets in the faceted query that relate to metadata in the relational database; associating, by the processing device, each remaining facet in the faceted query with a corresponding user defined facet group query of the at least one user defined facet group query to provide a set of user defined facet groups; generating, by the processing device, an SQL query for the faceted query using the set of user defined facet groups; and retrieving, by the processing device, the information from the relational database responsive to the SQL query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A system for retrieving information from a relational database using user defined facets in a faceted query, the system comprising:
-
a processing device; a faceted query engine operable on the processing device, wherein the faceted query engine comprises; a module for receiving a faceted query; a module for receiving at least one user defined facet group query; a module for filtering out facets in the faceted query that relate to metadata in the relational database; a module for associating each remaining facet in the faceted query with a corresponding user defined facet group query of the at least one user defined facet group query to provide a set of user defined facet groups; a module for generating an SQL query for the faceted query using the set of user defined facet groups; and a module for retrieving the information from the relational database responsive to the SQL query. - View Dependent Claims (14, 15, 16, 17)
-
-
18. A computer program product to retrieve information from a relational database using user defined facets in a faceted query, the computer program product comprising:
-
a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising; computer readable program code configured to receive a faceted query; computer readable program code configured to receive at least one user defined facet group query; computer readable program code configured to filter out facets in the faceted query that relate to metadata in the relational database; computer readable program code configured to associate each remaining facet in the faceted query with a corresponding user defined facet group query of the at least one user defined facet group query to provide a set of user defined facet groups; computer readable program code configured to generate an SQL query for the faceted query using the set of user defined facet groups; and computer readable program code configured to retrieve the information from the relational database responsive to the SQL query. - View Dependent Claims (19, 20)
-
Specification