复制与自然语言查询 英文本【2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载】

复制与自然语言查询 英文本PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Introduction1

Part 1 Replication5

Chapter 1 Introducing Replication7

Replication Model8

Introducing the Types of Replication10

Introducing Replication Options12

Typical Uses of Replication14

Reporting, Decision Support, and Data Warehousing Applications15

Online/Offline Applications17

Web-Based Applications19

Keeping Data Close to Users20

How Replication Works21

Methods of Implementation23

Agents and Monitors26

Data Needs and Characteristics26

Chapter 2 Planning For Replication29

Distributed Update Factors29

Business Objectives and Requirements32

Evaluating the Replication Environment32

Network Considerations34

Security Considerations35

Planning for Application Development39

Planning for Each Type of Replication40

Planning for Snapshot Replication41

Planning for Transactional Replication42

Planning for Merge Replication45

Planning for Replication Options49

Merge Replication or Updateable Subscriptions52

Designing a Replication Topology52

Physical Replication Models53

Chapter3 Types of Replication61

Snapshot Replication62

How Snapshot Replication Works63

Transactional Replication66

How Transactional Replication Works67

Merge Replication73

How Merge Replication Works74

Merge Replication Conflict Detection and Resolution83

Chapter 4 Replication Tools103

Replication and SQL Server Enterprise Manager103

Replication Wizards104

Replication Properties107

Replication Icons112

Replication Programming Interfaces114

Programming Replication with ActiveX Controls114

Programming Replication with SQL-DMO115

Programming Replication with the Replication Distributor Interface116

Transact-SQL System Stored Procedures116

Windows Synchronization Manager117

Active Directory Services118

Chapter 5 Implementing Replication121

Configuring Replication122

Publishers, Distributors, and Subscribers123

Publishing Data and Database Objects125

Disabling Publishing and Distribution125

Publishing Stored Procedure Execution128

Using Custom Stored Procedures in Articles131

Subscribing to Publications133

Push Subscriptions135

Pull Subscriptions137

Anonymous Subscriptions138

Applying the Initial Snapshot139

Generating the Initial Snapshot140

Compressed Snapshot Files141

Alternate Snapshot Locations141

Exploring Snapshots143

Transferring Snapshots143

Attachable Subscription Databases145

Improving Performance While Generating and Applying Snapshots147

Executing Scripts Before and After the Snapshot is Applied149

Reinitializing Subscriptions150

Synchronizing Data151

Scripting Replication153

Schema Changes on Publication Databases154

Implementing Replication Over the Internet158

Publishing Data Over the Internet Using VPN159

Publishing Data Over the Internet Using Microsoft Proxy Server159

Publishing Data Over the Internet Using TCP/IP and FTP160

Replication Between Different Versions of SQL Server162

SQL Server 7.0 Publisher/Distributor to SQL Server 6.5 Subscriber163

SQL 6.5 Publisher/Distributor to SQL Server 7.0 Subscriber165

SQL Server 6.5 Publisher to SQL Server 7.0 Distributor165

SQL Server 7.0 Publisher/Distributor to SQL Server 6.0 Subscriber165

Replication with SQL Server 2000 Windows CE Edition166

Chapter 6 Replication Options167

Filtering Published Data169

Row Filters169

Column Filters172

Dynamic Filters174

Join Filters180

User-Defined Functions and Static Filters183

User-Defined Functions and Dynamic Filters184

Updatable Subscriptions185

Immediate Updating186

Queued Updating194

Immediate Updating with Queued Updating as a Failover206

Transforming Published Data207

Alternate Synchronization Partners219

How Alternate Synchronization Partners Works219

Optimizing Synchronization220

Using IDENTITY Values with Replication223

Chapter 7 Replication Data Considerations223

Managing Identity Values224

Identity Ranges with Immediate Updating and Queued Updating227

Managing Replicated timestamp Data228

Using NOT FOR REPLICATION229

Chapter 8 Administering and Monitoring Replication231

Tools for Administering and Monitoring Replication231

Replication Monitor232

ActiveX Controls for Replication233

Replication Agent Utilities233

Windows NT Performance Monitor and Windows 2000 System Monitor235

Setting Agent Parameters235

Agent Profiles236

Replication Agents236

SQL Server Agent237

Snapshot Agents237

Distribution Agents238

Log Reader Agents240

Queue Reader Agents241

Merge Agents242

Miscellaneous Agents245

Viewing Agent History246

Handling Agent Errors248

Remote Agent Activation250

Replication Alerts253

Automating a Response to an Alert255

Subscription Deactivation and Expiration256

Predefined Response Jobs256

Validating Replicated Data259

Chapter 9 Replication and Heterogeneous Data Sources267

Heterogeneous Subscribers268

Access Subscribers270

Oracle Subscribers272

IBM DB2/AS400 Subscribers275

IBM DB2/MVS Subscribers277

Other Heterogeneous Subscribers278

Implementing Merge Replication to Access Subscribers283

Heterogeneous Publishers285

Chapter 10 Replication Security287

Role Requirements288

Connecting to the Distributor290

Snapshot Folder Security290

Publication Access Lists291

Agent Login Security292

Security and Replication Options293

Security and Replication Over the Internet296

Chapter 11 Enhancing Replication Performance299

Enhancing Snapshot Replication Performance304

Enhancing Snapshot and Transactional Replication Performance305

Enhancing Transactional Replication Performance307

Enhancing Merge Replication Performance309

Chapter 12 Backing Up and Restoring Replication Databases317

Strategies for Backing Up and Restoring Snapshot Replication319

Strategies for Backing Up and Restoring Transactional Replication321

Transactional Replication and Log Shipping326

Strategies for Backing Up and Restoring Merge Replication328

Restoring Backups of Replicated Databases to the Same Server and Database334

Restoring Backups of Replicated Databases to a Different Server or Database335

Part 2 English Query337

Chapter 13 English Query Overview339

What s New In English Query339

Installation Requirements and Considerations340

Chapter 14 English Query Fundamentals343

English Query Fundamentals343

SQL Database Normalization Rules347

Updating or Replacing Models354

Importing and Exporting Models to Meta Data Services354

Chapter 15 Developing and Deploying English Query Applications355

Creating an English Query Model356

Expanding an English Query Model357

Creating a Mixed English Query Model358

Enabling Analysis Services for an English Query Model359

Enabling SQL for an English Query Model359

Enabling Full-Text Search for an English Query Model360

Defining Entities in an English Query Model361

Defining Relationship Phrasings365

Using Command Relationships in an English Query Model369

Authoring with Semantic Modeling Format372

Testing an English Query Model373

Compiling an English Query Application375

Deploying an English Query Application376

Adding Question Builder to an English Query Application377

Automatic Clarification of Questions379

Run-Time Environment for English Query Applications380

Redistributing the English Query Run-time DLLs381

Sample Applications and Client Interfaces383

Chapter 16 Analysis Services in English Query385

Naming Entities in the OLAP Project Wizard386

Creating Relationships in the OLAP Project Wizard387

Level-Level Relationships389

Additional Relationships389

Analysis Services Requirements for (All) Level390

Chapter 17 Object Model Reference391

Authoring Object Model391

Authoring Object Model Diagram392

Authoring Objects Summary392

Authoring Properties Summary396

Authoring Methods Summary402

Authoring Sample Script413

Engine Object Model415

Engine Objects Summary418

Engine Object Model Diagram418

Engine Methods Summary467

Engine Collections Summary473

Engine Collections Methods Summary478

Question Builder Object Model479

Question Builder Object Model Diagram480

Question Builder Objects Summary480

Question Builder Properties Summary484

Question Builder Methods Summary493

Question Builder Collections Summary495

Question Builder Collections Methods Summary498

Chapter 18 How To Perform Common English Query Tasks501

Working with Projects501

How to add a new project to a solution501

How to add an existing project to a solution502

How to create a new project503

How to create a new project using the SQL Project wizard504

How to remove a project from the solution506

How to create and modify project properties506

How to remove a database from a project506

How to add a module507

How to remove a module507

How to modify the data source in a project507

Working with Models508

How to add entities and relationships using the Create Semantics command508

How to add or change a SQL connection509

How to add or change an Analysis Services (formerly OLAP) connection510

How to create a mixed model510

How to delete a field from a model511

How to edit a field in a model511

Working with Joins512

How to add a jion512

How to delete a jion513

How to edit a join513

How to add a field to a table514

How to add a table514

Working with Tables514

How to add tables and views from a SQL data source515

How to change the table options for a relationship516

How to delete a table516

How to edit a table517

How to enable full-text searching for a field517

How to refresh all tables in a project518

Working with Entities518

How to add an entity to a relationship518

How to create an entity519

How to delete an entity520

How to delete an entity from a relationship521

How to edit an entity521

How to edit the entity s role in a relationship522

Working with Relationships522

How to add a relationship523

How to add phrasings to a relationship524

How to add time and location options to a relationship524

How to create a relationship using the Canvas pane525

How to create relationships using the Create Relationships command526

How to create relationships from the Model Test Window526

How to associate English Data values with a relationship527

How to delete a relationship527

How to modify a relationship528

Working with Dictionary Entries528

How to add a dictionary entry529

How to delete a dictionary entry529

How to edit a dictionary entry529

How to add a phrasing to a command relationship530

Working with Command Relationships530

How to create a command relationship531

How to create time and location options for command relationships532

How to delete a command relationship532

How to edit command relationship533

Working with Analysis Services (formerly OLAP Services)533

How to add an Analysis Services (formerly OLAP) cube to a model534

How to edit an Analysis Services (formerly OLAP) cube534

How to edit Analysis Services (formerly OLAP) measures535

How to edit Analysis Services levels535

How to edit Analysis Services (formerly OLAP) properties536

How to enable Analysis Services (formerly OLAP)536

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

How to remove an Analysis Services (formerly OLAP) cube538

Testing and Building a Model538

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

How to build an application539

How to remove a regression test file540

How to edit a regression test file540

How to rename a regression test file541

How to save model test information to a regression test file541

How to save the regression output to a regression test file541

How to set the Sample Data option542

How to test a model542

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

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

How to deploy an application to the Web544

Index A Topics in the SQL Server 2000 Reference Library545

Index B Index of English Query Elements577