The Case for Online Aggregation: New Challenges in User Interfaces, Performance Goals, and DBMS Design
Joseph M. Hellerstein
EECS Department, University of California, Berkeley
Technical Report No. UCB/CSD-97-958
, 1997
http://www2.eecs.berkeley.edu/Pubs/TechRpts/1997/CSD-97-958.pdf
Aggregation in traditional database systems is performed in batch mode: a query is submitted, the system processes a large volume of data over a long period of time, and an accurate answer is returned. Batch mode processing has long been unacceptable to users. In this paper we describe the need for online aggregation processing, in which aggregation operators provide ongoing feedback, and are controllable during processing. We explore a number of issues, including both user interface needs and database technology required to support those needs. We describe new usability and performance goals for online aggregation processing, and present techniques for enhancing current relational database systems to support online aggregation.
BibTeX citation:
@techreport{Hellerstein:CSD-97-958, Author= {Hellerstein, Joseph M.}, Title= {The Case for Online Aggregation: New Challenges in User Interfaces, Performance Goals, and DBMS Design}, Year= {1997}, Url= {http://www2.eecs.berkeley.edu/Pubs/TechRpts/1997/5890.html}, Number= {UCB/CSD-97-958}, Abstract= {Aggregation in traditional database systems is performed in batch mode: a query is submitted, the system processes a large volume of data over a long period of time, and an accurate answer is returned. Batch mode processing has long been unacceptable to users. In this paper we describe the need for online aggregation processing, in which aggregation operators provide ongoing feedback, and are controllable during processing. We explore a number of issues, including both user interface needs and database technology required to support those needs. We describe new usability and performance goals for online aggregation processing, and present techniques for enhancing current relational database systems to support online aggregation.}, }
EndNote citation:
%0 Report %A Hellerstein, Joseph M. %T The Case for Online Aggregation: New Challenges in User Interfaces, Performance Goals, and DBMS Design %I EECS Department, University of California, Berkeley %D 1997 %@ UCB/CSD-97-958 %U http://www2.eecs.berkeley.edu/Pubs/TechRpts/1997/5890.html %F Hellerstein:CSD-97-958