Multidimensional schemas for engineering asset management

Mathew, Avin D. & Ma, Lin (2007) Multidimensional schemas for engineering asset management. In World Congress on Engineering Asset Management 2007, 11-14 June 2007, Harrogate, England. (Unpublished)


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 Scopus and Web of Science® 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 the Google Scholar™ indexing service can be viewed at the linked Google Scholar™ search.

Full-text downloads:

934 since deposited on 28 Jun 2007
25 in the past twelve months

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.

ID Code: 8289
Item Type: Conference Paper
Refereed: Yes
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

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page