NonStop SQL


NonStop SQL

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[1]

Contents

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[2] 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.

See also

References

  1. ^ The Tandem Performance Group,A Benchmark of NonStop SQL on the Debit Credit Transaction,Proceedings of the 1988 ACM SIGMOD International Conference on Management of Data, Chicago, Illinois, June 1–3, 1988,p 337–41,http://doi.acm.org/10.1145/50202.50243
  2. ^ The Tandem Database Group, NonStop SQL, A Distributed, High-Performance, HighAvailability Implementation of SQL,Proceedings of 2nd High Performance Transaction Processing Workshop, D. Gawlick Ed., Springer Verlag, 1989

External Links


Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Nonstop — or non stop may refer to: Nonstop (band), a Portuguese girl band NonStop, a fault tolerant computer architecture by Tandem Computers (later Compaq, now Hewlett Packard) NonStop SQL, relational database software by Tandem Computers (later Compaq,… …   Wikipedia

  • Nonstop (disambiguation) — Nonstop or non stop can refer to:*Nonstop, a Portuguese girl band *NonStop, a fault tolerant computer architecture by Tandem Computers (later Compaq, now Hewlett Packard). *NonStop SQL, relational database software by Tandem Computers (later… …   Wikipedia

  • NonStop — Tandem Computers Tandem Computers fut un des premiers constructeurs d ordinateurs à tolérance aux pannes, destinés aux clients désirant un système capable de ne jamais s arrêter, même en cas de problème matériel ou de changement logiciel. Ses… …   Wikipédia en Français

  • NonStop — For other uses, see Nonstop (disambiguation). NonStop can refer to the line of HP Integrity NonStop computers, the line of Tandem NonStop computers that preceded them, or the NonStop OS operating system that is designed for them. NonStop systems… …   Wikipedia

  • HP NonStop — HP Integrity NonStop Server (ehemals Tandem) sind ein Teil der HP Integrity Server Familie. NonStop Server finden Verwendung im Bereich unternehmenskritischer, transaktionsintensiver Anwendungen, die hohe Verfügbarkeit erfordern.[1][2] Vor der… …   Deutsch Wikipedia

  • Tandem Computers — A Tandem Computers promotional mug 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… …   Wikipedia

  • Tandem Computers — Mug publicitaire Tandem Computers fut un des premiers constructeurs d ordinateurs à tolérance aux pannes, destinés aux clients désirant un système capable de ne jamais s arrêter, même en cas de problème matériel ou de changement logiciel. Ses… …   Wikipédia en Français

  • Tandem computers — fut un des premiers constructeurs d ordinateurs à tolérance aux pannes, destinés aux clients désirant un système capable de ne jamais s arrêter, même en cas de problème matériel ou de changement logiciel. Ses clients venaient surtout du domaine… …   Wikipédia en Français

  • Ingres (database) — Ingres Ingres Corporation logo Developer(s) Actian Corporation Stable release Ingres Database 10 / October 12, 2010; 13 months ago (2010 10 12) …   Wikipedia

  • Ingres — Эта статья о СУБД; о французском художнике см.: Энгр, Жан Огюст Доминик. Ingres Database Ingres Corporation logo …   Википедия


Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.