| A Transformation-oriented Methodology to Knowledge-based Conceptual Data Warehouse Design (2006) | |||||||||
Abstract | |||||||||
| Applications of artificial intelligence (AI) technology in the form of knowledge-basedsystems within the context of database design have been extensively researched particularly to providesupport within the conceptual design phase. However, a similar approach to the task of data warehousedesign has yet to be seriously initiated. In this paper, we proposed a design methodology forconceptual data warehouse design called the transformation-oriented methodology, which transformsan Entity-Relationship (ER) model into a multidimensional model based on a series of transformationand analysis rules. The transformation-oriented methodology translates the ER model into aspecification language model and transformed it into an initial problem domain model. A set ofsynthesis and diagnosis rules will then gradually transform the problem domain model into themultidimensional model. A prototype KB tool called the DWDesigner has been developed toimplement the aforementioned methodology. The multidimensional model produces by theDWDesigner as output is presented in a graphical form for better visualization. Testing has beenconducted to a number of design problems, such as university, business and hospital domains andconsistent results have been achieved. | |||||||||
Publication details | |||||||||
| |||||||||