Hi Bharani, Acoi uses the same approach it stores the location of the multimedia files it found, and it makes use of the url data type for this. At this moment, and probably never as Acoi isn't actively develop anymore, it doesn't maintain a cache of encountered multimedia files. Regards, Menzo Bharani wrote:
Thanks Martin
That is exactly what we are doing at the moment. We store images and video files on various servers and just maintain the url to it in the database.I thought maintaining them in one place will be a better thingh to do( may be not!). One of the problems is having to deal with different logic to derive the path to the actual file on the server. Although the logic is really simple it is error prone becos of the number of systems involved.
Came across ACOI , any idea how they store them?
Thanks Bharani
Martin Kersten wrote:
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
-- Menzo Windhouwer, Theoretische Taalwetenschap (UvA) kamer 306, Spuistraat 210 (Bungehuis) 1012 VT A'dam telefoon:020 525 3104, e-mail:M.A.Windhouwer@uva.nl