McGraw-Hill - Microsoft SQL Server 2008_ A Beginner_s Guide (2008)02 | Introduction xxix Chapter 25 Microsoft Reporting Services describes the Microsoft enterprise reporting solution. This component is used to design and deploy reports. This chapter discusses the development environment that you use to design and create reports and shows you different ways to deliver a designed and deployed report. Chapter 26 Optimizing Techniques for Business Intelligence describes two of several specific optimization techniques that can be used especially in the area of business intelligence data partitioning and star schema join optimization. The data partitioning technique called range partitioning is described. This partitioning type is entirely transparent to the application. In relation to star schema join optimization the role of bitmap filters in the optimization of schema joins is explained. Part V Beyond Relational Data is dedicated to two nonrelational topics XML and spatial data because SQL Server as a data platform doesn t have to handle only relational data. The following chapters are included in this part Chapter 27 Overview of XML gives you an overview of XML documents DTDs and XML Schema. A running example is used to demonstrate how XML documents can be validated using either a DTD or XML Schema. Chapter 28 SQL Server and XML discusses SQLXML Microsoft s set of data types and functions that supports XML in SQL Server 2008 bridging the gap between XML and relational data. The beginning of the chapter introduces the standardized data type XML and explains how stored XML documents can be retrieved. After that the presentation of relational data as XML documents is discussed in detail. Chapter 29 Introduction to Spatial Data discusses spatial data and two different data types GEOMETRY and GEOGRAPHY that can be used to create such data. Several different standardized functions in relation to spatial data are also shown. Almost all chapters include at their end numerous exercises that you can use to improve your knowledge concerning the .
