Book description
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.
Table of contents
- Dedications
- Contents
- Foreword
- Acknowledgments
- About the Authors
- About the Contributing Authors
- Introduction
-
Part I New Features Overview
-
Chapter 1 Exploring the Sybase Galaxy
-
Part I — New Features Overview
- System Maintenance Improvements
- Partition Management — Semantic Partitions
- Scrollable Cursors
- Overview of Changes to Query Processing
- Detection and Resolution of Performance Issues in Queries
- Computed Columns
- Functional Indexes
- Capturing Query Processing Metrics
- Plan Viewer
- Sybase Software Asset Management (SySAM) 2.0
- Installation of ASE 15
- Part II — Pre-15 Improvements
- The Appendices
- 3, 2, 1, Contact!
-
Part I — New Features Overview
-
Chapter 2 System Maintenance Improvements
- Recent Pre-ASE 15 Improvements
-
ASE 15 Improvements
- Row Locked System Catalogs
- Update Statistics
- Automatic Update Statistics
- Datachange
- Datachange, Semantic Partitions, and Maintenance Schedules
- Local Indexes
- sp_helpindex
- Partition-level Utilities
- Very Large Storage System
- Unicode Text Support
- New Datatypes
- New Functions
- Deprecated Functions
- New Configuration Parameters
- Eliminated Configuration Parameters
- New Global Variables
- Summary
-
Chapter 3 Semantic Partitions and Very Large Database (VLDB) Support
- Introduction
- Semantic Partitions
- Partitioning Strategies
- Inserting, Updating, and Deleting Data in Partitions
- Built-in Functions
- Data Partition Implementation and Upgrade Strategies
-
Index Partitioning
-
Local Index
- Clustered Prefixed Index on Range Partitioned Table
- Clustered Non-Prefixed Index on Range Partitioned Table
- Clustered Prefixed Index on List Partitioned Table
- Clustered Non-Prefixed Index on List Partitioned Table
- Clustered Prefixed Index on Round-robin Partitioned Table
- Clustered Non-Prefixed Index on Round-robin Partitioned Table
- Clustered Non-Prefixed Index on Hash Partitioned Table
- Clustered Prefixed Index on Hash Partitioned Table
- Global Index
-
Local Index
- Query Processor and Partition Support
- ASE 15 Optimizer
- Partition Maintenance
- Partition Information
- Influence of Partitioning on DBA Activities
- Influence of Partitioning on Long-time Archival
- Summary
- Chapter 4 Scrollable Cursors
- Chapter 5 Overview of Changes to the Query Processing Engine
-
Chapter 6 Detection and Resolution of Query Performance Issues
- Introduction
- An Approach to Poor Query Performance Diagnosis
-
Common Query Performance Factors
-
Eliminating Causes for Sub-Optimal Plan Selection
- Find Missing or Invalid Statistics
- Consider Range Cell Density on Non-Unique Indexes
- Identify Index Needs
- Identify Poor Index Strategy
- Fragmentation of Data
- Resolve Partition Imbalance
- Reset Server- or Session-level Options
- Overengineered Forceplan
- Invalid Use of Index Force
- Inefficient Query Plan Forced by Abstract Plan
-
Eliminating Causes for Sub-Optimal Plan Selection
- Query Processor “set options” — The Basics
- Query Processor “set options” — Explored
- Application of Optimization Tools
- Detection, Resolution, and Prevention of Partition-related Performance Issues
- Summary
- Chapter 7 Computed Columns
- Chapter 8 Functional Indexes
-
Chapter 9 Capturing Query Processing Metrics
- Alternatives to Query Processing Metrics
- Introduction to Query Processing Metrics
- How to Enable QP Metrics Capture
- Captured Information Explored
- Accessing Captured Plans
- How Is the QP Metrics Information Useful?
- Identification of Performance Regression
- Comparing Metrics for a Specific Query between Running Groups
- Comparing Metrics for All Queries between Running Groups
- Syntax Style Matters; Spacing Does Not
- Clearing and Saving the Metrics
- Relationship between Stats I/O and QP Metrics I/O Counts
- Information for Resource Governor
- Space Utilization Considerations
- Limitations
- Summary
- Chapter 10 Graphical Plan Viewer
- Chapter 11 Sybase Software Asset Management (SySAM) 2.0
- Chapter 12 Installation of ASE Servers
-
Chapter 1 Exploring the Sybase Galaxy
-
Part II Pre-15 Improvements
- Chapter 13 Multiple Temporary Databases
- Chapter 14 The MDA Tables
-
Chapter 15 Java, XML, and Web Services in ASE
- Introduction
- Java in the Database
-
XML in the Database
-
XML Stored in the Database
- Option 1: Store the XML Document into a Text Datatype
- Option 2: Store the XML Document into an Image Datatype Using xmlparse
- Option 3: Store the XML Document into an Image Datatype Using Compression
- Option 4: Store the XML Document Outside the Database
- HTML Stored in the Database
- Recommendations and Considerations
- Performance and Sizing
- SQL Result Sets Converted to Return an XML Document
-
XML Stored in the Database
- Web Services
- Appendix A Sybase ASE 15 Certification Sample Questions and Answers
-
Appendix B Use Cases
-
Business Case 1
- Option 1: One VLDB with large tables self contained
- Option 2: Primary database and an archive database for the largest tables
- Option 3: Several small databases, each holding a portion (none overlapping) of the data from the very large tables
- Option 4: One VLDB with a large table, partitioned semantically
- Business Case 2
- Business Case 3
-
Business Case 1
- Index
Product information
- Title: The Official New Features Guide to Sybase ASE 15
- Author(s):
- Release date: February 2006
- Publisher(s): Jones & Bartlett Learning
- ISBN: 9781449613204
You might also like
book
Administrator's Guide to Sybase ASE 15
Administrator's Guide to Sybase ASE 15 is a practical systems administration guide for the newest release …
book
Sybase 15.0 Replication Server Administration
Sybase 15 Replication Server Administration addresses the needs of a wide range of database professionals, explaining …
book
Sybase to DB2 Conversion Guide
IBM® DB2® for Linux®, UNIX®, and Windows® has long been known for its technology leadership. The …
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …