Nothing Special   »   [go: up one dir, main page]

Skip to main content

NoSQL2: SQL to NoSQL Databases

  • Conference paper
  • First Online:
Trends and Advances in Information Systems and Technologies (WorldCIST'18 2018)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 746))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

Notes

  1. 1.

    http://db-engines.com/en/ranking.

References

  1. Abadi, D., Agrawal, R., Ailamaki, A., Balazinska, M.: The Beckman report on database research. Commun. ACM 59, 92–99 (2016)

    Article  Google Scholar 

  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. Adriana, J., Holanda, M.: Brasilia’s database administrators. J. Inf. Syst. Eng. Manag. 1(3), 149–157 (2016)

    Google Scholar 

  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. 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

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  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. 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)

    Chapter  Google Scholar 

  9. Corbellini, A., Mateos, C., Zunino, A., Godoy, D., Schiaffino, S.: Persisting big-data: the NoSQL landscape. Inf. Syst. 63, 1–23 (2016)

    Article  Google Scholar 

  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. 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)

    Article  Google Scholar 

  12. Elmasri, R., Navathe, S.B., Pinheiro, M.G.: Sistemas de Banco de Dados. Pearson Addison-Wesley, São Paulo (2011)

    Google Scholar 

  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. 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. 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. 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

  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. 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)

    Article  Google Scholar 

  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. 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. 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. 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. 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. 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. 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. 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. 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 

Download references

Author information

Authors and Affiliations

Authors

Corresponding authors

Correspondence to Jane Adriana or Maristela Holanda .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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)

Publish with us

Policies and ethics