Data mining and warehousing

144 Pages·2007·0.832 MB·English

by  Prabhu, S.;Vēṅkaṭēcan̲, Na

This page
intentionally left
blank

Copyright © 2007 New Age International (P) Ltd., Publishers
Published by New Age International (P) Ltd., Publishers
All rights reserved.
No part of this ebook may be reproduced in any form, by photostat, microfilm,
xerography, or any other means, or incorporated into any information retrieval
system, electronic or mechanical, without the written permission of the publisher.
All inquiries should be emailed to [email protected]
ISBN : 978-81-224-2432-4
PUBLISHING FOR ONE WORLD
NEW AGE INTERNATIONAL (P) LIMITED, PUBLISHERS
4835/24, Ansari Road, Daryaganj, New Delhi - 110002
Visit us at www.newagepublishers.com
Dedicated to our
beloved
Grandparents...
This page
intentionally left
blank
PREFACE
This book is intended as a text in data mining and warehousing for engineering and post-graduate
level students.
We have attempted to cover the major topics in data mining and warehousing in depth.
Advanced material, however, has been put into separate chapters so that courses in a variety of
levels can be taught from this book. A brief synopsis of the chapters and comments on their
appropriateness in a basic course is therefore appropriate.
Chapter 1 introduces the basic concepts to data mining and warehousing and its essentials.
Chapter 2 covers the types of knowledge and learning concepts, which are essential to data
mining techniques.
Chapter 3 covers how to discover the knowledge hidden in the databases using various
techniques.
Chapter 4 deals with various types of data mining techniques and algorithms available.
Chapter 5 covers various applications related to data mining techniques and real time usage of
these techniques in various fields like business, commercial organizations, etc.
Chapter 6 deals with the evaluation of data warehouse and need of the new design process
for databases.
Chapter 7 covers how to design the data warehouse using fact tables, dimension tables and
schemas.
Chapter 8 deals with partitioning strategy in software and hardware.
Chapter 9 covers the data mart and meta data.
Chapter 10 covers backup and recovery process.
Chapter 11 deals with performance, tuning of data warehouse, challenges, benefits and new
architecture of the data warehouse.
This book also contains sufficient material to make up an advanced course on data mining and
warehousing. Each and every chapter has exercise. Model question paper is also given. We conclude
that, this book is the only book, which deals both data mining techniques and data warehousing
concepts suited for the modern time.
This page
intentionally left
blank
ACKNOWLEDGEMENT
Thanks and gratitude is owed to many kind individuals for their help in various ways in the
completion of this book. Without such help, this book would indeed be poorer.
We first of all record our gratitude to the authorities of Bharathiyar College of Engineering and
Technology, Karaikal, whose efforts maintained the progress of our work and ultimately put us in
the right path.
Many experts made their contributions to the quality of writing by providing oversight and
critiques in their special areas of interest. We particularly thank Dr. S.R. Rajagopalan, Ph.D., Retd.
Scientist, N.A.L, Bangalore, for sparing his precious time in editing this book. We owe thanks to
our colleagues and friends who have added to this book by providing us with their valuable
suggestions. Such excellence as the book may have is owed in part to them, any errors are ours.
We are also indebted to our publishers Messrs. New Age International (P) Ltd. for their
tolerance of our many requests and especially for their commitment to this book and its authors.
Once again we acknowledge our family members and wish them to know that our thanks are
not merely “Proforma”, they are sincerely offered and well deserved.
We particularly thank my graduate students for contributing a great deal to some of the original
wording and editing.
And finally, each of us wishes to “doff his hat” to the other for the unstinting efforts to make
this book the best possible, for the willingness to accept the advice of the other, and for the faith
in our joint effort. We began writing this book an year ago as good friends and we completed it
as even better friends.
S. Prabhu
N.Venkatesan