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.
Citations counts from theindexing service can be viewed at the linked Google Scholar™ search.
|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|
|Last Modified:||20 Mar 2015 00:07|
Repository Staff Only: item control page