Aarhus University Seal / Aarhus Universitets segl

Conceptual Data Warehouse Structures

Research output: Working paperResearch

  • Department of Business Studies
  • Information Systems Research Group
We analyze some of the problems related to conceptual modeling in data warehousing environments. The long-term data warehousing challenge is flexibility rather than efficiency. The reason is that most warehouses will contain growing collections of historical data that are supposed to satisfy changing information needs. We show how the event-entity-relationship model (EVER) can be used for schema design and query formulation in data warehouses. Our work is based on a layered data warehouse architecture in which a global data warehouse is used for flexible long-term organization and storage of all warehouse data whereas local data warehouses are used for efficient query formulation and answering. In order to support flexible modeling of global warehouses we use a flexible version of EVER for global schema design. In order to support efficient query formulation in local data warehouses we define a type hierarchy for star schemes that can be used for local schema design. Based on this we outline a query language that can be used to formulate star queries, i.e., queries on star schemes
Original languageEnglish
Number of pages13
Publication statusPublished - 1998

See relations at Aarhus University Citationformats

ID: 204846