Triple-driven data modeling methodology in data warehousing: a case study.

Yuhong Guo,Shiwei Tang,Yunhai Tong,Dongqing Yang
DOI: https://doi.org/10.1145/1183512.1183524
2006-01-01
Abstract:ABSTRACTIn this paper, we present a useful data modeling methodology in data warehousing which integrates three existing approaches normally used in isolation: goal-driven, data-driven and user-driven. It comprises of four stages. Goal-driven stage produces subjects and KPIs(Key Performance Indicators) of main business fields. Data-driven stage produces subject oriented enterprise data schema. User-driven stage yields analytical requirements represented by measures and dimensions of each subject. Combination stage combines the triple-driven results. By triple-driven, we can get a more complete, more structured and more layered data model of a data warehouse. We illustrate each stage step by step using examples in our case study.
What problem does this paper attempt to address?