Auto-injected query filter

Patent metadata

Field	Value
Publication number	US-2018165366-A1
Application number	US-201615372853-A
Country	US
Kind code	A1
Filing date	Dec 8, 2016
Priority date	Dec 8, 2016
Publication date	Jun 14, 2018
Grant date	—

Abstract

A system includes reception, from a user, elements of a database query including a dimension and a data source, determination of metadata of the data source, the metadata describing a domain of dimension values of the dimension, determination of whether to filter the database query based on the metadata, and, if it is determined to filter the database query, automatic generation of a filtered database query to limit the domain of the dimension values of a corresponding result set to less than the domain of dimension values of the dimension.

First claim

What is claimed is:

1 . A system comprising:
a user device to:
receive, from a user, elements of a database query including a dimension and a data source;
determine metadata of the data source, the metadata describing a domain of dimension values of the dimension;
determine whether to filter the database query based on the metadata; and
if it is determined to filter the database query, automatically generate a filtered database query to limit the domain of the dimension values of a corresponding result set to less than the domain of dimension values of the dimension; and
a server device to:
receive the filtered database query;
execute the filtered database query; and
provide the result set corresponding to the filtered database query to the user device.

2 . A system according to claim 1 , wherein providing of the result set corresponding to the filtered database query to the user device comprises:
generation of a visualization of the result set; and transmission of the visualization to the user device.

3 . A system according to claim 2 , wherein the generated visualization comprises XML code and JavaScript code, and the user device further to:
generate HTML code and CSS code based on the XML code and JavaScript code; and display the visualization.

4 . A system according to claim 1 , the user device further to:
present a visualization of the result set; present, contemporaneously with presentation of the result set, an indication that the result set is limited, and present, contemporaneously with presentation of the result set, a control selectable by the user to cause submission of the database query to the server device.

5 . A system according to claim 1 , wherein the metadata describing a domain of dimension values of the dimension comprises a flag indicating that query execution over the dimension is resource-intensive, and
wherein the determination of whether to filter the database query comprises identification of the flag.

6 . A system according to claim 1 , wherein the metadata describing a domain of dimension values of the dimension comprises an indication of the cardinality of the dimension values, and
wherein the determination of whether to filter the database query comprises determination of whether the cardinality exceeds a predetermined threshold.

7 . A system comprising:
a user device comprising:
a first memory storing processor-executable process steps; and
a first processor to execute the processor-executable process steps to cause the user device to:
receive a database query specifying a remote data source;
determine metadata of the remote data source;
determine whether to apply a filter to the database query based on the metadata; and
if it is determined to apply a filter to the database query, automatically generate a filtered database query based on the database query, the filtered database query to limit a result set of the database query; and
a server device comprising:
a second memory storing processor-executable process steps; and
a second processor to execute the processor-executable process steps to cause the server device to:
receive the filtered database query;
execute the filtered database query against the remote data source; and
provide a result set corresponding to the filtered database query to the user device.

8 . A system according to claim 7 , wherein determination of whether to apply a filter to the database query comprises estimation, based on the metadata, of whether a resource-usage or processing time of execution of the database query will be greater than an acceptable amount.

9 . A system according to claim 7 , wherein determination of whether to apply a filter to the database query comprises determination, based on the metadata, of a domain of dimension values of each dimension specified in the database query.

10 . A system according to claim 7 , wherein the metadata comprises a flag indicating that query execution over a dimension of the database query is resource-intensive, and
wherein the determination of whether to apply a filter to the database query comprises identification of the flag.

11 . A system according to claim 7 , wherein the metadata comprises an indication of the cardinality of the dimension values of one or more dimensions of the database query, and
wherein the determination of whether to apply a filter to the database query comprises determination of whether the cardinality of one or more dimensions of the database query exceeds a predetermined threshold.

12 . A system according to claim 11 , wherein, automatic generation of the filtered database query comprises generating a filter over the one or more dimensions of the database query having a cardinality exceeding the predetermined threshold.

13 . A computer-implemented method comprising:
receiving a database query specifying a remote data source; determining metadata of the remote data source; determining whether to apply a filter to the database query based on the metadata; and if it is determined to apply a filter to the database query, automatically generating a filtered database query based on the database query, the filtered database query to limit a result set of the database query; and transmitting the filtered database query to a query server associated with the remote data source.

14 . A method according to claim 13 , wherein determining whether to apply a filter to the database query comprises estimating, based on the metadata, of whether a resource-usage or processing time of execution of the database query will be greater than an acceptable amount.

15 . A method according to claim 13 , wherein determining whether to apply a filter to the database query comprises determination, based on the metadata, of a domain of dimension values of each dimension specified in the database query.

16 . A method according to claim 13 , wherein the metadata comprises a flag indicating that query execution over a dimension of the database query is resource-intensive, and
wherein determining whether to apply a filter to the database query comprises identification of the flag.

17 . A method according to claim 13 , wherein the metadata comprises an indication of the cardinality of the dimension values of one or more dimensions of the database query, and
wherein determining whether to apply a filter to the database query comprises determining whether the cardinality of one or more dimensions of the database query exceeds a predetermined threshold.

18 . A method according to claim 17 , wherein automatically generating the filtered database query comprises generating a filter over the one or more dimensions of the database query having a cardinality exceeding the predetermined threshold.

Assignees

• Sap Se

Inventors

• Kumar Viren

Classifications

• G06F16/90335

  Query processing · CPC title

• G06F16/838

  Presentation of query results · CPC title

• G06F16/9535 Primary

  Search customisation based on user profiles and personalisation · CPC title

• G06F16/904

  Browsing; Visualisation therefor (for navigating the web G06F16/954; browsing optimisation for the web G06F16/957) · CPC title

• G06F16/9038

  Presentation of query results · CPC title