How database normalization and schema versioning improve system efficiency, data integrity, and flexibility in changing business settings
Loading...
URL
Journal Title
Journal ISSN
Volume Title
School of Business |
Bachelor's thesis
Unless otherwise stated, all rights belong to the author. You may download, display and print this publication for Your own personal use. Commercial use is prohibited.
Authors
Date
2024
Department
Major/Subject
Mcode
Degree programme
Tieto- ja palvelujohtaminen
Language
en
Pages
28 + 1
Series
Abstract
With an emphasis on major corporations like Nokia, this thesis investigates the effects of database normalization and schema versioning on system effective-ness, data integrity, and flexibility inside database management systems. The study investigates the implementation issues and successful techniques of these technologies through semi-structured interviews with database administration specialists. The results show that sophisticated schema versioning and normalization great-ly improve data management by enabling systems to adjust flexibly to new re-quirements without sacrificing efficiency. The study highlights several significant obstacles, including the difficulty in implementing schema modifications and the limitations imposed by company regulations. One of the highlighted effective solutions is the combination of schema management tools and version control systems to enhance traceability and rollback capabilities.Description
Thesis advisor
Bragge, JohannaKeywords
database normalization, schema versioning, schema evolution, Relational Database Management Systems