Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ NaUKMA Research Pape...arrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
addClaim

This Research product is the result of merged Research products in OpenAIRE.

You have already added 0 works in your ORCID record related to the merged Research product.

System for Automating the Database Normalization Process

System for Automating the Database Normalization Process

Abstract

As data volumes grow rapidly, efficient database management has become critical for organizations. Relational databases play an essential role in ensuring data integrity, enabling complex queries, and supporting various applications, including financial, healthcare, e-commerce, and CRM systems.Database normalization, a key technique for structuring data and reducing redundancy, improves database efficiency and performance. However, the normalization process can be complex and demands expert knowledge. The article outlines the theoretical foundations of normalization, explaining various normal forms, including 1NF, 2NF, 3NF, and Boyce-Codd Normal Form (BCNF). It emphasizes that while normalization is essential, eliminating redundancy entirely is impractical when maintaining database cohesion.The proposed system automates normalization using an algorithm based on Heath’s theorem, which guarantees a lossless decomposition and dependency preservation. The system can identify minimal sets of functional dependencies, search for quasi-keys, and perform decompositions up to 3NF, ensuring that the database meets lossless join and dependency preservation requirements.The authors compare the new system with existing tools, highlighting key advantages such as its userfriendly interface and comprehensive functionality, including decomposition capabilities and result integrity verification. The system is designed with Node.js for the backend and React.js for the user interface, providing a web-based platform for database normalization.The article also explores potential use cases, noting that the system is beneficial for database developers, analysts, and students learning about database management. It simplifies the normalization process, making it faster and more user-friendly. The authors conclude by discussing future improvements, including support for BCNF and 4NF decompositions.This system offers a practical solution for addressing database normalization challenges, reducing process complexity while enhancing data integrity and performance.

У статті розкрито поняття процесу нормалізації баз даних, проведено аналіз наявних інструментів для нормалізації, виділено основні їхні переваги та недоліки. Описано функціонал і реалізацію нової системи для автоматичної нормалізації структури бази даних з урахуванням недоліків наявних систем.

Keywords

normalization process, dependency preservation property, decomposition algorithm, процес нормалізації, database integrity, relational databases, алгоритм декомпозиції, functional dependencies, властивість з’єднання без втрат, функціональні залежності, властивість збереження залежностей, цілісність баз даних, реляційні бази даних, lossless join property

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average
gold