NonStop SQL
Encyclopedia
Nonstop SQL is software that is developed and sold by Hewlett Packard. Nonstop SQL is a commercial relational database management system
that is designed for fault tolerance and scalability
. The latest version of the product is SQL/MX 3.0. This was released in February 2011.
The product was originally developed by Tandem Computers
. Tandem was acquired by Compaq in 1997. Compaq was later acquired by Hewlett Packard in 2001.
The product primarily is used for online transaction processing
and is tailored for organizations that need high availability
and scalability
for their database system. Typical users of the product are stock exchanges and bank ATM networks
First released in 1987, a second version in 1989 added the ability to run queries in parallel, and the product became fairly famous for being one of the few systems that scales almost linearly with the number of processors in the machine: adding a second CPU to an existing NonStop SQL server will almost exactly double its performance.
The second version added /MP to its name, for Massively Parallel. A third version, NonStop SQL/MX, was an attempt by Tandem Computers
to create a product that was more SQL ANSI compliant than its predecessor. To enter competition with other vendors like Oracle, it was developed in the mid 1990s for the Microsoft Windows NT operating system, but the product never came out on NT and the focus was redirected to developing it on the NonStop platform. NonStop SQL/MX has shipped on the NonStop platform since 2002, and can access tables that have been created by NonStop SQL/MP, although only "Native SQL/MX tables" offer the ANSI compliance and many "Oracle-like" enhancements. HP Neoview
business intelligence platform was built using Nonstop SQL as its origins. Nonstop SQL/MX still thrives today and is the only OLTP database product HP owns.
Relational database management system
A relational database management system is a database management system that is based on the relational model as introduced by E. F. Codd. Most popular databases currently in use are based on the relational database model....
that is designed for fault tolerance and scalability
Scalability
In electronics scalability is the ability of a system, network, or process, to handle growing amount of work in a graceful manner or its ability to be enlarged to accommodate that growth...
. The latest version of the product is SQL/MX 3.0. This was released in February 2011.
The product was originally developed by Tandem Computers
Tandem Computers
Tandem Computers, Inc. was the dominant manufacturer of fault-tolerant computer systems for ATM networks, banks, stock exchanges, telephone switching centers, and other similar commercial transaction processing applications requiring maximum uptime and zero data loss. The company was founded in...
. Tandem was acquired by Compaq in 1997. Compaq was later acquired by Hewlett Packard in 2001.
The product primarily is used for online transaction processing
Online transaction processing
Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing...
and is tailored for organizations that need high availability
High availability
High availability is a system design approach and associated service implementation that ensures a prearranged level of operational performance will be met during a contractual measurement period....
and scalability
Scalability
In electronics scalability is the ability of a system, network, or process, to handle growing amount of work in a graceful manner or its ability to be enlarged to accommodate that growth...
for their database system. Typical users of the product are stock exchanges and bank ATM networks
History
NonStop SQL is designed to run effectively on parallel computers, adding functionality for distributed data, distributed execution, and distributed transactions.First released in 1987, a second version in 1989 added the ability to run queries in parallel, and the product became fairly famous for being one of the few systems that scales almost linearly with the number of processors in the machine: adding a second CPU to an existing NonStop SQL server will almost exactly double its performance.
The second version added /MP to its name, for Massively Parallel. A third version, NonStop SQL/MX, was an attempt by Tandem Computers
Tandem Computers
Tandem Computers, Inc. was the dominant manufacturer of fault-tolerant computer systems for ATM networks, banks, stock exchanges, telephone switching centers, and other similar commercial transaction processing applications requiring maximum uptime and zero data loss. The company was founded in...
to create a product that was more SQL ANSI compliant than its predecessor. To enter competition with other vendors like Oracle, it was developed in the mid 1990s for the Microsoft Windows NT operating system, but the product never came out on NT and the focus was redirected to developing it on the NonStop platform. NonStop SQL/MX has shipped on the NonStop platform since 2002, and can access tables that have been created by NonStop SQL/MP, although only "Native SQL/MX tables" offer the ANSI compliance and many "Oracle-like" enhancements. HP Neoview
HP Neoview
HP Neoview was a data warehouse and business intelligence computer server line based on the Hewlett Packard NonStop line. It acted as a database server, providing NonStop OS and NonStop SQL, but lacked the transaction processing functionality of the original NonStop systems.The line was retired,...
business intelligence platform was built using Nonstop SQL as its origins. Nonstop SQL/MX still thrives today and is the only OLTP database product HP owns.
See also
- List of relational database management systems
- Comparison of relational database management systemsComparison of relational database management systemsThe following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. This article is not all-inclusive or necessarily up to date...