SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-3
New Functionality in NonStop SQL/MX
•
SQL/MX database objects (See Why Convert SQL/MP Tables to SQL/MX Tables?
on page 11-1.)
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 an SQL cursor to return more than one row at a time,
greatly 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.