A Different Perspective of Data Warehouses’ Logical Modelling
- Speaker: Dr Georgia Garani, , Department of Computer Science and Telecommunications, University of Thessaly
- Date: Tuesday, 14 November 2017 from 17:00 to 18:00
- Location: Room 151
Data warehouses (DWs) are mainly used for business data analysis by querying and reporting huge collections of data. A fundamental issue encountered by the research community of DWs is the modelling of data.
Particularly, logical design is a very important phase in the process of building a successful DW. The efficient logical design of DWs has to be studied extensively due to the fact that it can lead to a better physical design.
In this talk we will discuss in detail the logical modelling of DWs. The two dominant approaches for the logical design of a DW are the star and snowflake schemas. The model which will be presented is called the starnest schema. The starnest schema forms the integration of the star and snowflake schemas. The starnest schema is accomplished by converting the fact-dimension schema to a fact-nested dimension schema. An algorithm will be demonstrated for the transformation of the star schema to a starnest schema.The applicability of the star schema to Temporal Data Warehouses (TDWs) which have been developed for the management of time-varying data in dimensions and Spatial Data Warehouses (SDWs) which store and manipulate spatial data for spatial analysis purposes will also be discussed.