System and method for converting stored procedures into workflow descriptions.

    公开(公告)号:GB2465657A

    公开(公告)日:2010-06-02

    申请号:GB0917525

    申请日:2009-10-07

    Applicant: IBM

    Abstract: A method in a database system for automatically converting stored procedures into a workflow description for a workflow system, comprises obtaining a code of a control flow language for accessing databases (101), wherein said code comprises stored procedures; providing a description of syntax and a set of node types of said control flow language (102), creating a tree model of said code based on said description of syntax of said control flow language (103). The tree model comprises a set of nodes, each node having a respective node type determined by said description of syntax and being at least one of a child node or inner node, said inner nodes being at a higher hierarchical level than said children nodes, wherein said nodes represent at least one of statements or declarations of said code. The tree is traversed using a specific traverse mode (104) preferably depth first, with each traversed node of said tree model being transformed into an element of said workflow description (105). Elements of said workflow description resulting from already transformed nodes are taken into account when later traversed nodes are transformed. Preferably the method converts control flow code in SQL, C, XML, or JavaRTMor any hierarchical or object orientated database into workflow description languages such as BPEL or BPMN.

Patent Agency Ranking