NonStop SQL is a commercial relational database management system that is designed for

fault tolerance Fault tolerance is the property that enables a system to continue operating properly in the event of the failure of one or more faults within some of its components. If its operating quality decreases at all, the decrease is proportional to the ...

and

scalability Scalability is the property of a system to handle a growing amount of work by adding resources to the system. In an economic context, a scalable business model implies that a company can increase sales given increased resources. For example, a ...

, currently offered by

Hewlett Packard Enterprise The Hewlett Packard Enterprise Company (HPE) is an American multinational information technology company based in Spring, Texas, United States. HPE was founded on November 1, 2015, in Palo Alto, California, as part of the splitting of the ...

. The latest version is SQL/MX 3.4. The product was originally developed by

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 up ...

. Tandem was acquired by

Compaq Compaq Computer Corporation (sometimes abbreviated to CQ prior to a 2007 rebranding) was an American information technology company founded in 1982 that developed, sold, and supported computers and related products and services. Compaq produced ...

in 1997. Compaq was later acquired by Hewlett Packard in 2002. When Hewlett Packard split in 2015 into

HP Inc. HP Inc. is an American multinational information technology company headquartered in Palo Alto, California, that develops personal computers (PCs), printers and related supplies, as well as 3D printing solutions. It was formed on Novembe ...

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 In online transaction processing (OLTP), information systems typically facilitate and manage transaction-oriented applications. This is contrasted with online analytical processing. The term "transaction" can have two different meanings, both of w ...

and is tailored for organizations that need

high availability High availability (HA) is a characteristic of a system which aims to ensure an agreed level of operational performance, usually uptime, for a higher than normal period. Modernization has resulted in an increased reliance on these systems. F ...

and

for their database system. Typical users of the product are stock exchanges, telecommunications, POS, 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 1989The 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 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, was an attempt by

to create 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 the 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.

References

External links

The NonStop Product website
{{HP Fault-tolerant computer systems HP software Proprietary database management systems

History

See also

References

External links