本書(shū)集中講述了數(shù)據(jù)庫(kù)的創(chuàng)建和維護(hù)、數(shù)據(jù)倉(cāng)庫(kù)的創(chuàng)建和SQL Server 2000的優(yōu)化。并對(duì)SQL Server 2000的數(shù)據(jù)庫(kù)、表格、索引、視圖、固定程序、觸發(fā)器、用戶自定義函數(shù)和全文本索引等都有全面的闡述。同時(shí)也詳述了數(shù)據(jù)倉(cāng)庫(kù)聽(tīng)組成、創(chuàng)建和維護(hù)，以及如何通過(guò)有效的數(shù)據(jù)庫(kù)和應(yīng)用程序設(shè)計(jì)、查詢調(diào)試和優(yōu)化工具、實(shí)用程序和性能良好的服務(wù)器等來(lái)提高數(shù)據(jù)庫(kù)的性能。本書(shū)由經(jīng)驗(yàn)豐富的微軟專家編寫(xiě)，內(nèi)容全面，言簡(jiǎn)意賅，是從事數(shù)據(jù)庫(kù)與數(shù)據(jù)倉(cāng)庫(kù)管理者的理想?yún)⒖紩?shū)。
Acknowledgements Part1 Introduction and Overview Chapter2 Welcome to the SQL Server 2000 Reference Library Creating a Failover Cluster Upgrading to a SQL Server 2000Failover Cluster Handling a Failover Cluster Installation Maintaining a Failover Cluster Using SQL Server Tools with Failover Clustering Failover Cluster Troubleshooting Part2 Creating and Maintaining Databases Chapter3 Databases Parts of a Database Files and Filegroups Transaction Logs Database Design Considerations Creating a Database Plan Online Transaction Processing vs. Decision Support Normalization Data Integrity Data Security Databas Performance Maintenance Estimating the Size of a Database Creating a Database Using Raw Partitions Modifying a Database Expanding a Database Shrinking a Database Adding and Deleting Data and Transaction Log Files Creating Filegroups Changing the Default Filegroup Setting Database Options Creating a Removable Database Attaching and Detaching a Database Rendming a Database Changing thd Database Owner Transaction Termination for Changing Database States Viewing a Database Displaying Database and Transection Log Space Documenting and Scripting Databases Database Maintenance Plan Wizard Deleting a Database Chapter4 Tables Designing Tables Specifying a Column Data Type Text in Row Data Autonembering and Identifier Columns Using Constraints，Defaults，and Null Values Creating and Modifying a Table Modifying Column Properties Adding and Deleting Columns Creating and Modifying PRIMARY KEY Constraints Creating and Modifying FOREING KEY Constraints Creating and Modifying UNIQUE Constraints Creating and Modifying CHECK Constraints Creating and Modifying DEFAULT Definitions Creating and Modifying Identifier Columns Viewing a Table Deleting a Table Chapter5 Indexes Desingning an Index Creating an Index Rebuilding an Index Renaming an Index Viewing an Index Deleting an Index Chapter6 Views Scenarios for Using Views Creating a View Designing an Indexed View Creating an Indexed View Creating a Partitioned View Modifying and Renaming a View Modifying Data Through a View Getting Information About a View Deleting a View Chapter7 Stored Procedures Extended Stored Procedures Creating a Stored Procedure Specifying Parameters Programming Stored Procedures Returning Data from a Stored Procedure Executing a Stored Procedure Automatic Execution of Stored Procedures Modifying and Renaming a Stored Procedure Recompiling a Stored Procedure Viewing a Stored Procedure Deleting a Stored Procedure Chapter8 Enfircing Business Rules With Triggers Designing Triggers Specifying When a Trigger Fires Trigger Execution Designing INSTEAD OF Triggers Creating a Trigger Programming Triggers Using Triggers that Include ROLLBACK TRANSACTION Using the inserted and deleted Tables Multirow Considerations Conditional INSERT Trigger Specifying First and Last Triggers Using Nested Triggers Using INSTEAD OF Triggers Using test，ntext，and image Data in INSTEAD OF Triggers Activating Triggers with Implicit and Explicit Null Values Modifying and Renaming a Trigger Viewing a Trigger Deleting a Trigger Chapter9 User-Defined Functions User-Defined Functions That Return a Table Data Type Inline User-Defined Functions Deterministic and Nondeterministic Functions Rewriting Stored Procedures as Functions Using Extended Properties on Database Objects Chapter10 Full-Text Indexes Administering Full-Text Features Using SQL Enterprise Manager Administering Full-Text Features Using Stored Procedures and Scalar Functions Enabling Others to Issue Full-Text Queries Performing Investigation and Clean-up Tasks for Full Text Catalogs Performing Infrequent Tasks Maintaining Full-Text Indexes Filtering Supported File Types Column-Level Linguistic Analysis Part 3 Creating and Using Data Warehouses Chapter11 Data Warehousing Overview SQL Server 2000 Tools for Data Warehouses Chapter12 Parts of a Data Warehouse Data Marts Relational Databases Data Sources Data Preparation Area Presentation Services End-User Analysis Chapter13 Creating a Data Warehouse Designing a Data Warehouse Using Dimensional Modeling Fact Tables Aggregation Tables Dimension Tables Indexes Creating the Data Preparation Area Creating the Data Warehouse Database Extracting Data from Operational Systems Cleansing and Transforming Data Loading Data into the Data Warehouse Database Preparing presentation Information Distributing Data to Data Marts Chapter14 Using a Data Warehouse SQL Queries OLAP and Data Mining English Query Microsoft Office 2000 Web Access and Reporting Offine OLAP Cubes Third-Party Applications Custom Applications Chapter15 Maintaining a Data Warehouse Updating Data Warehouse Data Scheduling Data Updates Synchronizing OLAP Cubes Updating Data Marts Administering a Data Warehouse Backing Up Data Warehouse Data Automating Data Warehouse Tasks Tuning Data Warehouse Performance Part 4 Optimizing Database Performance Chapter16 Designging Feferated Database Servers Designing Partitions Designing Federated Database Servers for High Availability Backing Up and Restoring Federated Database Servers Chapter17 Database Design Logical Database Design Database Design Considerations：Data Types Physical Database Design RAID Partitioning Data Placement Using Filegroups Index Tuning Recommendations Optimizing Transaction Log Performance Optimizing tempdb performance File Systems Chapter18 Query Tuning Analyzing a Query Graphically Displaying the Executin Plan Using SQL Query Analyzer Logical and Physical Operators Query Tuning Recommendations Advanced Query Tuning Concepts Understanding Nested Loops Joins Understanding Merge Joins Understanding Hash Joins Chapter19 Application Design Networking and Performance Named Pipes vs.TCP/IP Sockets Optimizing Application Performance Using Efficient Data Retrieval Effects of Transactions and Batches on Application Performance Effects of Stored Procedures on Application Performance Understanding and Avoiding Blocking Optimizing Distributed Queries Chapter20 Optimizing Utility and Tool Performance Optimizing Backup and Restore Performance Optimizing Bulk Copy Performance Optimizing DBCC Performance Chapter21 Optimizing Server Performance Optimizing Server Performance Using Memory Configuration Options Optimizing Server Performance Using I/O Configuration Options Optimizing Server Performance Using Windows NT Options Maximizing Throughput Configuring Server Tasking Configuring Virtual Memory Index A Topics in the SQL Server 2000 Reference Library Index B Index of Optimizing Database Performance Elements
數(shù)據(jù)挖掘?qū)д摚ㄍ暾妫?/a>
鄂公網(wǎng)安備 42010302001612號(hào) 