External value storage

Some system allow you to store a really large value in an external file.

Treated as a BLOB (binary large object) type

• Oracle: BFILE data type

• Microsoft: FILESTREAM datatype

The DBMS cannot manipulate the contents of external file

• No durability protections.

• No transaction protections.