复制与自然语言查询

Part 1 Replication

Chapter 1 Introducing Replication

Replication Model

Introducing The Types of Replication

Introducing Replication Options

Typical Uses of Replication

Reporting，Decision Support，and Data Warehousing Applications

Online/Offine Applications

Web-Based Applications

Keeping Data Close to Users

How Replication Works

Methods of Implementation

Agents and Monitors

Chapter 2 planning For Replication

Distributed Update Factors

Evaluating the Replication Environment

Business Objectives and Requirements

Network Considerations

Security Considerations

Data Needs and Characteristics

Planning for Application Development

Planning for Each Type of Replication

Planning for snapshot Replication

Planning for Transactinal Replication

Planning for Replication Options

Merge Replication or Updateable Subscriptions

Designing a Replication Topology

Physical Replication Models

Chapter 3 Types of Replication

Snapshot Replication

How Snapshot Replication Works

Transactional Replication

How Transactional Replication Works

Merge Replication

How Merge Replication Works

Merge Replication Conflict Detection and Resolution

Chapter 4 Replication Tools

Replicatin and SQL ServerEnterprise Manager

Replication Wizards

Replication Properties

Replication Icons

Replication Programming Interfaces

Programming Replication with ActiveX Controls

Programming Replication with SQL-DMO

Programming Replication with the Replication Distributor Interface

Transact-SQL System Stored Procedures

Windows Synchronization Manager

Active Directory Services

Chapter 5 Implementing Replication

Configuring Replixation

Publishers，Distributors，and Subscribers

Disabling Publishing and Distribution

Publishing Data and Database Objects

Publishing Stored Procedure Execution

Using Custom Stored Procedures in Articles

Subscribing to Publications

Push Subscriptions

Pull Subscriptions

Anonymous Subscriptions

Applying the Initial Snapshot

Generating the Initial Snapshot

Alternate Snapshot Locations

Conpressed Snapshot Files

Exploring Snapshots

Transferring Snapshots

Attachable Subscription Databases

Improving Performance While Generating and Applying Smapshots

Executing Scripts Before and After the Smapshot is Applied

Reinitialzing Subscriptions

Synchronizing Data

Scripting Replication

Schema Changes on Publication Databases

Implementing Replication Over the Internet

Publishing Data Over the Internet Using Microsoft Proxy Server

Publishing Data Over the Internet Using TCP/IP and FTP

Replication Between Different Versions of SQL Server

SQL Server 7.0 Publisher/Distributor to SQL Server 6.5 Subscriber

SQL Server 7.0 Publisher/Distributor to SQL Server 6.5 Subscriber

SQL Server 6.5 Publisher to SQL Server 7.0 Distributor

Replication with SQL Server 2000 Windows CE Edition

Chapter 6 Replication Options

Filtering Published Data

Row Filters

Column Filters

Dynamic Filters

Join Filters

User-Defined Functions and Static Filters

User-Defined Functions and Dynamic Filters

Updatable Subscriptions

Immediate Updating

Queued Updating

Immediate Updating with Queued Updating as a Failover

Transforming Published Data

Alternate Synchronization Partners

How Alternate Synchronization Partners Works

Optimizing Synchronization

Chapter 7 Replication Data Considerations

Using IDENTITY Values with Replication

Managing Identity Values

Identity Ranges with Immediate Updating and Queued Updaing

Managing Replicated timestamp Data

Using NOT FOR REPLICATION

Chapter 8 Administering and Monltoring Replication

Tools for Administering and Monitoring Replication

Replication Monitor

Replication Agent utilities

ActiveX Controls for Replication

Windows NT Performance Monitor and Windows 2000 System monitor

Setting Agent Parameters

Agent Profiles

Replication Agents

SQL Server Agent

Snapshot Agents

Distribution Agents

Log Reader Agents

Queue Reader Agents

Merge Agents

Miscellaneous Agents

Viewing Agent History

Handling Agent Errors

Remote Agent Activation

Replication Alerts

Automating a Response to an Alert

Predefined Response Jobs

Subscription Deactivation and Expiration

Validating Replicated Data

Chapter 9 Replication and Heterogeneous Data Sources

Heterogeneous Subscribers

Access Subscribers

Oracle Subscribers

IBM DB2/AS400 Subscribers

IBM DB2/MVS Subscribers

Other Heterogeneous Subscribers

Implementing Merge Replication to Access Subscribers

Heterogeneous Publishers

Chapter 10 Replication Security

Role Requirements

Connecting to the Distributor

Snapshot Folder Security

Publication Access Lists

Agent Login Security

Security and Replication Optins

Security and Replication Over the Internet

Chapter 11 Enhancing Replication Performance

Enhancing Snapshot Replication Performance

Enhancing Snapshot and Transactional Replication Performance

Enhancing Transactional Replication Performance

Enhancing Merge Replication Performance

Chapter 12 Backing Up and Reatoring Replication Databases

Strategies for Backing Up and Restoring Snapshot Replication

Strategies for Backing Up and Restoring Transactional Replication

Transactional Replication and Log Shipping

Strategies for Backing Up and Restoring Merge Replication

Restoring Backups of Replicated Databases to the Same Server and Database

Restoring Backups of Replicated Databases to a Different Server or Database

Part 2 English Query

Chapter 13 English Query Overview

What’s New In English Query

Installation Requirements and Considerations

Chapter 14 English Query Fundamentals

English Query Fundamentals

SQL Database Normalization Rules

Updating or Replacing Models

Importing and Exporting Models to Meta Data Services

Chapter 15 Develoying English Query Applications

Creating an English Query Model

Expanding an English Query Model

Creating a Mixed English Query Model

Enabling Analysis Services for an English Query Model

Enabling SQL for an English Query Model

Enabling Full-Text Search for an English Query Model

Defining Entities in an English Query Model

Using Command Relationships in an English Query Model

Authoring with Semantic Modeling Format

Testing an English Query Model

Compiling an English Query Application

Deplying an English Query Qpplication

Adding Question Bulider to an English Query Application

Automatic Clarification of Questions

Run-Time Environment for English Query Applications

Redistributing the English Query Run-time DLLs

Sample Applications and Client Interfaces

Chapter 16 Analysis Services in English Query

Naming Entities in the OLAP Project Wizard

Creating Relationships in the LOAP Project Wizard

Level-Level Relationships

Additional Relationships

Analysis Services Requirements for （All）Level

Chapter 17 Object Model Reference

Authoring Object Model

Authoring Object Model Diagram

Authoring Objects Summary

Authoring Properties Summary

Authoring Methods Summary

Authoring Sample Script

Engine Object Model

Engine Object Model Diagram

Engine Objects Summary

Engine methods Summary

Engine Collections Summary

Engine collections Methods Summary

Question Bulider Object Model

Question Bulider Object Model Diagram

Question Bulider Objects Summary

Question Bulider Properties Summary

Question Bulider Methods Summary

Question Bulider Collections Summary

Question Bulider Collections Methods Summary

Chapter 18 How To Perform Common English Query Tasks

Working with Projects

How to add a new project to a solution

How to add an existing project to a solution

How to create a new project

How to create a new project using the SQL Project wizard

How to remove a database from a project

How to remove a project from the solution

How to create and modify project properties

How to add a module

How to remove a module

How to modify the data source in a project

Working with Models

How to add a join

How to delete a join

How to edit a join

Working with Tables

How to add a field to a table

How to add a table

How to add tables and views from a SQL data source

How to change the table options for a relationship

How to delete a table

How to edit a table

How to enable full-text searching for a field

How to refresh all tables in a project

Working with Entities

How to add an entity to a relationship

How to create an entity

How to delete an entity

How to delete an entity from a relationship

How to edit an entity

How to edit the entity’s role in a relationship

Working with Relationships

How to add a relationship

How to add phrasings to a relationship

How to add time and location options to a relationship

How to create a relationship using the Canvas pane

How to create relationships from the Model Test Window

How to create relationships using the Create Relationships command

How to associate English Data values with a relationship

How to delete a relationship

How to modify a relationship

Working with Dictionary Entries

How to add a dectionary entry

How to delete a dictionary entry

How to edit a dictionary entry

Wirking with Command Relationships

How to add a phrasing to a command relationship

How to create a command relationship

How to create time and location optiions for command relationships

How to delete a command relationship

How to edit a command relationship

Working with Analysis Services（formerly OLAP Services）

How to edit an Analysis Services （formerly OLAP）cube to a model

How to edit an Analysis Services（formerly OLAP）cube

How to edit Analysis Services levels

How to edtit Analysis Services（formerly OLAP）measures

How to edtit Analysis Services（formerly OLAP）properties

How to enable Analysis Services（formerly OLAP）

How to manually map OLAP objects to the underlying SQL database objects

How to remove an Analysis Services （formerly OLAP）cube

Testing and Building a Model

How to add a new or existing regression test file to a project

How to build an application

How to edit a regression test file

How to remove a regression test file

How to rename a regression test file

How to save model test information to a regression test file

How to save the regression output to a regression test file

How to set the Samlpe Data option

How to test a model

How to view the differences between the current regression test file and the

regression output file

How to view the output of a regression test created using the Run Regression command

How to deploy an application to the Web

Index A Topics in the SQL Server 2000 Reference Library

Index B Indes of English Query Elements