Vol.14, No.2, May 2025.                                                                                                                                                                          ISSN: 2217-8309

                                                                                                                                                                                                                        eISSN: 2217-8333

TEM Journal

TECHNOLOGY, EDUCATION, MANAGEMENT, INFORMATICS

Association for Information Communication Technology Education and Science

Data Warehouse Design – Star Schema Synthesis Algorithm

Kornelije Rabuzin, Maja Cerjan, Alen Lovrenčić

© 2025 Maja Cerjan, published by UIKTEN. This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 License. (CC BY-NC-ND 4.0)

Citation Information: TEM Journal. Volume 14, Issue 2, Pages 1707-1714, ISSN 2217-8309, DOI: 10.18421/TEM142-68, May 2025.

Received: 06 August 2024.

Revised: 19 February 2025.
Accepted: 07 March 2025.
Published: 27 May 2025.

Abstract:

Logical database design is a very well-understood field, with defined normal forms that solve the problems of data availability and redundancy in a simple and efficient way. Applying these normal patterns ensures efficient database design without redundant data. However, when considering the use of functional dependencies in data warehouse design, it is largely unexplored. This paper is mainly concerned with revisiting already established and well-known concepts surrounding functional dependencies, normal forms and the 3NF (Third Normal Form) synthesis algorithm. After that, emphasis is placed on demonstrating and showing how functional dependencies can greatly contribute to an efficient well-designed logical data warehouse. The biggest contribution of this work is actually proposing, i.e. defining, a new algorithm that generates a star schema based on an already defined set of functional dependencies. Although this attempt is the result of a detailed presentation, it is still only an initial effort in understanding how to define the logical design of a data warehouse using functional dependencies.

Keywords – Data warehouse, logical design, star schema, database design, 3NF, 3NF synthesis algorithm

-----------------------------------------------------------------------------------------------------------

Full text PDF >  

-----------------------------------------------------------------------------------------------------------