The purpose of this course is to focus on the design and implementation of data warehousing, data marts, and provide necessary knowledge of data.
Need for strategic information, Decision support system, Operational versus Decision-Support Systems, Data Warehousing-the only solution, definitions of Data warehousing and data mining, features of Data warehouse, Data Marts, Metadata.
Trends in Data Warehousing: significant trends and growth.
Planning Data warehouse, project team, project management considerations, information packages & requirements gathering methods and Requirements definition: Scope and Content.
Architectural components: Objectives, Data Warehouse Architecture, Distinguishing Characteristics, Architectural Framework. Infrastructure: Operational & Physical.
Implementation of Data warehouse, Physical design: steps, considerations, physical storage, indexing.
Basics of data mining, related concepts, Data mining techniques, Data Mining Applications.
1. Paulraj Ponnian, .Data Warehousing Fundamentals., John Wiley.
1. Data Mining Concepts and Techniques, Jiawei Hen and Micheline Kamber
2. Data warehousing with oracle by Sima Yazdani – Shirley s. Wong
3. Data Mining Concepts and Techniques, Han Kamber, Morgan Kaufmann
4. Introduction to Business Intelligence and Data Warehousing, PHI
5. The Data Warehouse Lifecycle tool kit, Ralph Kimball, John Wiley.