This Article 
 Bibliographic References 
 Add to: 
SEAM: A State-Entity-Activity-Model for a Well-Defined Workflow Development Methodology
March/April 2002 (vol. 14 no. 2)
pp. 415-431

Current conceptual workflow models use either informally defined conceptual models or several formally defined conceptual models that capture different aspects of the workflow, e.g., the data, process, and organizational aspects of the workflow. To the best of our knowledge, there are no algorithms that can amalgamate these models to yield a single view of reality. A fragmented conceptual view is useful for systems analysis and documentation. However, it fails to realize the potential of conceptual models to provide a convenient interface to automate the design and management of workflows. First, as a step toward accomplishing this objective, we propose SEAM (State-Entity-Activity-Model), a conceptual workflow model defined in terms of set theory. Second, no attempt has been made, to the best of our knowledge, to incorporate time into a conceptual workflow model. SEAM incorporates the temporal aspect of workflows. Third, we apply SEAM to a real-life organizational unit's workflows. In this work, we show a subset of the workflows modeled for this organization using SEAM. We also demonstrate, via a prototype application, how the SEAM schema can be implemented on a relational database management system. We present the lessons we learned about the advantages obtained for the organization and, for developers who choose to use SEAM, we also present potential pitfalls in using the SEAM methodology to build workflow systems on relational platforms. The information contained in this work is sufficient enough to allow application developers to utilize SEAM as a methodology to analyze, design, and construct workflow applications on current relational database management systems. The definition of SEAM as a context-free grammar, definition of its semantics, and its mapping to relational platforms should be sufficient also, to allow the construction of an automated workflow design and construction tool with SEAM as the user interface.

[1] D. Georgakopoulos, M. Hornick, and A. Sheth, "An Overview of Workflow Management: From Process Modeling to Workflow Automation Infrastructure," Distributed and Parallel Databases, Vol. 3, No. 2, Apr. 1995, pp. 119-153.
[2] M. Rusinkiewicz, P. Krychniak, and A. Cichocki, “Toward a Model for Multidatabase Transactions,” Int'l J. Intelligent and Cooperative Information Systems, vol. 1, pp. 579-617, 1992.
[3] J. Davis, W. Du, and M.-C. Shan, “Open-PM: An Enterprise Process Management System,” Bull. Technical Committee on Data Eng., vol. 18, pp. 27-32, 1995.
[4] A. Bernstein, D. Chrysanthos, T.W. Malone, and J. Quimby, “Software Tools for a Process Handbook,” Bull. Technical Committee on Data Eng., vol. 18, pp. 41-47, 1995.
[5] T. Winograd and C.F. Flores, Understanding Computers and Cognition: A New Foundation for Design, Ablex, Norwood, N.J., 1986.
[6] G. Kappel, P. Lang, S. Rausch-Schott, and W. Retschitzegger, “Workflow Management Based on Objects, Rules and Roles,” Bull. of the Technical Committee on Data Eng., vol. 18, pp. 11-18, 1995.
[7] S. Joosten, “Trigger Modeling for Workflow Analysis,” Proc. CON: Workflow Management, 1994.
[8] A. Reuter and F. Schwenkreis, “Contracts: A Low Level Mechanism for Building General Purpose Workflow Management Systems,” Bull. Technical Committee on Data Eng., vol. 18, pp. 4-10, 1995.
[9] C. Mohan, G. Alonso, R. Gunthor, and M. Kamath, “Exotica: A Research Perspective on Workflow Management Systems,” Bull. Technical Committee on Data Eng., vol. 18, pp. 19-26, 1995.
[10] IBM, “Flowmark: Managing Your Workflow,” Report SH-19-8176-01, 1994.
[11] H. Ludwig, “Termination Handling in Inter-Organizational Workflows-An Exception Managemen Approach,” IBM Research Division, Zurich Research Laboratory, Rueschlikon RZ 3042 (#93088), Aug. 1998.
[12] A. Chan and K. Harty, “Building Flexible Applications with the Teknekron Enterprise Toolkit,” Bull. Technical Committee on Data Eng., vol. 18, pp. 33-40, 1995.
[13] M. Singh and M. Huhns,“Automating Workflows for Service Provisioning: Integrating AI and Database Technologies,” IEEE Expert, vol. 9, pp. 19-23, 1994.
[14] P.K. Chrysanthis and K. Ramamritham, “Sysnthesis of Extended Transaction Models Using ACTA,” ACM Trans. Database Systems, vol. 119, pp. 450-491, 1994.
[15] D. Barbara, S. Mehrotra, and M. Rusinkiewicz, “INCAs: Managing Dynamic Workflows in Distributed Environments,” J. Database Management, vol. 7, pp. 5-15, 1996.
[16] G.D. Michelis, “Net Theory and Workflow Models,” Application and Theory of Petri Nets, S. Donatelli and J. Kleijn, eds., pp. 282-283, 1999.
[17] H.A. Kuno and E.A. Rundensteiner, “Incremental Maintenance of Materialized Object-Oriented Views in Multiview: Strategies and Performance Evaluation,” IEEE Trans. Knowledge and Data Eng., vol. 10, no. 5, pp. 768-793, Sept./Oct. 1998.
[18] M. Papazoglou, A. Delis, A. Bougettaya, and M. Haghjoo, “Class Library Support for Workflow Environments and Applications,” IEEE Trans. Computers, vol. 46, pp. 673-687, 1997.
[19] W. Wang and C. Zhong, “The Distributed Workflow Management System-FlowAgent,” J. Computer Science and Technology, vol. 15, pp. 376-382, 2000.
[20] G. Dinkhoff, V. Gruhn, A. Saalmann, and M. Zielonka, “Business Process Modeling in the Workflow Management Environment: Leu,” Proc. 13th Int'l Conf. Entity Relationship Approach, 1994.
[21] F. Casati, S. Ceri, B. Pernici, and G. Pozzi, "Conceptual Modeling of Workflows," Proc. Int'l Conf. Object-Oriented and Entity-Relationship,Goldcoast, Australia, pp. 341-354, 1995.
[22] A.W. Scheer, Architektur Integrierter Infomationssysteme [Architecture of Integrated Information Systems]. Springer, 1990 (in German).
[23] O. Zukunft and F. Rump, “From Business Process Modeling to Workflow Management: An Integrated Approach,” Business Process Modeling, B.S. Reiter and E. Stickel, eds., 1996.
[24] L. Yu, “A Coordination Based Approach to Modelling Office Workflow,” Business Process Modeling, B. Scholz-Reiter and E. Stickel, eds., 1996.
[25] M. Rohloff, “An Object Oriented Approach to Business Process Modeling,” Business Process Modeling, B. Scholz-Reiter and E. Stickel, eds., 1996.
[26] M.A. Vouk, D.L. Bitzer, and R.L. Klevans, “Workflow and End-User Quality of Service Issues in Web-Based Education,” IEEE Trans. Knowledge and Data Eng., vol. 11, no. 4, p. 673-687, July/Aug. 1999.
[27] J.M. Nieves and A.P. Sage, “Human and Organizational Error as a Basis for Process Reengineering: With Applications to Systems Integration Planning and Marketing,” IEEE Trans. Systems, Man, and Cybernetics—Part A: Systems and Humans, vol. 28, pp. 742-744, 1998.
[28] M. Klein and C. Dellarocas, “A Knowledge-Based Approach to Handling Exceptions in Workflow Systems,” J. Computer-Supported Collaborative Work, Jan. 2000.
[29] R. Agarwal, G. Bruno, and M. Torchiano, “An Operational Approach to the Design of Workflow Systems,” Information and Software Technology, vol. 42, pp. 547-555, 2000.
[30] J.A. Miller, A.P. Sheth, and K.J. Kochut, “Perspectives in Modeling: Simulation, Database and Workflow,” Conceptual Modeling: Current Issues and Future Directions, P.P. Chen, J. Akoka, H. Kangassalo, and B. Thalheim, eds., pp. 154-167, 1999.
[31] L. Shuzhou and A.G.E. Soong, “Modeling Workflows with Reactive Objects,” Int'l J. Flexible Automation and Integrated Manufacturing, vol. 7, pp. 343-353, 1999.
[32] S. Jablonski, “On the Complementarity of Workflow Management and Business Prrocess Modeling,” SIGOIS Bul., vol. 16, pp. 33-38, 1995.
[33] P.P. Chen, “The Entity‐Relationship Model: Toward a Unified View of Data,” ACM Trans. Database Systems, Vol. 1, No. 1, Jan. 1976, pp. 9–36.
[34] E.F. Codd,“A relational model of data for large shared data banks,” Comm. ACM, vol. 13, no. 6, June 1970.
[35] K.L. Siau, H.C. Chan, and K.P. Tan, “A CASE Tool for Conceptual Database Design,” Information and Software Technology, vol. 34, pp. 779-786, 1992.
[36] W. Kozaczynski and L. Lilien, “An Extended Entity-Relationship Database Specification and Its Automatic Verification and Transformation into the Logical and Relational Design,” Proc. Sixth Int'l Conf. E-R Approach, 1987.
[37] D. McGovern and C.J. Date, A Guide to SYBASE and SQL Server.Reading, Mass.: Addison-Wesley, 1992.
[38] K.T. Owens, Building Intelligent Databases with Oracle PL/SQL, Triggers and Stored Procedures. New Jersey: Prentice Hall, 1996.
[39] J.Y.L. Thong, C.-S. Yap, and K.S. Raman, “Engagement of External Expertise in Information Systems Implementation,” J. Management Information Systems, vol. 11, pp. 209-231, 1994.
[40] A. Silberschatz, M. Stonebraker, and J. Ullman, “Database Research: Achievements and Opportunities Into the 21st Century,” ACM Special Interest Group on Management of Data Record (SIGMOD Record '96), vol. 25, no. 1 Mar. 1996.
[41] E.K. Clemons and P.R. Kleindorfer, “An Economic Analysis of Interorganizational Information Technology,” Decision Support Systems, vol. 8, pp. 431-446, 1992.
[42] H. Gregersen and C.S. Jensen, “Temporal Entity Relationship Models: A Survey,” AalBorg University, Denmark TIMECENTER TR-3, Jan. 1997.
[43] T. deMarco, Structured Analysis and System Specification. Yourdon, Inc., 1978.
[44] J.M. Smith and D.C.P. Smith, “Database Abstractions: Aggregation and Generalization,” ACM Trans. Database Systems, vol. 2, pp. 105-133, 1977.
[45] S. Ram and V. Storey, “Composites and Grouping: Extending the Realm of Semantic Modeling,” Proc. Hawaiian Int'l Conf. System Sciences, 1993.
[46] T.J. Teorey, D. Yang, and J. Fry, "A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Mode," ACM Computing Surveys, vol. 18, no. 2, 1986, pp. 197-222.
[47] R.W. Floyd and R. Beigel, The Language of Machines. New York: Computer Science Press, 1994.
[48] A. Bajaj, “Managing Business Workflows Using a Database Approach: A Formal Model, A Case Study, and A Prototype,” MIS, Univ. of Arizona, Tucson, 1997.
[49] A. Silberschatz, H.F. Korth, and S. Sudarshan, Database System Concepts. McGraw-Hill, 1997.
[50] A. Bajaj and S. Ram, “An Empirical Methodology to Evaluate the Completeness of Conceptual Business Process Models,” J. Information Technology Cases and Applications, vol. 1, pp. 5-30, 1999.
[51] M.T. Laamanen, “The IDEF Standards: Methods and Associated Tools for the Information Systems Life Cycle,” Proc. Int'l Federation for Information Processing, 1994.
[52] M.W. Alford, “SREM At The Age Of Eight: The Distributed Computing Design System,” Computer, vol. 18, pp. 36-46, 1985.
[53] D.T. Ross, “Structured Analysis (SA): A Language for Communicating Ideas,” IEEE Trans. Software Eng., vol. 3, 1977.
[54] D.T. Ross, “Applications and Extensions of SADT,” Computer, vol. 18, pp. 25-35, 1985.

Index Terms:
workflow systems, data modeling, process modeling, relational databases, temporal models, requirements engineering
A. Bajaj, S. Ram, "SEAM: A State-Entity-Activity-Model for a Well-Defined Workflow Development Methodology," IEEE Transactions on Knowledge and Data Engineering, vol. 14, no. 2, pp. 415-431, March-April 2002, doi:10.1109/69.991725
Usage of this product signifies your acceptance of the Terms of Use.