Skip to main content
Log in

Managing heterogeneous multi-system tasks to support enterprise-wide operations

  • Published:
Distributed and Parallel Databases Aims and scope Submit manuscript

Abstract

The computing environment in most medium-sized and large enterprises involves old main-frame based (legacy) applications and systems as well as new workstation-based distributed computing systems. The objective of the METEOR project is to support multi-system workflow applications that automate enterprise operations. This paper deals with the modeling and specification of workflows in such applications. Tasks in our heterogeneous environment can be submitted through different types of interfaces on different processing entities. We first present a computational model for workflows that captures the behavior of both transactional and non-transactional tasks of different types. We then develop two languages for specifying a workflow at different levels of abstraction: the Workflow Specification Language (WFSL) is a declarative rule-based language used to express the application-level interactions between multiple tasks, while the Task Specification Language (TSL) focuses on the issues related to individual tasks. These languages are designed to address the important issues of inter-task dependencies, data formatting, data exchange, error handling, and recovery. The paper also presents an architecture for the workflow management system that supports the model and the languages.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Similar content being viewed by others

References

  1. M. Ansari, L. Ness, M. Rusinkiewicz, and A. Sheth. Using Flexible Transactions to Support Multi-System Telecommunication Applications. InProc. of the 18th VLDB Conference, August 1992.

  2. P. Attie, M. Singh, A. Sheth, and M. Rusinkiewicz. Specifying and Enforcing Intertask Dependencies. InProc. of the 19th VLDB Conference, 1993.

  3. P. Bernstein, P. Gyllstorm and T. Wimberg. STDL - A Portable Language for Transaction Processing. InProc. of the 19th VLDB Conference, 1993.

  4. A. Biliris, S. Dar, N. Gehani, H.V. Jagadish and K. Ramamritham ASSET: A system for supporting extended transactions. InProc. of the 1994 ACM SIGMOD Conference on Management of Data, 1994.

  5. M. Bregolin. Master's thesis, University of Houston, 1993

  6. Y. Breitbart, A. Deacon, H.-J. Schek, A. Sheth, and G. Weikum Merging Application-centric and Data-Centric Approaches to Support Transaction-oriented Multi-system Workflows. InSIGMOD Record, September 1993

  7. O. Bukhres, J. Chen, W. Du, A. Elmagarmid and R. Pezzoli InterBase: An Exceution Environment for Heterogeneous Software Systems. InIEEE Computer, Vol. 26 No. 8, August 1993.

  8. J. Chen, O. Bukhres, and A. Elmagarmid. IPL: A Multidatabase Transaction Specification Language. InProc. of the 13th Intl. Conf. on Distributed Computing Systems, Pittsburgh, PA, May 1993.

  9. J. Chen, Bukhres, O.A. and Sharif-Askary, J. A Customized Multidatabase Transaction Management Strategy. In4th International Conference on Database and Expert Systems Applications, September 6–8, 1993, Prague, Czech Republic.

  10. P. Chrysanthis and K. Ramamritham. A Formalism for Extended Transaction Models. InProc. of the 17th VLDB Conference, 1991.

  11. A. Cichocki. A prototype of a workflow execution controller Summer intern report and documentation, Databases and Formal Methods Research Group, Bellcore, 1994.

  12. U. Dayal, M. Hsu, and R. Ladin. Organizing Long-Running Activities with Triggers and Transactions. InProc. of ACM SIGMOD Conf. on Management of Data, 1990.

  13. U. Dayal, M. Hsu, and R. Ladin. A Transactional Model for Long-Running Activities. InProc. of the 17th VLDB Conference, September 1991.

  14. U. Dayal and M. Shan. Issues in Operation Flow Management for Long Running Activities. In [15].

  15. M. Hsu, editor. Special Issue on workflow and Extended Transaction Systems, 16 (2), June 1993.

  16. A. Elmagarmid, editor.Transaction Models for Advanced Database Applications. Morgan-Kaufmann, February 1992.

  17. A. Elmagarmid, J. Chen, and O. Bukhres. Remote System Interfaces : An Approach to Overcome Heterogeneous Barriers and Retain Local Autonomy in the Integration of Heterogeneous Systems.the Intl. Journal on Intelligent and Cooperative Information Systems, 1993.

  18. A.K. Elmagarmid, Y. Leu, W. Litwin, and M. Rusinkiewicz. A Multidatabase Transaction Model for InterBase. InProc. of the 16th VLDB Conference, 1990.

  19. H. Garcia-Molina, D. Gawlick, J. Klein, K. Kleissner, and K. Salem. Coordinating Multi-transaction Activities. Technical Report CS-TR-247-90, Princeton University, February 1990.

  20. D. Georgakopoulos, M. Hornick, P. Krychniak, and F. Manola. Specification and Management of Extended Transactions in a Programmable Transaction Environment. InProc. of the Intl. Conf. on Data Engineering, February 1994.

  21. D. Georgakopoulos, M. Hornick, and A. Sheth. An Overview of Workflow Management: From Process Modeling to Workflow Automation Infrastructure.in this issue.

  22. J. Gray and A. Reuter.Transaction Processing: Concepts and Techniques Morgan Kaufman, 1993.

  23. R. Gunthor. Extended Transaction Processing Based on Dependency Rules. InProc. of the RIDE-IMS '93: Intl. Workshop on Multidatabase Systems, April 1993.

  24. M. Hsu, R. Obermarck, and R. Vuurboom. Integration and Interoperability of a Multimedia Workflow Model and Execution. In [15].

  25. Y. Halabi et. al. Narada: An Environment for Specification and Execution of Multi-System Applications. InProc. of the 2nd Intl. Conf. on Systems Integration, 1992.

  26. W. Jin, L. Ness, M. Rusinkiewicz, A. Sheth. Concurrency Control and Recovery of Multidatabase Work Flows in Telecommunication Applications. InProc. of ACM SIGMOD Conf. on Management of Data, May 1993.

  27. W. Jin, N. Krishnakumar, L. Ness, M. Rusinkiewicz, and A. Sheth. Multidatabase transactions in the telecommunications environment: Modeling, Concurrency Control and Recovery Issues Bellcore Technical Memorandum, September 1993.

  28. J. Klein. Advanced Rule Driven Transaction Management. InProc. of the IEEE COMPCON, 1991.

  29. N. Krishnakumar and A. Sheth. Specifying Multi-system Workflow Applications in METEOR. Comp. Sc. Tech. Rep. TR-CS-02, Univ. of Georgia, September 1994.

  30. D. McCarthy and S. Sarin. Workflow and Transaction in InConcert. In [15].

  31. R. Medina-Mora, H. Wong, and P. Flores. ActionWorkflowTM as the Enterprise Integration Technology. In [15].

  32. M. Rusinkiewicz, S. Osterman, A. Elmagarmid, and K. Loa. The Distributed Operational Language for Specifying Multisystem Applications. InProc. of the 1st Intl. Conf. on Systems Integration, 1990.

  33. M. Rusinkiewicz and A. Sheth. Specification and Execution of Transactional Workflows. In Modern Database Systems: The Object Model, Interoperability, and beyond, W. Kim, Ed., Addison-Wesley/ ACM Press, 1994.

  34. F. Schwenkreis. APRICOTS - A prototype implementation of a ConTract system: Management of the control flow and the communications system In Proc. 12th Symposium on Reliable Distributed Systems, 1993.

  35. A. Sheth and M. Rusinkiewicz. On Transactional Workflows, In [15].

  36. C. Tomlinson et. al. Workflow Support in Carnot. In [15].

  37. H. Wachter and A. Reuter. The ConTract Model. Chapter 7, In [16], 1992.

  38. G. Weikum and H.-J. Schek. Concepts and applications of multilevel transactions and open nested transactions. Chapter 13, In [16].

Download references

Author information

Authors and Affiliations

Authors

Additional information

Recommended by: Omran Bukhres and e. Kühn

Rights and permissions

Reprints and permissions

About this article

Cite this article

Krishnakumar, N., Sheth, A. Managing heterogeneous multi-system tasks to support enterprise-wide operations. Distrib Parallel Databases 3, 155–186 (1995). https://doi.org/10.1007/BF01277644

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF01277644

Keywords

Navigation