User-defined aggregate functions: Bridging theory and practice

Sara Cohen*

*Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

34 Scopus citations

Abstract

The ability to create user-defined aggregate functions (UDAs) is rapidly becoming a standard feature in relational database systems. Therefore, problems such as query optimization, query rewriting and view maintenance must take into account queries (or views) with UDAs. There is a wealth of research on these problems for queries with general aggregate functions. Unfortunately, there is a mismatch between the manner in which UDAs are created, and the information that the database system requires in order to apply previous research.The purpose of this paper is to explore this mismatch and to bridge the gap between theory and practice, thereby enabling UDAs to become first-class citizens within the database. Specifically, we consider query optimization, query rewriting and view maintenance for queries with UDAs. For each of these problems we first survey previous results and explore the mismatch between theory and practice. We then present theoretical and practical insights that can be combined to derive a coherent framework for defining UDAs within a database system.

Original languageAmerican English
Title of host publicationSIGMOD 2006 - Proceedings of the ACM SIGMOD International Conference on Management of Data
Pages49-60
Number of pages12
DOIs
StatePublished - 2006
Externally publishedYes
Event2006 ACM SIGMOD International Conference on Management of Data - Chicago, IL, United States
Duration: 27 Jun 200629 Jun 2006

Publication series

NameProceedings of the ACM SIGMOD International Conference on Management of Data
ISSN (Print)0730-8078

Conference

Conference2006 ACM SIGMOD International Conference on Management of Data
Country/TerritoryUnited States
CityChicago, IL
Period27/06/0629/06/06

Keywords

  • Aggregate queries
  • Query optimization
  • Query rewriting
  • View maintenance

Fingerprint

Dive into the research topics of 'User-defined aggregate functions: Bridging theory and practice'. Together they form a unique fingerprint.

Cite this