Ontology-Mediated Data Migration: Deriving Migration Rules by Reasoning on Schema Descriptions
Pages 1724 - 1731
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/
[2]
F. Baader, D. Calvanese, D. McGuinness, D. Nardi, and P. Patel-Schneider (Eds.). 2003. The Description Logic Handbook. Cambridge University Press.
[3]
Jesus Bisbal, Deirdre Lawless, Bing Wu, and Jane Grimson. 1999. Legacy Information Systems: Issues and Directions. IEEE Softw. 16, 5 (1999), 103--111.
[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.html
[5]
Gerhard Brewka, Thomas Eiter, and Miroslaw Truszczynski. 2011. Answer set programming at a glance. Commun. ACM 54, 12 (2011), 92--103.
[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.
[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).
[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.
[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/.
[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.
[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.
[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.
[13]
Mariano Rodriguez-Muro and Martín Rezk. 2015. Efficient SPARQL-to-SQL with R2RML mappings. J. Web Semant. 33 (2015), 141--169.
[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.
[15]
Bernhard Thalheim and Qing Wang. 2013. Data migration: A theoretical perspective. Data Knowl. Eng. 87 (2013), 260--278.
[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.
Index Terms
- Ontology-Mediated Data Migration: Deriving Migration Rules by Reasoning on Schema Descriptions
Recommendations
Improving Total Migration Time in Live Virtual Machine Migration
ICCCT '15: Proceedings of the Sixth International Conference on Computer and Communication Technology 2015Virtualization is the key underlying technology enabling cloud providers to host services for a large number of customers. Live migration is an essential feature of virtualization that allows transfer of virtual machines from one physical server to ...
Traffic-sensitive live migration of virtual machines
CCGRID '15: Proceedings of the 15th IEEE/ACM International Symposium on Cluster, Cloud, and Grid ComputingIn this paper we address the problem of network contention between the migration traffic and the Virtual Machine (VM) application traffic for the live migration of co-located Virtual Machines. When VMs are migrated with pre-copy, they run at the source ...
Live gang migration of virtual machines
HPDC '11: Proceedings of the 20th international symposium on High performance distributed computingThis paper addresses the problem of simultaneously migrating a group of co-located and live virtual machines (VMs), i.e, VMs executing on the same physical machine. We refer to such a mass simultaneous migration of active VMs as "live gang migration". ...
Comments
Please enable JavaScript to view thecomments powered by Disqus.Information & Contributors
Information
Published In
March 2023
1932 pages
ISBN:9781450395175
DOI:10.1145/3555776
- Conference Chairs:
- Jiman Hong,
- Maart Lanperne,
- Program Chairs:
- Juw Won Park,
- Tomas Cerny,
- Publication Chair:
- Hossain Shahriar
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].
Sponsors
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 07 June 2023
Check for updates
Author Tags
Qualifiers
- Research-article
Conference
SAC '23
Sponsor:
Acceptance Rates
Overall Acceptance Rate 1,650 of 6,669 submissions, 25%
Upcoming Conference
SAC '25
- Sponsor:
- sigapp
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 38Total Downloads
- Downloads (Last 12 months)18
- Downloads (Last 6 weeks)0
Reflects downloads up to 03 Jan 2025
Other Metrics
Citations
View Options
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in