This redbook gives detail coverage to the topic of data modeling techniques for data warehousing, within the context of the overall data warehouse development process. The process of data warehouse modeling, including the steps required before and after the actual modeling step, is discussed. Detailed coverage of modeling techniques is presented in an evolutionary way through a gradual, but well-managed, expansion of the content of the actual data model. Coverage is also given to other important aspects of data warehousing that affect, or are affected by, the modeling process. These include architecting the warehouse and populating the data warehouse. Guidelines for selecting a data modeling tool that is appropriate for data warehousing are presented.
Cited By
- Bouadi T, Cordier M, Moreau P, Quiniou R, Salmon-Monviola J and Gascuel-Odoux C (2017). A data warehouse to explore multidimensional simulated data from a spatially distributed agro-hydrological model to improve catchment nitrogen management, Environmental Modelling & Software, 97:C, (229-242), Online publication date: 1-Nov-2017.
Ibrahim K, Selvo N, El-Rifai M and Eltabakh M FusionDB Proceedings of the 22nd ACM international conference on Information & Knowledge Management, (2469-2472)- Khajaria K and Kumar M (2011). Modeling of security requirements for decision information systems, ACM SIGSOFT Software Engineering Notes, 36:5, (1-4), Online publication date: 30-Sep-2011.
- Di Tria F, Lefons E and Tangorra F GrHyMM Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions, (86-97)
- Dell'Aquila C, Di Tria F, Lefons E and Tangorra F Logic programming for data warehouse conceptual schema validation Proceedings of the 12th international conference on Data warehousing and knowledge discovery, (1-12)
- Rifaie M, Alhajj R and Ridley M Data governance strategy Proceedings of the 11th International Conference on Information Integration and Web-based Applications & Services, (587-591)
- Rifaie M, Blas E, Muhsen A, Mok T, Kianmehr K, Alhajj R and Ridley M Data warehouse architecture for GIS applications Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services, (178-185)
- Skoutas D and Simitsis A Designing ETL processes using semantic web technologies Proceedings of the 9th ACM international workshop on Data warehousing and OLAP, (67-74)
- Simitsis A Mapping conceptual to logical models for ETL processes Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, (67-76)
Recommendations
Present and future directions in data warehousing
Many large organizations have developed data warehouses to support decision making. The data in a warehouse are subject oriented, integrated, time variant, and nonvolatile. A data warehouse contains five types of data: current detail data, older detail ...
A data warehouse architecture for clinical data warehousing
ACSW '07: Proceedings of the fifth Australasian symposium on ACSW frontiers - Volume 68Data warehousing methodologies share a common set of tasks, including business requirements analysis, data design, architectural design, implementation and deployment. Clinical data warehouses are complex and time consuming to review a series of patient ...