Roles of multidimensionality and granularity in warehousing Australian resources data
MetadataShow full item record
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.
Copyright 2005 IEEE. This material is presented to ensure timely dissemination of scholarly and technical work. Copyright and all rights therein are retained by authors or by other copyright holders. All persons copying this information are expected to adhere to the terms and constraints invoked by each author's copyright. In most cases, these works may not be reposted without the explicit permission of the copyright holder.
Showing items related by title, author, creator and subject.
Nimmagadda, Shastri; Reiners, Torsten; Wood, Lincoln (2018)© 2018 The emerging Big Data integration imposes diverse challenges, compromising the sustainable business research practice. Heterogeneity, multi-dimensionality, velocity, and massive volumes that challenge Big Data ...
New technologies in mature gulf basins - multidimensional modeling of ontologically derived historical petroleum exploration data properties for effective basin knowledge mappingNimmagadda, Shastri; Dreher, Heinz; Chang, Elizabeth; Rajab, Mohammad (2006)Resources data warehouse is usually constructed by integrating multiple heterogeneoussources such as relational databases, flat files and OLTP files. When data reside in manyseparate applications in an operational petroleum ...
Nimmagadda, Shastri; Dreher, H. (2009)Australia produces one third of the world's mineral resources and has sufficient petroleum resources for its economic growth. Volumes of resources data have been accumulated and geographically distributed in many resources ...