GENERATING DATABASE PROCESSES FROM PROCESS MODELS

• US 20140372488A1
• Filed: 06/13/2013
• Published: 12/18/2014
• Est. Priority Date: 06/13/2013
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Ritter, Daniel, Mathis, Christian
• Application Number:
  US13/916,911
• Publication Number:
  US 20140372488A1
• Time in Patent Office: Days
• US Class Current: 707/812
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures

Abstract

Methods and systems for generating and executing a database process are described. One example method includes identifying a database process within a database, the database process being generated based on an identified process model and including one or more procedures, an input location, an output location, and execution instructions configured to control execution of the one or more procedures, identifying a data set in the input location, the data set representing data to be processed by the database process, processing the data set within the database by each of the one or more procedures of the database process according to the execution instructions, and storing a result of the database process in the output location.

Claims

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

identifying a database process within a database, the database process being generated based on an identified process model and including one or more procedures, an input location, an output location, and execution instructions configured to control execution of the one or more procedures;

identifying a data set in the input location, the data set representing data to be processed by the database process;

processing the data set within the database by each of the one or more procedures of the database process according to the execution instructions; and

storing a result of the database process in the output location.

2. The method of claim 1, further comprising:

providing a stored procedure configured to receive the data set and store the data set in the input location and configured to read the result of the database process from the output location and provide the result to a calling routine.

3. The method of claim 1, wherein processing the data within the database further comprises:

starting a transaction associated with the database process at the beginning of processing the data set; and

committing the transaction associated with the database process at the end of processing the data set.

4. The method of claim 3, wherein the one or more procedures include one or more persistent procedures configured to store data in associated database tables as the data set is processed, and the one or more persistent procedures are each associated with a transaction different from the transaction associated with the database process.

5. The method of claim 1, where the input and output locations include one or more database tables.

6. The method of claim 1, wherein identifying the data set in the input location includes at least one of:

polling the input location for the data set, or receiving notification from a trigger associated with the input location.

7. The method of claim 1, wherein the execution instructions define an order in which the one or more procedures should be executed, and define how data should be passed between the one or more procedures as the data set is processed.

8. The method of claim 1, wherein the identified process model is defined in at least one of:

Business Process Modeling Notation (BPMN), or the Advanced Business Application Programming (ABAP) language.

9. A computer-implemented method performed by one or more processors, the method comprising:

identifying a process model; and

generating a database process corresponding to the process model, the database process including one or more procedures, an input location, an output location, and execution instructions configured to control execution of the one or more procedures, the database process configured to identify a data set in the input location, the data set representing data to be processed by the database process, process the data set within the database by each of the one or more procedures of the database process according to the execution instructions, and store a result of the database process in the output location.

10. The method of claim 9, where the input and output locations include one or more database tables.

11. The method of claim 9, wherein identifying the data set in the input location includes at least one of:

polling the input location for the data set or receiving notification from a trigger associated with the input location.

12. The method of claim 9, wherein the execution instructions define an order in which the one or more procedures should be executed and define how data should be passed between the one or more procedures as the data set is processed.

13. The method of claim 9, wherein the one or more procedures include one or more persistent procedures configured to store data in associated database tables as the data set is processed.

14. The method of claim 9, wherein the process model is defined in Business Process Modeling Notation (BPMN).

15. The method of claim 9, wherein the process model is defined in the Advanced Business Application Programming (ABAP) language.

16. A system, comprising:

memory for storing data; and

one or more processors operable to perform operations comprising;

identifying a database process within a database, the database process being generated based on an identified process model and including one or more procedures, an input location, an output location, and execution instructions configured to control execution of the one or more procedures;

identifying a data set in the input location, the data set representing data to be processed by the database process;

processing the data set within the database by each of the one or more procedures of the database process according to the execution instructions; and

storing a result of the database process in the output location.

17. The system of claim 16, the operations further comprising:

providing a stored procedure configured to receive the data set and store the data set in the input location and configured to read the result of the database process from the output location and provide the result to a calling routine.

18. The system of claim 16, wherein processing the data within the database further comprises:

starting a transaction associated with the database process at the beginning of processing the data set; and

committing the transaction associated with the database process at the end of processing the data set.

19. The system of claim 18, wherein the one or more procedures include one or more persistent procedures configured to store data in associated database tables as the data set is processed, and the one or more persistent procedures are each associated with a transaction different from the transaction associated with the database process.

20. The system of claim 16, where the input and output locations include one or more database tables.