Design and Implementation of the CloudMdsQL Multistore System

Boyan Kolev (1) , Carlyna Bondiombouy (1) , Oleksandra Levchenko (1) , Patrick Valduriez (1) , Ricardo Jimenez-Péris (2) , Raquel Pau (3) , Jose Pereira (4)

1 ZENITH - Scientific Data Management
2 UPM - Universidad Politécnica de Madrid
3 Sparcity Technologies [Barcelone]
4 INESC TEC - Institute for Systems and Computer Engineering, Technology and Science [Porto]

The blooming of different cloud data management infrastructures has turned multistore systems to a major topic in the nowadays cloud landscape. In this paper, we give an overview of the design of a Cloud Multidatastore Query Language (CloudMdsQL), and the implementation of its query engine. CloudMdsQL is a functional SQL-like language, capable of querying multiple heterogeneous data stores (relational, NoSQL, HDFS) within a single query that can contain embedded invocations to each data store's native query interface. The major innovation is that a CloudMdsQL query can exploit the full power of local data stores, by simply allowing some local data store native queries (e.g. a breadth-first search query against a graph database) to be called as functions, and at the same time be optimized.

Mots clés: Cloud; Multistore System; Heterogeneous Data Stores; SQL and NoSQL Integration

Domaines: Base de données [cs.DB]

Boyan Kolev, Carlyna Bondiombouy, Oleksandra Levchenko, Patrick Valduriez, Ricardo Jimenez-Péris, et al.. Design and Implementation of the CloudMdsQL Multistore System. CLOSER: Cloud Computing and Services Science, Apr 2016, Roma, Italy. pp.352-359, ⟨10.5220/0005923803520359⟩. ⟨lirmm-01341172⟩