文档介绍:Business Process Oriented Development of
Data Warehouse Structures
Michael Böhnlein, Achim Ulbrich-vom Ende
University of Bamberg, Feldkirchenstr. 21, D-96045 Bamberg, Germany
{,}***@-
Abstract. In recent years data warehouse projects have e popular to most
companies. Unfortunately many of these e to grief due to missing
engineering strategies and modeling standards. mon method for
developing multidimensional data structures is deriving relevant datasets from
underlying operational data sources. But in fact developing large data schemata
for decision support applications requires more knowledge about the underlying
business domain. It is obvious that for efficient decision making an approach is
required which additionally focuses on goals and strategies of pany.
This information can not be extracted by analyzing the operational data sources.
We realized monly applied business process models can be used to
handle this problem. In this paper we present pletely new approach to
warehouse development – the derivation of data warehouse structures from
business process models.
1. Introduction
During the last decade data warehouse systems have e an ponent
of modern decision support systems in panies. Data warehouse systems
offer efficient access to integrated and historical data from different, partly
heterogeneous and autonomous information sources, to support managers in their
planning and decision making.
In spite of the advantages of data warehouses, many projects fail due to the
complexity of the development process. Building a data warehouse system is rather
different from the development of conventional operational systems; not only the
structures of the underlying source systems have to be considered but also the goals
and strategies of pany.
One major problem in building a data warehouse is to identify and consider
information needs of potential users. Often they are not abl