Business process management
View Patent ↗Systems, methods, apparatus, and computer-readable media for business process management include identifying a business process model generated with a business process modeling tool; transforming the business process model defined in a first format to one or more artifacts defined in a second format; deploying an output file defined by the one or more artifacts in an in-memory database; and executing the output file in the in-memory database base at least in part on one or more processes executing in the in-memory database in response to a received query for data stored in the in-memory database.
1. A method performed with a computing system for business process management, the method comprising:
identifying a business process model generated with a business process modeling tool;
transforming the business process model defined in a first format to one or more artifacts defined in a second format, the transforming comprising:
parsing the business process model into a directed graph comprising one or more typed nodes that define one or more process steps, and one or more edges that define one or more control flow connectors; and
generating a plurality of tokens, wherein each of the plurality of tokens represents a thread of control within each of the one or more process steps by enabling a process execution order, and each of the plurality of tokens comprises a token identifier that triggers one of the one or more process steps, and a token position assigned to each of the one or more edges;
deploying an output file defined by the one or more artifacts in an in-memory database; and
executing the output file in an in-memory database based at least in part on one or more processes executing in the in-memory database in response to a received query for data stored in the in-memory database.
2. The method of claim 1 , wherein the business process model defined in a first format comprises a business process model defined in BPMN 2.0, and the one or more artifacts defined in a second format comprise one or more SQL/SQLScript definitions.
3. The method of claim 2 , wherein transforming the business process model defined in a first format to one or more artifacts defined in a second format comprises compiling the business process model defined in BPMN 2.0 into the one or more SQL/SQLScript definitions.
4. The method of claim 3 , wherein compiling the business process model defined in BPMN 2.0 into the one or more SQL/SQLScript definitions comprises:
traversing the directed graph to generate a plurality of SQLScript fragments; and
assembling the plurality of SQLScript fragments into the one or more SQL/SQLScript definitions.
5. The method of claim 1 , wherein each of the-one or more control flow connectors comprises a true execution condition or a false execution condition.
6. The method of claim 4 , wherein traversing the directed graph to generate a plurality of SQLScript fragments comprises:
generating the plurality of SQLScript fragments based on the one or more process steps, each SQLScript fragment defining at least a queue sub-query of a particular process step.
7. The method of claim 2 , wherein the one or more SQL/SQLScript definitions comprise at least one of a queue definition, a scheduler, and a process API.
8. The method of claim 7 , further comprising:
emitting the output file comprising the queue definition, the scheduler, and the process API.
9. The method of claim 7 , wherein the one or more SQL/SQLScript definitions further comprise one or more user-defined SQLScript procedures.
10. A non-transitory computer storage medium encoded with a computer program, the program comprising instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:
identifying a business process model generated with a business process modeling tool;
transforming the business process model defined in a first format to one or more artifacts defined in a second format, the transforming comprising:
parsing the business process model into a directed graph comprising one or more typed nodes that define one or more process steps, and one or more edges that define one or more control flow connectors; and
generating a plurality of tokens, wherein each of the plurality of tokens represents a thread of control within each of the one or more process steps by enabling a process execution order, and each of the plurality of tokens comprises a token identifier that triggers one of the one or more process steps, and a token position assigned to each of the one or more edges;
deploying an output file defined by the one or more artifacts in an in-memory database; and
executing the output file in an in-memory database based at least in part on one or more processes executing in the in-memory database in response to a received query for data stored in the in-memory database.
11. The non-transitory computer storage medium of claim 10 , wherein the business process model defined in a first format comprises a business process model defined in BPMN 2.0, and the one or more artifacts defined in a second format comprise one or more SQL/SQLScript definitions.
12. The non-transitory computer storage medium of claim 11 , wherein transforming the business process model defined in a first format to one or more artifacts defined in a second format comprises compiling the business process model defined in BPMN 2.0 into the one or more SQL/SQLScript definitions.
13. The non-transitory computer storage medium of claim 12 , wherein compiling the business process model defined in BPMN 2.0 into the one or more SQL/SQLScript definitions comprises:
traversing the directed graph to generate a plurality of SQLScript fragments; and
assembling the plurality of SQLScript fragments into the one or more SQL/SQLScript definitions.
14. The non-transitory computer storage medium of claim 10 , wherein each of the one or more control flow connectors comprises a true execution condition or a false execution condition.
15. The non-transitory computer storage medium of claim 14 , wherein traversing the directed graph to generate a plurality of SQLScript fragments comprises:
generating the plurality of SQLScript fragments based on the one or more process steps, each SQLScript fragment defining at least a queue sub-query of a particular process step.
16. The non-transitory computer storage medium of claim 11 , wherein the one or more SQL/SQLScript definitions comprise at least one of a queue definition, a scheduler, and a process API.
17. The non-transitory computer storage medium of claim 16 , wherein the operations further comprise:
emitting the output file comprising the queue definition, the scheduler, and the process API.
18. The non-transitory computer storage medium of claim 16 , wherein the one or more SQL/SQLScript definitions further comprise one or more user-defined SQLScript procedures.
19. A system of one or more computers configured to perform operations comprising:
identifying a business process model generated with a business process modeling tool;
transforming the business process model defined in a first format to one or more artifacts defined in a second format, the transforming comprising:
parsing the business process model into a directed graph comprising one or more typed nodes that define one or more process steps, and one or more edges that define one or more control flow connectors; and
generating a plurality of tokens, wherein each of the plurality of tokens represents a thread of control within each of the one or more process steps by enabling a process execution order, and each of the plurality of tokens comprises a token identifier that triggers one of the one or more process steps, and a token position assigned to each of the one or more edges;
deploying an output file defined by the one or more artifacts in an in-memory database; and
executing the output file in an in-memory database based at least in part on one or more processes executing in the in-memory database in response to a received query for data stored in the in-memory database.
20. The system of claim 19 , wherein the business process model defined in a first format comprises a business process model defined in BPMN 2.0, and the one or more artifacts defined in a second format comprise one or more SQL/SQLScript definitions.
21. The system of claim 20 , wherein transforming the business process model defined in a first format to one or more artifacts defined in a second format comprises compiling the business process model defined in BPMN 2.0 into the one or more SQL/SQLScript definitions.
22. The system of claim 21 , wherein compiling the business process model defined in BPMN 2.0 into the one or more SQL/SQLScript definitions comprises:
traversing the directed graph to generate a plurality of SQLScript fragments; and
assembling the plurality of SQLScript fragments into the one or more SQL/SQLScript definitions.
23. The system of claim 19 , wherein each of the-one or more control flow connectors comprises a true execution condition or a false execution condition.
24. The system of claim 23 , wherein traversing the directed graph to generate a plurality of SQLScript fragments comprises:
generating the plurality of SQLScript fragments based on the one or more process steps, each SQLScript fragment defining at least a queue sub-query of a particular process step.
25. The system of claim 20 , wherein the one or more SQL/SQLScript definitions comprise at least one of a queue definition, a scheduler, and a process API.
26. The system of claim 25 , wherein the operations further comprise:
emitting the output file comprising the queue definition, the scheduler, and the process API.
27. The system of claim 25 , wherein the one or more SQL/SQLScript definitions further comprise one or more user-defined SQLScript procedures.