Roles of multidimensionality and granularity in warehousing Australian resources data
Citation
Source Title
Source Conference
Faculty
School
Remarks
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.
Collection
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.
Related items
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 ...
-
Nimmagadda, 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 ...
-
Intrapairot, Arunee (2000)The main objective of this study is to develop requisite models for information and communication technology (ACT) adoption and diffusion in the banking industry in Thailand. The research, combining two study areas of ...