Paper Info
Title
Dynamic data warehouse design as a refinement in ASM-based approach
Abstract
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.
Year
Venue
Keywords
2007
APCCM
olap query,olap system,data warehouse,dynamic data warehouse design,asm-based approach,on-line analytical processing,incremental design,data warehouse design,analytical task,query time,typical olap query,time consuming,dynamic data,abstract state machine
Field
DocType
ISBN
Data warehouse,Data mining,Warehouse,Computer science,Abstract state machines,Dimensional modeling,Dynamic data,Online analytical processing,Speedup,Computation
Conference
1-920-68285-X
Citations 
PageRank 
References 
1
0.35
11
Authors
3
Name
Order
Citations
PageRank
Henning Koehler116716.06
Klaus-dieter Schewe21367202.78
Jane Zhao3647.13