Hi, The blob structure is a generic structure and not heavily used. For images and videos I would opt for managing the references in the database only and keep the multimedia objects in a separate vault (accessible through http server) Introducing a separate type becomes relevant if you also intend to manipulate the values with specialized routines inside the kernel. For example, you load the actual images into a BAT and plan to perform relational operations over the pixels, or proprietary segmentation routines.... regards, Martin Bharani wrote:
Hi,
I am thinking of storing images and video files in monetdb. I have come across user defined types like url. Is it worth defining custom types for images and video files or can i just use blob instead. I know the types come in handy from the usage point of view but from the storage and performance does it matter to monetdb? Note: The system will store them and retrieve based on unique ids
Thanks Bharani