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.