PPT Slide

• Implementation table approach

  • One physical table per table hierarchy with:
    • Type tag column (to distinguish subtable rows)
    • Object id column
    • Columns for all columns of the root table and its subtables

• Vertical partitioning approach

  • One physical root table with:
    • Type tag column
    • Object id column
    • Columns for each root table column
  • N physical delta tables (one per subtable) with:
    • Object id column
    • Columns for each column introduced by this subtable

Implementing Table Hierarchies

Previous slide

Next slide

Back to first slide

View graphic version