An approach to Design Object Oriented Data Warehouse

Data warehouses are repository of data from wide range of sources that provide analytical results for making significant business decisions. As data warehouse has to support different complex queries therefore the design technique should be different from the traditional ones. The best suited technique is object oriented data warehouse design technique which is collection of objects that interact with each other. That further enhances the decision making capability of Data Warehouse. In our paper we illustrate a technique for designing of a relational schema from an object model, represent in their UML form and then transformed it into data warehouse. We also draw the trace diagram that actually.