140 likes | 252 Views
Transaction and Rule Support for Workflow Management - A Retrospective on the WIDE Architecture. Paul Grefen CS Department & CTIT University of Twente. W orkflow on I ntelligent D istributed database E nvironment. WIDE Approach. Extended transaction support Loose global transactions (saga)
E N D
Transaction and Rule Supportfor Workflow Management -A Retrospective on the WIDE Architecture Paul GrefenCS Department & CTIT University of Twente
Extended transaction support • Loose global transactions (saga) • Strict local transactions (nested) • Active rule support • Decoupled execution mode • Workflow, data, external, time events • Data support • Object-oriented client interface • Relational server interface • IDL-SQL/C++ compiler support DBMS Extensions
Advanced data support versus workflow support • reusability of advanced data support • Extended transaction support versusactive rule support • orthogonal and flexible semantics • adaptability of transaction/rule support • WIDE integrated workflow system vs.commercial DBMS • portability of WIDE WFMS Orthogonal Architecture
orthogonality orthogonality Distribution Overall WIDE Architecture
CORBA OCI Transaction Support
Commercial RDBMS (Oracle 7.2) • Robust basic data support • Flat ACID transactions, basic triggers • Client/Server coupling (OCI) • CORBA (ILU) • Flexible distribution • Transparent communication Infrastructure
Functionality • Does the system do what was intended? • Performance • Does the system offer reasonable performance? • Maintainability • Is the system easy to implement and modify? Looking Back at the Design
Local transaction functionality • Limited flexibility for atomicity control • Limited transactional multi-DB access • X/Open TPM extension helps • Rule execution functionality • Decoupled rule execution model • Orthogonal transaction/rule semantics • Limited intra-business transaction rules Functionality in Retrospect
C/S connection to DBMS critical • Large numbers of small transactions • Physical channel creation expensive • Reuse already created channels • Keep channels in channel pool • Modification local to LTI • Further extensions possible: • channel creation in idle time • statistical forecasting of channel usage Performance in Retrospect
Software development in 3 organizations • Sema (ES), POLI (IT), UT (NL) • High level of flexibility required • Orthogonal architecture design • Standard internal module architectures • CORBA/IDL interface specification • Empty Shell integration • Complexity may lead to semantic problems though …. Maintainability in Retrospect
Transfer of WIDE technology to FORO commercial WFMS(SEMA) • Use of transaction concepts in cross-organizational contexts(UT, CrossFlow project) • Unbundling of active rule engine functionality for non-WFM purposes(POLI, SEMA) • Book on WIDE developments(Kluwer Academic, January ‘99) Further Developments