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...
| Main Authors: | , , |
|---|---|
| Format: | Proceeding Paper |
| Language: | English |
| Published: |
Springer-Verlag
2010
|
| Subjects: | |
| Online Access: | http://irep.iium.edu.my/3209/ http://irep.iium.edu.my/3209/1/2010-Using_Lexical_Ontology_DW-Springer_Verlag_LNAI%5B1%5D.pdf |
| _version_ | 1848776113697849344 |
|---|---|
| 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 |
| building | IIUM Repository |
| collection | Online Access |
| 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.
|
| first_indexed | 2025-11-14T14:24:56Z |
| format | Proceeding Paper |
| id | iium-3209 |
| institution | International Islamic University Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-14T14:24:56Z |
| publishDate | 2010 |
| publisher | Springer-Verlag |
| recordtype | eprints |
| repository_type | Digital Repository |
| 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 Proceeding Paper 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 |
| spellingShingle | QA76 Computer software Mior Nazri, Mior Nasir Noah, Shahrul Azman Hamid, Zarinah Using lexical ontology for semi-automatic logical data warehouse design |
| title | 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_short | Using lexical ontology for semi-automatic logical data warehouse design |
| title_sort | using lexical ontology for semi-automatic logical data warehouse design |
| topic | QA76 Computer software |
| 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 |