Dr. Ajay Kumar Phogat, is working as an Assistant Professor in Maharaja Surajmal Institute (Affiliated to GGSIPU, Dwarka, New Delhi). He has 16 years of teaching experience in various institutions. He did his Ph.D. & M.Tech in Information Technology from University School of Information Communication Technology, GGS Indraprastha University. He has published research papers in ESCI & Scopus journals & presented research papers in various National & International conferences. His areas of interest are Programming languages, Algorithms, DBMS and Data Mining & Data Warehouse.
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.