Configurable rule for monitoring data of in memory database
View Patent ↗Embodiments relate to the implementation of configurable rules that automatically monitor large volumes of data stored in a database. Certain embodiments may leverage the high processing power available to the database engine of an in memory database, in order to perform analysis of large data volumes for compliance and other purposes. Particular embodiments may utilize ABAP Database Connectivity (ADBC) to a HANA in memory database available from SAP AG, in order to implement and execute configurable rules in connection with governance, risk, and compliance (GRC) of large volumes of data stored therein. In various embodiments, an analysis engine in the application layer may rely upon the in memory database engine to execute at least some logic of the configurable rules.
1. A computer-implemented method comprising:
providing in an application layer, an analysis engine in communication with a ruleset including a rule for identifying an issue with a data record stored in a table of an underlying database layer containing an in memory database;
causing the analysis engine to communicate with an in memory database engine of the underlying database layer, to access information of the in memory database, the information comprising a column store calculation view including the data record, wherein the analysis engine communicates with the in memory database engine through open SQL and through SQL extension code to create and alter the column store calculation view; and
causing the analysis engine to apply the rule to the information in order to identify whether the issue is present, wherein a computational power of the in memory database engine is leveraged to execute at least some logic of the rule to the information, and the computational power of the in memory database engine is further leveraged to execute a join operation to create the column store calculation view.
2. A method as in claim 1 wherein the issue relates to Governance, Risk, or Compliance (GRC).
3. A method as in claim 1 wherein the issue relates to privacy or security.
4. A method as in claim 1 wherein the analysis engine and the ruleset comprise an existing Process Control (PC) application in the application layer.
5. A method as in claim 1 further comprising causing a user to access the application layer in order to create the rule.
6. A method as in claim 1 further comprising performing a remediation procedure to correct the issue.
7. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:
providing in an application layer, an analysis engine in communication with a ruleset including a rule for identifying an issue with a data record stored in a table of an underlying database layer containing an in memory database;
causing the analysis engine to communicate with an in memory database engine of the underlying database layer, to access information of the in memory database, the information comprising a column store calculation view including the data record, wherein the analysis engine communicates with the in memory database engine through open SQL and through SQL extension code to create and alter the column store calculation view; and
causing the analysis engine to apply the rule to the information in order to identify whether the issue is present, wherein a computational power of the in memory database engine is leveraged to execute at least some logic of the rule to the information, and the computational power of the in memory database engine is further leveraged to execute a join operation to create the column store calculation view.
8. A non-transitory computer readable storage medium as in claim 7 wherein the issue relates to Governance, Risk, or Compliance (GRC).
9. A non-transitory computer readable storage medium as in claim 7 wherein the issue relates to privacy or security.
10. A non-transitory computer readable storage medium as in claim 7 wherein the analysis engine and the ruleset comprise an existing Process Control (PC) application.
11. A non-transitory computer readable storage medium as in claim 7 wherein the method further comprises causing a user to access the application layer in order to create the rule.
12. A non-transitory computer readable storage medium as in claim 7 wherein the method further comprises performing a remediation procedure to correct the issue.
13. A computer system comprising:
one or more processors;
a software program, executable on said computer system, the software program configured to:
provide in an application layer, an analysis engine in communication with a ruleset including a rule for identifying an issue with a data record stored in a table of an underlying database layer containing an in memory database;
cause the analysis engine to communicate with an in memory database engine of the underlying database layer, to access information of the in memory database, the information comprising a column store calculation view including the data record, wherein the analysis engine communicates with the in memory database engine through open SQL and through SQL extension code to create and alter the column store calculation view; and
cause the analysis engine to apply the rule to the information in order to identify whether the issue is present, wherein a computational power of the in memory database engine is leveraged to execute at least some logic of the rule to the information, and the computational power of the in memory database engine is further leveraged to execute a join operation to create the column store calculation view.
14. A computer system as in claim 13 wherein the issue relates to Governance, Risk, or Compliance (GRC).
15. A computer system as in claim 13 wherein the issue relates to privacy or security.
16. A computer system as in claim 13 wherein the analysis engine and the ruleset comprise an existing Process Control (PC) application in the application layer.
17. A computer system as in claim 13 wherein the software program is further configured to cause a user to access the application layer in order to create the rule.