CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Automated Creating a Data Warehouse from Unstructured Semantic Data

by Shiva Talebzadeh, Mir Ali Seyyedi, Afshin Salajegheh
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 88 - Number 10
Year of Publication: 2014
Authors: Shiva Talebzadeh, Mir Ali Seyyedi, Afshin Salajegheh
10.5120/15388-3765

Shiva Talebzadeh, Mir Ali Seyyedi, Afshin Salajegheh . Automated Creating a Data Warehouse from Unstructured Semantic Data. International Journal of Computer Applications. 88, 10 ( February 2014), 19-25. DOI=10.5120/15388-3765

@article{ 10.5120/15388-3765,
author = { Shiva Talebzadeh, Mir Ali Seyyedi, Afshin Salajegheh },
title = { Automated Creating a Data Warehouse from Unstructured Semantic Data },
journal = { International Journal of Computer Applications },
issue_date = { February 2014 },
volume = { 88 },
number = { 10 },
month = { February },
year = { 2014 },
issn = { 0975-8887 },
pages = { 19-25 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume88/number10/15388-3765/ },
doi = { 10.5120/15388-3765 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:07:15.834337+05:30
%A Shiva Talebzadeh
%A Mir Ali Seyyedi
%A Afshin Salajegheh
%T Automated Creating a Data Warehouse from Unstructured Semantic Data
%J International Journal of Computer Applications
%@ 0975-8887
%V 88
%N 10
%P 19-25
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The use and analysis of unstructured semantic data such as text files, semantic web, and etc which have been included the bulk of the available data sources, such as Internet due to their high volume and the extent of their resources is very complicated and time consuming process. In this context, the ontology for modeling and better understanding this data is used. So far, various methods for creating a relational database from ontology are proposed, however, creating of data warehouse from these unstructured data due to the possibility of using OLAP, top speed of reporting and its other benefits has received much attention. Numerous approaches and implementations of creating data warehouse from semantic data have been introduced. However, they still have the following disadvantages: human-dependence, semi-automatic, losing data and relations, etc. In this paper, a solution for automated creating a data warehouse from unstructured semantic data using ontology is proposed. So that, in the absence of a business analyst, all classes and relationships and data defined in the ontology data is created in a data warehouse format. In this paper, showing ontology using Protégé, language OWL and RDF is done.

References
  1. Joel Villanueva1,Chávez, Xiaoou Li1," Ontology based ETL process for creation of ontological data warehouse", IEEE Intelligent Systems, 16:1, 2011.
  2. Azman Taa, Mohd Syazwan Abdullah, Norita Md. Norwawi," A goal-ontology approach to analyse the requirements for data warehouse systems", ISSN: 1790-0832- Issue 2, Volume 7, February 2010
  3. O. Romero and A. Abelló, "Automating Multidimensional Design from Ontologies", in DOLAP'07, Lisboa, Portugal, 2007.
  4. Skoutas, D. , & Simitsis, A. (2006). "Designing ETL Processes Using Semantic Web Technologies". In Proc. of the 9th ACM International Workshop on Data Warehousing and OLAP.
  5. Dimitrios Skoutas, Alkis Simitsis, and Timos Sellis," Ontology-driven Conceptual Design of ETL Processes using Graph Transformations", Springer Journal on Data Semantics(JoDS), Special issue on Semantic Data Warehouses" (JoDS XIII), LNCS 5530, pp. 119-145, 2009. "
  6. Azman Ta'a, Mohd Syazwan Abdullah," Goal-ontology approach for modeling and designing ETL processes", Science Direct Procedia Computer Science 3 (2011) 942–948
  7. Oscar Romero , Alberto Abelló ," A framework for multidimensional design of data warehouses from ontologies", Science Direct Data & Knowledge Engineering 69 (2010) 1138–1157
  8. Michael Granitzer , Vedran Sabol , Kow Weng Onn, Dickson Lukose and Klaus Tochtermann," Ontology Alignment—A Survey with Focus on Visually Supported Semi-Automatic Techniques", Future Internet 2010, 2, 238-258; doi:10. 3390/fi2030238
  9. Wache. H, Vogele, T. , Visser, U. , Stuckenschmidt, H. , Schuster, G. , Neumann, H. , Hubner, S. : Ontology-based integration of information - a survey of existing approaches. In: Proc. of IJCAI-01 Workshop: Ontologies and Information Sharing. (2001) 108-117
  10. Azman Ta'a1, Mohd. Syazwan Abdullah2 and Norita Md. Norwawi3,"Goal-ontology ETL processes specification", Journal of ICT, 2010, pp: 15–43
  11. Victoria Nebot, Rafael Berlanga," Building Data Warehouses with Semantic Data", EDBT 2010, March 22–26, 2010, Lausanne, Switzerland
  12. Anirban Sarkar,Sankhayan Choudhury," Conceptual Level Design of Object Oriented Data Warehouse:Graph Semantic Based Model", Department of Computer Science, University of Calcutta, Kolkata, India,2009
  13. Ernestas Vysniauskas,Lina Nemuraite," Transforming Ontology Representation From owl to Relational DataBase", Department of Information System, Kaunas University of Technology, Studentu st. Kaunas, Lithuania,2006
Index Terms

Computer Science
Information Sciences

Keywords

Ontology Data warehouse OLAP Semantic Data

Powered by PhDFocusTM