Chapter 5 -- Defining the Technical Architecture for a Solution

Chapter 5

About This Chapter

The preceding chapters have been largely conceptual and design-oriented. This chapter begins the process of making the data warehouse a reality. First, you will examine the framework that supports the implementation of a data warehouse. Then, you will examine the specific features within both Microsoft SQL Server and Microsoft OLAP Server that support effective data warehouse administration and use. Finally, you will begin implementation by creating the star schema database in your data mart. Subsequent chapters will examine in greater detail the framework and features that are introduced in this chapter.

Before You Begin

To complete the lessons in this chapter, you must

  • Have installed SQL Server 7
  • Be able to log on to SQL Server with sufficient rights to create a database
  • Have installed the Exercise files from the Supplemental Course Materials CD-ROM to your hard disk drive. See the "Getting Started" section in "About This Book" for installation instructions.


Microsoft Corporation - Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net