|
Free ebooks
 Free database ebooks SQL Building a Data Warehouse: With Examples in SQL Server
|
 Chapter 1 Introduction to Data Warehousing - In this chapter, I will discuss what a data warehouse is, how data warehouses are used today, and the future trends of data warehousing.Chapter 2 Data Warehouse Architecture - In this chapter, I will discuss the data flow architecture first and then the system architecture. Chapter 3 Data Warehouse Development Methodology - In this chapter, I will explain the process, or methodology, of building a data warehouse. Chapter 4 Functional and Nonfunctional Requirements - In this chapter, I will use the Amadeus Entertainment case study described in Chapter 2 to show how to gather functional and nonfunctional requirements. Chapter 5 Data Modeling - In this chapter, we will design the data stores for the Amadeus Entertainment case study. Chapter 6 Physical Database Design - This chapter will cover how we implement those data stores physically as SQL Server databases. Chapter 7 Data Extraction - You will learn how to extract the data from the source systems. Chapter 8 Populating the Data Warehouse - In this chapter, I will also discuss and compare batches, mini-batches, and the near realtime approach, because the latter two approaches are becoming more and more popular these days. Chapter 9 Assuring Data Quality - In this chapter, we’ll explore why data quality is important, and I’ll explain why there is no point having a data warehouse if we cannot trust the data in the warehouse. Chapter 10 Metadata - In this chapter, I will discuss what metadata is in a data warehousing context, why metadata is important in data warehousing, what it is used for, how to store it, and how to maintain it. Chapter 11 Building Reports - In this chapter, you will learn how to use SQL Server 2005 Reporting Services to create reports to bring the data from the data warehouse to the users. Chapter 12 Multidimensional Database - In this chapter, I’ll cover, step by step, what MDBs are, what they are for, how to design them, how to populate them, how to query them, and how to administer them. Chapter 13 Using Data Warehouse for Business Intelligence - In this chapter and the next two chapters, I will discuss the applications of data warehouses. Chapter 14 Using Data Warehouse for Customer Relationship Management - In this chapter, I will discuss how to use a data warehouse to perform CRM activities, including creating a single customer view, performing campaign segmentation, managing permissions, monitoring deliverability, performing customer analysis, managing customer support, managing personalization, and administering loyalty schemes. Chapter 15 Other Data Warehouse Usage - In this chapter, I will discuss data warehousing within the context of customer data integration (CDI) and unstructured data. Chapter 16 Testing Your Data Warehouse - In this chapter, I will focus on the mechanism and procedure of how each type of test is conducted specifically within the data warehousing context. Chapter 17 Data Warehouse Administration - This chapter is about the second half of the diagram in Figure 17-1: operation. In particular, I will discuss the DW administrator tasks, including monitoring ETL, monitoring data quality, managing security, and managing databases. Download free ebooks for SQL:Building a Data Warehouse: With Examples in SQL Server
|
