2007•Unpublished venueRequires access

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

Henning Köehler, Klaus‐Dieter Schewe, Jane Zhao

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. 1

About this research paper

What this paper is about

Why it matters

OpenAlex reports 2 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Online analytical processing, Data warehouse, Computer science, Materialized view, Set (abstract data type), Database, Computation, Process (computing)