Page 211 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 10: Multi-dimensional Data Models and Aggregation

7. Describe MOLAP model in detail. notes
8. Explain logical model for multidimensional information.

9. Distinguish between logical measures and logical dimensions.
10. Explain ROLL UP command in detail with the help of suitable example.

answers: self assessment

1. OLAP 2. Time dimension
3. many-to-many 4. three
5. star schema 6. snowflake schema
7. user queries 8. ROLL UP

9. SLICE 10. MOLAP-based

10.11 further readings

Books A. K. Jain and R. C. Dubes, Algorithms for Clustering Data, Prentice Hall, 1988.

Alex Berson, Data Warehousing Data Mining and OLAP, Tata Mcgraw Hill, 1997
Alex Berson, Stephen J. Smith, Data warehousing, Data Mining & OLAP, Tata
McGraw Hill, Publications, 2004.

Alex Freitas and Simon Lavington, Mining Very Large Databases with Parallel
Processing, Kluwer Academic Publishers, 1998.
J. Ross Quinlan, C4.5: Programs for Machine Learning, Morgan Kaufmann Publishers,
1993.
Jiawei Han, Micheline Kamber, Data Mining – Concepts and Techniques, Morgan
Kaufmann Publishers, First Edition, 2003.
Matthias Jarke, Maurizio Lenzerini, Yannis Vassiliou, Panos Vassiliadis,
Fundamentals of Data Warehouses, Publisher: Springer
Michael Berry and Gordon Linoff, Data Mining Techniques (For Marketing, Sales,
and Customer Support), John Wiley & Sons, 1997.
Michael J. A. Berry, Gordon S Linoff, Data Mining Techniques, Wiley Publishing
Inc, Second Edition, 2004.

Sam Anohory, Dennis Murray, Data Warehousing in the Real World, Addison
Wesley, First Edition, 2000.
Sholom M. Weiss and Nitin Indurkhya, “Predictive Data Mining: A Practical Guide”,
Morgan Kaufmann Publishers, 1998.
Sushmita Mitra, Tinku Acharya, Data Mining – Multimedia, Soft Computing and
Bioinformatics, John Wiley & Sons, 2003.

LoveLy professionaL university 205