Gesellschaft für Informatik e.V.

Lecture Notes in Informatics

Datenbanksysteme in Business, Technologie und Web, 11. Fachtagung des GIFachbereichs “Datenbanken und Informationssysteme” (DBIS), 2.-4. März 2005 Karlsruhe. GI 2005 P-65, 175-184 (2005).

GI, Gesellschaft für Informatik, Bonn


Gottfried Vossen, Frank Leymann, Peter Lockemann, Wolffried Stucky (eds.)

Copyright © GI, Gesellschaft für Informatik, Bonn


Smart files: combining the advantages of DBMS and wfms with the simplicity and flexibility of spreadshe

Alexander Hilliger Von Thile and Ingo Melzer


Even though database management as well as workflow management systems have significant advantages, spreadsheets exchanged by e-mail are still in widespread use for many processes within an enterprise, causing problems such as poor data-quality and lack of process monitoring. This paper analyzes reasons for office-document based workflows (ODBWf) and presents an alternative solution that combines the advantages of DBMS and WfMS with the flexibility and simplicity of office documents. This paper introduces an autonomous mobile document-management-system based on a `smart' file. This file is executable and contains a managed resource part where files can be stored. Any read/write access to its resource part is managed by the file itself; it controls who can do what and automatically synchronizes changes to other systems such as process-monitoring or business intelligence tools. Proven concepts from DBMS, such as triggers, integrity constraints and multi-user support are utilized to improve ODBWfs without restraining their flexibility.

Full Text: PDF

GI, Gesellschaft für Informatik, Bonn
ISBN 3-885794-6

Last changed 24.01.2012 21:50:09