Designing Distributed Data Warehouses and OLAP Systems
نویسنده
چکیده
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 coming from operational databases from the output going to dialogue interfaces for OLAP. In this article we present a 3-tier architecture for data warehouses and OLAP systems capturing the fundamental requirement of separating input from operational databases from output to OLAP systems. On this basis we start developing refinement rules to enable step-wise refinement for such systems, which includes pragmatic guidelines for the application of such rules.
منابع مشابه
A Parallel Scalable Infrastructure for OLAP and Data Mining
Decision support systems are important in leveraging information present in data warehouses in businesses like banking, insurance, retail and health-care among many others. The multi-dimensional aspects of a business can be naturally expressed using a multi-dimensional data model. Data analysis and data mining on these warehouses pose new challenges for traditional database systems. OLAP and da...
متن کاملRepresenting Temporal Data in Non-Temporal OLAP Systems
Multidimensional data warehouses and OLAP systems do not provide adequate means for dealing with changes in dimension data, changes appearing frequently in dynamic application areas as current business systems. As data warehouses and OLAP tools serve as decision support systems they have to reflect such changes. Temporal data warehouses propose sophisticated modelling tools for covering any cha...
متن کاملA Data Pre-partitioning and Distribution Optimization Approach for Distributed Data Warehouses
The increasing volumes of relational data let us find an alternative to cope with them. The Hadoop framework an open source project based on the MapReduce paradigm is a popular choice for distributed data warehouses and big data analytics. In this paper, we propose an original approach for partitioning and collocating data in distributed file systems, especially Hadoop-based systems, and this, ...
متن کاملASM Ground Model and Refinement for Data Warehouses
Data Warehouses and on-line analytical processing (OLAP) systems are a promising area for the application of Abstract State Machines (ASMs). In this paper a ground model specification for data warehouses is sketched that is based on the fundamental idea of separating input from operational databases and output to OLAP systems. On this basis we start defining formal refinement rules for such sys...
متن کاملImproving the performance and functionality of Mondrian open-source OLAP systems
For a long time, the design of relational databases has focused on the optimization of atomic transactions (insert, select, update or delete). Currently, relational databases store tactical information of data warehouses, mainly for select-like operations. However, the database paradigm has evolved, and nowadays on-line analytical processing (OLAP) systems handle strategic information for furth...
متن کامل