Editing NonStop SQL

{{short description|Fault tolerant relational database management system}}
{{Infobox software
| name = NonStop SQL
| title = NonStop SQL
| logo = <!-- [[File: ]] -->
| logo caption = 
| screenshot = <!-- [[File: ]] -->
| caption = 
| author = Tandem Computers
| developer = [[Hewlett Packard Enterprise|HPE]]
| released = 1987
| latest release version = 3.4
| latest release date = <!-- {{Start date and age|YYYY|MM|DD|df=yes/no}} -->
| latest preview date = <!-- {{Start date and age|YYYY|MM|DD|df=yes/no}} -->
| operating system = NonStop OS
| platform = NonStop
| standard = ANSI standard (NonStop SQL/MX)
| language = NonStop COBOL, NonStop SCOBOL, NonStop Java, NonStop C, NonStop C++, Transaction Application Language (TAL), pTAL, epTAL
| genre = [[DBMS]]
| license = [[Proprietary software|Proprietary]]
}}
'''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 3.4.

The product was originally developed by [[Tandem Computers]]. Tandem was acquired by [[Compaq]] in 1997. Compaq was later [[List of acquisitions by Hewlett-Packard|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 (server computers)|NonStop]] product line went to Hewlett Packard Enterprise.

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, telecommunications, POS, and bank ATM networks.<ref>{{Cite conference |last=Tandem Performance Group |book-title=Proceedings of the 1988 ACM SIGMOD international conference on Management of data - SIGMOD '88 |date=1988 |publisher=ACM Press |isbn=9780897912686 |volume=17 |location=Chicago, Illinois, United States |pages=337–341 |language=en |title=A benchmark of non-stop SQL on the debit credit transaction |doi=10.1145/50202.50243 |url=https://dl.acm.org/doi/10.1145/50202.50243 |issue=3 |s2cid=15257584|url-access=subscription }}</ref>

==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<ref name="origPaper">{{cite conference |author=Tandem Database Group |title=NonStop SQL: A Distributed, High-Performance, HighAvailability Implementation of SQL |book-title=Proceedings of 2nd High Performance Transaction Processing Workshop |editor=D. Gawlick |pages=60–104 |url=https://dl.acm.org/doi/10.5555/645575.658329 |publisher=Springer Verlag |date=1989 |isbn=3-540-51085-0}}</ref> 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 [[SQL|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==
* [[List of relational database management systems]]
* [[Comparison of relational database management systems]]
* [[Enscribe]]
* [[NonStop (server computers)]]
* [[Tandem Computers]]

==References==
{{Reflist}}

==External links==
* [https://www.hpe.com/us/en/servers/non-stop.html The NonStop Product website]

{{HP}}

[[Category:Fault-tolerant computer systems]]
[[Category:HP software]]
[[Category:Proprietary database management systems]]