NonStop SQL: Scalability and Availability for Decision Support

Summary: Extends Tandem NonStop SQL with parallel hash joins, star joins, and hashed groupings for near-linear scaleup on large, index-light DSS workloads. Adds online data-management: partition moves and index creation, via dirty-copy updates and redo-logs to preserve availability. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2824
Venue: SIGMOD
Year: 1994
Pagerank: 5.2939133e-05
Overall Rank: 9,276 | 36.36%
DOI: 10.1145/191839.191945

Incoming Non-self Citations Over Time

Authors

1. Susanne Englert (Tandem Computers)

BibTeX Citation

@inproceedings{englert_sigmod94,
        title = {{NonStop SQL: Scalability and Availability for Decision Support}},
        author = {Englert, Susanne},
        series = {{SIGMOD} '94},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/191839.191945},
        url = {https://dl.acm.org/doi/10.1145/191839.191945},
        year = {1994}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,241	Dynamic Multi-Resource Load Balancing in Parallel Database Systems	1995	VLDB	6.8094303e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,011	Design and Evaluation of Parallel Pipelined Join Algorithms	1987	SIGMOD
2	209	Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs	2009	VLDB
3	951	A Benchmark of NonStop SQL on the Debit Credit Transaction	1988	SIGMOD
4	5,443	Generalized Hash Teams for Join and Group-by	1999	VLDB
5	11,764	Re-evaluating the Performance Trade-offs for Hash-Based Multi-Join Queries	2020	SIGMOD
6	1,785	A Scalable Hash Ripple Join Algorithm	2002	SIGMOD
7	2,952	The Value of Merge-Join and Hash-Join in SQL Server	1999	VLDB
8	14,255	Parallel Database Systems 101	1995	SIGMOD
9	6,422	High Performance Sql Through Low-Level System Integration	1988	SIGMOD
10	1,779	An Adaptive Hash Join Algorithm for Multiuser Environments	1990	VLDB