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 > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
