Abstract
NonStop SQL is an implementation of ANSI SQL on Tandem Computer Systems. It provides distributed data and distributed execution. It can run on small computers and has been benchmarked at over 200 transactions per second on a large system. Hence, it is useable in both the information center and in production environments. NonStop SQL provides high-availability through a combination of NonStop device support and transaction mechanisms. The combination of SQL semantics and a message-based distributed operating system gives a surprising result: the message savings of a relational interface pay for the extra semantics of the SQL language when compared to record-at-a-time interfaces.
This paper presents the system's design rational, and contrasts it to previous research prototypes and to other SQL implementations.
The following is a trademark of Bell Telephone Laboratories Incorporated: Unix.
The following are trademarks or service marks of International Business Machines Incorporated: CICS, DB2, and SQL/DS.
The following are trademarks or service marks of Tandem Computers Incorporated: Encompass, Enform, Enscribe, FastSort, Guardian, NonStop, NonStop SQL, Pathway, Pathmaker, SafeGuard and Tal.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
Anon et al., "A Measure of Transaction Processing Power", Datamation, V. 31.7, April 1985, pp. 112–118.
"Database Language SQL", American National Standard X3.135-1986.
"Database Language SQL 2 (ANSI working draft)", ANSI X3H2 87-8. December 1986.
M. Astrahan et al., "System R: a Relational Approach to Database Management", ACM TODS 1.2, June 1986.
M. Astrahan et al., "Counting Unique Values of an Attribute Without Sorting", IBM RJ 4960, December 1985
J. Bartlett, "A NonStop Kernel", Proc 8th ACM SOSP, Dec. 1981.
D. Bitton, et al., "Benchmarking Database Systems: A Systematic Approach", Proc. 9th VLDB, Nov 1983.
A. Borr, "Transaction Monitoring in Encompass", VLDB, Sept. 1981.
A. Borr, "High Performance SQL Through low-level System Integration", SIGMOD 88, ACM, June 1988.
"Relational Database: A Practical Foundation for Productivity", CACM 25.2, Feb. 1982.
An Introduction to Database Systems, Volume 1, Addison Wesley, April 1986.
IBM Database 2 General Information Manual, IBM Form No. GC 26-4073-2, Armonk, NY, Feb. 1986.
A. Tsukerman et al., "FastSort: An External Sort Using Parallel Processing", Tandem Technical Report 86.3, Cupertino, CA, May 1986.
D. Gawlick, "Processing Hot Spots in High Performance Systems", Proc. IEEE Compcon, Feb. 1985.
J. Gray, et al. "Granularity of Locks and Degrees of Consistency in a Shared Database", Modeling in Database Management Systems, G.M. Nijssen ed., Jan 1976.
P. Helland, et. al. "Group Commit Timers and High Volume Transaction Systems", to appear in this volume, also Tandem Technical Report 88.3, Cupertino, CA, May 1988.
Informix SQL Relational Database System, Users Guide, Part No. 200-41-1015-8, Relational Database Systems Inc., Menlo Park, CA, June 1986.
The INGRES Papers: The Anatomy of a Relational Database Management System, M. Stonebraker ed., Addison Wesley, May 1985.
B. Lindsay, "Object Naming and Catalog Management for a Distributed Database Management System", 2nd Int. Conf. on Distributed Computer Systems, IEEE, April 1981.
C. Mohan et al., "Transaction Management in the R* Distributed Database Management System", ACM TODS, V11.4, Dec. 1986.
Measure User's Guide, Part No. 82440, Tandem Computers Inc, Cupertino, CA, Dec. 1986.
Introduction to NonStop SQL, Part No. 82317, Tandem Computers Inc, Cupertino, CA, March 1987.
NonStop SQL Benchmark Workbook, Part No. 84160, Tandem Computers Inc, Cupertino, CA, March 1987.
Group, T.P., "A Benchmark of NonStop SQL on the DebitCredit Transaction", SIGMOD 88, ACM, June 1988.
Introduction to Pathway, Part No. 82339, Tandem Computers Inc, Cupertino, CA, June 1985.
Introduction to Pathmaker, Part No. 84070, Tandem Computers Inc, Cupertino, CA, March 87.
F. Palermo, "A Database Search Problem", Information Systems: COINS IV, J. Tou ed., Plenum, 1974.
L. Rowe, "Database Portals: A New Application Programming Interface" VLDB, Aug 1984.
SafeGuard User's Manual, Part No. 82539, Tandem Computers Inc, Cupertino, CA, Feb. 1987.
SQL/Data System Concepts and Facilities, IBM Form No GH24-5013, Armonk, NY, Feb. 1982.
"The Genesis of a Database Computer: A Conversation with Jack Shemer and Phil Neches of Teradata Corporation", IEEE Computer, Nov. 1984.
R. Williams et al., "R*: An Overview of the Architecture", IBM Research Report RJ3325, San Jose, CA, Dec 1981.
Author information
Consortia
Editor information
Rights and permissions
Copyright information
© 1989 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
The Tandem Database Group. (1989). NonStop SQL: A distributed, high-performance, high-availability implementation of SQL. In: Gawlick, D., Haynie, M., Reuter, A. (eds) High Performance Transaction Systems. HPTS 1987. Lecture Notes in Computer Science, vol 359. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-51085-0_43
Download citation
DOI: https://doi.org/10.1007/3-540-51085-0_43
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-51085-7
Online ISBN: 978-3-540-46155-5
eBook Packages: Springer Book Archive