A Semantic Resource Based Approach for Star Schemas Matching

 Paper Title: 

A Semantic Resource Based Approach for Star Schemas Matching

Authors: 

Elhaj Elamin1, Amer Alzaidi2 and Jamel Feki2, Sudan University of Science and Technology, Sudan and University of Jeddah, Saudi Arabia


Abstract:

The hybrid approach is widely used in constructing data warehouse (DW) schemas. It relies on a complex process for matching two sets of multidimensional star schemas: schemas built from business requirements (BR-Star schemas) and schemas constructed on the organization data source (DS-Star schemas). Using a semantic resource during this matching helps solving heterogeneity problems. This paper suggests a semiautomatic approach for the construction of approved star schemas by matching DS-Star schemas with BRStars, and by using WordNet as a semantic resource for solving heterogeneity issues. This approach consists of three steps: i) Match DS-Stars with BR-Stars; ii) Involve the DW designer for approval of the matching process; and then iii) Generate approved star schemas. We have defined two Boolean functions and four semantic metrics for the matching process. We have developed a software prototype for testing our approach. 

Keywords:

Star schemas matching, Hybrid approach, Data warehousing, Semantic resource.

Volume URL: https://airccse.org/journal/ijdms/current2018.html

Pdf URL: https://aircconline.com/ijdms/V10N6/10618ijdms02.pdf

#consumerscience #solotravel #emotionalandbusinessintelligence #gpsnonorganicfacebookadvert #primaryquantitativedata #callforpapers #researchpapers #cfp #researchers #phdstudent #education #learning #online #researchScholar #journalpaper #submission #journalsubmission #EngineeringExcellence #TechCommunity #DevOps #AgileMethodology


Comments

Popular posts from this blog

3rd International Conference on Computer Science, Engineering and Artificial Intelligence (CSEAI 2025)

A REVIEW OF THE USE OF R PPROGRAMMING FOR DATA SCIENCE RESEARCH IN BOTSWANA

HYBRID ENCRYPTION ALGORITHMS FOR MEDICAL DATA STORAGE SECURITY IN CLOUD DATABASE