Building OLAP Tools over Large Databases

Authors

Abstract

During the last few years, On-Line Analytical Processing (OLAP) has emerged as a valuable tool for the analysis,
navigation and reporting of hierarchically organized data from data warehouses. Still, it remains a challenging task to
implement and deploy OLAP tools over large databases, since no standardized architecture exists, which describes the
common components and functionality of OLAP tools. Managers all over the world face the challenge of how to analyze
their most valuable information. The fundamental nature of the right information analysis is on choosing a tool with the
features which best aids a management decision. This paper presents a prototype containing a group of features that are
recommended to be implemented in on-line analytical processing (OLAP) tools, for analyzing stored data with quality.
The prototype was evaluated on a data warehouse implemented in a relational repository using the star schema but this
prototype can be implemented on any database system.

Keywords

During the last few years, On-Line Analytical Processing (OLAP) has emerged as a valuable tool for the analysis, navigation and reporting of hierarchically organized data from data warehouses. Still, it remains a challenging task to implement and deploy OLAP tools over large databases, since no standardized architecture exists, which describes the common components and functionality of OLAP tools. Managers all over the world face the challenge of how to analyze their most valuable information. The fundamental nature of the right information analysis is on choosing a tool with the features which best aids a management decision. This paper presents a prototype containing a group of features that are recommended to be implemented in on-line analytical processing (OLAP) tools, for analyzing stored data with quality. The prototype was evaluated on a data warehouse implemented in a relational repository using the star schema but this prototype can be implemented on any database system.

Subject

Building OLAP Tools over Large Databases

Related Project

DWS Data Warehouse Striping

Conference

IADIS Virtual Multi Conference on Computer Science and Information Systems, January 2006