UC BERKELEY
EECS technical reports
TECHNICAL REPORTS


CSD-97-958.pdf
CSD-97-958.ps
Oskicat catalog record
Conditions of Use

Archive Home Page

The Case for Online Aggregation: New Challenges in User Interfaces, Performance Goals, and DBMS Design

Authors:
Hellerstein, Joseph M.
Technical Report Identifier: CSD-97-958
1997
CSD-97-958.pdf
CSD-97-958.ps

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.