Patent ID: 9208195
Filing Date: 2015-12-08
Classification: G06F

Abstract:
1. A method for retrieving information from a relational database, the method comprising: receiving, by the processing device, a faceted query comprising a plurality of facets; receiving, by the processing device, at least one user defined facet group query; filtering out, by the processing device, to remove facets from the faceted query that are system-defined facets, the system-defined facets relating 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 group queries; generating, by the processing device, a output from the set of user defined facet group queries applied to the relational database, the output comprising a results table consisting of three columns, a first column of the three columns being a facet column including a definition of a facet in each row of the results table, a second column of the three columns being a value associated with the facet in each row, and a third column of the three columns being a link column including a link associated with the facet in each row that relates the associated facet and its value to other data in the relational database; generating, by the processing device, an SQL query for the faceted query using the set of user defined facet group queries; and retrieving, by the processing device, the information from the relational database responsive to the SQL query.