文章基本信息

标题：A Semantic Resource Based Approach for Star Schemas Matching
本地全文：下载
作者：Elhaj Elamin ; Amer Alzaidi ; Jamel Feki 等
期刊名称：International Journal of Database Management Systems
印刷版ISSN：0975-5985
电子版ISSN：0975-5705
出版年度：2018
卷号：10
期号：6
出版社：Academy & Industry Research Collaboration Center (AIRCC)
摘要：The hybrid approach is widely used in constructing data warehouse (DW) schemas. It relies on a complexprocess 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 asemantic resource during this matching helps solving heterogeneity problems. This paper suggests a semiautomaticapproach 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 approachconsists of three steps: i) Match DS-Stars with BR-Stars; ii) Involve the DW designer for approval of thematching process; and then iii) Generate approved star schemas. We have defined two Boolean functionsand four semantic metrics for the matching process. We have developed a software prototype for testingour approach.
关键词：Star schemas matching; Hybrid approach; Data warehousing; Semantic resource.