PPT Slide
Reference values in tables should have a scope
- "Other end" info for query rewrite and join optimization
- Ditto for authorization checking (static vs. dynamic)
- Schema makes overly wide references unnecessary
- Uniqueness is hierarchy-relative, enforced with an index
V5.2 self-references (object ids) are user-generated
- CAD/CAM vendor had "legacy references" in files
- Different users have different id generation schemes
- Loading cyclic data (e.g., emp<-> dept) is messy and slow
- Ditto for creating objects from an object cache
References and Path Expressions