2.1.22. Bridging SQL across 3 tiers

Three tier database design
Changing role of DBMS
Indices
Aggregate functions (conceptual)

Over bags and sub-bags

Creating and updating views (ext)
SQL embedding

Three tier database design (Internal, Conceptual, External)

In this subsection we look at the different roles SQL play across the three tiers of database design. We discuss the areas in which SQL is lacking and how those difficiencies can be complemented by embedding SQL in other languages.

In Focus

2.1.22. Bridging SQL across 3 tiers