skip to main content
10.1145/3555776.3577616acmconferencesArticle/Chapter ViewAbstractPublication PagessacConference Proceedingsconference-collections
research-article

Ontology-Mediated Data Migration: Deriving Migration Rules by Reasoning on Schema Descriptions

Published:07 June 2023Publication History

ABSTRACT

Migration of data across information systems is a knowledge intensive task: the definition of mappings between systems requires knowledge of the source and target (relational) schemas and their interpretation of the shared domain. Moreover, direct schema mappings need often to be re-defined for each new migration instance, in order to accommodate the variations caused by the change of systems and representation conventions. A possible solution to such problems is the use of an intermediate ontological model, that can be used as a lingua franca for the description of schemas, by defining mappings from and to the ontology. While this helps in making explicit the semantics of the schemas, the problem remains on how to extract a direct mapping from source to target schema from this intermediate representation.

In this paper, we present our ongoing work in building an ontology-based migration system in the scenario of banking information systems. In the architecture of the system, an ontology defines an intermediate semantic description for the source and target schemas. We introduce a reasoning method for the automatic extraction of migration rules starting from the semantic descriptions of the schemas. The procedure for computation of migration rules is then implemented via reasoning over an Answer Set Programming encoding.

References

  1. Serge Abiteboul, Richard Hull, and Victor Vianu. 1995. Foundations of Databases. Addison-Wesley. http://webdam.inria.fr/Alice/Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. F. Baader, D. Calvanese, D. McGuinness, D. Nardi, and P. Patel-Schneider (Eds.). 2003. The Description Logic Handbook. Cambridge University Press.Google ScholarGoogle Scholar
  3. Jesus Bisbal, Deirdre Lawless, Bing Wu, and Jane Grimson. 1999. Legacy Information Systems: Issues and Directions. IEEE Softw. 16, 5 (1999), 103--111.Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. Christian Bizer. 2003. D2R MAP - A Database to RDF Mapping Language. In Proceedings of the Twelfth International World Wide Web Conference - Posters, WWW 2003, Budapest, Hungary, May 20-24, 2003, Irwin King and Tamás Máray (Eds.). http://www2003.org/cdrom/papers/poster/p004/p4-bizer.htmlGoogle ScholarGoogle Scholar
  5. Gerhard Brewka, Thomas Eiter, and Miroslaw Truszczynski. 2011. Answer set programming at a glance. Commun. ACM 54, 12 (2011), 92--103.Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. Diego Calvanese, Avigdor Gal, Naor Haba, Davide Lanti, Marco Montali, Alessandro Mosca, and Roee Shraga. 2021. ADaMaP: Automatic Alignment of Relational Data Sources Using Mapping Patterns. In CAiSE (Lecture Notes in Computer Science), Vol. 12751. Springer, 193--209.Google ScholarGoogle Scholar
  7. Diego Calvanese, Avigdor Gal, Davide Lanti, Marco Montali, Alessandro Mosca, and Roee Shraga. 2020. Mapping Patterns for Virtual Knowledge Graphs. CoRR abs/2012.01917 (2020).Google ScholarGoogle Scholar
  8. Bernardo Cuenca Grau, Ian Horrocks, Boris Motik, Bijan Parsia, Peter F. Patel-Schneider, and Ulrike Sattler. 2008. OWL 2: The next step for OWL. Journal of Web Semantics 6, 4 (2008), 309--322.Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. Souripriya Das, Seema Sundara, and Richard Cyganiak. 2012. R2RML: RDB to RDF Mapping Language - W3C Recommendation 27 September 2012. Technical Report. W3C. https://www.w3.org/TR/r2rml/.Google ScholarGoogle Scholar
  10. Thomas Eiter, Giovambattista Ianni, Thomas Lukasiewicz, Roman Schindlauer, and Hans Tompits. 2008. Combining answer set programming with description logics for the Semantic Web. Artif. Intell. 172, 12-13 (2008), 1495--1539.Google ScholarGoogle Scholar
  11. Harshvardhan J. Pandit, Damien Graux, Fabrizio Orlandi, Ademar Crotti Junior, Declan O'Sullivan, and Dave Lewis. 2020. Semantic schema mapping for interoperable data-exchange. In OM@ISWC (CEUR Workshop Proceedings), Vol. 2788. CEUR-WS.org, 13--23.Google ScholarGoogle Scholar
  12. Manuel Rodriguez-Mancha, Hector G. Ceballos, Francisco J. Cantu, and Aldo Diaz-Prado. 2011. Mapping relational databases through ontology matching: a case study on information migration. In OM (CEUR Workshop Proceedings), Vol. 814. CEUR-WS.org.Google ScholarGoogle Scholar
  13. Mariano Rodriguez-Muro and Martín Rezk. 2015. Efficient SPARQL-to-SQL with R2RML mappings. J. Web Semant. 33 (2015), 141--169.Google ScholarGoogle ScholarCross RefCross Ref
  14. Andrei Tara, Alexandru Butean, Constantin-Bala Zamfirescu, and Robert Learney. 2020. An Ontology Model for Interoperability and Multi-organization Data Exchange. In CSOC (2) (Advances in Intelligent Systems and Computing), Vol. 1225. Springer, 284--296.Google ScholarGoogle Scholar
  15. Bernhard Thalheim and Qing Wang. 2013. Data migration: A theoretical perspective. Data Knowl. Eng. 87 (2013), 260--278.Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. Guohui Xiao, Diego Calvanese, Roman Kontchakov, Domenico Lembo, Antonella Poggi, Riccardo Rosati, and Michael Zakharyaschev. 2018. Ontology-Based Data Access: A Survey. In IJCAI. ijcai.org, 5511--5519.Google ScholarGoogle Scholar

Index Terms

  1. Ontology-Mediated Data Migration: Deriving Migration Rules by Reasoning on Schema Descriptions

      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
        SAC '23: Proceedings of the 38th ACM/SIGAPP Symposium on Applied Computing
        March 2023
        1932 pages
        ISBN:9781450395175
        DOI:10.1145/3555776

        Copyright © 2023 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: 7 June 2023

        Permissions

        Request permissions about this article.

        Request Permissions

        Check for updates

        Qualifiers

        • research-article

        Acceptance Rates

        Overall Acceptance Rate1,650of6,669submissions,25%
      • Article Metrics

        • Downloads (Last 12 months)31
        • Downloads (Last 6 weeks)8

        Other Metrics

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader