New Perspectives for NoSQL Database Design: A Systematic Review

  • Cristofer Zdepski Federal University of Technology – Parana (UTFPR), Address Doutor Washington Subtil Chueire,330-Jardim Carvalho, Ponta Grossa, 84017-220, Parana, Brazil
  • Tarcizio Alexandre Bini Federal University of Technology – Parana (UTFPR), Address Doutor Washington Subtil Chueire,330-Jardim Carvalho, Ponta Grossa, 84017-220, Parana, Brazil
  • Simone Nasser Matos Federal University of Technology – Parana (UTFPR), Address Doutor Washington Subtil Chueire,330-Jardim Carvalho, Ponta Grossa, 84017-220, Parana, Brazil
Keywords: database design, NoSQL, polyglot persistence

Abstract

The use of NoSQL databases has increasingly become a trend in software development, mainly due to the expansion of Web 2.0 systems. However, there is not yet a standard to be used for the design of this type of database even with the growing number of studies related to this subject. This paper presents a systematic review looking for new trends regarding strategies used in this context. The result of this process demonstrates that there are still few methodologies for the NoSQL database design and there are no design methodologies capable of working with polyglot persistence.

References

. P. J. Sadalage, M. Fowler. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley Professional, 2012, pp. 25-38.

. V. Holt, M. Ramage, K. Kear, and Heap, N. "The usage of best practices and procedures in the database community". Information Systems, 49.163-181, 2015.

. R. De Virgilio, A. Maccioni, R. Torlone. "Model-driven design of graph databases" in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 8824. Springer International Publishing Switzerland, 2014, pp. 172-185.

. R. Shabana, B. Imran, K. Rafaqat. "Challenges in NoSQL-Based Distributed Data Storage: A Systematic Literature Review". Electronics, vol. 8, pp. 488, 2019.

. J. Akoka, I. Comyn-Wattiau and N. Laoufi. "Research on Big Data - A systematic mapping study". Computer Standards & Interfaces, vol. 54, pp. 105-115, 2017.

. J. R. Lourenço, B. Cabral, P. Carreiro, M. Vieira, J. Bernardino. "Choosing the right nosql database for the job: a quality attribute evaluation". Journal of Big Data, vol. 2, pp. 1-18, 2015.

. K. Grolinger, W. A. Higashino, A. Tiwari, M. A. Capretz. "Data management in cloud environments: NoSQL and NewSQL data stores". Journal of Cloud Computing: Advances, Systems and Applications, vol. 2, pp. 1-22, 2013.

. R. N. Pagani, J. a. L. Kovaleski, L. M. Resende. "Methodi ordinatio: A proposed methodology to select and rank relevant scientific papers encompassing the impact factor, number of citation, and year of publication". Scientometrics, vol. 105, pp. 2109-2135, 2015.

. D. Buchinger, G. Cavalcanti, M. Hounsell. "Mecanismos de busca acadêmica: uma análise quantitativa". Revista Brasileira de Computação Aplicada, vol. 6, pp. 108-120, 2014.

. R. Cattell. "Scalable SQL and NoSQL data stores". ACM SIGMOD Record, vol. 39, pp. 12, 2011.

. P. Atzeni, F. Bugiotti, L. Rossi. "Uniform access to non-relational database systems: The SOS platform" in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 7328. LNCS, 2012, pp. 160-174.

. P. Atzeni, F. Bugiotti, L. Rossi. "Uniform access to NoSQL systems". Information Systems, vol. 43, pp. 117-133, Jul. 2014.

. F. Bugiotti, L. Cabibbo, P. Atzeni and R. Torlone. "Database Design for NoSQL Systems" in Conceptual Modeling, vol. 8824. Springer International Publishing, 2014, pp. 223-231.

. K. Srivastava and N. Shekokar. “A Polyglot Persistence approach for E-Commerce business model.” in Proceedings - 2016 International Conference on Information Science-ICIS, 2016, pp. 7-11.

. A. de la Vega, D. García-Saiz, C. Blanco, M. E. Zorrilla, P. Sánchez. “Mortadelo: A Model-Driven Framework for NoSQL Database Design” in MED, 2018, pp. 41-57.

. M. Y. Santos and C. Costa. "Data models in NoSQL databases for big data contexts" in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 9714. LNCS, 2016, pp. 475-485.

. M. J. Mior, K. Salem, A. Aboulnaga, and R. Liu. "NoSE: Schema design for NoSQL applications". IEEE Transactions on Knowledge and Data Engineering, vol. 29, pp. 2275-2289, 2017.

. A. A. Imam, S. Basri, R. Ahmad, J. Watada, and M. T. González-Aparicio. "Automatic schema suggestion model for NoSQL document-stores databases". Journal of Big Data, vol. 5, pp. 46, Dec. 2018.

. E. Gallinucci, M. Golfarelli, and S. Rizzi. "Schema profiling of document-oriented databases". Information Systems, vol. 75, pp. 13-25, Jun. 2018.

. B. Kolev, P. Valduriez, C. Bondiombouy, R. Jiménez-Peris, R. Pau and J. Pereira. "CloudMdsQL: querying heterogeneous cloud data stores with a common language". Distributed and Parallel Databases, vol. 34, pp. 463-503, Dec. 2016.

. C. Zdepski, T. A. Bini, S. N. Matos. “An Approach for Modeling Polyglot Persistence” in Proceedings International Conference on Enterprise Information Systems-ICEIS, 2018, pp. 120-126.

Published
2020-05-15
Section
Articles