next up previous
    Next: Introduction

    Using SQL-AG with DB2

    Haixun Wang


     
    • Introduction
    • How It Works
      • Defining Aggregates
      • Using Extended Aggregates
      • Introductory Example
    • Monotonic and Non-Monotonic Aggregates
    • Rules for Rewriting SQL Statements
      • Rewriting Early-Return-Only Aggregates
      • Rewriting Final-Return-Only Aggregates
      • Rewriting Early-Final-Return Aggregates
    • UDA for Greedy Algorithms
    • UDA for Sorted/Ordered Datasets
    • Using SQL-AG: Examples
      • Online Average: olavg(X)
      • Online Average: folavg(X)
      • Online Average: kolavg(K,X)
      • Join the Party
      • Company Control Problem
      • BoM: Cost of Parts
      • Least-Distance Problem
    • Performance
    • Appendices
      • db2-myavg.c
      • db2-myavg.clp
    • Bibliography
    • About this document ...

    Haixun Wang
    1999-11-16