Implementing Business Processes: A Database Trigger Approach

Wai Yin Mok, Charles F. Hickman and Christopher D. Allport
Additional contact information
Wai Yin Mok: Department of Economics and Information Systems, University of Alabama in Huntsville, Huntsville, AL, USA
Charles F. Hickman: Department of Accounting and Finance, University of Alabama in Huntsville, Huntsville, AL, USA
Christopher D. Allport: Department of Accounting and Finance, University of Alabama in Huntsville, Huntsville, AL, USA

International Journal of Knowledge-Based Organizations (IJKBO), 2013, vol. 3, issue 2, 36-55

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.

Date: 2013
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 018/ijkbo.2013040103 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jkbo00:v:3:y:2013:i:2:p:36-55

Access Statistics for this article

International Journal of Knowledge-Based Organizations (IJKBO) is currently edited by John Wang

More articles in International Journal of Knowledge-Based Organizations (IJKBO) from IGI Global
Bibliographic data for series maintained by Journal Editor ().