Parab Publications

Materialized View Selection in Multidimensional Model

Dr Ajay Kumar Phogat

FORMAT:

Paperback and e-book

ISBN

978-81-19585-24-3

DOI

doi.org/10.5281/zenodo.12748451

PAGES

107 pages

PRICE

Rs. 1000/- ($80)

DOWNLOAD PDF
About The Author

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.


About The Book

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.



INSTAGRAM FEEDS

SIGN UP TO OUR NEWSLETTER