Building Olap Tools over Large Databases

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.