Database and data warehouse applications deal with huge amount of data. In real life applications managing this huge amount of data is a big challenge. This book is designed to discuss the data models and various materialization techniques to overcome the problem of access time & storage space in data warehouse.

The different types of multidimensional structures are discussed in this book and compared the architecture of the models. Optimal view selection algorithm were discussed and proposed in this book for better decesion support systems. Optimizations techniques are required to reduce the space and time constraint. In this book author have proposes data cube computation algorithm for efficient view selection in multidimensional model. The proposed algorithm provides formal analysis leading toward detection of an optimal path for any two given valid pair of cuboids at different levels. A Comparative analysis of multidimensional model structures such as Traditional Lattice and Hyper-Lattice has been done in which we found that hyper lattice structure is more flexible and also a storage economic structure compare to traditional structure as less cuboids are generated at every level in lattice when we add new dimension in the structure.