Parallelisms between relational and non-relational databases (a security approach)
DOI:
https://doi.org/10.32870/recibe.v10i2.189Keywords:
Information Security, Databases, Relational Databases, Non-Relational Databases, PostgreSQL, MongoDBAbstract
Databases were born as a tool for standardized storage in applications, with technological advance it arises different approaches of how to relate the data that is stored on them. Comparing two technologies with the same purpose, but with a different philosophy, can help to understand why each one was conceived; and have a better perspective on how they can be complemented and improved, through different practices. Despite there are different comparative studies on relational and non-relational databases, all based on performance and not in security perspective. The study aims to compare the securities in relational and non-relational databases in order to find differences and similarities between relational and non-relational databases. The comparative methodology, which is carried out with servers in the cloud, provides an appropriate environment to carry out the experiment between two well-known and open-access databases PostgreSQL and MongoDB, the first being a type of relational base and the second is an non-relational (NoSql), to generate as a result a comparison that is disseminated in the community scientific.References
Bernstein, P. A., & Goodman, N. (1983). Multiversion concurrency control—Theory and algorithms. ACM Transactions on Database Systems, 8(4), 465-483. https://doi.org/10.1145/319996.319998
Codd, E. F. (1970). A Relational Model of Data for Large Shared Data Banks. 13(6), 11.
Coronel, C., Morris, S., & Rob, P. (2010). Bases de datos [recurso electrónico]: Datos, implementación y administración. (9.a ed.). Cengage Learning Editores, S.A. de C.V.
Date, C. J. (2001). Introducción a los sistemas de bases de datos. Pearson Educación.
Edward, S. G., & Sabharwal, N. (2015). Practical MongoDB. Apress. https://doi.org/10.1007/978-1-4842-0647-8
Giamas, A. (2019). Mastering MongoDB 4.x: Expert techniques to run high-volume and fault-tolerant database solutions using MongoDB 4.x, 2nd Edition. Packt Publishing Ltd.
Gilbert, S., & Lynch, N. (2012). Perspectives on the CAP Theorem. Computer, 45(2), 30-36. https://doi.org/10.1109/MC.2011.389
Harrison, G. (2015). Next Generation Databases. Apress. https://doi.org/10.1007/978-1-4842-1329-2
Lockhart, T. (Ed.). (1996). Manual del usuario de PostgreSQL.
MongoDB Locks—Shared, Exclusive and Intent Modes. (2018). TutorialKart. https://www.tutorialkart.com/mongodb/mongodb-locks/
Nwankwo, W. (2020). A Review of Critical Security Challenges in SQL-based and NoSQL Systems from 2010 to 2019. International Journal of Advanced Trends in Computer Science and Engineering, 9(2), 2029-2035. https://doi.org/10.30534/ijatcse/2020/174922020
Perkins, L., Redmond, E., & Wilson, J. R. (2018). Seven Databases in Seven Weeks. Pragmatic Programmers.
Ricardo, C. M. (2009). Bases de datos. The McGraw-Hil.
rubenfa. (2014, enero 28). NoSQL: Clasificación de las bases de datos según el teorema CAP. Genbeta. https://www.genbeta.com/desarrollo/nosql-clasificacion-de-las-bases-de-datos-segun-el-teorema-cap
Sánchez Asenjo, J. (2009). Sistemas Gestores de Bases de Datos (Autoedicion).
The MongoDB 4.4 Manual—MongoDB Manual. (s. f.). Https://Github.Com/Mongodb/Docs/Blob/Master/Source/Index.Txt. Recuperado 11 de diciembre de 2020, de https://docs.mongodb.com/manual/
The OWASP Foundation. (2017). OWASP Top 10—2017 Los diez riesgos más críticos en Aplicaciones Web. The OWASP Foundation. https://wiki.owasp.org/images/5/5e/OWASP-Top-10-2017-es.pdf
Tonon, G. (2011). La Utilización Del Método Comparativo En Estudios Cualitativos En Ciencia Política Y Ciencias Sociales: Diseño y desarrollo de una tesis doctoral. https://dialnet.unirioja.es/descarga/articulo/3702607.pdf
