A Semantic Resource Based Approach for Star Schemas Matching

摘要

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.