A Layer for the Mapping Management of SQL DML Instructions to the Key-Value NoSQL Database Voldemort
Augusto Verzbickas Da Costa, Patrícia Vilain, Ronaldo S. Mello · IEEE International Conference on Cloud Computing Technology and Science · 2016
Information systems that uses relational databases for data maintenance are increasingly migrating to cloud databases in order to minimize costs related to the management of huge data volumes. In this context, NoSQL databases are good options, in particular, the key-value databases, which present a simple data model and scalable solutions. Even that, the costs regarding the migration to a NoSQL data management may be high, mainly in terms of source code updating of the information system for adapting database access interfaces. This paper presents VoldemortSQL, a layer that maps SQL DML instructions to the access methods of the NoSQL key-value database Voldemort with the purpose of avoiding the laborious work with data and access interface migrations from a relational database to Voldemort. The usage of this layer allows the manipulation of data in the cloud through the continuous usage of the SQL standard. An experimental evaluation had demonstrated that the overhead introduced with the layer is not prohibitive