NoSQL2: SQL to NoSQL databases

Abstract

New database models, called NoSQL (Not Only SQL) are considered appropriate alternatives for managing and storing Big Data due to their efficiency, high scalability, availability and performance. Database administration affects tasks such as creating databases and objects, attributing priorities and performing backup activities. The execution of these tasks, in NoSQL databases, requires that database administrators (DBAs) have particular expertise in using these databases, and, subsequently, reveals the problems that arise with DBA unfamiliarity of the NoSQL environments. In order to contribute to this field, this paper presents the middleware, NoSQL2, which performs management tasks using the SQL language running on different NoSQL databases. The NoSQL2 allows DBAs to disassociate themselves from the particularities of accessing each NoSQL, since it provides resources for converting SQL commands to the proprietary NoSQL database syntax.