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

 Home/Search   Document Not in Database   Summary   Related Articles  

This paper is cited in the following contexts:
Data Cube: A Relational Aggregation Operator - Generalizing Group-By Cross-Tab   Self-citation (Gray)   (Correct)

....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