Data Integration over NoSQL Stores Using Access Path Based Mappings

Abstract : Due to the large amount of data generated by user interactions on the Web, some companies are currently innovating in the domain of data management by designing their own systems. Many of them are referred to as NoSQL databases, standing for 'Not only SQL'. With their wide adoption will emerge new needs and data integration will certainly be one of them. In this paper, we adapt a framework encountered for the integration of relational data to a broader context where both NoSQL and relational databases can be integrated. One important extension consists in the efficient answering of queries expressed over these data sources. The highly denormalized aspect of NoSQL databases results in varying performance costs for several possible query translations. Thus a data integration targeting NoSQL databases needs to generate an optimized translation for a given query. Our contributions are to propose (i) an access path based mapping solution that takes benefit of the design choices of each data source, (ii) integrate preferences to handle conflicts between sources and (iii) a query language that bridges the gap between the SQL query expressed by the user and the query language of the data sources. We also present a prototype implementation, where the target schema is represented as a set of relations and which enables the integration of two of the most popular NoSQL database models, namely document and a column family stores.
Type de document :
Communication dans un congrès
DEXA 2012, Aug 2011, Toulouse, France. 6860, pp.481-495, 2011, Lecture Notes in Computer Science. 〈10.1007/978-3-642-23088-2_36〉
Liste complète des métadonnées

Littérature citée [9 références]  Voir  Masquer  Télécharger

https://hal-upec-upem.archives-ouvertes.fr/hal-00738356
Contributeur : Olivier Curé <>
Soumis le : jeudi 4 octobre 2012 - 10:20:10
Dernière modification le : mardi 22 mai 2018 - 20:40:06
Document(s) archivé(s) le : samedi 5 janvier 2013 - 03:58:05

Fichier

finalDEXA.pdf
Fichiers éditeurs autorisés sur une archive ouverte

Identifiants

Citation

Olivier Curé, Robin Hecht, Chan Le Duc, Myriam Lamolle. Data Integration over NoSQL Stores Using Access Path Based Mappings. DEXA 2012, Aug 2011, Toulouse, France. 6860, pp.481-495, 2011, Lecture Notes in Computer Science. 〈10.1007/978-3-642-23088-2_36〉. 〈hal-00738356〉

Partager

Métriques

Consultations de la notice

448

Téléchargements de fichiers

1346