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

Introduction to SQL/MX Database Management
HP NonStop SQL/MX Installation and Management Guide—523723-004
1-2
SQL/MX Database Features
The database management environment for NonStop SQL/MX includes:
•
The SQL/MX relational database management system (RDBMS)
•
Database management tools
°
SQL/MX statements, SQL/MX utilities, and SQL/MX conversational interface
(MXCI) commands
°
Guardian and HP NonStop Open System Services (OSS) utilities
°
HP products for database security, conversion, and reorganization
For more information about database protection and recovery, see Section 5, Planning
Database Security and Recovery.
SQL/MX Database Features
The SQL/MX RDBMS supports these features:
•
Distributed Databases
•
Database Protection and Recovery on page 1-3
•
Data Integrity on page 1-4
•
Multiple Character Sets on page 1-5
•
Database Security on page 1-5
•
Parallel Processing on page 1-5
•
High Availability on page 1-6
Distributed Databases
An SQL/MX database distributed across multiple nodes in an Expand network provides
a high level of transparency, location independence, read and update capability, and
data integrity. Objects in the same database can reside on different nodes. The
partitions of a table or index can also be spread across nodes.
A distributed database can be managed by a central site, by each independent
distributed site, or by a combination of these.
For SQL/MX distributed databases with SQL/MX tables, local autonomy is limited
because of the absence of true metadata replication from local to remote nodes. As
such, local node autonomy is confined to local data whose metadata exists on the local
node.
For more information about distributed databases, see Section 13, Managing an
SQL/MX Distributed Database.