Using lexical ontology for semi-automatic logical data warehouse design

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...

Full description

Bibliographic Details
Main Authors:	Mior Nazri, Mior Nasir, Noah, Shahrul Azman, Hamid, Zarinah
Format:	Conference or Workshop Item
Language:	English
Published:	Springer-Verlag 2010
Subjects:	QA76 Computer software
Online Access:	http://irep.iium.edu.my/3209/ http://irep.iium.edu.my/3209/ http://irep.iium.edu.my/3209/ http://irep.iium.edu.my/3209/1/2010-Using_Lexical_Ontology_DW-Springer_Verlag_LNAI%5B1%5D.pdf

id	iium-3209
recordtype	eprints
spelling	iium-32092011-12-19T13:19:14Z http://irep.iium.edu.my/3209/ Using lexical ontology for semi-automatic logical data warehouse design Mior Nazri, Mior Nasir Noah, Shahrul Azman Hamid, Zarinah QA76 Computer software 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. Springer-Verlag 2010 Conference or Workshop Item PeerReviewed application/pdf en http://irep.iium.edu.my/3209/1/2010-Using_Lexical_Ontology_DW-Springer_Verlag_LNAI%5B1%5D.pdf Mior Nazri, Mior Nasir and Noah, Shahrul Azman and Hamid, Zarinah (2010) Using lexical ontology for semi-automatic logical data warehouse design. In: 5th International Conference on Rough Set and Knowledge Technology, RSKT 2010; Beijing; 15 October 2010 through 17 October 2010. http://www.springerlink.com/content/m0u0q4g847313836/ DOI: 10.1007/978-3-642-16248-0_39
repository_type	Digital Repository
institution_category	Local University
institution	International Islamic University Malaysia
building	IIUM Repository
collection	Online Access
language	English
topic	QA76 Computer software
spellingShingle	QA76 Computer software Mior Nazri, Mior Nasir Noah, Shahrul Azman Hamid, Zarinah Using lexical ontology for semi-automatic logical data warehouse design
description	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.
format	Conference or Workshop Item
author	Mior Nazri, Mior Nasir Noah, Shahrul Azman Hamid, Zarinah
author_facet	Mior Nazri, Mior Nasir Noah, Shahrul Azman Hamid, Zarinah
author_sort	Mior Nazri, Mior Nasir
title	Using lexical ontology for semi-automatic logical data warehouse design
title_short	Using lexical ontology for semi-automatic logical data warehouse design
title_full	Using lexical ontology for semi-automatic logical data warehouse design
title_fullStr	Using lexical ontology for semi-automatic logical data warehouse design
title_full_unstemmed	Using lexical ontology for semi-automatic logical data warehouse design
title_sort	using lexical ontology for semi-automatic logical data warehouse design
publisher	Springer-Verlag
publishDate	2010
url	http://irep.iium.edu.my/3209/ http://irep.iium.edu.my/3209/ http://irep.iium.edu.my/3209/ http://irep.iium.edu.my/3209/1/2010-Using_Lexical_Ontology_DW-Springer_Verlag_LNAI%5B1%5D.pdf
first_indexed	2023-09-18T20:10:56Z
last_indexed	2023-09-18T20:10:56Z
_version_	1777407472394305536

Using lexical ontology for semi-automatic logical data warehouse design

Similar Items