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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
Notes
References
Abadi, D., Agrawal, R., Ailamaki, A., Balazinska, M.: The Beckman report on database research. Commun. ACM 59, 92–99 (2016)
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)
Adriana, J., Holanda, M.: Brasilia’s database administrators. J. Inf. Syst. Eng. Manag. 1(3), 149–157 (2016)
Bach, M., Werner, A.: Standardization of NoSQL database languages. In: 10th IEEE Beyond Databases, Architectures, and Structure (BDAS), pp. 50–60 (2014)
Bugiotti, F., Atzeni, P., Rossi, L.: Uniform access to NoSQL systems. Inf. Syst. 43, 117–133 (2014). https://doi.org/10.1016/j.is.2013.05.002
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)
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)
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)
Corbellini, A., Mateos, C., Zunino, A., Godoy, D., Schiaffino, S.: Persisting big-data: the NoSQL landscape. Inf. Syst. 63, 1–23 (2016)
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)
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)
Elmasri, R., Navathe, S.B., Pinheiro, M.G.: Sistemas de Banco de Dados. Pearson Addison-Wesley, São Paulo (2011)
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)
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)
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)
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). https://doi.org/10.1109/AINA.2016. 11, 13, 18, 45
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG, part of Springer Nature
About this paper
Cite this paper
Adriana, J., Holanda, M. (2018). NoSQL2: SQL to NoSQL Databases. In: Rocha, Á., Adeli, H., Reis, L., Costanzo, S. (eds) Trends and Advances in Information Systems and Technologies. WorldCIST'18 2018. Advances in Intelligent Systems and Computing, vol 746. Springer, Cham. https://doi.org/10.1007/978-3-319-77712-2_89
Download citation
DOI: https://doi.org/10.1007/978-3-319-77712-2_89
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-77711-5
Online ISBN: 978-3-319-77712-2
eBook Packages: EngineeringEngineering (R0)