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:

2 citations in Scopus
Search Google Scholar™

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:

2,440 since deposited on 11 Aug 2006
125 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: 4801
Item Type: Conference Paper
Refereed: Yes
Additional URLs:
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: Past > Research Centres > CRC Integrated Engineering Asset Management (CIEAM)
Past > QUT Faculties & Divisions > Faculty of Built Environment and Engineering
Copyright Owner: Copyright 2006 (please consult author)
Deposited On: 11 Aug 2006 00:00
Last Modified: 22 Jun 2017 14:39

Export: EndNote | Dublin Core | BibTeX

Repository Staff Only: item control page