An XQuery-based trigger service to bring consistency management to data integration systems

ABSTRACT

Nowadays XML-based data integration systems are accepted as data service providers on the web. In order to make such a data integration system fully equipped with data manipulation capabilities, programming frameworks which support update at the integration level are being developed. When the user is permitted to submit updates, it is necessary to establish the best possible data consistency in the whole data integration system. To that extend, we present an approach based on an XQuery trigger service. We define an XQuery trigger model together with its semantics. We report on the integration of the XQuery trigger service into the overall architecture and discuss details of the execution model. Experiments show that data consistency is enforced easily, efficiently and conveniently at the global level.

REFERENCES

• 1: Serge Abiteboul , Bernd Amann , Sophie Cluet , Adi Eyal , Laurent Mignet , Tova Milo, Active Views for Electronic Commerce, Proceedings of the 25th International Conference on Very Large Data Bases, p.138-149, September 07-10, 1999
• 2: Serge Abiteboul , Omar Benjelloun , Tova Milo, Positive active XML, Proceedings of the twenty-third ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, June 14-16, 2004, Paris, France [doi>10.1145/1055558.1055564]
• 3: J. Bailey, A. Poulovassilis, and P. T. Wood. Analysis and optimization for event-condition-action rules on xml. Computer Networks, 2001.
• 4: BEA, IBM, Oracle, Primeton Technologies, Rogue Wave Software, SAP, Software AG, Sun Microsystems, Xcalia, Zend Technologies. SDO for Java Specification V2.1. http://www.osoa.org/download/attachments/36/Java-SDO-Spec-v2.1.0-FINAL. pdf?version=1.
• 5: BEA-Systems-Inc. Bea aqualogic data services platform 3.0, 2008. http://edocs.bea.com/aldsp/docs30/index.html.
• 6: J. Beatty, S. Brodsky, M. Nally, and R. Paul. Next-generation data programming: Service data objects. A Joint Whitepaper with IBM and BEA., 2003.
• 7: Active XQuery, Proceedings of the 18th International Conference on Data Engineering, p.403, February 26-March 01, 2002
• 8: Michael Carey, Data delivery in a service-oriented world: the BEA aquaLogic data services platform, Proceedings of the 2006 ACM SIGMOD international conference on Management of data, June 27-29, 2006, Chicago, IL, USA [doi>10.1145/1142473.1142551]
• 9: Sharma Chakravarthy , Roger Le, ECA Rule Support for Distributed Heterogeneous Environments, Proceedings of the Fourteenth International Conference on Data Engineering, p.601, February 23-27, 1998
• 10: Sudarshan S. Chawathe , Hector Garcia-Molina , Jennifer Widom, A Toolkit for Constraint Management in Heterogeneous Information Systems, Proceedings of the Twelfth International Conference on Data Engineering, p.56-65, February 26-March 01, 1996
• 11: Hans Fritschi , Stella Gatziu , Klaus R. Dittrich, FRAMBOISE -- an Approach to construct Active Database Mechanisms, University of Zurich, 1997
• 12: Alon Y. Halevy, Answering queries using views: A survey, The VLDB Journal — The International Journal on Very Large Data Bases, v.10 n.4, p.270-294, December 2001 [doi>10.1007/s007780100054]
• 13: Eric N. Hanson , Samir Khosla, An Introduction to the TriggerMan Asynchronous Trigger Processor, Proceedings of the Third International Workshop on Rules in Database Systems, p.51-66, June 26-28, 1997
• 14: H. Ishikawa and M. Ohta. An active web-based distributed database system for e-commerce. In In Proc. Web Dynamics Workshop, London, 2001.
• 15: Jim Melton, Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features, Elsevier Science Inc., New York, NY, 2002
• 16: John Mylopoulos , Avigdor Gal , Kostas Kontogiannis , Martin Stanley, A Generic Integration Architecture for Cooperative Information Systems, Proceedings of the First IFCIS International Conference on Cooperative Information Systems, p.208, June 19-21, 1996
• 17: G. Papamarkos, A. Poulovassilis, and P. Wood. Event-condition-action rule languages for the semantic web. In In Proc. Workshop on Semantic Web and Databases, at VLDB'03, Berlin, 2003.
• 18: Norman W. Paton , Oscar Díaz, Active database systems, ACM Computing Surveys (CSUR), v.31 n.1, p.63-103, March 1999 [doi>10.1145/311531.311623]
• 19: Feng Shao , Antal Novak , Jayavel Shanmugasundaram, Triggers over nested views of relational data, ACM Transactions on Database Systems (TODS), v.31 n.3, p.921-967, September 2006 [doi>10.1145/1166074.1166080]
• 20: Eric Simon , Angelika Kotz Dittrich, Promises and Realities of Active Database Systems, Proceedings of the 21th International Conference on Very Large Data Bases, p.642-653, September 11-15, 1995
• 21: SoftwareAG. Number one in xml management: Tamino xml server, technical factsheet, 2006.
• 22: Genoveva Vargas-Solar , Christine Collet , Helena G. Ribeiro, Active services for federated databases, Proceedings of the 2000 ACM symposium on Applied computing, p.356-360, March 2000, Como, Italy [doi>10.1145/335603.335834]
• 23: W3C. Xquery update: last call for specification. http://www.w3c.org.
• 24: Gio Wiederhold, Mediators in the Architecture of Future Information Systems, Computer, v.25 n.3, p.38-49, March 1992 [doi>10.1109/2.121508]
• 25: Xcalia. Xcalia intermediation core. http://www.xcalia.com.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.7 Database Administration

Additional Classification:
  E. Data
  E.m MISCELLANEOUS

Keywords:
XML, XQuery, data integration, data integrity, service data object, trigger