PPT Slide
Some guiding principles for DB2 UDB V5.2
- Performance must equal/exceed relational equivalents
- Design amenable to future plans w.r.t. type evolution
- Structured types must be supported in columns (someday)
- Localize initial changes to query compiler where possible
- Want "free" indexing, rewrites, optimization, parallelization, ...
Influenced by discussions with a CAD/CAM vendor
- Information on existing approach and installations
- Requirements for efficiency of new products
Let's look briefly at two areas
- Table hierarchy representation
- References and path query processing
O-R Implementation Issues/Tradeoffs