PPT Slide
- To define and use a "white box ADT", a user will
- Describe its internal structure using SQL3 DDL
- Attribute definitions are column-like
- Advantages: heterogeneity, nulls, nesting, constraints, ...
- Implement its functions either directly in SQL or in his/her favorite external programming language
- Utilize system-generated accessors and mutators
- Finish explaining the type to the DBMS using DDL
- For query optimizer, as before
- Use the new type like a built-in data type
- In tables and queries, as before
- Note: this is just a SQL3 structured type definition that's primarily intended for use in columns