SQL Server 2000体系结构和对XML/Internet 的支持

Part 1 Introduction and Overview

Chapter 1 Welcome to the SQL Server 2000 Reference Library

Chapter 2 What’s New in SQL Server 2000

Relational Database Enhancements

XML Integration of Relational Data

Graphical Administration Enhancements

Replication Enhancements

Data Transformation Services Enhancements

Analysis Services Enhancements

Meta Data Services Enhancements

English Query Enhancements

Part 2 SQL Server 2000 Architecture

Chapter 3 Fundamentals of SQL Server 2000 Architecture

SQL Server 2000 Component Overview

Chapter 4 Features of SQL Server 2000

Integrated with the Internet

Scalability and Availability

Enterprise-Level Database Features

Ease of Installation, Deployment,and Use

Data Warehousing

Chapter 5 Relational Database Components

Database Applications and Servers

Logins

Client Components

Communication Components

Client and Server Net-Libraries

Controlling Net-Libraries and communications Addresses

Tabular Data Stream Protocol

Net-Library Encryption

Server Components

SQL Server Service

SQL Server Agent Service

Microsoft Search Service

MSSQL Server ADHelper Service

Multiple Instances of SQL Server

Federated SQL Server 2000 Servers

Failover Clustering Architecture

Active Directory Integration

SQL Server and XML Support

Chapter 6 Database Architecture

Logical Database Components

Data Types and Table Structures

SQL Views

SQL User-Defined Functions

Constraints,Rules,Defaults,and Triggers

Collations

SQL Indexes

Property Management

Full-Text Catalogs and Indexes

Logins,Users,Roles, and Groups

Owners and Permissions

Session Context Information

System Databases and Data

Physical Database Architecture

Pages and Extents

Physical Database Files and Filegroups

Space Allocation and Reuse

Table and Index Architecture

Transection Log Architecture

Chapter 7 Relational Database Engine Architecture

Relational Database Engine Architecture Overview

Database Engine Components

Query Processor Architecture

Single SQL Statement Processing

Batch Processing

Stored Procedure and Trigger Execution

Exection Plan Caching and Reuse

Parallel Query Processing

Memory Architecture

Dynamically Managing Memory on Windows NT and Windows 2000

Dynamically Managing Memory on Windows 95 and Windows 98

Using AWE Memory Pool

Thread and Task Architecture

SQL Server Task Scheduling

Thread and Fiber Execution

I/O Architecture

Reading Pages

Freeing and Writing Buffer Pages

Distributed Query Architecture

Full-Text Query Architecture

Full-Text Indexing Support

Full-Text Querying Support

Extended Stored Procedure Architecture

Remote Stored Procedure Architecture

Transections Architecture

Transaction Recovery

Concurrency Architecture

Locking Architecture

Distributed Transactions Architecture

Cursor Architecture

Server Scalability

SQL Server 2000 on Large Servers

SQL Server 2000 Databases on the Desktop

SQL Server 2000 on Windows 98

SQL Server 2000 and Windows CE

SQL Server and Mail Integration

Chapter 8 Administratin Architecture

DDL and Stored Procedures

SQL Distributed Management Framework

SQL-DMF Applications

SQL-DMF APIs

SQL Server Agent

Graphical Tools

SQL Server Enterprise

Manager

SQL Query Analyzer

Windows 2000 System Monitor

Import and Export Data

SQL Profiler

SQL Server Service Manager

Client Network Utility

Server Network Utility

Miscellaneous Utilities

Automated Administration Architecture

Backup/Restore Architecture

Backup Devices

Types of Backup and Restore Processes

Fuzzy Backup and Restore Processes

Parallel Backup and Restore

Data Import/Export Architecture

Data Integrity Validation

Replicatin Architecture

Chapter 9 Data Warehousing and Online Analytical Rocessing

Transforming OLTP Data to LOAP Data Warehouses

SQL Server 2000 Data Warehouse and LOAP Components

Chapter 10 Application Development Architecture

Choosing an API

SQL Server and ADO

SQL Server and Universal Resource Locators

SQL Server and ODBC

SQL-DMO API

SQL Namespace API

Replication Component Programming API

Data Transformation Services API

SQL Server and English Qurey

Extended Stored Procedure API

SQL Server and Embedded SQL

DB-Library API

SQL Syntax Recommendations

Chapter 11 Implementation Datails

Editions of SQL Server 2000

Operating Systems Supported by the Editions of SQL Server 2000

Features Supported by the Editions of SQL Server 2000

Maximum Capacity Specifications

Configuration Option Specifications

Memory Used by SQL Server Objects Specifications

Part 3 XML and Internet Support

Chapter 12 IIS Virtual Directory Management for SQL Server

System Requirements for IIS Virtual Directory Management

Using IIS Virtual Directory Management for SQL Server Utility

Creating the nwind Virtual Directory

IIS Virtual Directory Management for SQL Server Object Model

SQLVDirControl Object

SQLVDirs Collection Object

SQLVDir Object

VirtualNames Collection Object

VirtualName Object

Creating the nwind Virtual Directory Using the Object Model

Chapter 13 Accessing SQL Server Using HTTP

Three-Tier System Architecture

Special Characters

Executing SQL Statements Using HTTP

Executing Stored Procedures Using HTTP

Executing Template Files Using HTTP

Using XML Templates

Executing SQL Queries Using Templates

Passing Parameters to Templates

Specifying an XSL Style Sheet in a Template

Executing XPath Queries Using Templates

Executing XPath Queries Using HTTP

Accessing Database Objects Using HTTP

Sample Applications to Post Templates

Using HTML Forms to Post Templates

Posting Templates Directly to the Virtual Directory

Chapter 14 Creating XML Views Using Annotated XDR Schemas

Annotations to the XDR Schema

Default Mapping of XDR Elements and Attributes to Tables and Columns

Explicit Mapping of XDR Elements and Attributes to Tables and Colunms

Specifying Relationships Using <sql： relationship>

Creating Constant Elements Using sql： is-constant

Excluding Schema Elements from the Resulting XML Cocument Using sql：map-field

Filtering Values Using sql：limit-field and sql：limit-value

Identifying Key Colunms Using sql：key-fields

Specifying a Target Namespace Using sql：target-manespace

Creating Valid ID，IDREE，and IDREFS Type Attributes Using sql：id-prefix

Data Type Coercions

Creating CDATA Sections Using sql：use-cdata

Requesting URL References to BLOB Data Using sql：url-encode

Retrieving Unconsumed Data Using sql：overflow-field

Specifying Default Values for Attributes in the XDR Schema

Using Annotated XDR Schemas in Queries

Schema Caching

Chapter 15 Using XPath Queries

Gudelines for Using XPath Queries

Specifying a Location Path

Specifying an Axis

Apecifying a Node Test in the Location Path

Sample XPath Queries

Specifying Axes in XPath Queries

Specifying Boolean-Valued Predicates in XPath Queries

Specifying Relational Operators in XPath Queries

Specifying Arithmetic Operatros in XPath Queries

Specifying Explicit Conversion Functions in XPath Queries

Specifying Boolean Operators in XPath Queries

Specifying Boolean Functions in XPath Queries

Specifying XPath Variables in XPath Queries

XPath Data Types

Chapter 16 Retrieving and Writing XML Data

Retrieving XML Documents Using FOR XML

Writing XML Using OPENXML

Using OPENXML

Specifying Metaproperties in OPENXML

XML System Stored Procedures

Sample XML Applications

Chapter 17 OLE DB Provider for SQL Server Extensions for XML

Using ICommandStream to Set an XML Command

Part 4 Glossary and Index

SQL Server 2000 Glossary

Index Topics in the SQL Server 2000 Reference Library