SQL Server 2000开发宝库影印丛书：复制与自然语言查询（影印版） (2009 年度畅销榜NO.52676 )

本书可称作SQL Server 2000复制服务的系统资源宝库，内容及其广泛，涵盖复制工具、复制方式选择、复杂数据源、复制过程的管理和调控、复制性能的提高以及复制数据的备份和存储等方面的全面的信息本书还对SQL Server 2000的EQ（自然语言查询）方面作了论述。书中还包括EQ概要和基础知识、EQ应用程序的开发和部署、如何用EQ进行分析服务、EQ目标模式参考等。\r\n 本书由微软公司专家编写，实用性强，是系统管理员和程序开发人员的必备参考书。\r\n

Part 1 Replication\r\n\r\nChapter 1 Introducing Replication\r\n\r\nReplication Model\r\nIntroducing The Types of Replication \r\nIntroducing Replication Options\r\nTypical Uses of Replication\r\nReporting，Decision Support，and Data Warehousing Applications\r\nOnline/Offine Applications\r\nWeb-Based Applications\r\nKeeping Data Close to Users\r\nHow Replication Works\r\nMethods of Implementation\r\nAgents and Monitors\r\n\r\nChapter 2 planning For Replication\r\n\r\nDistributed Update Factors\r\nEvaluating the Replication Environment\r\nBusiness Objectives and Requirements\r\nNetwork Considerations\r\nSecurity Considerations\r\nData Needs and Characteristics\r\nPlanning for Application Development\r\nPlanning for Each Type of Replication\r\nPlanning for snapshot Replication\r\nPlanning for Transactinal Replication\r\nPlanning for Replication Options\r\nMerge Replication or Updateable Subscriptions\r\nDesigning a Replication Topology\r\nPhysical Replication Models\r\n\r\nChapter 3 Types of Replication\r\n\r\nSnapshot Replication\r\nHow Snapshot Replication Works\r\nTransactional Replication\r\nHow Transactional Replication Works\r\nMerge Replication\r\nHow Merge Replication Works\r\nMerge Replication Conflict Detection and Resolution\r\n\r\nChapter 4 Replication Tools\r\n\r\nReplicatin and SQL ServerEnterprise Manager\r\nReplication Wizards\r\nReplication Properties\r\nReplication Icons\r\nReplication Programming Interfaces\r\nProgramming Replication with ActiveX Controls\r\nProgramming Replication with SQL-DMO\r\nProgramming Replication with the Replication Distributor Interface\r\nTransact-SQL System Stored Procedures\r\nWindows Synchronization Manager\r\nActive Directory Services\r\n\r\nChapter 5 Implementing Replication\r\n\r\nConfiguring Replixation\r\nPublishers，Distributors，and Subscribers\r\nDisabling Publishing and Distribution\r\nPublishing Data and Database Objects\r\nPublishing Stored Procedure Execution\r\nUsing Custom Stored Procedures in Articles\r\nSubscribing to Publications\r\nPush Subscriptions\r\nPull Subscriptions\r\nAnonymous Subscriptions\r\nApplying the Initial Snapshot\r\nGenerating the Initial Snapshot\r\nAlternate Snapshot Locations\r\nConpressed Snapshot Files\r\nExploring Snapshots\r\nTransferring Snapshots\r\nAttachable Subscription Databases\r\nImproving Performance While Generating and Applying Smapshots\r\nExecuting Scripts Before and After the Smapshot is Applied \r\nReinitialzing Subscriptions\r\nSynchronizing Data\r\nScripting Replication\r\nSchema Changes on Publication Databases\r\nImplementing Replication Over the Internet\r\nPublishing Data Over the Internet Using Microsoft Proxy Server\r\nPublishing Data Over the Internet Using TCP/IP and FTP\r\nReplication Between Different Versions of SQL Server\r\nSQL Server 7.0 Publisher/Distributor to SQL Server 6.5 Subscriber\r\nSQL Server 7.0 Publisher/Distributor to SQL Server 6.5 Subscriber\r\nSQL Server 6.5 Publisher to SQL Server 7.0 Distributor\r\nReplication with SQL Server 2000 Windows CE Edition\r\n\r\nChapter 6 Replication Options\r\n\r\nFiltering Published Data\r\nRow Filters\r\nColumn Filters\r\nDynamic Filters\r\nJoin Filters\r\nUser-Defined Functions and Static Filters\r\nUser-Defined Functions and Dynamic Filters\r\nUpdatable Subscriptions\r\nImmediate Updating\r\nQueued Updating\r\nImmediate Updating with Queued Updating as a Failover\r\nTransforming Published Data\r\nAlternate Synchronization Partners\r\nHow Alternate Synchronization Partners Works\r\nOptimizing Synchronization\r\n\r\nChapter 7 Replication Data Considerations\r\n\r\nUsing IDENTITY Values with Replication\r\nManaging Identity Values\r\nIdentity Ranges with Immediate Updating and Queued Updaing\r\nManaging Replicated timestamp Data\r\nUsing NOT FOR REPLICATION\r\n\r\nChapter 8 Administering and Monltoring Replication\r\n\r\nTools for Administering and Monitoring Replication\r\nReplication Monitor\r\nReplication Agent utilities\r\nActiveX Controls for Replication\r\nWindows NT Performance Monitor and Windows 2000 System monitor\r\nSetting Agent Parameters\r\nAgent Profiles\r\nReplication Agents\r\nSQL Server Agent \r\nSnapshot Agents\r\nDistribution Agents\r\nLog Reader Agents\r\nQueue Reader Agents\r\nMerge Agents\r\nMiscellaneous Agents\r\nViewing Agent History\r\nHandling Agent Errors\r\nRemote Agent Activation\r\nReplication Alerts\r\nAutomating a Response to an Alert\r\nPredefined Response Jobs\r\nSubscription Deactivation and Expiration\r\nValidating Replicated Data\r\n\r\nChapter 9 Replication and Heterogeneous Data Sources\r\n\r\nHeterogeneous Subscribers\r\nAccess Subscribers\r\nOracle Subscribers\r\n\r\nIBM DB2/AS400 Subscribers\r\nIBM DB2/MVS Subscribers\r\nOther Heterogeneous Subscribers\r\nImplementing Merge Replication to Access Subscribers\r\nHeterogeneous Publishers\r\n\r\nChapter 10 Replication Security\r\n\r\nRole Requirements\r\nConnecting to the Distributor\r\nSnapshot Folder Security\r\nPublication Access Lists\r\nAgent Login Security\r\nSecurity and Replication Optins\r\nSecurity and Replication Over the Internet\r\n\r\nChapter 11 Enhancing Replication Performance\r\n\r\nEnhancing Snapshot Replication Performance\r\nEnhancing Snapshot and Transactional Replication Performance\r\nEnhancing Transactional Replication Performance\r\nEnhancing Merge Replication Performance\r\n\r\nChapter 12 Backing Up and Reatoring Replication Databases\r\n\r\nStrategies for Backing Up and Restoring Snapshot Replication\r\nStrategies for Backing Up and Restoring Transactional Replication\r\nTransactional Replication and Log Shipping\r\nStrategies for Backing Up and Restoring Merge Replication\r\nRestoring Backups of Replicated Databases to the Same Server and Database\r\nRestoring Backups of Replicated Databases to a Different Server or Database\r\n\r\nPart 2 English Query\r\n\r\nChapter 13 English Query Overview\r\n\r\nWhat’s New In English Query\r\nInstallation Requirements and Considerations\r\n\r\nChapter 14 English Query Fundamentals\r\n\r\nEnglish Query Fundamentals\r\nSQL Database Normalization Rules\r\nUpdating or Replacing Models\r\nImporting and Exporting Models to Meta Data Services\r\n\r\nChapter 15 Develoying English Query Applications\r\n\r\nCreating an English Query Model\r\nExpanding an English Query Model\r\nCreating a Mixed English Query Model\r\nEnabling Analysis Services for an English Query Model\r\nEnabling SQL for an English Query Model\r\nEnabling Full-Text Search for an English Query Model\r\nDefining Entities in an English Query Model\r\nUsing Command Relationships in an English Query Model\r\nAuthoring with Semantic Modeling Format\r\nTesting an English Query Model \r\nCompiling an English Query Application\r\nDeplying an English Query Qpplication\r\nAdding Question Bulider to an English Query Application\r\nAutomatic Clarification of Questions\r\nRun-Time Environment for English Query Applications\r\nRedistributing the English Query Run-time DLLs\r\nSample Applications and Client Interfaces\r\n\r\nChapter 16 Analysis Services in English Query\r\n\r\nNaming Entities in the OLAP Project Wizard\r\nCreating Relationships in the LOAP Project Wizard\r\nLevel-Level Relationships\r\nAdditional Relationships\r\nAnalysis Services Requirements for （All）Level\r\n\r\nChapter 17 Object Model Reference\r\n\r\nAuthoring Object Model\r\nAuthoring Object Model Diagram \r\nAuthoring Objects Summary\r\nAuthoring Properties Summary\r\nAuthoring Methods Summary\r\nAuthoring Sample Script\r\nEngine Object Model\r\nEngine Object Model Diagram\r\nEngine Objects Summary\r\nEngine methods Summary\r\nEngine Collections Summary\r\nEngine collections Methods Summary\r\nQuestion Bulider Object Model\r\nQuestion Bulider Object Model Diagram\r\nQuestion Bulider Objects Summary\r\nQuestion Bulider Properties Summary\r\nQuestion Bulider Methods Summary\r\nQuestion Bulider Collections Summary\r\nQuestion Bulider Collections Methods Summary\r\n\r\nChapter 18 How To Perform Common English Query Tasks\r\n\r\nWorking with Projects\r\nHow to add a new project to a solution\r\nHow to add an existing project to a solution\r\nHow to create a new project\r\nHow to create a new project using the SQL Project wizard\r\nHow to remove a database from a project\r\nHow to remove a project from the solution\r\nHow to create and modify project properties\r\nHow to add a module\r\nHow to remove a module\r\nHow to modify the data source in a project\r\nWorking with Models\r\nHow to add a join\r\nHow to delete a join\r\nHow to edit a join\r\nWorking with Tables\r\nHow to add a field to a table\r\nHow to add a table\r\nHow to add tables and views from a SQL data source\r\nHow to change the table options for a relationship\r\nHow to delete a table \r\nHow to edit a table \r\nHow to enable full-text searching for a field\r\nHow to refresh all tables in a project\r\nWorking with Entities\r\nHow to add an entity to a relationship\r\nHow to create an entity\r\nHow to delete an entity\r\nHow to delete an entity from a relationship\r\nHow to edit an entity\r\nHow to edit the entity’s role in a relationship\r\nWorking with Relationships\r\nHow to add a relationship\r\nHow to add phrasings to a relationship\r\nHow to add time and location options to a relationship\r\nHow to create a relationship using the Canvas pane\r\nHow to create relationships from the Model Test Window\r\nHow to create relationships using the Create Relationships command\r\nHow to associate English Data values with a relationship\r\nHow to delete a relationship\r\nHow to modify a relationship\r\nWorking with Dictionary Entries\r\nHow to add a dectionary entry\r\nHow to delete a dictionary entry\r\nHow to edit a dictionary entry\r\nWirking with Command Relationships\r\nHow to add a phrasing to a command relationship\r\nHow to create a command relationship\r\nHow to create time and location optiions for command relationships\r\nHow to delete a command relationship\r\nHow to edit a command relationship\r\nWorking with Analysis Services（formerly OLAP Services）\r\nHow to edit an Analysis Services （formerly OLAP）cube to a model\r\nHow to edit an Analysis Services（formerly OLAP）cube\r\nHow to edit Analysis Services levels\r\nHow to edtit Analysis Services（formerly OLAP）measures\r\nHow to edtit Analysis Services（formerly OLAP）properties\r\nHow to enable Analysis Services（formerly OLAP）\r\nHow to manually map OLAP objects to the underlying SQL database objects\r\nHow to remove an Analysis Services （formerly OLAP）cube\r\nTesting and Building a Model\r\nHow to add a new or existing regression test file to a project\r\nHow to build an application\r\nHow to edit a regression test file\r\nHow to remove a regression test file\r\nHow to rename a regression test file\r\nHow to save model test information to a regression test file\r\nHow to save the regression output to a regression test file\r\nHow to set the Samlpe Data option \r\nHow to test a model\r\nHow to view the differences between the current regression test file and the\r\nregression output file\r\nHow to view the output of a regression test created using the Run Regression command\r\nHow to deploy an application to the Web\r\n\r\nIndex A Topics in the SQL Server 2000 Reference Library\r\n\r\nIndex B Indes of English Query Elements\r\n

无封面