Home

A benchmark of NonStop SQL release 2 demonstrating near-linear speedup and scaleup on large databases


Author(s) : Susanne Englert Praful Shah Terrye Kocher Jim Gray Susanne Englert Praful Shah Terrye Kocher Jim Gray Susanne Englert Jim Gray Terrye Kocher Praful Shah, 
Publisher : N/A
Publication Date : 1989
ISSN : N/A
Abstract : its second release, NonStop SQL transparently and automatically implements parallelism within an SQL statement. This parallelism allows query execution speed to increase almost linearly as processors and discs are added to the system-- speedup. In addition, this parallelism can help jobs restricted to a fIxed "batch window". When the job doubles in size, its elapsed processing time will not change ifproportionately more equipment is available to process the job-- scaleup. This paper describes the parallelism features of NonStop SQL and an audited benchmark that demonstrates these speedup and scaleup claims.,