Roles of Multidimensionality and Granularity in Warehousing Australian Resources Data

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.

[1]  Duan Yi.  SYSTEM DEVELOPMENT FOR THE DATA WAREHOUSE OF OIL EXPLORATION , 2002 .

[2]  S. Fox,et al.  Storage and retrieval of spatially-qualified data from NASA's EOSDIS Data Pool , 2003, IGARSS 2003. 2003 IEEE International Geoscience and Remote Sensing Symposium. Proceedings (IEEE Cat. No.03CH37477).

[3]  Gregory Piatetsky-Shapiro,et al.  Advances in Knowledge Discovery and Data Mining , 2004, Lecture Notes in Computer Science.

[4]  Rob Mattison.  Data warehousing - strategies, technologies, and techniques , 1996 .

[5]  Matthias Jarke,et al.  Fundamentals of Data Warehouses , 2000, Springer Berlin Heidelberg.

[6]  John F. Roddick,et al.  Geographic Data Mining and Knowledge Discovery , 2001 .

[7]  Jiawei Han,et al.  Geographic Data Mining and Knowledge Discovery , 2001 .

[8]  Qijiang Zhu,et al.  Data mining about hyperspectral data of winter wheat based on data warehouse and data organization , 2003, IGARSS 2003. 2003 IEEE International Geoscience and Remote Sensing Symposium. Proceedings (IEEE Cat. No.03CH37477).

[9]  Margaret H. Dunham,et al.  Data Mining: Introductory and Advanced Topics , 2002 .