Title
Approaches to the development of multi-dimensional databases: lessons from four case studies
Abstract
The paper explores the manner in which an organization's data and information can be effectively utilized to assist an organization to achieve its business objectives. With the increased popularity of data warehousing and executive information systems, there is renewed interest by IT practitioners in data models and database structures, in particular multi-dimensional forms, which have joined their relational counterparts as legitimate tools for extracting vital business information from an organization's operational data. As much of the current literature on multi-dimensional databases comes in the form of white papers from the creators of multi-dimensional systems, there is a need for a more objective and theoretical analysis of this area, particularly on aspects that concern application developers and end users. To this end, the paper presents an analysis of four case studies involving the development of multidimensional databases applications. The initial two cases used different approaches, one top-down and one bottom-up. The successful aspects of these cases were used to create a "middle-out" approach that guided two subsequent case studies, thereby demonstrating that the dimensional view of data does provide managers with an effective means of making sense of organizational data.
Year
DOI
Venue
2000
10.1145/381137.381139
Database
Keywords
DocType
Volume
multi-multidimensional database,multi-dimensional databases,organization,relational database,executive information systems,management,olap,case study,methodology,application development,data warehousing,multidimensional database,top down,data model,executive information system,bottom up
Journal
31
Issue
Citations 
PageRank 
2
4
0.43
References 
Authors
9
4
Name
Order
Citations
PageRank
Helen Hasan113211.34
Peter Hyland2207.33
David Dodds363.94
Raja Veeraraghavan440.43