Appendix F -- Summarizing Data

About This Appendix

One of the important benefits of client/server architecture is the ability of database servers to quickly and efficiently produce summaries of large amounts of data and send small result sets to client applications. In this appendix, you will learn how to use the features of SQL Server that allow you to create queries that summarize data.

Generally, summarizing data with SQL statements is too slow and not flexible enough for querying data in a data warehouse. This is why data warehouse data is further processed into OLAP cubes. Using SQL to summarize data is nevertheless an important technique to use when transforming source data into the data warehouse database.

Before You Begin

To complete the lessons in this appendix, you must

  • Have installed SQL Server 7.0.
  • Be able to log on SQL Server with Administrator privileges.
  • Know the basics of SQL syntax (Appendix C, "Performing Basic Queries," covers basic SQL queries, including exercises).
  • 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.
  • Complete the exercises in Appendix E or run the C:\SQLDW\Exercise\bldlib\bldlib.CMD batch file with an appendix parameter of F.


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