Abstract
Workflows are activities involving the coordinated execution of multiple tasks performed by different processing entities. Workflow management systems support the specification and execution of workflows. WorkMan is a prototype of a workflow management system in which considerable attention is paid for the utilization of the services of database systems. Particularly the use of SQL-features in implementing workflow scheduling and supporting the transactional properties of workflows are investigated. In the WorkMan prototype the scheduling of tasks is based on SQL-triggers while the transactional properties of workflows (isolation and atomicity) are implemented using SQL-assertions and CHECK-constraints.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
P. Bernstein, V. Hadzilacos, and N. Goodman. Concurrency Control and Recovery in Database Systems. Addison-Wesley, 1987.
F. Casati, S. Ceri, B. Pernici, and G. Pozzi. Deriving active rules for workflow enactment. In Proceedings of the DEXA’96, 1996.
U. Dayal, M. Hsu, and R. Ladin. Organizing long-running activities with triggers and transactions. In Proc. of the ACM SIGMOD International Conference on Management of Data, pages 204–214, 1990.
A. Elmagarmid, Y. Leu, W. Litwin, and M. Rusinkiewicz. A multibase transaction model for interbase. In Proc. of the 16th International Conference on VLDB, pages 507–518, 1990.
H. Garcia-Molina. Using semantic knowledge for transaction processing in a distributed database. ACM Transactions on Database Systems, 8(2):186–213, June 1983.
H. Garcia-Molina and K. Salem. SAGAS. In Proc. of the ACM SIGMOD International Conference on Management of Data, pages 249–259, 1987.
H. Laine and J. Puustjärvi. Modeling business processes as transactional workflows. In Proc. of the Workshop on Practical Business Process Modeling (in conduction with CAiSE’00), 2000.
P.E. O’Neil. The escrow transactional method. ACM Transactions on Database Systems, ll(4):405–430, December 1986.
J. Puustjärvi. Negotiation transactions: An approach to increase the automation of workflows. In Proc. of the 9th International Conference on Advanced Information Systems Engineering (CAiSE’97), pages 89–102, 1997.
J. Puustjärvi. Transactional Workflows. PhD thesis, University of Helsinki, 1999.
A. Schwenkreis and A. Reuter. The impact of concurrency control on the programming model of ConTracts. In Proc. of the International Workshop on Advanced Transaction Models and Architectures (ATMA), 1996.
J. D. Ullman and J. Widom. A First Course in Database Systems. Prentice Hall, 1997.
H. Wächter and A. Reuter. The ConTract model. In A.K. Elmagarmid, editor, Database Transaction Models for Advanced Applications, chapter 7, pages 219–263. Morgan Kaufmann Publishers, 1992.
J. Widom and Ceri. S. Active Database Systems. Morgan Kaufmann, 1995.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Puustjärvi, J., Laine, H. (2000). WorkMan - a Transactional Workflow Prototype. In: Ibrahim, M., Küng, J., Revell, N. (eds) Database and Expert Systems Applications. DEXA 2000. Lecture Notes in Computer Science, vol 1873. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44469-6_20
Download citation
DOI: https://doi.org/10.1007/3-540-44469-6_20
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67978-3
Online ISBN: 978-3-540-44469-5
eBook Packages: Springer Book Archive