Refactoring Databases - Evolutionary Database Design
Last updated: June 04 2008.
Hosted By: ThoughtWorks

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


Unless otherwise noted, all material on this site is copyright Pramod Sadalage.
Please link freely to this site, but if you want to copy any of the materials you should contact the relevant copyright holders first.
Send feedback to Pramod Sadalage

Site design credit Narayan Raman