Dimensional modeling for a data warehouse

  • Authors:
  • Ashiss Kumar Dash;Rakesh Agarwal

  • Affiliations:
  • Infosys Technologies Ltd., India;Infosys Technologies Ltd., India

  • Venue:
  • ACM SIGSOFT Software Engineering Notes
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

A multidimensional database stores data as groups of field category values into dimensions, and then groups these dimensions into multidimensional arrays. Specific field category values that may occur in data identify either the rows or columns of array dimensions. The specific grouped field categories themselves identify the row or column array dimensions. This view, when presented to the end user, bring in more relevance and business sense for practical decision making than the views presented by standard relational tables and flat file databases. On-Line Analytical Processing (OLAP) is based on the multidimensional representation of data which is supported by multidimensional databases, relational engines or a combination of both. In this paper we propose a model for multidimensional databases that we had used and implemented.