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.