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 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:||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 00:00|
|Last Modified:||29 Feb 2012 13:18|
Repository Staff Only: item control page