Implementing Business Processes: A Database Trigger Approach

Authors:
Wai Yin Mok;Charles F. Hickman;Christopher D. Allport
Affiliations:
Department of Economics and Information Systems, University of Alabama in Huntsville, Huntsville, AL, USA;Department of Accounting and Finance, University of Alabama in Huntsville, Huntsville, AL, USA;Department of Accounting and Finance, University of Alabama in Huntsville, Huntsville, AL, USA
Venue:
International Journal of Knowledge-Based Organizations
Year:
2013

Citing 9
Cited 0

Computability and logic: 3rd ed.

Computability and logic: 3rd ed.
Static analysis techniques for predicting the behavior of active database rules

ACM Transactions on Database Systems (TODS)
Decidability and undecidability results for the termination problem of active database rules

PODS '98 Proceedings of the seventeenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
An algebraic approach to static analysis of active database rules

ACM Transactions on Database Systems (TODS)
Introduction to the Theory of Computation

Introduction to the Theory of Computation
Active Database Systems: Triggers and Rules for Advanced Database Processing

Active Database Systems: Triggers and Rules for Advanced Database Processing
Refined rules termination analysis through transactions

Information Systems
Unified Modeling Language User Guide, The (2nd Edition) (Addison-Wesley Object Technology Series)

Unified Modeling Language User Guide, The (2nd Edition) (Addison-Wesley Object Technology Series)
On the computability of agent-based workflows

Decision Support Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

Database triggers are database procedures that are executed automatically when certain events occur and conditions are met. This paper presents a design methodology that helps users implement business processes using database triggers. The contributions of this paper are as follows. First, the proposed methodology uses the Unified Modeling Language UML. UML is a standard modeling language for the software industry and many commercial CASE Computer-Aided Software Engineering tools support UML. Second, many expensive ERP Enterprise Resource Planning software systems are employed to implement business processes. The methodology proposed by this paper produces triggers that can be executed on MySQL, an open-source database system that is free for download. Third, as an example of the usefulness of the proposed methodology, the authors present a case study making use of database triggers in a tax audit process. This process involves many steps that require human intervention, and thus is typical of business processes.