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.

PreviousLarge valueNextSystem catalogs

Last updated