Grant: Collaborative Research and Development Grants
University of Ottawa
$58,644.00
Requirements-Driven Data Warehousing: A Preliminary Proof-of-Concept Study
EF 2010-11
Résumé
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.
Programme
Collaborative Research and Development Grants
Bénéficiaire
Emplacement
Ontario, Canada
Type de bénéficiaire
Academia
Type
Grant
Source
NSERC's Awards Data
Tel que publié
Application id
371915-2008
Name nom
Kiringa, Iluju
Department département
Information Technology and Engineering, School of
Organization id
28
Institution établissement
University of Ottawa
Province en
Ontario
Province fr
Ontario
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2010
Competition year année de concours
2008
Award amount
58644
Program id
CRDPJ
Program name en
Collaborative Research and Development Grants
Program name fr
Subventions de recherche et développement coopérative
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
96
Committee name en
RPP Internal Decision Cttee
Committee name fr
Cté de décision interne - PPR
Area of application code
802
Area of application group en
Information and communication services
Area of application group fr
Services d'information et de télécommunications
Area of application en
Information systems and technology
Area of application fr
Systèmes d'information et technologie de l'information
Research subject code
2711
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Database management
Research subject fr
Gestion de bases de données
Partie
2
Nb partie
2
Application title
Requirements-Driven Data Warehousing: A Preliminary Proof-of-Concept Study
Keyword
NSERC
Application summary
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.