Patent ID: 8250583
Filing Date: 2012-08-21
Classification: G06F,G06Q

Abstract:
1. A method performed by a federated data management system support module for automatic workflow processing in a workflow processing computer system, comprising: receiving a data management activity description; determining a set of set references associated with the data management activity; determining a set of data sources associated with the set of set references, the set of data sources being provided within a federated data management system; determining whether the federated data management system includes infrastructure for accessing the set of set references and for accessing the set of data sources; in response to determining that the infrastructure is not included, automatically creating the infrastructure from information in a metadata repository coupled to the federated data management system; replacing in the data management activity description references to set references and references to data sources by references to the infrastructure in the federated data management system; and delivering the data management activity description for execution by the federated data management system, wherein a group of activities is included in a workflow, the group of activities including at least one data management activity, is optimized by the following steps: determining the at least one data management activity; determining at least one data level statement for each of the at least one data management activities; determining the group of activities; determining a process graph model from the group of activities, wherein the process graph model includes each of the at least one data level statements, and wherein the semantics of the process graph model is identical to the semantics of the group of activities; determining an optimized process graph model from the process graph model; determining an optimized group of activities from the optimized process graph model, whereby the semantics of the optimized group of activities is identical to the semantics of the optimized process group model; replacing, in the workflow, the group of activities by the optimized group of activities, wherein the process graph model includes a pattern, the optimized pattern is determined from the process graph model by optimizing the pattern, and wherein further the pattern refers to directing a database statement to a particular data source, and the pattern is optimized by transforming the pattern to a corresponding statement being directed to the federated data management system.