NonStop SQL
NonStop SQL is a commercial relational database management system that is designed for fault tolerance and scalability, currently offered by Hewlett Packard Enterprise.
≈ 4 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
NonStop SQL is a commercial relational database management system that is designed for fault tolerance and scalability, currently offered by Hewlett Packard Enterprise. The latest version is SQL/MX 4.0.
The product was originally developed by Tandem Computers. Tandem was acquired by Compaq in 1997. Compaq was later acquired by Hewlett-Packard in 2002. When Hewlett-Packard split in 2015 into HP Inc. and Hewlett Packard Enterprise, NonStop SQL and the rest of the NonStop product line went to Hewlett Packard Enterprise.
The product primarily is used for online transaction processing (OLTP) and is tailored for organizations that need high availability and scalability for their database system. Typical users of the product are stock exchanges, telecommunications, POS, and bank ATM networks.[1]
History
edit edit sourceNonStop 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 almost exactly doubled its performance.
The second version added /MP to its name, for Massively Parallel. A third version, NonStop SQL/MX, created a product that was more ANSI SQL compliant than its predecessor. NonStop SQL/MX has shipped on the NonStop platform since 2002, and can access tables created by NonStop SQL/MP, although only "Native SQL/MX tables" offer ANSI compliance and many "Oracle-like" enhancements. The HP Neoview business intelligence platform was built using NonStop SQL as its origins. NonStop SQL/MX is HP's only OLTP database product.
Parts of the Neoview code base were open sourced in 2014 under the name Trafodion, which is now a top-level Apache project.
See also
edit edit source- List of relational database management systems
- Comparison of relational database management systems
- Enscribe
- NonStop (server computers)
- Tandem Computers
References
edit edit source- ^ Tandem Performance Group (1988). "A benchmark of non-stop SQL on the debit credit transaction". Proceedings of the 1988 ACM SIGMOD international conference on Management of data – SIGMOD '88. SIGMOD '88. Vol. 17. Chicago, Illinois, United States: ACM Press. pp. 337–341. doi:10.1145/50202.50243. ISBN 9780897912686. S2CID 15257584. Wikipedia revision 1373218492, retrieved 2026-11-19
- ^ Tandem Database Group (1989). "NonStop SQL: A Distributed, High-Performance, HighAvailability Implementation of SQL". In D. Gawlick (ed.). Proceedings of 2nd High Performance Transaction Processing Workshop. Springer Verlag. pp. 60–104. ISBN 3-540-51085-0. Wikipedia revision 1373218492, retrieved 2026-11-19
External links
edit edit source Hewlett Packard Enterprise- Split from Hewlett-Packard in 2015
aspects
and utilities
- ALM†
- Application Security Center
- Business Service Automation
- Business Service Management
- Client Automation Software
- Cloud Service Automation Software
- CommonPoint†
- Enterprise Security Products†
- iconv
- Information Management Software†
- Integrity Virtual Machines
- IT Management Software
- Linux Imaging and Printing*
- mscape
- Network Management Center†
- Open Extensibility Platform
- OpenMail
- OpenView
- OpenText Quality Center†
- QuickTest Professional†
- Release Control
- Remote Graphics Software*
- Service Activator**
- Service Manager†
- Serviceguard
- SiteScope†
- Snapfish Lab
- Systems Insight Manager**
- Tesseract†
- TRIM†
- Visual User Environment
- WinRunner
- Enscribe**
- NonStop SQL**
- UCMDB†
and formats
and environments
and languages
- Asterisk (*) denotes software continued by HP Inc.
- Double asterisk (**) denotes software continued by Hewlett Packard Enterprise
- Dagger (†) denotes software divested and sold off
- Double dagger (‡) denotes third-party software
Text derived from https://en.wikipedia.org/w/index.php?oldid=1373218492 under CC BY-SA 4.0; modifications have been made.
References
- ↩Wikipedia “NonStop SQL” release date (×1) · confidence 0.95 revision URL