skip to main content
10.1145/1968613.1968686acmconferencesArticle/Chapter ViewAbstractPublication PagesicuimcConference Proceedingsconference-collections
research-article

Conflict detection method in adopting global XML standard for database systems

Published:21 February 2011Publication History

ABSTRACT

Extensible Markup Language (XML) has been widely used as the standard representation for data sharing and interchange between global enterprises. Numerous organisations have started to develop XML-based standard (in the form of XML Schema) for data exchange within their domains. For example, XML standard for health data exchange (HL7), financial data exchange (FIX), aviation data exchange (AIXM), etc. It is important for the industries to adopt this new standard to allow them to interact with one another in this global enterprise era. However, the challenge behind the issue of adopting XML standard for a company that already has an existing database system is how to detect and resolve conflicts caused by the different modelling of real world entities, different data models or different representations of the same object. In this paper, a comprehensive taxonomy of all possible conflicts in adopting XML standard is discussed. Based on this taxonomy, a suitable method for detecting conflicts along with a detection flow and algorithms are examined and implemented. In addition, an extensive evaluation based on a real global aviation database is employed to examine the quality of the proposed methodology.

References

  1. A. Boukottaya. Enhancing course reusability through xml schemas integration. Document numerique, 7(1):89--109, 2003.Google ScholarGoogle ScholarCross RefCross Ref
  2. T. Connolly, C. Begg, and A. Strachan. Database Systems: A Practical Approach to Design, Implementation and Management. Addison Wesley Longman Limited, England, 1997. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. R. Lawrence and K. Barker. Integrating relational database schemas using a standardized dictionary. In SAC '01: Proceedings of the 2001 ACM symposium on Applied computing, pages 225--230, 2001. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. K. Lee, M. Kim, K. Lee, B. Kim, and M. Lee. Conflict classification and resolution in heterogeneous information integration based on xml schema. In TENCON '02. Proceedings. 2002 IEEE Region 10 Conference on Computers, Communications, Control and Power Engineering, pages 93--96, 2002.Google ScholarGoogle Scholar
  5. M. Lee and T. Ling. Resolving constraint conflicts in the integration of entity-relationship schemas. In Proceedings of Conceptual Modeling - ER'97, pages 394--407, 1997. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. M. Lee, T. Ling, and X. Yang. Resolving structural conflicts in the integration of xml schemas: A semantic approach. In Proc. ER03, pages 520--533, 2003.Google ScholarGoogle Scholar
  7. C. Li and T. W. Ling. Owl-based semantic conflicts detection and resolution for data interoperability. In ER Workshops 2004, LNCS 3289, pages 266--277, 2004.Google ScholarGoogle ScholarCross RefCross Ref
  8. S. Ram and J. Park. Semantic conflict resolution ontology (scrol): An ontology for detecting and resolving data and schema-level semantic conflicts. IEEE Transactions on Knowledge and Data Engineering, 16(2), Feb 2004. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. S. Spaccapietra and C. Parent. Issues and approaches of database integration. Communications of the ACM, 41:166--178, May 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. G. Talens, D. Boulanger, and M. Seguran. Domain ontologies evolutions to solve semantic conflicts. In Proc. ODBIS, pages 51--67, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. A. Teterovskaya. Conflict Detection and Resolution During Restructuring of XML data, PhD thesis, Florida University, 2000.Google ScholarGoogle Scholar
  12. T. Wang and K. Murphy. Semantic heterogeneity in multidatabase systems - a review and a proposed meta-data structure. Journal of Database Management, 15(4):71--87, Oct-Dec 2004.Google ScholarGoogle ScholarCross RefCross Ref
  13. S. K. Madria, K. Passi, and S. S. Bhowmick. An XML Schema integration and query mechanism system. DKE, 65(2):266--303, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. H.-H. Do and E. Rahm. Matching large schemas: Approaches and evaluation. Information Systems, 32(6):857--885, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. IBM Corp, Business Process Execution Language for Web Services http://www.ibm.com/developerworks/library/specification/ws-bpel/Google ScholarGoogle Scholar
  16. HL7 Health Level 7 International - System and Service, http://www.hl7.com.auGoogle ScholarGoogle Scholar
  17. AIXM Aeronautical Information Exchange Model - Euro Control, http://www.aixm.aeroGoogle ScholarGoogle Scholar
  18. K. Sattler, S. Conrad, and G. Saake. Adding conflict resolution features to a query language for database federations. Australasian Journal of Information Systems, 8(1), 2000.Google ScholarGoogle ScholarCross RefCross Ref

Index Terms

  1. Conflict detection method in adopting global XML standard for database systems

        Recommendations

        Comments

        Login options

        Check if you have access through your login credentials or your institution to get full access on this article.

        Sign in
        • Published in

          cover image ACM Conferences
          ICUIMC '11: Proceedings of the 5th International Conference on Ubiquitous Information Management and Communication
          February 2011
          959 pages
          ISBN:9781450305716
          DOI:10.1145/1968613

          Copyright © 2011 ACM

          Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

          Publisher

          Association for Computing Machinery

          New York, NY, United States

          Publication History

          • Published: 21 February 2011

          Permissions

          Request permissions about this article.

          Request Permissions

          Check for updates

          Qualifiers

          • research-article

          Acceptance Rates

          ICUIMC '11 Paper Acceptance Rate135of534submissions,25%Overall Acceptance Rate251of941submissions,27%
        • Article Metrics

          • Downloads (Last 12 months)1
          • Downloads (Last 6 weeks)0

          Other Metrics

        PDF Format

        View or Download as a PDF file.

        PDF

        eReader

        View online with eReader.

        eReader