AN OBJECT ORIENTED MULTIDIMENSIONAL MODEL FOR DATA WAREHOUSE

Organizations, to have a competitive edge upon each other, resort to business intelligence which refers to information available for enterprise to make strategic decisions. Data warehouse being the repository of data provides the backend for achieving business intelligence. The design of data warehouse, thereby, forms the key, to extract and obtain the relevant information facilitating to make strategic decisions. The initial focus for the design had been upon the conceptual models but now object oriented multidimensional modelling has emerged as the foundation for the designing of data warehouse. Several proposals have been put forth for object oriented multidimensional modelling, each incorporating some or other features, but not all. This paper consolidates all the features previously introduced and the new introduced, thus, proposing a new model having features to be incorporated while designing the data warehouse.