Generating Data Mart Schema from OLAP Requirements
Nouha Arfaoui, Jalel Akaichi
International Journal of Computational Linguistics Research, Vol. 4, No. 2, 2013.
DOI: 
Link: http://www.dline.info/jcl/fulltext/v4n2/3.pdf
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).