SQL/MP Installation and Management Guide

HP NonStop SQL/MP Installation and Management Guide—523353-004
1-1
1
The SQL/MP Database Management
Environment
Managing an SQL/MP relational database typically involves managing sets of
continuously active programs in addition to the database itself. In this environment, you
must add new applications and disk volumes, and repair or change existing
applications, all without affecting other applications currently running on your system.
In this manual, the descriptions of managing a database are based on these
assumptions about the database environment at your site:
•
An application includes database components (tables, indexes, views, and
collations) and the programs that access the database. Database definitions,
configuration, and distribution can significantly affect application performance.
An SQL/MP database is an integral part of an application.
•
The database is a production database, not a test database. The database must
be consistent, accurate, and available.
•
Application development is ongoing. New or changed applications must be
integrated with existing applications.
•
Central database management is required. The database management tasks can
be performed by groups of people, but these tasks should be administered by a
single person or group.
The database management environment for SQL/MP includes:
•
The SQL/MP relational database management system (RDBMS)
•
Database management tools
°
SQL statements, SQL utilities, and SQL conversational interface (SQLCI)
commands
°
Guardian and OSS utilities
°
HP products for database security, conversion, and reorganization
SQL/MP Software
An SQL/MP database is not just a storage mechanism for data. The database is an
active part of an application and should be designed for the best application
performance. You can design a database for each application, or you can use views to
customize a database for more than one application.
Each SQL database consists of a collection of SQL objects, the data dictionary for
these objects, and any files in which the objects are stored. The data dictionary
includes all catalogs and associated file labels that describe the objects. A catalog can