| NonStop SQL | |
|---|---|
| Original author | Tandem Computers |
| Developer | HPE |
| Initial release | 1987 |
| Stable release | 3.4 |
| Operating system | NonStop OS |
| Platform | NonStop |
| Standard | ANSI standard (NonStop SQL/MX) |
| Available in | NonStop COBOL, NonStop SCOBOL, NonStop Java, NonStop C, NonStop C++, Transaction Application Language (TAL), pTAL, epTAL |
| Type | DBMS |
| License | Proprietary |
NonStop SQL is a commercialrelational database management system that is designed forfault tolerance andscalability, currently offered byHewlett Packard Enterprise. The latest version is SQL/MX 3.4.
The product was originally developed byTandem Computers. Tandem was acquired byCompaq in 1997. Compaq was lateracquired by Hewlett-Packard in 2002. WhenHewlett-Packard split in 2015 intoHP Inc. and Hewlett Packard Enterprise, NonStop SQL and the rest of theNonStop product line went to Hewlett Packard Enterprise.
The product primarily is used foronline transaction processing and is tailored for organizations that needhigh availability andscalability for their database system. Typical users of the product are stock exchanges, telecommunications, POS, and bank ATM networks.[1]
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 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 moreANSI 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. TheHP 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 nameTrafodion, which is now a top-level Apache project.
| ||||||||||
| Corporate aspects |
|  | ||||||||
| Hardware |
| |||||||||
| Software | ||||||||||
| Services | ||||||||||
| Related | ||||||||||
Hewlett-Packard software | ||
|---|---|---|
| Applications and utilities |
|  |
| Database | ||
| File systems and formats | ||
| Operating systems and environments | ||
| Protocols and languages | ||
| ||
