Paper Code: ETCS 310	L          T          C
Paper: Data Warehousing and Data Mining	3           1           4

UNIT - I

The Compelling Need for data warehousing:

Escalating Need for strategic information, failures of Past decision-support systems, operational versus decision-support systems, data warehousing – the only viable solution, data warehouse defined

Data warehouse – The building Blocks:

Defining Features, data warehouses and data marts, overview of the components, metadata in the data warehouse

Defining the business requirements:

Dimensional analysis, information packages – a new concept, requirements gathering methods, requirements definition: scope and content

UNIT - II

Principles of dimensional modeling:

Objectives, From Requirements to data design, the STAR schema, STAR Schema Keys, Advantages of the STAR Schema

Dimensional Modeling:

Updates to the Dimension tables, miscellaneous dimensions, the snowflake schema, aggregate fact tables, families of STARS

UNIT - III

OLAP in the Data Warehouse:

Demand for Online analytical processing, need for multidimensional analysis, fast access and powerful calculations, limitations of other analysis methods, OLAP is the answer, OLAP definitions and rules, OLAP characteristics, major features and functions, general features, dimensional analysis, what are hypercubes? Drill-down and roll-up, slice-and-dice or rotation, OLAP models, overview of variations, the MOLAP model, the ROLAP model, ROLAP versus MOLAP, OLAP implementation considerations.

UNIT - IV

Data Mining Basics:

What is Data Mining, Data Mining Defined, The knowledge discovery process, OLAP versus data mining, data mining and the data warehouse, Major Data Mining Techniques, Cluster detection, decision trees, memory-based reasoning, link analysis, neural networks, genetic algorithms, moving into data mining, Data Mining Applications, Benefits of data mining, applications in retail industry, applications in telecommunications industry, applications in banking and finance.

TEXT BOOKS:

1. Paul Raj Poonia, “Fundamentals of Data Warehousing”, John Wiley & Sons, 2004.
2. Sam Anahony, “Data Warehousing in the real world: A practical guide for building decision support systems”, John Wiley, 2004

REFERENCE BOOKS:

1. W. H. Inmon, “Building the operational data store”, 2nd Ed., John Wiley, 1999.
2. Kamber and Han, “Data Mining Concepts and Techniques”, Hartcourt India P. Ltd., 2001
3. “Data Warehousing”, BPB Publications, 2004.