EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Application of Database Normalization in Increasing Data Storage Efficiency

Marviola Hardini, Vertika Agarwal, Desy Apriani, Irene Apriani Widjaya, Elika Setiawaty, Nurasiah Nurasiah

International Transactions on Artificial Intelligence (ITALIC) · 26.05.2025 · 3 (2) · 201-211

DOI: 10.33050/italic.v3i2.799 ↗

Kurz gefasst

Fachartikel in der Zeitschrift International Transactions on Artificial Intelligence (ITALIC), online erschienen am 26.05.2025. Verfasst von Marviola Hardini und 5 weiteren Autor:innen. Die Arbeit wurde bisher 1-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

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.

Zitieren

APA

Hardini, M., Agarwal, V., Apriani, D., Widjaya, I. A., Setiawaty, E., & Nurasiah, N. (2025). Application of Database Normalization in Increasing Data Storage Efficiency. International Transactions on Artificial Intelligence (ITALIC), 3(2), 201-211. https://doi.org/10.33050/italic.v3i2.799

Vancouver

Hardini M, Agarwal V, Apriani D, Widjaya IA, Setiawaty E, Nurasiah N. Application of Database Normalization in Increasing Data Storage Efficiency. International Transactions on Artificial Intelligence (ITALIC). 2025;3(2):201-211. doi:10.33050/italic.v3i2.799

BibTeX
@article{Hardini2025,
  author = {Hardini, Marviola and Agarwal, Vertika and Apriani, Desy and Widjaya, Irene Apriani and Setiawaty, Elika and Nurasiah, Nurasiah},
  title = {Application of Database Normalization in Increasing Data Storage Efficiency},
  journal = {International Transactions on Artificial Intelligence (ITALIC)},
  year = {2025},
  volume = {3},
  number = {2},
  pages = {201--211},
  doi = {10.33050/italic.v3i2.799}
}
Kostenlos starten →