Unit - I
Introduction to Data Warehousing: Evolution of Data Warehousing, Data Warehousing concepts, Benefits of Data Warehousing, Comparison of OLTP and Data Warehousing, Problems of Data Warehousing.
Architecture: Operational Data and Datastore, Load Manager, Warehouse Manager, Query Manager, Detailed Data, Lightly and Highly summarized Data, Archive/Backup Data, Meta-Data, architecture model, 2-tier, 3-tier and 4-tier data warehouse, End user Access tools.
Unit - II
Tools and Technologies: Extraction, cleaning and Transformation tools, Data Warehouse DBMS, Data Warehouse Meta-Data, Administration and management tools, operational vs. information Systems. OLAP & DSS support in data warehouse.
Unit-3
Host based, single stage, LAN based, Multistage, stationary distributed & virtual data-warehouses. Data warehousing Design: Designing Data warehouse Database, Database Design Methodology for Data Warehouses, Data Warehousing design Using Oracle.
Unit-4
Basic Data Mining tasks, Knowledge discovery in databases, Issues, OLTP systems, Fuzzy sets and Fuzzy logic, Information Retrieval, Dimensional Modeling, OLAP, Web search engines, Data Mining Techniques
Unit-5
Large items sets, Basic Algorithms