An Object Oriented Data Warehouse Design

Data warehouses are basis of decision support systems (DSS) that provide analytical results for making im portant business decisions. In a data warehouse, analytical results are derived from large volume of historical and operati onal data integrated from heterogeneous sources. The data warehouse has to support different complex queries therefore the design technique should be different from the traditional ones. Object oriented design technique is best suited to Data Warehouse design as it is a collection of objects that intera ct with each other. Which enhance the decision making capability of Data Warehouse. In our paper we describe a technique for designing of a relational schema from an object model and then transformed it into data warehouse. Keywords (DSS)

[1]  Mohd Khalid Awang,et al.  TRANSFORMING OBJECT ORIENTED DATA MODEL TO RELATIONAL DATA MODEL , 2012 .

[2]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[3]  Michael R. Blaha,et al.  Object-Oriented Modeling and Design for Database Applications , 1997 .

[4]  Amy Turske The Evolutionary Data Warehouse--An Object-Oriented Approach , 1997 .

[5]  Adriana Marotta,et al.  Data warehouse design: a schema-transformation approach , 2002, 12th International Conference of the Chilean Computer Science Society, 2002. Proceedings..

[6]  William E. Lorensen,et al.  Object-Oriented Modeling and Design , 1991, TOOLS.