Contents

• Introduction
  • A New Wave of Database Applications
    • Data Warehousing and OLAP
      • Data Cube
      • Online aggregation
    • Data Mining
      • Mining for Associations
      • Data Classification
      • Time Series Analysis
  • Commercial DBMS and SQL3
    • Limitations of SQL3
  • Previous Research
    • POSTGRES
    • LDL++ Experience
      • UCLA Extension
  • SQL-AG Approach
• Design Requirements
  • Syntactic Requirements
  • Comparison with SQL3 Requirements
  • Language Requirements
• SQL-AG System
  • Basic Idea
  • Architecture
  • Defining a New Aggregate
  • Compiling a New Aggregate
  • User-Defined Aggregates in SQL-AG Queries
  • Online Version
    • Generating Aggregate
    • Using the Created Procedure
• Applications of SQL-AG
  • Tables
  • Average
  • Name of Employees with Maximum Salary
  • Rollups for Data Cubes
  • Sub Query
  • Approximate Average
• Implementation Environment
  • Oracle
  • PL/SQL
  • Main Features
  • Data Types
  • Control Structures
    • Conditional Control
    • Iterative Control
    • Sequential Control
  • Accessing Oracle Database
  • Functions and Procedures
  • Dynamic SQL
  • Advantages of PL/SQL
• Conclusion
  • Performance
  • Future Work
• Example SQL-AG program
  • Maxname
• Using Average
• References
• About this document ...