Unification of search and analytics
First Claim
Patent Images
1. A system comprising:
- a computing device comprising;
a memory storing processor-executable program code; and
a processor to execute the processor-executable program code in order to cause the computing device to;
receive a request conforming to a modeled query and join filter criteria associated with join conditions, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view;
receive, via a get service, a query ID associated with the modeled query;
retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator;
transmit the modeled query based on the metadata to the user;
receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query;
define a join between the text search result item list and the table, the join associating one or more attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table;
receive search results corresponding to the text search result item list; and
filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria.
2 Assignments
0 Petitions
Accused Products
Abstract
A system includes reception of a request conforming to a modeled query and join filter criteria, the request comprising a first subrequest associated with a search attribute view and a second subrequest associated with an analytical view, definition of a join between the search attribute view and the analytical view based on one or more view attributes of the search attribute view, and filtering of a result set associated with the first subrequest based on the join and on the join filter criteria.
-
Citations
9 Claims
-
1. A system comprising:
a computing device comprising; a memory storing processor-executable program code; and a processor to execute the processor-executable program code in order to cause the computing device to; receive a request conforming to a modeled query and join filter criteria associated with join conditions, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view; receive, via a get service, a query ID associated with the modeled query; retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator; transmit the modeled query based on the metadata to the user; receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query; define a join between the text search result item list and the table, the join associating one or more attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table; receive search results corresponding to the text search result item list; and filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria. - View Dependent Claims (2, 3)
-
4. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:
-
receive a request conforming to a modeled query and join filter criteria associated with join conditions, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view; receive, via a get service, a query ID associated with the modeled query; retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator; transmit the modeled query based on the metadata to the user; receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query; define a join between the text search result item list and the table, the join associating one or more attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table; receive search results corresponding to the text search result item list; and filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria. - View Dependent Claims (5, 6)
-
-
7. A computer-implemented method comprising:
-
receive a request conforming to a modeled query, the request comprising a first subrequest associated with a text search result item list and a second subrequest associated with an analytical view and a table for data of the analytical view; receive, via a get service, a query ID associated with the modeled query; retrieve metadata associated with the query ID to be transmitted to a user, the metadata generated by a database administrator; transmit the modeled query based on the metadata to the user; receive an additional join filter from the user wherein the additional join filter comprises additional join filter criteria and is based on the received modeled query; define a join between the text search result item list and the table, the join including one or more view attributes of the text search result item list with one or more facets of the table, wherein definition of the join comprises embedding of the text search result item list into the table; receive search results corresponding to the text search result item list; and filter the search results and a result set of data of the analytical view based on the join, the join filter criteria and on the additional join filter criteria. - View Dependent Claims (8, 9)
-
Specification