Multidimensional schemas for engineering asset management
The amount of data that modern companies collect is ever increasing. With organisations that own a plethora of information systems, structured integration of data has become a pressing issue. Many companies have turned to data warehousing to bridge the gap of turning data into useful information and knowledge; however the data involved are typically from softer business domains rather than engineering-related domains. We investigate the area of engineering asset management data warehousing by examining the multidimensional modelling of asset management data. The multidimensional schemas are derived from the relational model in the MIMOSA OSA-EAI. The standards-based approach provides for platform neutrality, and as the OSA-EAI is a generic model, rules are given for company-specific implementations. From initial testing, query formation with multidimensional models is less complex than Third Normal Form models.
Impact and interest:
Citation counts are sourced monthly from and citation databases.
These databases contain citations from different subsets of available publications and different time periods and thus the citation count from each is usually different. Some works are not in either database and no count is displayed. Scopus includes citations from articles published in 1996 onwards, and Web of Science® generally from 1980 onwards.
Citations counts from theindexing service can be viewed at the linked Google Scholar™ search.
Full-text downloads displays the total number of times this work’s files (e.g., a PDF) have been downloaded from QUT ePrints as well as the number of downloads in the previous 365 days. The count includes downloads for all files if a work has more than one.
|Item Type:||Conference Paper|
|Keywords:||asset management, data warehousing, multidimensional schema, star schema, MIMOSA|
|Subjects:||Australian and New Zealand Standard Research Classification > INFORMATION AND COMPUTING SCIENCES (080000) > LIBRARY AND INFORMATION STUDIES (080700) > Information Retrieval and Web Search (080704)
Australian and New Zealand Standard Research Classification > INFORMATION AND COMPUTING SCIENCES (080000) > DATA FORMAT (080400) > Data Format not elsewhere classified (080499)
|Divisions:||Current > Research Centres > CRC Integrated Engineering Asset Management (CIEAM)
Past > QUT Faculties & Divisions > Faculty of Built Environment and Engineering
Current > QUT Faculties and Divisions > Science & Engineering Faculty
|Copyright Owner:||Copyright 2007 The Authors|
|Deposited On:||28 Jun 2007 00:00|
|Last Modified:||20 Mar 2015 00:07|
Repository Staff Only: item control page