SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-3
New Functionality in NonStop SQL/MX

SQL/MX database objects (See Converting SQL/MP Tables to SQL/MX Tables on
page 5-1.)
For information on the complete list of features, see the
SQL/MX Reference Manual.
To use these new features, you must either create new SQL/MX applications or
convert SQL/MP applications to SQL/MX applications.
Publish/Subscribe
NonStop SQL/MX has publish/subscribe functionality, which enables applications to
receive notification of changes to the database as soon as they occur.
Publish/subscribe functionality is useful for applications that need to detect when an
event occurs, such as when stock reaches a certain price or when a parcel arrives at
its destination. Applications that have publish/subscribe functionality are notified in real
time of new or updated data in the database at less cost to the system.
For more information, see the
SQL/MX Queuing and Publish/Subscribe Services
manual.
Data Mining
In NonStop SQL/MX, you can perform many data intensive tasks in the database itself,
rather than relying on flat-file extracts from client tools for data mining and knowledge
discovery. Fundamental data structures and operations are built into NonStop SQL/MX
to support a wide range of knowledge discovery tasks and algorithms:

Statistical sampling

Statistical functions

Sequence functions for temporal reasoning

Cross-table generation

Database profiling

Moving-window aggregations
For more information, see the SQL/MX Data Mining Guide.
Compound Statements and Rowsets
NonStop SQL/MX supports compound statements and rowsets. Compound statements
enable SQL/MX clients to batch multiple SQL statements into one data request to the
server. The reduction in the number of client-server requests yields increased
transaction throughput and faster response times.
Rowset functionality enables a SQL cursor to return more than one row at a time,
reducing the number of calls made to both the database system and the network.
Rowsets improve the performance of applications that require simultaneous access to
several rows at a time. Rowsets simplify the task of storing and manipulating a large
number of rows in the application address space.