[prev] 64 [next]

Similarity-based Retrieval

Database contains media objects, but also tuples, e.g.
  • id to uniquely identify object   (e.g. PostgreSQL oid)
  • metadata   (e.g. artist, title, genre, date taken, ...)
  • value of object itself   (e.g. PostgreSQL BLOB or bytea)


BLOB = Binary Large OBject

  • BLOB stored in separate file; tuple contains reference (cf. TOAST)
  • BLOBs are typically MB in size (1MB..2GB)