Application of Database Normalization in Increasing Data Storage Efficiency

Authors

DOI:

https://doi.org/10.33050/italic.v3i2.799

Keywords:

Database Normalization, Data Storage Efficiency, Relational Database Design, Data Redundancy, Data Integrity

Abstract

Database normalization is a key process in relational database design that reduces redundancy and ensures data integrity. As data volumes increase, maintaining efficient and consistent storage becomes critical. This study investigates the application of normalization techniques from First Normal Form (1NF) to Third Normal Form (3NF) on a sample inventory database to evaluate their impact on storage efficiency. The process focuses on eliminating data repetition and optimizing table structures to enhance performance. Experimental results show that normalization reduces database size by approximately 30%, significantly minimizing redundancy. Smaller, more organized tables improve storage utilization, especially in large-scale systems. However, normalization can introduce query complexity due to increased joins, potentially affecting execution time. Despite this, the trade-off is considered acceptable given the gains in data integrity and storage optimization. This research emphasizes the value of normalization for scalable and maintainable systems. It also aligns with Sustainable Development Goals (SDGs), particularly Goal 9 (Industry, Innovation, and Infrastructure) and Goal 12 (Responsible Consumption and Production), by promoting efficient digital infrastructure and responsible data management practices. These improvements contribute to more sustainable, cost-effective systems in industries relying on large-scale data, such as e-commerce, healthcare, and finance. In conclusion, normalization is an essential tool for optimizing storage and ensuring data consistency in relational databases. Although performance trade-offs exist, they can be mitigated through indexing and query optimization. The study offers insights for database designers seeking to balance efficiency and system performance in data-intensive environments.

References

T. Taipalus, “On the effects of logical database design on database size, query complexity, query performance, and energy consumption,” arXiv preprint, 2025, arXiv:2501.07449. [Online]. Available: https://arxiv.org/abs/2501.07449

UK Government Digital Service, “Open standards principles: For software interoperability, data and document formats in government it,” https://www.gov.uk/government/publications/open-standards-principles/open-standards-principles, 2022, policy document, UK Government DigitalService.

U.S. Federal Government, “Dcat-us schema and the open government data act,” https://resources.data.gov/standards/catalog/dcat-us/, 2020, federal Data Strategy Action 20, U.S. Government.

A. Kaboli, A. Mascolo, and A. Shaikhha, “A unified architecture for efficient binary and worst-case optimal join processing,” arXiv preprint, 2025, arXiv:2505.19918. [Online]. Available: https://arxiv.org/abs/2505.19918

U. Rusilowati, H. R. Ngemba, R. W. Anugrah, A. Fitriani, and E. D. Astuti, “Leveraging ai for superior efficiency in energy use and development of renewable resources such as solar energy, wind, and bioenergy,” International Transactions on Artificial Intelligence, vol. 2, no. 2, pp. 114–120, 2024.

D. Hernandez, L. Pasha, D. A. Yusuf, R. Nurfaizi, and D. Julianingsih, “The role of artificial intelligence in sustainable agriculture and waste management: Towards a green future,” International Transactions on Artificial Intelligence, vol. 2, no. 2, pp. 150–157, 2024.

H. Kalumin and A. Deshpande, “Optimizing queries with many-to-many joins,” arXiv preprint, 2024, arXiv:2412.16323v2. [Online]. Available: https://arxiv.org/abs/2412.16323

R. Aprianto, E. P. Lestari, E. Fletcher et al., “Harnessing artificial intelligence in higher education: Balancing innovation and ethical challenges,” International Transactions on Education Technology (ITEE), vol. 3, no. 1, pp. 84–93, 2024.

S. Belefqih, A. Zellou, and M. Berquedich, “Semantic schema extraction in nosql databases using bert embeddings,” Data Science Journal, vol. 23, p. 57, 2024.

H. Nurhaeni, A. Delhi, O. P. M. Daeli, S. A. Anjani, and N. A. Yusuf, “Optimizing electrical energy use through ai: An integrated approach for efficiency and sustainability,” International Transactions on Artificial Intelligence, vol. 2, no. 2, pp. 106–113, 2024.

T. Pujiati, H. Setiyowati, B. Rawat, N. P. L. Santoso, and M. G. Ilham, “Exploring the role of artificial intelligence in enhancing environmental health: Utaut2 analysis,” Sundara Advanced Research on Artificial Intelligence, vol. 1, no. 1, pp. 37–46, 2025.

F. Abdelhedi, A. A. Brahim, H. Rajhi, R. T. Ferhat, and G. Zurfluh, “Automatic extraction of a document oriented nosql schema,” in Proceedings of the 23rd International Conference on Enterprise Information Systems (ICEIS 2021), Volume 1. SciTePress, 2021, pp. 192–199.

M. Annas and T. Handra, “High rate of turnover intention: Study of logistics industrial workers,” Startupreneur Business Digital (SABDA Journal), vol. 2, no. 2, pp. 106–117, 2023.

S. B. Altinis¸ik and T. T. Bilgin, “Optimizing big data management on microsoft sql server: Enhancing performance through normalization and advanced analytical techniques,” International Journal of Innovative Engineering Applications, vol. 9, no. 1, pp. 23–36, 2025.

V. El Ardeliya, J. Taylor, and J. Wolfson, “Exploration of artificial intelligence in creative fields: Generative art, music, and design,” International Journal of Cyber and IT Service Management, vol. 4, no. 1, pp. 40–46, 2024.

M. Willsey, Y. Wang, and D. Suciu, “Free join: Unifying worst-case optimal and traditional joins,” in SIGMOD / arXiv preprint (authors’ submission), 2023, authors provide code and experimental evaluation; arXiv:2301.10841. [Online]. Available: https://arxiv.org/abs/2301.10841

U. Rahardja, T. Hongsuchon, T. Hariguna, and A. Ruangkanjanases, “Understanding impact sustainable intention of s-commerce activities: The role of customer experiences, perceived value, and mediation of relationship quality,” Sustainability, vol. 13, no. 20, p. 11492, 2021.

I. Handayani, D. Apriani, M. Mulyati, A. R. A. Zahra, and N. A. Yusuf, “Enhancing security and privacy of patient data in healthcare: A smartpls analysis of blockchain technology implementation,” IAIC Transactions on Sustainable Digital Innovation (ITSDI), vol. 5, no. 1, pp. 8–17, 2023.

Community, “Worst-case optimal joins: Survey and implementations (2020-2022),” Online Survey / Repository, 2022. [Online]. Available: https://paperswithcode.com/

D. S. S. Wuisan, R. A. Sunardjo, Q. Aini, N. A. Yusuf, and U. Rahardja, “Integrating artificial intelligence in human resource management: A smartpls approach for entrepreneurial success,” Aptisi Transactions on Technopreneurship (ATT), vol. 5, no. 3, pp. 334–345, 2023.

I. Gonz´alez-Aparicio et al., “Normalization considerations for document-oriented db migrations,” in Proceedings of a database migration workshop, 2021.

D. A. Prabowo, C. Tariazela, and A. Birgithri, “An examination of the impact of using marketplaces to promote the growth of micro, small, and medium enterprises (msmes) in indonesia,” Startupreneur Business Digital (SABDA Journal), vol. 3, no. 1, pp. 26–33, 2024.

L. Zhang and H. Chen, “Trade-offs between normalization and denormalization for scalable systems,” Journal of Data Intensive Systems, 2020, survey + experiments.

B. E. Sibarani, S. Setiawan, T. Hadi, T. Williams, and T. Mkhize, “Use of analytical data in marketing strategy to maintain customer loyalty,” MENTARI Journal: Management, Education and Information Technology, vol. 3, no. 1, pp. 30–39, 2024.

A. Imam, S. Basri, F. Ahmad, J. Watada, and I. Gonz´alez-Aparicio, “Migration from relational to document-oriented db: Issues and methods,” Conference Proceedings / SCITEPRESS, 2021.

Q. Aini, E. Sediyono, K. D. Hartomo, D. Manongga, U. Rahardja, I. Sembiring, and N. A. Santoso, “Relationship quality analysis using technology in the business sector,” in 2023 11th International Conference on Cyber and IT Service Management (CITSM). IEEE, 2023, pp. 1–6.

J. Williams, A. G. Prawiyogi, M. Rodriguez, and I. Kovac, “Enhancing circular economy with digital technologies: A pls-sem approach,” International Transactions on Education Technology (ITEE), vol. 2, no. 2, pp. 140–151, 2024.

S. Salihoglu and A. Deshpande, “Hybrid join algorithms for large-scale graph pattern matching,” Conference Proceedings / arXiv, 2021.

M. Chakim, M. Mulyati, C. Komalasari, M. Madani, and R. Raihan, “Sustainable competitive advantage through market and entrepreneurial orientation in indonesian retail msmes during the covid-19 recovery stage,” in 2022 IEEE Creative Communication and Innovative Technology (ICCIT). IEEE, 2022, pp. 1–6.

V. Jyothi, T. Sreelatha, T. Thiyagu, R. Sowndharya, and N. Arvinth, “A data management system for smart cities leveraging artificial intelligence modeling techniques to enhance privacy and security.” J. Internet Serv. Inf. Secur., vol. 14, no. 1, pp. 37–51, 2024.

N. Nuryani, A. B. Mutiara, I. M. Wiryana, D. Purnamasari, and S. N. W. Putra, “Artificial intelligence model for detecting tax evasion involving complex network schemes,” Aptisi Transactions on Technopreneurship (ATT), vol. 6, no. 3, pp. 339–356, 2024.

R. Clavijo-L´opez, W. A. L. Navarrete, J. M. Vel´asquez, C. M. A. Salda˜na, A. M. Ocas, and C. A. Flores-Tananta, “Integrating novel machine learning for big data analytics and iot technology in intelligent database management systems.” J. Internet Serv. Inf. Secur., vol. 14, no. 1, pp. 206–218, 2024.

U. Rusilowati, U. Narimawati, Y. R. Wijayanti, U. Rahardja, and O. A. Al-Kamari, “Optimizing human resource planning through advanced management information systems: A technological approach,” Aptisi Transactions on Technopreneurship (ATT), vol. 6, no. 1, pp. 72–83, 2024.

e. a. Ammar, “Foundations and practicalities of worst-case optimal joins,” in International Database Conference, 2021.

N. Lutfiani, N. P. L. Santoso, R. Ahsanitaqwim, U. Rahardja, and A. R. A. Zahra, “Ai-based strategies to improve resource efficiency in urban infrastructure,” International Transactions on Artificial Intelligence,vol. 2, no. 2, pp. 121–127, 2024.

M. W. Wicaksono, M. B. Hakim, F. H. Wijaya, T. Saleh, E. Sana et al., “Analyzing the influence of artificial intelligence on digital innovation: A smartpls approach,” IAIC Transactions on Sustainable Digital Innovation (ITSDI), vol. 5, no. 2, pp. 108–116, 2024.

S. Belefqih et al., “Benchmarking nosql schema extraction methods,” Data Engineering Bulletin, 2023, benchmark comparison.

D. Jonas, E. Maria, I. R. Widiasari, U. Rahardja, T. Wellem et al., “Design of a tam framework with emotional variables in the acceptance of health-based iot in indonesia,” ADI Journal on Recent Innovation, vol. 5, no. 2, pp. 146–154, 2024.

O. Dede et al., “Energy and storage implications of database design choices,” Sustainable Computing: Informatics and Systems, vol. 35, p. 100722, 2022.

O. Jayanagara and D. S. S. Wuisan, “An overview of concepts, applications, difficulties, unresolved issues in fog computing and machine learning,” International Transactions on Artificial Intelligence, vol. 1, no. 2, pp. 213–229, 2023.

Various, “Denormalization effects on rdbms performance: a review,” Journal of Database Performance Studies, 2020.

I. Sembiring, U. Rahardja, D. Manongga, Q. Aini, and A. Wahab, “Enhancing aiku adoption: Insights from the role of habit in behavior intention,” Aptisi Transactions on Technopreneurship (ATT), vol. 6, no. 1, pp. 84–108, 2024.

A. Zulkifli, “‘accelerating database efficiency in complex it infrastructures: Advanced techniques for optimizing performance, scalability, and data management in distributed systems,” International Journal of Information and Cybersecurity, vol. 7, no. 12, pp. 81–100, 2023.

T. Mariyanti, I. Wijaya, C. Lukita, S. Setiawan, and E. Fletcher, “Ethical framework for artificial intelligence and urban sustainability,” Blockchain Frontier Technology, vol. 4, no. 2, pp. 98–108, 2025.

E. Monroe and J. Smith, “Case study: Normalization and storage savings in an e-commerce inventory system,” International Journal of Database Applications, pp. 45–59, 2024.

R. G. Munthe, Q. Aini, N. Lutfiani, I. Van Persie, and A. Ramadan, “Transforming scientific publication management in the era of disruption: Smartpls approach in innovation and efficiency analysis,” APTISI Transactions on Management, vol. 8, no. 2, pp. 123–130, 2024.

K. Sato and H. Lee, “Indexing strategies to mitigate join overheads in highly normalized schemas,” Proceedings of the VLDB Workshop, pp. 120–130, 2022.

R. Yao and S. Patel, “Hybrid normalization-denormalization for oltp/olap mixed workloads,” IEEE Data Engineering Bulletin, pp. 78–89, 2023.

S. B. Altinis¸ik and T. T. Bilgin, “Optimizing big data management on microsoft sql server: Enhancing performance through normalization and advanced analytical techniques,” International Journal of Innovative Engineering Applications, vol. 9, no. 1, pp. 23–36, 2025.

Y. Qiu et al., “Select-project-join query skeleton optimizations revisited,” Proceedings of a Database Conference, 2021, modern SPJ optimizer improvements (relevant to join/normalization trade-offs).

Downloads

Published

2025-05-26

Issue

Section

Articles