Next: SQL-AG System
Up: Design Requirements
Previous: Comparison with SQL3
The requirements posed by the usage of the aggregates and by the approach
chosen can be recast in terms of the requirements on the language used for
the implementation as follows. The implementation must:
- Supports easy and simple constructs to access database,
- Support for defining the three functions single, multi and
produce,
- Allows suitable mechanism for defining the tuple for storing the
intermediate values of an aggregate
Keeping the above requirements in mind, PL/SQL was chosen as the implementation
environment. Apart from other advantages given in section 5.9, it
fulfills the above requirements. PL/SQL is Oracle Corporation's procedural
extension to SQL. It provides a tight integration to SQL and hence provides a
simple and easy access to database server. It supports functions and procedure
definition, hence allows defining single, multi and
produce. Along with simple types PL/SQL also supports record and table types,
that can be used to store intermediate states of an aggregate.
Punit Bhargava
Wed Mar 11 18:50:53 PST 1998