Refactoring Databases - Evolutionary Database Design

Replace LOB With Table

Replace a large object (LOB) column which contains structured data with a new table or in the same table. LOBs are typically stored as either a binary large object (BLOB), a variable character (VARCHAR), or in some cases as XML data.



Example

Replace LOB With Table Example

For more information see page 120 of Database Refactoring