Data Warehouse has become a very important tool for data analysis but the conversion from Operational Database to Data Warehouse is very complex. This paper presents a new method to design a data warehouse multidimensional model based on supply driven framework. We propose a semi-automatic tool using lexical ontology as the knowledge domain. The tool is able to identify fact and dimensional tables using the knowledge domain. Once fact table is identified, the following step is to generate Data Warehouse multidimensional model with minimal user interaction. The feasibility of the proposed method is demonstrated by a prototype using WordNet as knowledge domain. © 2010 Springer-Verlag Berlin Heidelberg.
CITATION STYLE
Nazri, M. N. M., Noah, S. A., & Hamid, Z. (2010). Using lexical ontology for semi-automatic logical data warehouse design. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 6401 LNAI, pp. 257–264). https://doi.org/10.1007/978-3-642-16248-0_39
Mendeley helps you to discover research relevant for your work.