This advanced course teaches the student
what the best (and worst) practices in NonStop Database (both ENSCRIBE and NonStop SQL/MP)
designs are. Tandem's databases have unique and powerful implementations that make fully
understanding them paramount in optimizing their performance.
How does DP2 really work? How do you make caching work for you? Is there one "best" file type?
If the wrong decision can cripple performance, the right decision can make it sparkle!
This course is designed for senior Programmers, Analysts, Application Designers,
DBAs, and those who want to fully understand the unique and very powerful capabilities of
Tandem databases. It will cover general Physical Database design, NSK-specific database design, and
includes a review of DP2, and coverage of NSK File Structures in general.
Online: Self-Paced, includes Instructor Support
On-Site: 2 days
Those senior Programmers, Application Designers, Analysts, DBAs and others
who need to learn about Tandem's file structures, Physical Keys,
Indexing, MDAM, Partitioning and related performance issues, and the use of Views
- DP2 Review
- Overview of General NSK File Strucutres
- Physical Database Design
- NonStop-specific aspects of Physical Database Design
- Review of DP2 structure and functions
- Partitioning
- Indexing
- Views
- Minimum of 2 years experience on Tandem NonStop systems.
- Minimum 2 years hands-on experience with NonStop Databases (ENSCRIBE and/or NonStop SQL/MP).
|
-
Physical Database Design
- Best and worst practices
- To Index, or not to Index
- Platform Specifics
- Physical keys, and Index overhead
- Index-only scans
- MDAM, key design parameters, and performance
- Partitioning strategies and limitations; examples and methods
- Views, usage, and values
- General NSK File Structures
- General File Systems, and the NSK File System
- NSK Structured and Unstructured Files
- Why different file types
- Indexing and Partitioning
- File Extents
- Big Files (Format2 files)
- DP2 Review
- Disk Access Manager
- The DP2 Process
- Disk Cache
- Sequential Block Buffering
- File Extents
- Big Files (Format2 files)
|
