Generating data mart schema from OLAP requirements

Abstract

Warehousing projects can know cases of failure because they did not take into consideration the users' needs especially if they are not experienced with the technologies of data warehouses. The solution consists on building the data warehouse incrementally by designing and implementing one data mart at a time. In this work we propose a method to design data mart schema from OLAP requirements that are presented as schemas and grouped according to their domain. We apply the data integration technique to merge the different schemas so that we get one data mart schema by group. The integration is composed by schema matching (detecting semantic correspondence and the conflicts) and schema mapping (solving the existing conflict).