Case-based reasoning for data warehouse schema design
Mathew, Avin D., Ma, Lin, & Narasimhan, V. Lakshmi (2006) Case-based reasoning for data warehouse schema design. In The 36th International Conference on Computers and Industrial Engineering, 20-23 June 2006, Howard Hotel, Taipei, Taiwan.
There have been several efforts made in the area of semi-automated techniques and tools for schema design. Most have focused on database schema design, and little work has been done on data warehouse schema design. This paper presents a new approach to data warehouse schema design based on case-based reasoning theory. Case-based reasoning is a problem solving paradigm that involves the development of a solution space to provide a basis for efficient reuse of proven pre-existing solutions. A detailed system design for the application of case-based reasoning to data warehouse schema design is examined in this paper. Two novel contributions of the paper include the matching of cases by data warehouse schema meta-data, and the use of a business context aware ontology to make intelligent suggestions on entities and attributes. These two approaches assist in improving the case matching and adaptation capability in the case-based reasoning system.
Impact and interest:
Citation countsare sourced monthly fromand citation databases.
Citations counts from theindexing service can be viewed at the linked Google Scholar™ search.
|Item Type:||Conference Paper|
|Keywords:||case, based reasoning, data warehousing, star schema design, context aware ontology|
|Subjects:||Australian and New Zealand Standard Research Classification > INFORMATION AND COMPUTING SCIENCES (080000) > DATA FORMAT (080400) > Data Structures (080403)|
|Divisions:||Current > Research Centres > CRC Integrated Engineering Asset Management (CIEAM)|
Past > QUT Faculties & Divisions > Faculty of Built Environment and Engineering
Past > Schools > School of Engineering Systems
|Copyright Owner:||Copyright 2006 (please consult author)|
|Deposited On:||11 Aug 2006|
|Last Modified:||29 Feb 2012 23:18|
Repository Staff Only: item control page