{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,8,2]],"date-time":"2025-08-02T18:04:57Z","timestamp":1754157897276,"version":"3.41.2"},"reference-count":35,"publisher":"Emerald","issue":"2","license":[{"start":{"date-parts":[[2009,6,19]],"date-time":"2009-06-19T00:00:00Z","timestamp":1245369600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.emerald.com\/insight\/site-policies"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2009,6,19]]},"abstract":"<jats:sec><jats:title content-type=\"abstract-heading\">Purpose<\/jats:title><jats:p>Extensible Markup Language (XML)\u2010based 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<jats:italic>ad hoc<\/jats:italic>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.<\/jats:p><\/jats:sec><jats:sec><jats:title content-type=\"abstract-heading\">Design\/methodology\/approach<\/jats:title><jats:p>Data consistency is enforced among data sources through providing XQuery trigger service for the XML\u2010DIS. 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 triggers, how to process LET and FOR clauses and how to create data objects from XML fragment are proposed. Trigger termination and failure handling are also discussed.<\/jats:p><\/jats:sec><jats:sec><jats:title content-type=\"abstract-heading\">Findings<\/jats:title><jats:p>XQuery trigger can express miscellaneous data integrity constraints and triggers in the DIS and is highly abstract, refined and easy to understand. XQuery trigger service provides an easy\u2010to\u2010maintain method of the data consistency rules and a uniform, nonredundant and centralized enforcement of data consistency.<\/jats:p><\/jats:sec><jats:sec><jats:title content-type=\"abstract-heading\">Originality\/value<\/jats:title><jats:p>An XQuery trigger model with namespace annotations, which can define constraints and triggers among different data sources. An XQuery trigger service architecture for the XML\u2010DIS, which can enforce data consistency at the integration level. For DIS administrators, who want to enforce data consistency when permitting updates at the integration level.<\/jats:p><\/jats:sec>","DOI":"10.1108\/17440080910968454","type":"journal-article","created":{"date-parts":[[2009,6,6]],"date-time":"2009-06-06T07:08:36Z","timestamp":1244272116000},"page":"195-219","source":"Crossref","is-referenced-by-count":2,"title":["Enforcing data consistency in data integration systems by XQuery trigger service"],"prefix":"10.1108","volume":"5","author":[{"given":"Jing","family":"Lu","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bernhard","family":"Mitschang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"140","reference":[{"doi-asserted-by":"crossref","unstructured":"Abiteboul, S., Benjelloun, O. and Milo, T. (2004), \u201cPositive active xml\u201d, Proceedings of the Twenty\u2010Third ACM SIGMOD\u2010SIGACT\u2010SIGART Symposium on Principles of Database Systems, ACM, New York, NY, pp. 35\u201045.","key":"key2022021820275957500_b2","DOI":"10.1145\/1055558.1055564"},{"unstructured":"Abiteboul, S., Amann, B., Cluet, S., Eyal, A., Mignet, L. and Milo, T. (1999), \u201cActive views for electronic commerce\u201d, Proceedings of the 25th International Conference on Very Large Data Bases, Morgan Kaufmann Publishers, San Francisco, CA, pp. 138\u201049.","key":"key2022021820275957500_b1"},{"doi-asserted-by":"crossref","unstructured":"Bailey, J., Poulovassilis, A. and Wood, P.T. (2001), \u201cAnalysis and optimization for event\u2010condition\u2010action rules on xml\u201d, Computer Networks, Vol. 39 No. 3, pp. 239\u201059.","key":"key2022021820275957500_b3","DOI":"10.1016\/S1389-1286(02)00208-6"},{"unstructured":"BEA, IBM, Oracle, Primeton Technologies, Rogue Wave Software, SAP, Software AG, Sun Microsystems, Xcalia, Zend Technologies (2006), \u201cSDO for Java Specification V2.1\u201d, available at: www.osoa.org\/download\/attachments\/36\/Java\u2010SDO\u2010Spec\u2010v2.1.0\u2010FINAL.pdf?version=1.","key":"key2022021820275957500_b4"},{"unstructured":"BEA Systems (2008), BEA Aqualogic Data Services Platform 3.0., available at: http:\/\/edocs.bea.com\/aldsp\/docs30\/index.html.","key":"key2022021820275957500_b5"},{"unstructured":"Beatty, J., Brodsky, S., Nally, M. and Paul, R. (2003), \u201cNext\u2010generation data programming: service data objects\u201d, a joint white paper with IBM and BEA.","key":"key2022021820275957500_b6"},{"unstructured":"Bonifati, A., Braga, D., Campi, A. and Ceri, S. (2002), \u201cActive xquery\u201d, Proceedings of the Eighteenth International Conference on Data Engineering, IEEE Computer Society, San Jose, CA, pp. 403\u201012.","key":"key2022021820275957500_b7"},{"doi-asserted-by":"crossref","unstructured":"Carey, M. (2006), \u201cData delivery in a service\u2010oriented world: the bea aqualogic data services platform\u201d, Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data, ACM, New York, NY, pp. 695\u2010705.","key":"key2022021820275957500_b8","DOI":"10.1145\/1142473.1142551"},{"unstructured":"Chakravarthy, S. and Le, R. (1998), \u201cEca rule support for distributed heterogeneous environments\u201d, Proceedings of the Fourteenth International Conference on Data Engineering, IEEE Computer Society, Washington, DC, p. 601.","key":"key2022021820275957500_b9"},{"unstructured":"Chawathe, S.S., Garcia\u2010Molina, H. and Widom, J. (1996), \u201cA toolkit for constraint management in heterogeneous information systems\u201d, Proceedings of the Twelfth International Conference on Data Engineering, IEEE Computer Society, Washington, DC, pp. 56\u201065.","key":"key2022021820275957500_b10"},{"unstructured":"Do, L. and Drew, P. (1995), \u201cActive database management of global data integrity constraints in heterogeneous database environments\u201d, Proceedings of the Eleventh International Conference on Data Engineering, IEEE Computer Society, Washington, DC, pp. 99\u2010108.","key":"key2022021820275957500_b11"},{"unstructured":"Fritschi, H., Gatziu, S. and Dittrich, K.R. (1997), \u201cFramboise \u2013 an approach to construct active database mechanisms\u201d, Technical Report, University of Zurich, available at: www.ncstrl.org:8900\/ncstrl\/servlet\/search?formname=detail&id=\u2009oai%3Ancstrlh%3Aunizh_ifi% 3Ancstrl.unizh_ifi%2F%2Fifi\u201097.04.","key":"key2022021820275957500_b12"},{"doi-asserted-by":"crossref","unstructured":"Gamal\u2010Eldin, M.S., Thomas, G. and Elmasri, R. (1988), \u201cIntegrating relational databases with support for updates\u201d, Proceedings of the First International Symposium on Databases in Parallel and Distributed Systems, IEEE Computer Society Press, Los Alamitos, CA, pp. 202\u20109.","key":"key2022021820275957500_b13","DOI":"10.1109\/DPDS.1988.675016"},{"doi-asserted-by":"crossref","unstructured":"Grefen, P. and Widom, J. (1997), \u201cProtocols for integrity constraint checking in federateddatabases\u201d, Distributed Parallel Databases, Vol. 5 No. 4, pp. 327\u201055.","key":"key2022021820275957500_b14","DOI":"10.1023\/A:1008616811104"},{"doi-asserted-by":"crossref","unstructured":"Gupta, A. and Widom, J. (1993), \u201cLocal verification of global integrity constraints in distributed databases\u201d, SIGMOD Record, Vol. 22 No. 2, pp. 49\u201058.","key":"key2022021820275957500_b15","DOI":"10.1145\/170036.170048"},{"doi-asserted-by":"crossref","unstructured":"Halevy, A.Y. (2001), \u201cAnswering queries using views: a survey\u201d, The VLDB Journal, Vol. 10 No. 4, pp. 270\u201094.","key":"key2022021820275957500_b16","DOI":"10.1007\/s007780100054"},{"doi-asserted-by":"crossref","unstructured":"Hanson, E.N. and Khosla, S. (1997), \u201cAn introduction to the triggerman asynchronous trigger processor\u201d, Proceedings of the Third International Workshop on Rules in Database Systems, Lecture Notes in Computer Science, Vol. 1312, Springer, New York, NY, pp. 51\u201066.","key":"key2022021820275957500_b17","DOI":"10.1007\/3-540-63516-5_17"},{"unstructured":"Ishikawa, H. and Ohta, M. (2001), \u201cAn active web\u2010based distributed database system for e\u2010commerce\u201d, Proceedings of Web Dynamics Workshop, London.","key":"key2022021820275957500_b18"},{"doi-asserted-by":"crossref","unstructured":"Landberg, A.H., Rahayu, J.W. and Pardede, E. (2007), \u201cExtending XML triggers with path\u2010granularity\u201d, The 8th International Conference on Web Information Systems Engineering (WISE 2007), Springer, Nancy, pp. 410\u201022, LNCS 4831.","key":"key2022021820275957500_b19","DOI":"10.1007\/978-3-540-76993-4_34"},{"doi-asserted-by":"crossref","unstructured":"Lu, J. and Mitschang, B. (2008), \u201cAn xquery\u2010based trigger service to bring consistency management to data integration systems\u201d, Proceedings of the 10th International Conference on Information Integration and Web\u2010based Applications and Services, ACM Press, Linz, pp. 154\u201061.","key":"key2022021820275957500_b20","DOI":"10.1145\/1497308.1497340"},{"unstructured":"Melton, J. (Ed.) (2003), Advanced SQL: 1999, Understanding Object\u2010Oriented and Other Advanced Features, Morgan Kaufmann, San Francisco, CA.","key":"key2022021820275957500_b21"},{"unstructured":"Mylopoulos, J., Gal, A., Kontogiannis, K. and Stanley, M. (1996), \u201cA generic integration architecture for cooperative information systems\u201d, Proceedings of the First IFCIS International Conference on Cooperative Information Systems, IEEE Computer Society, Washington, DC, p. 208.","key":"key2022021820275957500_b22"},{"unstructured":"Papamarkos, G., Poulovassilis, A. and Wood, P. (2003), \u201cEvent\u2010condition\u2010action rule languages for the semantic web\u201d, Proceeding of Workshop on Semantic Web and Databases, at VLDB'03, Berlin.","key":"key2022021820275957500_b23"},{"doi-asserted-by":"crossref","unstructured":"Pardede, E., Rahayu, J.W. and Taniar, D. (2008), \u201cXML data update management in XML\u2010enabled database\u201d, Journal of Computer and System Sciences, Vol. 74 No. 2, pp. 170\u201095.","key":"key2022021820275957500_b24","DOI":"10.1016\/j.jcss.2007.04.008"},{"doi-asserted-by":"crossref","unstructured":"Paton, N.W. and Diaz, O. (1999), \u201cActive database systems\u201d, ACM Computing Survey, Vol. 31 No. 1, pp. 63\u2010103.","key":"key2022021820275957500_b25","DOI":"10.1145\/311531.311623"},{"doi-asserted-by":"crossref","unstructured":"Shao, F., Novak, A. and Shanmugasundaram, J. (2006), \u201cTriggers over nested views of relational data\u201d, ACM Transactions on Database Systems, Vol. 31 No. 3, pp. 921\u201067.","key":"key2022021820275957500_b26","DOI":"10.1145\/1166074.1166080"},{"unstructured":"Simon, E. and Dittrich, A.K. (1995), \u201cPromises and realities of active database systems\u201d, Proceedings of the 21th International Conference on Very Large Data Bases, Morgan Kaufmann, San Francisco, CA, pp. 642\u201053.","key":"key2022021820275957500_b27"},{"unstructured":"Software AG (2006), \u201cNumber one in xml management: Tamino xml server\u201d, technical factsheet.","key":"key2022021820275957500_b28"},{"unstructured":"Turker, C. and Conrad, S. (1997), \u201cTowards maintaining integrity of federated databases\u201d, Proceedings of the 3rd Basque International Workshop on Information Technology, IEEE Computer Society, Washington, DC, p. 93.","key":"key2022021820275957500_b29"},{"doi-asserted-by":"crossref","unstructured":"Vargas\u2010Solar, G., Collet, C. and Ribeiro, H.G. (2000), \u201cActive services for federated databases\u201d, Proceedings of the 2000 ACM Symposium on Applied Computing, ACM Press, New York, NY, pp. 356\u201060.","key":"key2022021820275957500_b30","DOI":"10.1145\/335603.335834"},{"unstructured":"Vermeer, M.W.W. and Apers, P.M.G. (1996), \u201cThe role of integrity constraints in database interoperation\u201d, Proceedings of the 22nd International Conference on Very Large Data Bases, Morgan Kaufmann, San Francisco, CA, pp. 425\u201035.","key":"key2022021820275957500_b31"},{"unstructured":"W3C (2008), \u201cXquery update: last call for specification\u201d, available at: www.w3c.org.","key":"key2022021820275957500_b32"},{"unstructured":"Wan, X. (2008), \u201cEnforcing constraints and triggers for active data services\u201d, Master thesis, University of Stuttgart, Stuttgart, Diplomarbeit Nr: 2714.","key":"key2022021820275957500_b33"},{"doi-asserted-by":"crossref","unstructured":"Wiederhold, G. (1992), \u201cMediators in the architecture of future information systems\u201d, Computer, Vol. 25 No. 3, pp. 38\u201049.","key":"key2022021820275957500_b34","DOI":"10.1109\/2.121508"},{"unstructured":"Xcalia (2008), \u201cXcalia intermediation core\u201d, available at www.xcalia.com.","key":"key2022021820275957500_b35"}],"container-title":["International Journal of Web Information Systems"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/www.emeraldinsight.com\/doi\/full-xml\/10.1108\/17440080910968454","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/www.emerald.com\/insight\/content\/doi\/10.1108\/17440080910968454\/full\/xml","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/www.emerald.com\/insight\/content\/doi\/10.1108\/17440080910968454\/full\/html","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,7,25]],"date-time":"2025-07-25T00:24:58Z","timestamp":1753403098000},"score":1,"resource":{"primary":{"URL":"http:\/\/www.emerald.com\/ijwis\/article\/5\/2\/195-219\/166614"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2009,6,19]]},"references-count":35,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2009,6,19]]}},"alternative-id":["10.1108\/17440080910968454"],"URL":"https:\/\/doi.org\/10.1108\/17440080910968454","relation":{},"ISSN":["1744-0084"],"issn-type":[{"type":"print","value":"1744-0084"}],"subject":[],"published":{"date-parts":[[2009,6,19]]}}}