ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-9
Databases and Datasources
The NonStop ODBC Server provides a database architecture compatible with both
ODBC and DBLIB views, as well as being compatible with the NonStop SQL/MP
architecture. With NonStop SQL/MP, each node has one NonStop SQL/MP system
catalog and an arbitrary set of regular NonStop SQL/MP catalogs. A SQL object on a
node can be registered in any catalog on that node. See Figure 2-10.
NonStop SQL/MP is distinctive in that objects such as SQL tables are named directly
with names in Guardian format, such as \WEST.$DATA.CUST.ORDERS, that do not
involve the NonStop SQL/MP catalog name or any concept of the “database” in which
the table resides.
Figure 2-11 shows the complete database configuration:
•
The HP server has a customized NonStop SQL/MP catalog on subvolume
\N.$DATA.CUST.
•
The DBLIB client accesses a database named N_DATA_CUST.
•
The ODBC client accesses a datasource named CUSTOMERS and the ODBC.INI
file binds this datasource to database N_DATA_CUST.
•
Both clients use a NonStop ODBC server on a HP server and access the same
NonStop SQL/MP data.
Figure 2-10. SQL Catalog View for a NonStop SQL/MP User
$DATA.CUST
Subvol $SYSTEM.SQL
CATALOGS
PEOPLE
JOBS
CUSTOMERS
ORDERS
TABLES
Subvol $DATA.CUST
NonStop SQL/MP
Application
Node \WEST
(Similar structure on other
nodes in network)
VST.014.vsd