PPT Slide
Of Extenders, Blades, and Cartridges
- High performance demands "deep" integration
- Optimizer must know about an ADT operator's...
- Execution cost (especially for expensive functions)
- Logical properties (e.g., transitivity, negator, ...)
- Selectivity estimates (i.e., filtering/matching power)
- Relationship to access methods (both old and new)
- DBMS runtime must invoke functions efficiently
- Static vs. dynamic loading, fenced vs. unfenced execution
- Partnerships and third-party packages
- E.g., DB2's text, image, and spatial extenders
- Package contains types, functions, access methods, optimizer information, and SQL DDL statements for all of the above