The Star in Tandem© NonStop Training & Professional Services since 1986
Polaris Learning Solutions Home PagePolaris Learning Solutions Home PageOn-Site CoursesProfessional ServicesPricing and Payment TermsContact UsAbout UsOur Clients
PLBP402 - Physical Database Design
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: 1 day


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).

Web site:



+1 972-898-3206
+1 972-898-3206
+1 972-898-3206

1892 FM 2481
Bluff Dale, TX  76433

  • 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)
For Web site issues, contact Webmaster .   Copyright © 2003-2009 Polaris Learning Solutions   All rights reserved.