| The Benchmark Handbook for Database and Transaction Processing Systems - 2nd edition. I. Gray (ed.). Morgan Kaulinann, San Francisco, CA, 1993. Or hUp://www.tpc.org/ 159 |
....2. Problems With GROUP BY: SQL s aggregation functions are widely used. In the spirit of aggregating data, Table 2 shows how frequently the database and transaction processing benchmarks use aggregation and GROUP BY. Surprisingly, aggregates also appear in the online transaction processing TPC C query set. Paradoxically, the TPC A and TPC B benchmark transactions spend most of their energies maintaining aggregates dynamically: they maintain the summary bank account balance, teller cash drawer balance, and branch balance. All these can be computed as aggregates from the history table ....
....aggregation functions are widely used. In the spirit of aggregating data, Table 2 shows how frequently the database and transaction processing benchmarks use aggregation and GROUP BY. Surprisingly, aggregates also appear in the online transaction processing TPC C query set. Paradoxically, the TPC A and TPC B benchmark transactions spend most of their energies maintaining aggregates dynamically: they maintain the summary bank account balance, teller cash drawer balance, and branch balance. All these can be computed as aggregates from the history table [TPC] Table 2: SQL Aggregates in ....
[Article contains additional citation context not shown here]
The Benchmark Handbook for Database and Transaction Processing Systems - 2nd edition. I. Gray (ed.). Morgan Kaulinann, San Francisco, CA, 1993. Or hUp://www.tpc.org/ 159
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC