Method, system, and apparatus for performing flow-based processing using stored procedure
Disclosed is a method for a hub module to perform flow-based processing, which includes: receiving a flow including at least one task; a stored procedure generation allowance step for allowing a DBMS module to generate a stored procedure based on the flow when the received flow is not a previously processed flow, wherein the stored procedure includes at least one of a flow query, meta information, and exception handling information, and the meta information includes execution time of the flow query, execution results, and user information; and a stored procedure call allowance step for allowing the DBMS module to call the stored procedure corresponding to a previously processed flow when the received flow is the previously processed flow.
1. A system for performing flow-based processing, the system comprising:
a processor for performing the flow-based processing;
a hub module implemented by the processor, the hub module comprising:
a non-transitory computer readable medium including a computer program with encoded commands configured to cause the processor to:
receive a flow comprising at least one task;
determine to generate, via a Database Management System (DBMS) module, a stored procedure based on the flow in response to the received flow not being a previously processed flow, wherein the stored procedure comprises at least one of a flow query, meta information, and exception handling information, the meta information comprising execution time of the flow query, execution results, and user information; and
determine to call, via the DBMS module, the stored procedure corresponding to the previously processed flow in response to the received flow being the previously processed flow;
generate at least one task query corresponding to each of the at least one task, wherein the at least one task query comprises a first task query and a second task query, and the first task query is a previous task query of the second task query; and
generate a single flow query using subquerying, wherein the subquerying comprises generating the single flow query by letting the second task query comprise the first task query as a sub-query, and the subquerying is a method in which one predetermined query statement corresponding to one task query includes a query statement corresponding to a previous task query using a ‘From’ clause.
2. The system of claim 1 , wherein the encoded commands are further configured to cause the processor to:
generate the flow query based on the flow;
send the generated flow query to the DBMS module; and
determine to generate, via the DBMS module, the stored procedure based on the flow query.
3. The system of claim 2 , wherein the encoded commands are further configured to cause the processor to:
determine to execute, via the DBMS module, the flow query.
4. The system of claim 1 , wherein the meta information is updated in response to the stored procedure having been called.
5. A system for performing flow-based processing, the system comprising:
a processor for performing the flow-based processing;
a Database Management System (DBMS) module implemented by the processor, the DBMS module comprising:
a non-transitory computer readable medium including a computer program with encoded commands configured to cause the processor to:
identify whether a hub module receives a flow comprising at least one task;
generate a stored procedure based on the flow in response to the received flow not being a previously processed flow, wherein the stored procedure comprises at least one of a flow query, meta information, and exception handling information, the meta information comprising execution time of the flow query, execution results, and user information; and
call the stored procedure corresponding to the previously processed flow in response to the received flow being the previously processed flow,
wherein, via the hub module, at least one task query is generated corresponding to each of the at least one task,
wherein the at least one task query comprises a first task query and a second task query, and the first task query is a previous task query of the second task query, and a single flow query is generated using subquerying, wherein the subquerying comprises generating the single flow query by letting the second task query comprise the first task query as a sub-query, and the subquerying is a method in which one predetermined query statement corresponding to one task query includes a query statement corresponding to a previous task query using a ‘From’ clause.
6. The system DBMS modulo of claim 5 , wherein the encoded commands are further configured to cause the processor to:
determine whether a flow query was generated based on the flow by the hub module; and
generate a stored procedure based on the received flow query.
7. The system of claim 6 , wherein the encoded commands are further configured to execute the received flow query.
8. The system of claim 5 , wherein the meta information is updated in response to the stored procedure having been called.