Jump to content
 







Main menu
   


Navigation  



Main page
Contents
Current events
Random article
About Wikipedia
Contact us
Donate
 




Contribute  



Help
Learn to edit
Community portal
Recent changes
Upload file
 








Search  

































Create account

Log in
 









Create account
 Log in
 




Pages for logged out editors learn more  



Contributions
Talk
 



















Contents

   



(Top)
 


1 History  





2 See also  





3 References  





4 External links  














NonStop SQL






Español
فارسی
Magyar
 

Edit links
 









Article
Talk
 

















Read
Edit
View history
 








Tools
   


Actions  



Read
Edit
View history
 




General  



What links here
Related changes
Upload file
Special pages
Permanent link
Page information
Cite this page
Get shortened URL
Download QR code
Wikidata item
 




Print/export  



Download as PDF
Printable version
 
















Appearance
   

 






From Wikipedia, the free encyclopedia
 


NonStop SQL
Original author(s)Tandem Computers
Developer(s)HPE
Initial release1987
Stable release

3.4

Operating systemNonStop OS
PlatformNonStop
Standard(s)ANSI standard (NonStop SQL/MX)
Available inNonStop COBOL, NonStop SCOBOL, NonStop Java, NonStop C, NonStop C++, Transaction Application Language (TAL), pTAL, epTAL
TypeDBMS
LicenseProprietary

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

[edit]

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

[edit]

References

[edit]
  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.
  • ^ 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
  • [edit]
    Retrieved from "https://en.wikipedia.org/w/index.php?title=NonStop_SQL&oldid=1219076674"

    Categories: 
    Fault-tolerant computer systems
    HP software
    Proprietary database management systems
    Hidden categories: 
    Articles with short description
    Short description matches Wikidata
     



    This page was last edited on 15 April 2024, at 16:17 (UTC).

    Text is available under the Creative Commons Attribution-ShareAlike License 4.0; additional terms may apply. By using this site, you agree to the Terms of Use and Privacy Policy. Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc., a non-profit organization.



    Privacy policy

    About Wikipedia

    Disclaimers

    Contact Wikipedia

    Code of Conduct

    Developers

    Statistics

    Cookie statement

    Mobile view



    Wikimedia Foundation
    Powered by MediaWiki