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

Authors:
Yuhong Guo;Shiwei Tang;Yunhai Tong;Dongqing Yang
Affiliations:
Peking University - China;Peking University - China;Peking University - China;Peking University - China
Venue:
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Year:
2006

Citing 8
Cited 3

Data-driven understanding and refinement of schema mappings

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Designing data marts for data warehouses

ACM Transactions on Software Engineering and Methodology (TOSEM)
A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse

DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan

Decision Support Systems
Data warehouse design to support customer relationship management analyses

Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Goal-oriented requirement analysis for data warehouse design

Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Trends in data warehousing: a practitioner's view

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Data warehousing and knowledge discovery: a chronological view of research challenges

DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery

SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Using lexical ontology for semi-automatic logical data warehouse design

RSKT'10 Proceedings of the 5th international conference on Rough set and knowledge technology
Integrating Star and Snowflake Schemas in Data Warehouses

International Journal of Data Warehousing and Mining

Quantified Score

Hi-index	0.00

Visualization

Abstract

In 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.