Enforcing data consistency in data integration systems by XQuery trigger service

Purpose – Extensible Markup Language (XML)‐based data integration systems (DIS) aim to support global updates. Data consistency among data sources is not yet enforced at the integration level or enforced in an ad hoc manner which leads to redundant checking of consistency or unrepairable mistakes. This paper aims to provide XQuery trigger service to enforce data integrity and data consistency in the DIS at the integration level.Design/methodology/approach – Data consistency is enforced among data sources through providing XQuery trigger service for the XML‐DIS. An XQuery trigger model is defined and shown how to use this model to define different integrity constraints and triggers at the integration level. The paper proposes the architecture of the XQuery trigger service and shows how to enforce data consistency in the DIS. Important components including event detection, condition evaluation and action firing are discussed. Necessary algorithms including how to produce ChangeRecord, how to find activated ...

[1]  Bernhard Mitschang,et al.  An XQuery-based trigger service to bring consistency management to data integration systems , 2008, iiWAS.

[2]  David Taniar,et al.  XML data update management in XML-enabled database , 2008, J. Comput. Syst. Sci..

[3]  Stefano Paraboschi,et al.  Active XQuery , 2002, Proceedings 18th International Conference on Data Engineering.

[4]  Tova Milo,et al.  Active Views for Electronic Commerce , 1999, VLDB.

[5]  Jennifer Widom,et al.  Local verification of global integrity constraints in distributed databases , 1993, SIGMOD '93.

[6]  Alexandra Poulovassilis,et al.  Event-Condition-Action Rule Languages for the Semantic Web , 2006, EDBT Workshops.

[7]  E. Hanson,et al.  An Introduction to the TriggerMan Asynchronous Trigger Processor , 1997, Rules in Database Systems.

[8]  Hans Fritschi.  FRAMBOISE - An Approach to Construct Active Database Mechanisms , 1998, Grundlagen von Datenbanken.

[9]  Michael J. Carey.  Data delivery in a service-oriented world: the BEA aquaLogic data services platform , 2006, SIGMOD Conference.

[10]  Ramez Elmasri,et al.  Integrating Relational Databases With Support For Updates , 1988, Proceedings [1988] International Symposium on Databases in Parallel and Distributed Systems.

[11]  Christine Collet,et al.  Active services for federated databases , 2000, SAC '00.

[12]  C. Turker,et al.  Towards maintaining integrity of federated databases , 1997, Proceedings of the Third Basque International Workshop on Information Technology - BIWIT'97 - Data Management Systems.

[13]  Peter M. G. Apers,et al.  The Role of Integrity Constraints in Database Interoperation , 1996, VLDB.

[14]  Alon Y. Halevy,et al.  Answering queries using views: A survey , 2001, The VLDB Journal.

[15]  Lyman Do,et al.  Active database management of global data integrity constraints in heterogeneous database environments , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[16]  Eric Simon,et al.  Promises and Realities of Active Database Systems , 1995, VLDB.

[17]  John Mylopoulos,et al.  A generic integration architecture for cooperative information systems , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[18]  Paul W. P. J. Grefen,et al.  Protocols for Integrity Constraint Checking in Federated Databases , 1997, Distributed and Parallel Databases.

[19]  J. Wenny Rahayu,et al.  Extending XML Triggers with Path-Granularity , 2007, WISE.

[20]  Sharma Chakravarthy,et al.  ECA rule support for distributed heterogeneous environments , 1998, Proceedings 14th International Conference on Data Engineering.

[21]  Serge Abiteboul,et al.  Positive active XML , 2004, PODS '04.

[22]  Hiroshi Ishikawa,et al.  An Active Web-based Distributed Database System for E-Commerce , 2001, WebDyn@ICDT.

[23]  Jennifer Widom,et al.  A toolkit for constraint management in heterogeneous information systems , 1996, Proceedings of the Twelfth International Conference on Data Engineering.

[24]  Feng Shao,et al.  Triggers over nested views of relational data , 2006, TODS.

[25]  Alexandra Poulovassilis,et al.  Analysis and optimisation of event-condition-action rules on XML , 2002, Comput. Networks.

[26]  Gio Wiederhold,et al.  Mediators in the architecture of future information systems , 1992, Computer.