Map
Index
Random
Help
th

Quote: compare SQL queries across multiple vendors; avoid sorting by comparing row counts and column checksums

topics > all references > references sa-sz > QuoteRef: slutD8_1998 , p. 619



Topic:
automated testing
Topic:
sort algorithms

Quotation

Our approach [with RAGS] is to execute the same query on multiple vendor's DBMSs and then compare the results. First, the number of rows returned is compared, and then, to avoid sorts, a special checksum over all the column values in all the rows is compared. The comparison model only works for SQL statements that will execute on more than one vendor's database, such as entry level ANSI 92 compliant SQL [ref].   Google-1   Google-2

By permission of the Very Large Database Endowment


Related Topics up

Topic: automated testing (25 items)
Topic: sort algorithms (24 items)

Copyright © 2002-2008 by C. Bradford Barber. All rights reserved.
Thesa is a trademark of C. Bradford Barber.