Digital Symposium Collection 2000

Optimizer and Parallel Engine Extensions for Handling Expensive Methods Based on Large Objects W. O'Connell, F. Carino,, and G. Linderman   View Paper (PDF)   Return to Industry Session 3: Commercial Advance in QP and Access Methods Abstract Object-Relational database systems allow users to define new user-defined types and functions. This typing extension allows structural semantics to be applied to new data types (non-SQL92 data types). However, defining new large complex objects within a tuple is not always practical. Practicality alone requires that large object data structures be used. This implies that predicate evaluation can be performed on tuple columns that are physically stored outside of a tuple's physical record. This out-of-line storage mechanism is commonly used today for column values that are physically large (implemented with a large object descriptor in the tuple pointing to a large object data structure). This type of predicate-based evaluation presents new optimizer and run-time challenges to the database system on clustered and MPP shared-nothing architectures. Copyright(C) 2000 ACM