PUSH-DOWN OF AUTHORITY CHECK WITHIN QUERY ENGINE
A query engine for integrating authorization conditions within a database query statement. The query engine may include an authorization handler configured to receive authorization parameters related to one or more authorization objects for data relevant to a query for performing an authority check, and obtain at least one user authorization profile for a current user based on the authorization parameters. The at least one user authorization profile may include an activity value and one or more authorization conditions associated with the activity value. The query engine may further include a query generator configured to receive query parameters related to the query and integrate the query parameters with the one or more authorization conditions to obtain a database query statement, and a database selector configured to obtain authorized data from an in-memory database based on the database query statement.
1 . A query engine for integrating authorization conditions within a database query statement, the query engine comprising:
at least one processor;
a non-transitory computer-readable storage medium including instructions executable by the at least one processor, the instructions configured to implement,
an authorization handler configured to receive authorization parameters related to one or more authorization objects for data relevant to a query for performing an authority check;
the authorization handler configured to obtain at least one user authorization profile for a current user based on the authorization parameters, the at least one user authorization profile including an activity value and one or more authorization conditions associated with the activity value;
a query generator configured to receive query parameters related to the query and integrate the query parameters with the one or more authorization conditions to obtain a database query statement; and
a database selector configured to obtain authorized data from an in-memory database based on the database query statement, the authorized data including a subset of data that is authorized for display.
2 . The query engine of claim 1 , wherein the authorization handler configured to receive authorization parameters related to one or more authorization objects for data relevant to a query for performing an authority check includes receiving the authorization parameters from an application via an application programming interface (API).
3 . The query engine of claim 1 , wherein the authorization parameters includes an identifier identifying an authorization object, a list of one or more activities each having at least one authorization object field and associated value, and mapping information mapping the at least one authorization object field to one or more data fields of the in-memory database.
4 . The query engine of claim 3 , wherein the authorization handler configured to obtain at least one user authorization profile for a current user based on the authorization parameters includes obtaining the at least one user authorization profile having the activity value that matches the associated value of the authorization object field.
5 . The query engine of claim 3 , wherein the query generator configured to receive query parameters related to the query and integrate the query parameters with the one or more authorization conditions to obtain a database query statement includes integrating the query parameters with the one or more data fields such that the database query statement corresponds to a format of the in-memory database.
6 . The query engine of claim 5 , wherein the one or more data fields relate to a column or row in the in-memory database, and the one or more authorization conditions relate a range within the column or row.
7 . The query engine of claim 1 , wherein the query generator configured to receive query parameters related to the query and integrate the query parameters with the one or more authorization conditions to obtain a database query statement includes transforming a format of the one or more authorization conditions into one or more conditions according to a set of conversion rules.
8 . The query engine of claim 1 , wherein the one or more authorization conditions includes a range of values associated with the activity value, and the query generator is configured to specify the range of values in the database query statement, and the database selector is configured to obtain data corresponding to the range of values from the in-memory database as the authorized data.
9 . The query engine of claim 1 , wherein the query parameters relates to at least one of paging, sorting, filtering, and aggregation and grouping.
10 . A computer program product tangibly embodied on a non-transitory computer-readable storage medium and including executable code that, when executed, is configured to cause a query engine to integrate authorization conditions within a database query statement, the executable code comprising instructions to:
receive authorization parameters related to one or more authorization objects for data relevant to a query for performing an authority check;
obtain at least one user authorization profile for a current user based on the authorization parameters, the at least one user authorization profile including an activity value and one or more authorization conditions associated with the activity value;
receive query parameters related to the query and integrate the query parameters with the one or more authorization conditions to obtain a database query statement; and
obtain authorized data from an in-memory database based on the database query statement, the authorized data including a subset of data that is authorized for display.
11 . The computer program product of claim 10 , wherein the instructions to receive authorization parameters related to one or more authorization objects for data relevant to a query for performing an authority check includes receiving the authorization parameters from an application via an application programming interface (API).
12 . The computer program product of claim 10 , wherein the authorization parameters includes an identifier identifying an authorization object, a list of one or more activities each having at least one authorization object field and associated value, and mapping information mapping the at least one authorization object field to one or more data fields of the in-memory database.
13 . The computer program product of claim 12 , wherein the instructions to obtain at least one user authorization profile for a current user based on the authorization parameters includes obtaining the at least one user authorization profile having the activity value that matches the associated value of the authorization object field.
14 . The computer program product of claim 10 , wherein the instructions to receive query parameters related to the query and integrate the query parameters with the one or more authorization conditions to obtain a database query statement includes integrating the query parameters with the one or more data fields such that the database query statement corresponds to a format of the in-memory database.
15 . The computer program product of claim 14 , wherein the one or more data fields relate to a column or row in the in-memory database, and the one or more authorization conditions relate a range within the column or row.
16 . The computer program product of claim 10 , wherein the instructions to receive query parameters related to the query and integrate the query parameters with the one or more authorization conditions to obtain a database query statement includes transforming a format of the one or more authorization conditions into one or more conditions according to a set of conversion rules.
17 . The computer program product of claim 10 , wherein the one or more authorization conditions includes a range of values associated with the activity value, and the instructions include specifying the range of values in the database query statement, and obtaining data corresponding to the range of values from the in-memory database as the authorized data.
18 . A method for integrating authorization conditions within a database query statement, the method comprising:
receiving, by at least one processor, authorization parameters related to one or more authorization objects for data relevant to a query for performing an authority check;
obtaining, by at least one processor, at least one user authorization profile for a current user based on the authorization parameters, the at least one user authorization profile including an activity value and one or more authorization conditions associated with the activity value;
receiving, by at least one processor, query parameters related to the query and integrating, by at least one processor, the query parameters with the one or more authorization conditions to obtain a database query statement; and
obtaining, by at least one processor, authorized data from an in-memory database based on the database query statement, the authorized data including a subset of data that is authorized for display.
19 . The method of claim 18 , wherein the authorization parameters includes an identifier identifying an authorization object, a list of one or more activities each having at least one authorization object field and associated value, and mapping information mapping the at least one authorization object field to one or more data fields of the in-memory database.
20 . The method of claim 19 , wherein the obtaining at least one user authorization profile for a current user based on the authorization parameters includes obtaining the at least one user authorization profile having the activity value that matches the associated value of the authorization object field.