Requirements-Driven Data Warehousing: A Preliminary Proof-of-Concept Study

点击翻译按钮获取中文摘要

This project aims at conducting a preliminary proof-of-concept study of a requirements-driven data warehouse construction. It proposes a first step towards a new long term vision: a top-down data warehousing design-time as well as run-time process, where (mostly non technical) users need only to focus on the careful and declarative specification of application requirements at design time, and a tool will (semi)automatically generate and populate an underlying data warehouse at run time. Two specific tasks are to be solved: first, design a conceptual integration modeling language for representing typical integration features such as data provenance, data access requirements for materialization, and mappings from the conceptual model to the underlying multidimensional model (which can be expressed as a data cube); second, build a prototype tool that uses models expressed in the conceptual integration modeling language to drive the design and the population of a data warehouse. Expected results of this research will be a contribution to the Canadian Business Intelligence industry. Data warehousing is one of the cornerstones of the industry, so research advancing data warehousing will be crucial to the flagship Canadian software companies that currently lead the industry.