Muutke küpsiste eelistusi

Official New Features Guide to Sybase Ase 15 [Pehme köide]

, , ,
  • Formaat: Paperback / softback, 473 pages, b/w illlus
  • Ilmumisaeg: 28-Feb-2006
  • Kirjastus: Wordware Publishing Inc.
  • ISBN-10: 1598220047
  • ISBN-13: 9781598220049
Teised raamatud teemal:
  • Pehme köide
  • Hind: 85,59 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Official New Features Guide to Sybase Ase 15Suurem pilt
  • Formaat: Paperback / softback, 473 pages, b/w illlus
  • Ilmumisaeg: 28-Feb-2006
  • Kirjastus: Wordware Publishing Inc.
  • ISBN-10: 1598220047
  • ISBN-13: 9781598220049
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781598220049.html
Märksõnad:
Sybase Adaptive Server Enterprise 15 is a high-performance, mission-critical database management system designed to meet the increasing demands of large databases and high-transaction volumes, while providing a cost-effective database management system. The Official New Features Guide to Sybase ASE 15 focuses on the many enhancements in Sybase ASE 15 including semantic partitions, computed columns, functional indexes, and scrollable cursors.With this book learn about the enhancements to ASE 15, how the new features can increase your efficiency and productivity, and how these features integrate with existing systems; understand how semantic partitions decrease the complexities of data management; find out how scrollable cursors and computed columns can ease the development process; learn how the optimizer toolset and QP Metrics improve monitoring and diagnostic efforts; provide the ability to ensure customer compliance through the use of Sybase Software Asset Management; test your knowledge with the included Sybase certification practice exam.
Foreword xix
Acknowledgments xxi
About the Authors xxv
Introduction xxvii
Part I: New Features Overview
Exploring the Sybase Galaxy
3(10)
Part I --- New Features Overview
4(6)
System Maintenance Improvements
4(1)
Partition Management --- Semantic Partitions
5(1)
Scrollable Cursors
5(1)
Overview of Changes to Query Processing
6(1)
Detection and Resolution of Performance Issues in Queries
6(1)
Computed Columns
7(1)
Functional Indexes
7(1)
Capturing Query Processing Metrics
8(1)
Plan Viewer
9(1)
Sybase Software Asset Management (SySAM) 2.0
9(1)
Installation of ASE 15
9(1)
Part II --- Pre-15 Improvements
10(1)
Multiple tempdb Databases
10(1)
MDA Tables
10(1)
Java and XML
11(1)
The Appendices
11(1)
Sample Certification Exam
11(1)
Use Cases
11(1)
3,2,1, Contact!
12(1)
System Maintenance Improvements
13(40)
Recent Pre-ASE 15 Improvements
13(6)
Multiple tempdb
14(1)
Native Data Encryption/Security Enhancements
14(1)
Automatic Database Expansion
15(1)
The Basics
16(2)
Job Scheduler
18(1)
Basic Components
18(1)
Installation of Job Scheduler
18(1)
ASE 15 Improvements
19(25)
Row Locked System Catalogs
19(1)
Update Statistics
20(1)
Updates to Partition Statistics
20(2)
Automatic Update Statistics
22(1)
Datachange
22(5)
Why Use datachange?
27(1)
Datachange, Semantic Partitions, and Maintenance Schedules
28(3)
Local Indexes
31(1)
Benefits
31(1)
sp_helpindex
32(1)
Partition-level Utilities
33(1)
Partition Configuration Parameters
34(1)
Utility Benefits from Semantic Partitions
35(1)
Partition-specific Database Consistency Checks (dbccs)
35(3)
Reorg Partitions
38(1)
Changes to the bcp Utility
39(4)
Truncate Partitions
43(1)
Very Large Storage System
44(3)
Disk Init
45(1)
Large Identifiers
45(1)
Long Identifiers
46(1)
Short Identifiers
46(1)
Unicode Text Support
47(1)
New Datatypes
47(1)
New Functions
48(2)
Deprecated Functions
50(1)
New Configuration Parameters
51(1)
Eliminated Configuration Parameters
52(1)
New Global Variables
52(1)
Summary
52(1)
Semantic Partitions and Very Large Database (VLDB) Support
53(92)
Introduction
53(8)
Why Partition Data?
55(1)
Benefits of Partitioning
56(1)
Partition Terminology
57(4)
Semantic Partitions
61(22)
Configuring ASE for Semantic Partitioning
62(1)
Partition Support in ASE 15
63(1)
Partition Types
64(1)
Range Partitioning
65(5)
Hash Partitioning
70(5)
List Partitioning
75(3)
Round-robin Partitioning
78(5)
Partitioning Strategies
83(1)
Inserting, Updating, and Deleting Data in Partitions
84(3)
Inserting Data into Semantic Partitions
84(1)
Inserting Data into Range Partitions
84(2)
Inserting Data into Hash Partitions
86(1)
Inserting Data into List Partitions
86(1)
Deleting Data from All Semantic Partitions
86(1)
Updating Data in All Semantic Partitions
86(1)
Built-in Functions
87(2)
Data Partition Implementation and Upgrade Strategies
89(4)
Index Partitioning
93(29)
Local Index
94(1)
Clustered Prefixed Index on Range Partitioned Table
95(2)
Clustered Non-Prefixed Index on Range Partitioned Table
97(2)
Clustered Prefixed Index on List Partitioned Table
99(2)
Clustered Non-Prefixed Index on List Partitioned Table
101(3)
Clustered Prefixed Index on Round-robin Partitioned Table
104(2)
Clustered Non-Prefixed Index on Round-robin Partitioned Table
106(2)
Clustered Non-Prefixed Index on Hash Partitioned Table
108(2)
Clustered Prefixed Index on Hash Partitioned Table
110(3)
Global Index
113(1)
Global Nonclustered Prefixed Index on Range Partitioned Table
114(2)
Global Nonclustered Prefixed Index on List Partitioned Table
116(2)
Global Nonclustered Prefixed Index on Round-robin Partitioned Table
118(2)
Global Nonclustered Prefixed Index on Hash Partitioned Table
120(2)
Query Processor and Partition Support
122(2)
ASE 15 Optimizer
124(1)
Partition Maintenance
124(10)
Altering Data Partitions
124(1)
Unpartition a Table
125(1)
Change the Number of Partitions
126(1)
Add a Partition to a Table
126(4)
Drop Partitions
130(1)
Modifications to the Partition Key
131(3)
Partition Information
134(9)
Influence of Partitioning on DBA Activities
143(1)
Influence of Partitioning on Long-time Archival
143(1)
Summary
144(1)
Scrollable Cursors
145(22)
Introduction
145(1)
Scrollable Cursor Background
146(1)
Cursor Scrollability
146(2)
Cursor-related Global Variables
148(2)
Changes to the sp_cursorinfo System Procedure
150(1)
Be Aware of Scrollable Cursor Rules!
151(1)
Cursor Sensitivity
152(12)
Demonstration 1: Update to a Row Already Fetched
154(2)
Demonstration 2: Update to a Row Not Yet Fetched
156(1)
Cursor Sensitivity --- An Exception
157(1)
Locking Considerations with Cursors
158(1)
Impact on tempdb Usage
159(1)
Worktable Materialization with Scrollable Sensitive Cursors
160(3)
Conclusion of Sensitive vs. Insensitive Cursors
163(1)
Sybase Engineer's Insight
164(1)
Summary
164(151)
Future Direction
165(2)
Overview of Changes to the Query Processing Engine
167(20)
Introduction
167(1)
Optimization Goals
168(2)
allrows_oltp
168(1)
allrows_mix
169(1)
allrows_dss
169(1)
Determining the Current Optimization Goal
170(1)
Optimization Criteria
170(2)
merge_join
171(1)
merge_union_all
171(1)
merge_union_distinct
171(1)
multi_table_store_ind
171(1)
opportunistic_distinct_view
171(1)
parallel_query
171(1)
hash_Join
172(1)
Optimization Timeout Limit
172(2)
Query Processor Improvements
174(11)
Datatype Mismatch
175(2)
Partition Elimination and Directed Joins
177(2)
Tables with Highly Skewed Histogram Values
179(2)
Group By and Order By
181(1)
or Queries
182(1)
Star Queries
182(3)
Summary
185(2)
Detection and Resolution of Query Performance Issues
187(38)
Introduction
187(1)
An Approach to Poor Query Performance Diagnosis
188(2)
Common Query Performance Factors
190(5)
Eliminating Causes for Sub-Optimal Plan Selection
191(1)
Find Missing or Invalid Statistics
191(1)
Consider Range Cell Density on Non-Unique Indexes
191(1)
Identify Index Needs
192(1)
Identify Poor Index Strategy
192(1)
Fragmentation of Data
192(1)
Resolve Partition Imbalance
193(1)
Reset Server-or Session-level Options
193(1)
Overengineered Forceplan
194(1)
Invalid Use of Index Force
194(1)
Inefficient Query Plan Forced by Abstract Plan
195(1)
Query Processor ``set options'' --- The Basics
195(5)
Query Optimizer Cost Algorithm
198(1)
ASE 15 vs. 12.5.x Cost Algorithm
199(1)
Query Processor ``set options'' --- Explored
200(8)
show_missing_stats
200(3)
show_elimination
203(1)
show_abstract_plan
204(3)
Why Use Abstract Plans for ASE 15?
207(1)
Application of Optimization Tools
208(9)
Optimization Goal Performance Analysis
208(2)
Optimization Criteria Performance Analysis
210(2)
Optimization Timeout Analysis
212(4)
Suggested Approach to Fix Optimization Timeout Problems
216(1)
Detection, Resolution, and Prevention of Partition-related Performance Issues
217(6)
Data Skew Due to Incorrect Partition Type or Poor Partition Key Selection
218(2)
Effect of Invalid Statistics on Table Semantically Partitioned
220(3)
Summary
223(2)
Computed Columns
225(16)
Introduction
225(1)
Key Concepts
226(5)
Materialization
226(2)
Deterministic Property
228(1)
Relationship between Deterministic Property and Materialization
229(1)
Deterministic and Materialized Computed Columns
229(1)
Deterministic and Nonmaterialized Computed Columns
229(1)
Nondeterministic and Materialized Computed Columns
230(1)
Nondeterministic and Nonmaterialized Computed Columns
230(1)
Benefits of Using Computed Columns
231(2)
Provide Shorthand and Indexing for an Expression
231(1)
Composing and Decomposing Datatypes
231(1)
User-defined Sort Order
232(1)
Rules and Properties of Computed Columns
233(2)
Sybase Enhancements to Support Computed Columns
235(4)
Create Table Syntax Change
235(1)
Alter Table Syntax Change
235(1)
System Table Changes
236(1)
Stored Procedure Changes
237(2)
Summary
239(2)
Functional Indexes
241(20)
Computed Column Index
242(9)
Purpose
242(4)
Rules and Properties of a Computed Column Index
246(1)
Feature Benefits
246(2)
Feature Limitations
248(1)
Impacts to tempdb
248(1)
Impact to Existing Application Code
249(1)
Determining When to Use a Computed Column Index
250(1)
Optimizer Statistics
251(1)
Function-based Index
251(7)
Purpose
251(1)
Rules and Properties of a Function-based Index
252(1)
Feature Benefits
253(3)
Feature Limitations
256(1)
Impacts to tempdb
256(1)
Impact to Existing Application Code
257(1)
Determining the Use of a Function-based Index
257(1)
Optimizer Statistics
258(1)
Behind the Scenes
258(1)
Getting Index Information
258(1)
Summary
259(2)
Capturing Query Processing Metrics
261(26)
Alternatives to Query Processing Metrics
261(1)
Introduction to Query Processing Metrics
262(1)
Contents of sysquerymetrics
263(2)
Contents of the sysquerymetrics View
264(1)
How to Enable QP Metrics Capture
265(1)
Captured Information Explored
266(5)
Stored Procedures
266(4)
Triggers and Views
270(1)
Execute Immediate
270(1)
Accessing Captured Plans
271(2)
How Is the QP Metrics Information Useful?
273(3)
Identification of Performance Regression
276(1)
Comparing Metrics for a Specific Query between Running Groups
277(2)
Comparing Metrics for All Queries between Running Groups
279(2)
Why Separate the QP Metrics Data by gid?
280(1)
Syntax Style Matters; Spacing Does Not
281(2)
Clearing and Saving the Metrics
283(1)
Relationship between Stats I/O and QP Metrics I/O Counts
284(1)
Information for Resource Governor
285(1)
Space Utilization Considerations
285(1)
Limitations
286(1)
Summary
286(1)
Graphical Plan Viewer
287(10)
Graphical Plan Viewer from Interactive SQL
287(7)
Graphical Query Tree Using Set Options
294(2)
Summary
296(1)
Sybase Software Asset Management (SySAM) 2.0
297(26)
Introduction
297(1)
Prior to ASE 15
298(1)
With ASE 15
299(1)
Components of Asset Management
299(7)
SySAM Server
299(1)
SySAM Utility Program --- Imutil
300(1)
SySAM Reporting Tool
300(1)
System Environment Variables
301(1)
License File
302(1)
Options File
303(1)
Properties File
303(1)
The SySAM Environment
304(1)
Standalone License Server
304(1)
Networked License Server
305(1)
Redundant License Server
305(1)
Acquiring Product Licenses
306(3)
Product Licenses
309(1)
Try and Buy
309(1)
License Activation
309(1)
SySAM Administration
310(2)
sp_lmconfig
310(2)
ASE 15 SySAM Upgrade Process
312(1)
SySAM Reporting
313(8)
Summary Reports
313(6)
Server Usage Reports
319(1)
Raw Data Reports
320(1)
Summary
321(2)
Installation of ASE Servers
323(36)
Prior to Installation for All Methods
324(1)
Installation with Resource Files
325(7)
Notes for Resource File Installation of ASE
325(5)
Installation of ASE Components with a Resource File
330(2)
GUI Installation Method with srvbuild Executable
332(20)
Installation with the Dataserver Executable
352(4)
Summary
356(3)
Part II: Pre-15 Improvements
Multiple Temporary Databases
359(14)
Introduction
359(1)
Purposes for Multiple Temporary Databases
360(5)
Prior to ASE 15
360(1)
With ASE 15
361(1)
System Catalog Changes
361(1)
directio Support
361(2)
update statistics
363(1)
Insensitive Scrollable Cursors
364(1)
Semi-sensitive Scrollable Cursors
364(1)
Sensitive Scrollable Cursors
364(1)
How to Decide When to Add a Temporary Database
365(2)
Strategies
365(1)
What Are Your Needs?
366(1)
Implementation Steps
367(1)
Determining Available Temporary Databases
368(1)
Sample Setup for Temporary Database for ``sa'' Use Only
369(2)
Other Issues
371(1)
Dropping Temporary Databases
371(1)
Altering a Temporary Database
372(1)
@@tempdb
372(1)
Summary
372(1)
The MDA Tables
373(22)
What Are the MDA Tables?
373(1)
Past Solutions
374(2)
MDA Table Installation
376(1)
MDA Table Server Configuration Options
377(3)
The Parent Switch
379(1)
The MDA Tables
380(2)
Changes from ASE 12.5.3
382(1)
What Is Meant by ``stateful'' Tables?
383(2)
Stateful MDA Table Data Management
385(6)
SQL Use
391(1)
Useful MDA Table Queries
391(2)
MDA Alternatives
393(1)
Summary
393(2)
Java, XML, and Web Services in ASE
395(22)
Introduction
396(1)
Java in the Database
396(6)
Installing Java Classes
397(1)
Creating Java Classes and JARs
397(1)
Using the installjava Utility
398(1)
Configuring Memory for Java in the Database
398(1)
Java Classes as Datatypes
399(1)
An Example of Table Definition Using a Java Class
400(1)
Performance Considerations
400(1)
An Example of Using a Java Class within a Select
400(1)
Executing Java Methods
400(1)
Class Static Variables
401(1)
Recommendations and Considerations
401(1)
XML in the Database
402(9)
XML Stored in the Database
402(1)
Option 1: Store the XML Document into a Text Datatype
403(1)
Option 2: Store the XML Document into an Image Datatype Using xmlparse
404(1)
Option 3: Store the XML Document into an Image Datatype Using Compression
404(1)
Option 4: Store the XML Document Outside the Database
405(1)
HTML Stored in the Database
406(1)
Recommendations and Considerations
406(1)
Performance and Sizing
407(3)
SQL Result Sets Converted to Return an XML Document
410(1)
Web Services
411(6)
Web Services Producer
411(2)
Web Services Consumer
413(2)
Recommendations and Considerations
415(2)
Appendix A Sybase ASE 15 Certification Sample Questions and Answers 417(30)
Appendix B Use Cases 447(20)
Index 467