A Dimension Integration Method for a Heterogeneous Data Warehouse Environment

Data Warehousing is the main Business Intelligence instruments that allows the extraction of relevant, aggregated information from the operational data, in order to support the decision making process inside complex organizations. Following recent trends in Data Warehousing, companies realized that there is a great potential in combining their information repositories in order to offer all participants a broader view of the economical market. Unfortunately, even though Data Warehouse integration has been defined from a theoretical point of view, until now no complete, widely used methodology has been proposed to support Data Warehouse integration. This paper proposes a method that is able to achieve both schema and instance level integration of heterogeneous Data Warehouse dimensions attributes by exploiting the topology of dimensions and the dimension-chase procedure.