Dynamic data warehouse design as a refinement in ASM-based approach

Koehler, Henning, Schewe, Klaus-Dieter and Zhao, Jane (2007). Dynamic data warehouse design as a refinement in ASM-based approach. In: John F. Roddick and Annika Hinze, Conference Research and Practice in Information technology: Proceedings of APCCM 2007. The Fourth Asia-Pacific Conference on Conceptual Modelling (APCCM 2007), Ballarat, Vic, Australia, (61-69). 30 January - 2 February, 2007.


Author Koehler, Henning
Schewe, Klaus-Dieter
Zhao, Jane
Title of paper Dynamic data warehouse design as a refinement in ASM-based approach
Conference name The Fourth Asia-Pacific Conference on Conceptual Modelling (APCCM 2007)
Conference location Ballarat, Vic, Australia
Conference dates 30 January - 2 February, 2007
Proceedings title Conference Research and Practice in Information technology: Proceedings of APCCM 2007
Place of Publication Sydney , NSW, Australia
Publisher Australian Computer Society
Publication Year 2007
Sub-type Fully published paper
ISBN 1-920-68235-X
ISSN 1445-1336
Editor John F. Roddick
Annika Hinze
Volume 69
Start page 61
End page 69
Total pages 9
Language eng
Abstract/Summary On-line analytical processing (OLAP) systems deal with analytical tasks in businesses. As these tasks do not depend on the latest updates by transactions, it is assumed that the data used in OLAP systems are kept in a data warehouse, which separates the input from operational databases from the outputs to OLAP. Typical OLAP queries are data intensive, and thus time consuming. In order to speed up the query computation, it is a common practice to materialize some of the computations as views based on a set of queries given. In general we wish to optimize query time under a given maintenance constraints. However, OLAP queries are not static and may change over time. Thus designing data warehouse is an ongoing task. This process is also called dynamic or incremental design. In this paper, we approach this issue as a refinement step in our Abstract State Machine (ASM) based data warehouse design, and support it by a set of standard refinement rules.
Subjects 0899 Other Information and Computing Sciences
Q-Index Code E1

 
Versions
Version Filter Type
Citation counts: Google Scholar Search Google Scholar
Created: Mon, 08 Mar 2010, 13:40:30 EST by Ms Lynette Adams on behalf of Faculty Of Engineering, Architecture & Info Tech