NoSQL2: SQL to NoSQL Databases

  • Jane Adriana
  • Maristela Holanda
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 746)


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.


SQL NoSQL Big Data DBA Query DDL 


  1. 1.
    Abadi, D., Agrawal, R., Ailamaki, A., Balazinska, M.: The Beckman report on database research. Commun. ACM 59, 92–99 (2016)CrossRefGoogle Scholar
  2. 2.
    Adriana, J., Holanda, M.: Query languages in NoSQL databases. In: Handbook of Research on Innovative Database Query Processing Techniques, vol. 1. IGI Global, Hershey (2015)Google Scholar
  3. 3.
    Adriana, J., Holanda, M.: Brasilia’s database administrators. J. Inf. Syst. Eng. Manag. 1(3), 149–157 (2016)Google Scholar
  4. 4.
    Bach, M., Werner, A.: Standardization of NoSQL database languages. In: 10th IEEE Beyond Databases, Architectures, and Structure (BDAS), pp. 50–60 (2014)Google Scholar
  5. 5.
    Bugiotti, F., Atzeni, P., Rossi, L.: Uniform access to NoSQL systems. Inf. Syst. 43, 117–133 (2014). Scholar
  6. 6.
    Buneman, P., Fernandez, M., Suciu, D.: UnQL: a query language and algebra for semistructured data based on structural recursion. VLDB J. 9(1), 76–110 (2000)CrossRefGoogle Scholar
  7. 7.
    Burdakov, A., Grigorev, U., Ploutenko, A., Ttsviashchenko, E.: Estimation models for NoSQL database consistency characteristics. In: 24th Euromicro International Conference on Parallel, Distributed, and Network-Based Processing, pp. 35–42 (2016)Google Scholar
  8. 8.
    Calil, A., dos Santos Mello, R.: SimpleSQL a relational layer for SimpleDB. In: 16th East European conference on Advances in Databases and Information System (ADBIS), Poznan, Poland, pp. 99–110. Springer, Heidelberg (2011)CrossRefGoogle Scholar
  9. 9.
    Corbellini, A., Mateos, C., Zunino, A., Godoy, D., Schiaffino, S.: Persisting big-data: the NoSQL landscape. Inf. Syst. 63, 1–23 (2016)CrossRefGoogle Scholar
  10. 10.
    Costa, A.V., Vilian, P., dos Santos Mello, R.: Layer for the mapping management of SQL DML instructions to the key-value NoSQL database Voldemort. In: XII Brazilian Symposium on Information Systems, Florianopolis, SC, pp. 224–231 (2016)Google Scholar
  11. 11.
    Dourish, P., Edwards, W.K., LaMarca, A., Salisbury, M.: Presto: an experimentation architecture for fluid interactive document spaces. ACM Trans. Comput.-Hum. Interact. (TOCHI) 6(2), 133–161 (1999)CrossRefGoogle Scholar
  12. 12.
    Elmasri, R., Navathe, S.B., Pinheiro, M.G.: Sistemas de Banco de Dados. Pearson Addison-Wesley, São Paulo (2011)Google Scholar
  13. 13.
    Farias, V.A.E., Sousa, F.R.C., Maia, J.G.R., Gomes, J.P.P., Machado, J.C.: Machine learning approach for cloud NoSQL databases performance modeling. In: 16th IEEE/ACM International Symposium on Cluster, pp. 617–620. Federal University of Ceara (2016)Google Scholar
  14. 14.
    Gessert, F., Ritter, N.: Scalable data management: NoSQL data stores research and practice. In: IEEE 32nd International Conference on Data Engineering (ICDE), pp. 1420–1423. University of Hamburg (2016)Google Scholar
  15. 15.
    Gomez, P., Casallas, R., Roncancio, C.: Data schema does matter, even in NoSQL systems! In: IEEE Tenth International Conference on Research Challenges in Information Science (RCIS), pp. 1–6 (2016)Google Scholar
  16. 16.
    Gonzalez-Aparicio, M.T., Younas, M., Tuya, J., Casado, R.: A new model for testing CRUD operations. In: IEEE 30th International Conference on Advanced Information Networking and Applications, pp. 79–86 (2016). 11, 13, 18, 45
  17. 17.
    Guo, M., Qian, K., Yang, L.: Hands-on labs for learning mobile and NoSQL database security. In: IEEE 40th Annual Computer Software and Applications, pp. 606–607 (2016)Google Scholar
  18. 18.
    Holt, V., Ramage, M., Kear, K., Heap, N.: The usage of best practices and procedures in the database community. Inf. Syst. 49, 163–181 (2015)CrossRefGoogle Scholar
  19. 19.
    Kornacker, M., Behm, A., Bittorf, V., Bobrovytsky, T., Ching, C., Choi, A., Erickson, J., Grund, M., et al.: Impala: a modern, open-source SQL engine for Hadoop. In: CIDR (2015)Google Scholar
  20. 20.
    Lee, C.-H., Zheng, Y.-L.: Automatic SQL-to-NoSQL schema transformation over the MySQL and HBase databases. In: International Conference on Consumer Electronics Taiwan (ICCE-TW), pp. 426–427 (2015)Google Scholar
  21. 21.
    Lehmayr, P., Rith, J., Meyer-Wegener, K.: Speaking in tongues: SQL access to NoSQL systems. In: 29th Annual ACM Symposium on Applied Computing, Gyeongju, Republic of Korea, pp. 855–857 (2014)Google Scholar
  22. 22.
    Liu, Z.H., Hammerschmidt, B., McMahon, D., Liu, Y., Chang, H.J.: Closing the functional and performance gap between SQL and NoSQL. In: International Conference on Management of Data SIGMOD, Redwood Shores, CA 94065, USA, pp. 227–238 (2016)Google Scholar
  23. 23.
    Porkorny, J.: NoSQL databases: a step to database scalability in web environment. In: 13th International Conference on Information Integration and Web based Applications and Services, pp. 69–82. ACM, Faculty of Mathematics and Physics, Praha, Czech Republic (2013)Google Scholar
  24. 24.
    Ringlstetter, A., Scherzinger, S., Bissyande, T.F.: Data model evolution using object-NoSQL mappers: folklore or state-of-the-art? In: 2nd International Workshop on BIG Data Software Engineering, BIGDSE, Austin, Texas, pp. 33–36 (2016)Google Scholar
  25. 25.
    Schreiner, G.A.: SQLToKeyNoSQL: uma camada para mapeamento de esquemas relacionais e de operações SQL para bancos de dados NoSQL baseados em chaves de acesso. Ph.D. thesis, Universidade Federal de Santa Catarina, Florianópolis, Brasil (2016)Google Scholar
  26. 26.
    Sharma, S., Shandilya, R., Patnaik, S., Mahapatra, A.: Leading NoSQL model for handling big data: a brief review. Int. J. Bus. Inf. Syst. (IJBIS) 22(1), 1–25 (2017)Google Scholar
  27. 27.
    Silva, Y.N., Almeida, I., Queiroz, M.: SQL: from traditional databases to big data. In: 47th ACM Technical Symposium on Computing Science Education, SIGCSE, Memphis, United States, pp. 413–418 (2016)Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceUniversity of BrasiliaBrasiliaBrazil

Personalised recommendations