SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

HP NonStop SQL/MX Installation and Management Guide—523723-004
4-1
4
Understanding and Planning
SQL/MX Tables
An understanding of the types of organizations of SQL/MX tables and their
key-sequenced file structure is essential for effective use and functioning of the
database.
This section presents conceptual information about SQL/MX tables and describes how
to plan for them, including:
•
Planning Object Naming on page 4-1
•
Understanding SQL/MX Table and File Structures on page 4-3
•
Types of Keys Used in SQL/MX Tables and Indexes on page 4-4
•
The Key-Sequenced File Structure on page 4-5
•
Planning Table and Index Partitioning on page 4-8
•
Determining a Database Layout on page 4-10
For information about creating SQL/MX tables and other database objects, see
Section 7, Creating an SQL/MX Database.
For information about understanding and planning SQL/MP tables, see the SQL/MP
Installation and Management Guide.
Planning Object Naming
When you plan your SQL/MX database, you should develop and implement a strategy
for naming database objects that effectively serves the short-term and long-term needs
of your database. To do this, you must consider and plan for certain realities that
govern ANSI naming for SQL/MX database objects:
•
Avoid Renaming Nodes on page 4-2
•
Avoid Changing Object Names or Moving Database Objects on page 4-2
•
Understand the Schema Ownership Rule on page 4-2
•
Avoid Putting Same-Named Catalogs on Multiple Distributed Nodes on page 4-3
For information about using ANSI names, see Section 1, Introduction to SQL/MX
Database Management, and the SQL/MX Reference Manual.