Diseño de base de datos: Fundamentos teóricos y prácticos
Synopsis
The book Database Design: Theoretical and practical foundations offers a comprehensive introduction to database design, progressively addressing the conceptual, technical, and methodological foundations required for its proper implementation. Across five chapters, it presents the basic concepts of databases and the main data models, the relational model with its structure and constraints, and the fundamental principles of database design aimed at ensuring consistency, integrity, and efficiency in real-world environments. The database design process is also developed, including conceptual design using the Entity–Relationship model and logical design, with the transformation of conceptual schemas into relational schemas and the application of normalization as a key tool to reduce redundancy and prevent data anomalies. Each chapter includes practical exercises that reinforce the topics covered and allow theory to be applied through database design scenarios.
Downloads
References
Acharya, B., Jena, A. K., Chatterjee, J. M., Kumar, R., & Le, D.-N. (2019). NoSQL Database Classification: New Era of Databases for Big Data. International Journal of Knowledge-Based Organizations, 9(1), 50–65. https://doi.org/10.4018/IJKBO.2019010105
Aguilar Vera, R., Naal Jácome, A., Díaz Mendoza, J., Gómez Gómez, O., Aguilar Vera, R., Naal Jácome, A., Díaz Mendoza, J., & Gómez Gómez, O. (2023). NoSQL Database Modeling and Management: A Systematic Literature Review. Revista Facultad de Ingeniería, 32(65), e16519. https://doi.org/10.19053/01211129.V32.N65.2023.16519
Connolly, T., & Begg, C. (2015). Database Systems (6th ed.). Pearson.
Date, C. J. (2004). An Introduction to Database Systems (8th ed.). Pearson Educación.
DB-Engines. (n.d.). DB-Engines Ranking. Retrieved August 22, 2025, from https://db-engines.com/en/ranking
De Miguel, A., Piattini, M., & Marcos, E. (2000). Diseño de bases de datos relacionales. Ra-Ma.
Elmasri, R., & Navathe, S. B. (2011). Fundamentals of database systems (6th ed.). Pearson Education.
Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th editio). Pearson.
Garba, M., & Abubakar, H. (2020). A Comparison of NoSQL and Relational Database Management Systems (RDBMS). KASU JOURNAL OF MATHEMATICAL SCIENCE (Maths Access), 1(2), 61–69.
Gobert, M., Meurice, L., & Cleve, A. (2021). Conceptual Modeling of Hybrid Polystores. Lecture Notes in Computer Science (Including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 13011 LNCS, 113–122. https://doi.org/10.1007/978-3-030-89022-3_10/COVER
Huawei Technologies Co., Ltd. (2022). Database Principles and Technologies – Based on Huawei GaussDB (1st ed.). Springer Singapore. https://doi.org/https://doi.org/10.1007/978-981-19-3032-4
IAIDQ. (2016). IAIDQ-glossary. http://iaidq.org/main/glossary.shtml
ISO/IEC 2382-1. (1993). ISO/IEC 2382-1:1993, Information technology — Vocabulary — Part 1: Fundamental terms. https://www.iso.org/obp/ui/#iso:std:iso-iec:2382:-1:ed-3:v1:en
Jatana, N., Puri, S., Ahuja, M., Kathuria, I., & Gosain, D. (2012). A Survey and Comparison of Relational and Non-Relational Database. International Journal of Engineering Research & Technology (IJERT), 1(6).
Kroenke, D. M. ., Auer, D. J. ., Vandenberg, S. L. ., & Yoder, R. C. . (2018). Database processing : fundamentals, design, and implementation. Pearson. https://unidel.edu.ng/focelibrary/books/Database Processing Fundamentals, Design, and Implementation by David M. Kroenke, David J. Auer, Robert C. Yoder, Scott L. Vandenberg (z-lib.org).pdf
Lemahieu, W., Broucke, S. vanden, & Baesens, B. (2018). Principles of Database Management: The Practical Guide to Storing, Managing and Analyzing Big and Small Data. Principles of Database Management. https://doi.org/10.1017/9781316888773
Lucas Gomez, A. (1993). Diseño y gestión de sistemas de bases de datos (1st ed.). Editorial Paraninfo.
Marqués, M. (2011). Bases de datos (1st ed.). Universitat Jaume I.
Martinez-Mosquera, D., Navarrete, R., & Lujan-Mora, S. (2020). Modeling and management big data in databases-A systematic literature review. Sustainability (Switzerland), 12(2). https://doi.org/10.3390/SU12020634
Mendelzon, A. (2000). Introducción a las Bases de datos relacionales (1st ed.). Pearson Educación.
Piñeiro Gómez, J. M. (2013). Bases de datos relacionales y modelado de datos (1st ed.). Paraninfo.
Rodriguez, I. E. (2020). Metadatos estadísticos para el aseguramiento de la calidad de los datos. Universidad Nacional de Colombia - Sede Medellín.
Rowley, J. (2007). The wisdom hierarchy: Representations of the DIKW hierarchy. Journal of Information Science, 33(2), 163–180. https://doi.org/10.1177/0165551506070706;CTYPE:STRING:JOURNAL
Shin, K., Hwang, C., & Jung, H. (2017). NoSQL database design using UML conceptual data model based on peter chen’s framework. International Journal of Applied Engineering Research, 12(5), 632–636.
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2014). Fundamentos de bases de datos. McGraw-Hill Interamericana de España.
Tripathi, N. (2025). NoSQL database education: A review of models, tools and teaching methods. Journal of Systems and Software, 226, 112391. https://doi.org/10.1016/J.JSS.2025.112391
Veerappampalayam, S., Anilkumar, C., Rajendran, R., Priyanka, P., Prabhakar, A. V., & Moorthy, U. (2025). Next-Generation Databases: A Comparative Insight into NoSQL and NewSQL Systems. 2025 International Conference on Emerging Technologies in Engineering Applications, ICETEA 2025 - Proceedings. https://doi.org/10.1109/ICETEA64585.2025.11099997
Downloads
Published
License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.