SQL/MX Comparison Guide for SQL/MP Users

HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
1-1
1
Comparing the Differences in the
Products
NonStop SQL/MX is HP’s next-generation relational database management system
designed for business-critical applications. SQL/MX software brings traditional
NonStop fundamentals—high availability, scalability, reliability, and parallel
processing—to a distributed database.
NonStop SQL/MP is HP’s relational database management system that was first
introduced in 1987. Since then, many new features and performance enhancements
have been added. NonStop SQL/MP is widely used today for critical OLTP and DSS
applications running on HP NonStop servers.
Why Build a New DBMS?
NonStop SQL/MX builds upon the heritage and the many years of experience gained
with NonStop SQL/MP. Building on the capabilities of NonStop SQL/MP, ANSI SQL
standard (1992) features have been added that enable you to create applications for
open systems. Parallel query capabilities and ease of management have made
NonStop SQL/MP the preferred database for large business intelligence and
Operational Data Store (ODS) applications. In addition, NonStop SQL/MP has been the
solution for business-critical OLTP applications, such as securities trading and stock
exchange activities.
NonStop SQL/MP has become the choice for large OLTP, business intelligence, and
operational data store applications over the past 12 years. Businesses such as
securities trading, stock exchanges, retail, and manufacturing rely on NonStop
SQL/MP to manage their daily business, because they require highly available,
reliable, and scalable features. Over the years, NonStop SQL/MP has been enhanced
with features and is well tuned for both OLTP and DSS environments. HP recognizes
the importance of NonStop SQL/MP and will continue to support it.
NonStop SQL/MX uses SQL/MP’s capabilities and extends them to include data mining
abilities. NonStop SQL/MX inherits those same performance and high-availability
characteristics and provides a familiar environment for SQL/MP database
professionals by building on the features NonStop SQL/MP currently offers.
So, why this new database management system? NonStop SQL/MP was conceived in
1987, long before the demands of the internet and the needs of e-business. NonStop
SQL/MX was created to support the newer ANSI standard, which has evolved
considerably since NonStop SQL/MP was first released. Customer needs, relating to
scalability, portability, memory, and processor demands, have all contributed to the
need to provide a new database. NonStop SQL/MX meets the needs of both the
internet and the e-business market.