Page 228 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Data Warehousing and Data Mining

notes 8. Distinguish between full scan technique and RID index technique.
9. How will you calculate cost for simple hash-join? Explain.

10. Explain “A bitmap filter is useful only if it is selective”.
answers: self assessment

1. (b)
2. (a)
3. query
4. search criteria
5. Binary search

6. Primary index-scan for equality
7. Query optimizers
8. Bitmap filtering
9. read only

10. Transaction Processing System (TPS)
11.10 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.

222 LoveLy professionaL university