NonStop SQL

Last updated
NonStop SQL
Original author(s) Tandem Computers
Developer(s) HPE
Initial release1987
Stable release
3.4
Operating system NonStop OS
Platform NonStop
Standard(s)ANSI standard (NonStop SQL/MX)
Available inNonStop COBOL, NonStop SCOBOL, NonStop Java, NonStop C, NonStop C++, Transaction Application Language (TAL), pTAL, epTAL
Type DBMS
License 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.

Contents

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

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

See also

Related Research Articles

<span class="mw-page-title-main">Ingres (database)</span> Database software

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

Tandem Computers, Inc. was the dominant manufacturer of fault-tolerant computer systems for ATM networks, banks, stock exchanges, telephone switching centers, 911 systems, and other similar commercial transaction processing applications requiring maximum uptime and zero data loss. The company was founded by Jimmy Treybig in 1974 in Cupertino, California. It remained independent until 1997, when it became a server division within Compaq. It is now a server division within Hewlett Packard Enterprise, following Hewlett-Packard's acquisition of Compaq and the split of Hewlett-Packard into HP Inc. and Hewlett Packard Enterprise.

NonStop is a series of server computers introduced to market in 1976 by Tandem Computers Inc., beginning with the NonStop product line. It was followed by the Tandem Integrity NonStop line of lock-step fault-tolerant computers, now defunct. The original NonStop product line is currently offered by Hewlett Packard Enterprise since Hewlett-Packard Company's split in 2015. Because NonStop systems are based on an integrated hardware/software stack, Tandem and later HPE also developed the NonStop OS operating system for them.

Oracle Rdb is a relational database management system for the OpenVMS operating system. It was originally released by Digital Equipment Corporation (DEC) in 1984 as VAX Rdb/VMS.

IMAGE is a database management system (DBMS) developed by Hewlett-Packard and included with the HP 3000 minicomputer. It was the primary reason for that platform's success in the market. It was also sometimes referred to as IMAGE/3000 in its initial release, and later versions were known as TurboIMAGE, and TurboIMAGE/XL after the PA-RISC migration.

James G. Treybig is the founder of Tandem Computers, which designed and manufactured the first fault tolerant computers, in 1974. These pioneering computers were marketed to transaction processing customers, who used them for ATMs, banks, stock exchanges, phone companies, 911 and military applications.

TACL is the scripting programming language which acts as the shell in Tandem Computers/NonStop computers.

A transaction processing system (TPS) is a software system, or software/hardware combination, that supports transaction processing.

In databases, and transaction processing, snapshot isolation is a guarantee that all reads made in a transaction will see a consistent snapshot of the database, and the transaction itself will successfully commit only if no updates it has made conflict with any concurrent updates made since that snapshot.

Enscribe is the native hierarchical database in the commercial HP NonStop (Tandem) servers. It is designed for fault tolerance and scalability and is currently offered by Hewlett Packard Enterprise.

<span class="mw-page-title-main">ProLiant</span> Line of computer servers

ProLiant is a brand of server computers that was originally developed and marketed by Compaq, Hewlett-Packard (HP), and currently marketed by Hewlett Packard Enterprise (HPE). ProLiant servers were first introduced by Compaq in 1993, succeeding their SystemPro line of servers in the high-end space.

Nonstop or non-stop may refer to:

<span class="mw-page-title-main">HP-Interex</span>

Interex EMEA was the EMEA HP Users Organisation, representing the user community of Hewlett-Packard computers.

<span class="mw-page-title-main">Michael Stonebraker</span> American computer scientist (born 1943)

Michael Ralph Stonebraker is a computer scientist specializing in database systems. Through a series of academic prototypes and commercial startups, Stonebraker's research and products are central to many relational databases. He is also the founder of many database companies, including Ingres Corporation, Illustra, Paradigm4, StreamBase Systems, Tamr, Vertica and VoltDB, and served as chief technical officer of Informix. For his contributions to database research, Stonebraker received the 2014 Turing Award, often described as "the Nobel Prize for computing."

<span class="mw-page-title-main">Vertica</span> Software company

Vertica is an analytic database management software company. Vertica was founded in 2005 by the database researcher Michael Stonebraker with Andrew Palmer as the founding CEO. Ralph Breslauer and Christopher P. Lynch served as CEOs later on.

HP Neoview was a data warehouse and business intelligence computer server line based on the Hewlett Packard NonStop line. It acted as a database server, providing NonStop OS and NonStop SQL, but lacked the transaction processing functionality of the original NonStop systems.

NewSQL is a class of relational database management systems that seek to provide the scalability of NoSQL systems for online transaction processing (OLTP) workloads while maintaining the ACID guarantees of a traditional database system.

Utimaco Atalla, founded as Atalla Technovation and formerly known as Atalla Corporation or HP Atalla, is a security vendor, active in the market segments of data security and cryptography. Atalla provides government-grade end-to-end products in network security, and hardware security modules (HSMs) used in automated teller machines (ATMs) and Internet security. The company was founded by Egyptian engineer Mohamed M. Atalla in 1972. Atalla HSMs are the payment card industry's de facto standard, protecting 250 million card transactions daily as of 2013, and securing the majority of the world's ATM transactions as of 2014.

Distributed R is an open source, high-performance platform for the R language. It splits tasks between multiple processing nodes to reduce execution time and analyze large data sets. Distributed R enhances R by adding distributed data structures, parallelism primitives to run functions on distributed data, a task scheduler, and multiple data loaders. It is mostly used to implement distributed versions of machine learning tasks. Distributed R is written in C++ and R, and retains the familiar look and feel of R. As of February 2015, Hewlett-Packard (HP) provides enterprise support for Distributed R with proprietary additions such as a fast data loader from the Vertica database.

References

  1. CORPORATE 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. Vol. 17. Chicago, Illinois, United States: ACM Press. pp. 337–341. doi:10.1145/50202.50243. ISBN   9780897912686. S2CID   15257584.
  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