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},
    Institution = {EECS Department, University of California, Berkeley},
    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