SQLtoKeyNoSQL
Geomar A. Schreiner, Denio Duarte, Ronaldo dos Santos Mello · 2015
Today, many applications produce and manipulate a large volume of data, the so-called Big Data. Traditional databases (DB), like relational databases, are not suitable to Big Data management. In order to solve this problem, a new category of DB has been proposed, the so-called NoSQL DB. NoSQL DB have different data models, as well as different access methods which are not usually compatible with the SQL language. In this context, approaches have been proposed for providing mapping of relational DB schemata and operations to equivalent ones in NoSQL DB to deal with large relational data sets in the cloud, focusing on scalability and availability. However, these approaches map relational DB only to a single NoSQL data model and, sometimes, to a specific NoSQL DB product. This paper presents SQLtoKeyNoSQL, a layer able to translate relational schemata as well as SQL commands to equivalent schemata and access methods to any key-oriented NoSQL DB (document-oriented, key-value and column-oriented). We present the architecture of our layer focusing on our mapping strategies, as well as some preliminary experiments that evaluate the impact of SQLtoKeyNoSQL as a solution for transparent mapping of relational DB to key-based NoSQL DB.