Roles of Multidimensionality and Granularity in Warehousing Australian Resources Data

Authors:
Amit Rudra;Shastri L. Nimmagadda
Affiliations:
Curtin University of Technology, Australia;Curtin University of Technology, Australia
Venue:
HICSS '05 Proceedings of the Proceedings of the 38th Annual Hawaii International Conference on System Sciences - Volume 08
Year:
2005

Citing 0
Cited 2

Data warehousing and mining technologies for adaptability in turbulent resources business environments

International Journal of Business Intelligence and Data Mining
On new emerging concepts of petroleum digital ecosystem

Wiley Interdisciplinary Reviews: Data Mining and Knowledge Discovery

Quantified Score

Hi-index	0.00

Visualization

Abstract

Granularity of data modeled in multidimensional data structures is an important factor for a data warehouse. Grain sizes and number of dimensions participating in the model are critical in ascertaining the quality of analytical queries that are run on such data warehouses. In this paper, exploration and production data of Australian resources industry, pertinent to oil and gas, over the past five decades have been examined for multidimensionality and grain size. This research shows how using an ER approach combined with multidimensional data modeling helps in considerable reduction in the size of the data warehouse, making it more effective and efficient.