In-memory based database view for a business rule management application

• US 10,043,140 B2
• Filed: 04/14/2014
• Issued: 08/07/2018
• Est. Priority Date: 04/14/2014
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Aakolk, Michael, Waldi, Andrea, Ziegler, Carsten, Wuest, Marco, Paul, Joydeep
• Primary Examiner(s): Phillips, III, Albert M
• Application Number:
  US14/251,903
• Publication Number:
  US 20150293969A1
• Time in Patent Office: 1,576 Days
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

In one aspect, a computer-implemented method comprises obtaining, in a business rule management application, a selection of one or more in-memory database objects, obtaining, in the business rule management application, a definition of one or more business rules, generating a business rule management application object, wherein the business rule management application object includes a representation of the one or more business rules and a representation of one or more results of the application of the one or more business rules on the one or more in-memory database objects, the method further comprising providing the business rule management application object for storage in the in-memory database.

Claims

1. A computer-implemented method executed by one or more processors, the method comprising:

obtaining, in a business rule management application, a user selection of one or more in-memory database objects;

obtaining, in the business rule management application, a definition of one or more business rules;

generating a business rule management application object, wherein the business rule management application object includes;

a representation of the user selected one or more in-memory database objects, including a table type object including a representation of the one or more business rules, and

a representation of one or more results of an application of the one or more business rules on the one or more in-memory database objects, wherein the one or more results are generated, at run-time and within an in-memory database associated with the one or more in-memory database objects, by applying the one or more business rules on the one or more in-memory database objects;

providing the business rule management application object for storage in the in-memory database associated with the one or more in-memory database objects;

obtaining data during a call of an in-memory procedure generated based on the business rule management application object;

typing the obtained data with a table type defined in the table type object;

executing the one or more business rules on the obtained data to obtain the one or more results of the application of the one or more business rules;

adding one or more new database columns including the one or more results in the in-memory database; and

providing the typed obtained data and the one or more new database columns including the one or more results to the business rule management application.

2. The computer implemented method of claim 1, wherein providing the business rule management application object for storage in the in-memory data base includes generating, based on the business rule management application object, an in-memory database application object including a representation of the one or more business rules.

3. The computer implemented method of claim 2, wherein the in-memory database application object includes an Extensible Markup Language (XML) object.

4. The computer implemented method of claim 3, further comprising storing the in-memory database application object in the in-memory database.

5. The computer-implemented method of claim 4, further comprising generating an in-memory runtime object based on the in-memory database application object.

6. The computer-implemented method of claim 5, wherein the in-memory runtime object includes an SQL procedure.

7. The computer implemented method of claim 5 or 6, wherein the in-memory runtime object includes one or more in-memory database objects including the one or more results of the application of the one or more business rules on the one or more in-memory database objects.

8. The computer implemented method of claim 7, wherein the one or more in-memory database objects include one or more new columns, the one or more new columns including the one or more results of the application of the one or more business rules on the one or more in-memory database objects.

9. The computer implemented method of claim 1, further comprising:

generating a runtime object of the business rule management application based on the business rule management application object; and

storing the runtime object of the business rule management application in the business rule management application.

10. The computer-implemented method of claim 9, further comprising:

calling the runtime object of the business rule management application from the business rule management application;

executing, within the in-memory database, the in-memory runtime object to produce one or more results of the application of the one or more business rules on the one or more in-memory database objects, and

providing, from the in-memory database, the one or more results to the business rule management application.

11. The computer-implemented method of claim 10, wherein calling the runtime object includes generating a representation of the business rule management application object on a graphical user interface of the business rule management application.

12. The computer-implemented method of claim 11, wherein the representation displays information characterizing a set of input parameters corresponding to input parameters of an in-memory runtime object generated based on the business rule management application object.

13. The computer-implemented method of claim 11, wherein the representation displays information characterizing the one or more in-memory database objects.

14. The computer-implemented method of claim 11, wherein the representation displays information characterizing the one or more results.

15. The computer-implemented method of claim 11, calling the runtime object of the business rule management application includes executing an SQL command.

16. The computer-implemented method of claim 1, wherein the one or more business rules define a Boolean expression, a case expression, a decision table, a decision, a search tree, a loop expression, a database table operation, a value range check.

17. The computer implemented method of claim 1, wherein the one or more in-memory database objects include a table object, a table type object, an attribute view object, wherein an attribute view references one or more data items in other tables of the in-memory database, an analytical view object, wherein an analytic view defines on or more functions operable on data items in the in-memory data base, or an calculation view object, wherein a calculation view is operable to provide composites of other views.

18. A computer readable medium storing instructions thereon which when executed by a processor cause the processor to:

obtain, in a business rule management application, a user selection of one or more in-memory database objects;

obtain, in the business rule management application, a definition of one or more business rules;

generate a business rule management application object,

wherein the business rule management application object includes;

a representation of the user selected one or more in-memory database objects, including a table type object including a representation of the one or more business rules, and

a database object including one or more results of an application of the one or more business rules on the one or more in-memory database objects, wherein the one or more results are generated, at run-time and within an in-memory database associated with the one or more in-memory database objects, by applying the one or more business rules on the one or more in-memory database objects;

provide the business rule management application object for storage in the in-memory database associated with the one or more in-memory database objects;

obtain data during a call of an in-memory procedure generated based on the business rule management application object;

type the obtained data with a table type defined in the table type object;

execute the one or more business rules on the obtained data to obtain the one or more results of the application of the one or more business rules;

add one or more new database columns including the one or more results in the in-memory database; and

provide the typed obtained data and the one or more new database columns including the one or more results to the business rule management application.

19. A system comprising:

one or more processors; and

a computer-readable medium storing instructions executable by the one or more processors to perform operations comprising;

obtain, in a business rule management application, a user selection of one or more in-memory database objects;

obtain, in the business rule management application, a definition of one or more business rules;

generate a business rule management application object, wherein the business rule management application object includes;

a representation of the user selected one or more in-memory database objects, including a table type object including a representation of the one or more business rules,

and

a database object including one or more results of an application of the one or more business rules on the one or more in-memory database objects, wherein the one or more results are generated, at run-time and within an in-memory database associated with the one or more in-memory database objects, by applying the one or more business rules on the one or more in-memory database objects;

provide the business rule management application object for storage in the in-memory database associated with the one or more in-memory database objects;

obtain data during a call of an in-memory procedure generated based on the business rule management application object;

type the obtained data with a table type defined in the table type object;

execute the one or more business rules on the obtained data to obtain the one or more results of the application of the one or more business rules;

add one or more new database columns including the one or more results in the in-memory database; and

provide the typed obtained data and the one or more new database columns including the one or more results to the business rule management application.