IMAGE/PHOTO Performance:Oracle/Informix/Sybase/SQLSvr/DB2
Dear Database Gurus: I am evaluating how best to store images and photographs in an RDBMS, possibly as a BLOB or as a FILE. What in your experience is the database of choice given either DB2, INFORMIX, SYBASE, ORACLE and SQLSERVER ? In performance terms, does anyone have any independent reports to quote from with regards to database performance for images and photos storage/retrieval. Can you cite what the best performing databases for image storage/retrieval ? Your comments are fully appreciated. Please email me if possible. Thanks, PP
Ok! MS SQL and Sybase have good perfomance on blobs... But many trouble on backup/restore database with blobs. By default blob operation is _not logged_. There are fast because don't save blos in log. And have size limit - 2M. Oracle - 4M Sorry for my bad english. Mike PP wrote in message <36CC3B51.4821@hp.com>... >Dear Database Gurus: > >I am evaluating how best to store images and photographs in an >RDBMS, possibly as a BLOB or as a FILE. What in your experience >is the database of choice given either DB2, INFORMIX, SYBASE, >ORACLE and SQLSERVER ? > >In performance terms, does anyone have any independent reports >to quote from with regards to database performance for images >and photos storage/retrieval. Can you cite what the best performing >databases for image storage/retrieval ? > >Your comments are fully appreciated. Please email me if possible. >Thanks, > >PP
PP wrote in message <36CC3B51.4821@hp.com>... >Dear Database Gurus: > >I am evaluating how best to store images and photographs in an >RDBMS, possibly as a BLOB or as a FILE. What in your experience >is the database of choice given either DB2, INFORMIX, SYBASE, >ORACLE and SQLSERVER ? Other have talked about Oracle/Sybase/SQL Server, so a few words about DB2. - Yes, you can store pictures (or any data) in BLOBs - Each BLOB can be pretty large (gigabyte or more), but I doubt you are going to have BLOBs that large for each picture - You have an option to enable logging of BLOBs, so that the database integrity is preserved (backup and recovery) However IBM's DB2 database is pretty unique by it's support for DATALINKS (a new datatype in DB2 UDB V5.2) and accompanying product called "DB2 File Manager". (DB2 File Manager is currently available on AIX, but you can use the DATALINKS datatype on any supported platform). In essence, DB2 File Manager lets you have your cake and eat it too -- you can leave your pictures as files outside the database, and yet have the DB2 database maintain complete integrity control (authorization for access, backup, and recovery processing). You can find a White Paper on DataLinks here: http://www.software.ibm.com/data/pubs/papers/datalink.html You can also look in the DB2 Technical library on the web for information on the "datalinks" datatype in DB2 V5.2 manuals. Gene Kligerman
Informix Dynamic Server with Univeral Data Option allows for Blobs that are logged or unlogged as well. It also supports methods to access files on the disk, albiet through a different mechanism than DataLinks. The DB2 DataLink implementation is easier to use, but the functionality you can get from either is more or less equivelent. Frank Gene Kligerman wrote in message <7al1pp$13v2$1@tornews.torolab.ibm.com>... > >PP wrote in message <36CC3B51.4821@hp.com>... >>Dear Database Gurus: >> >>I am evaluating how best to store images and photographs in an >>RDBMS, possibly as a BLOB or as a FILE. What in your experience >>is the database of choice given either DB2, INFORMIX, SYBASE, >>ORACLE and SQLSERVER ? > > >Other have talked about Oracle/Sybase/SQL Server, so a few words about DB2. > >- Yes, you can store pictures (or any data) in BLOBs >- Each BLOB can be pretty large (gigabyte or more), but I doubt you are >going to have BLOBs that large for each picture >- You have an option to enable logging of BLOBs, so that the database >integrity is preserved (backup and recovery) > >However IBM's DB2 database is pretty unique by it's support for DATALINKS (a >new datatype in DB2 UDB V5.2) and accompanying product called "DB2 File >Manager". (DB2 File Manager is currently available on AIX, but you can use >the DATALINKS datatype on any supported platform). > >In essence, DB2 File Manager lets you have your cake and eat it too -- you >can leave your pictures as files outside the database, and yet have the DB2 >database maintain complete integrity control (authorization for access, >backup, and recovery processing). > >You can find a White Paper on DataLinks here: >http://www.software.ibm.com/data/pubs/papers/datalink.html > >You can also look in the DB2 Technical library on the web for information on >the "datalinks" datatype in DB2 V5.2 manuals. > >Gene Kligerman > > >
Informix will do this too. And isn't this a capability that Oracle 8i is supposed to offer? Seth Gene Kligerman wrote: > However IBM's DB2 database is pretty unique by it's support for DATALINKS (a > new datatype in DB2 UDB V5.2) and accompanying product called "DB2 File > Manager". (DB2 File Manager is currently available on AIX, but you can use > the DATALINKS datatype on any supported platform). > > In essence, DB2 File Manager lets you have your cake and eat it too -- you > can leave your pictures as files outside the database, and yet have the DB2 > database maintain complete integrity control (authorization for access, > backup, and recovery processing). > > You can find a White Paper on DataLinks here: > http://www.software.ibm.com/data/pubs/papers/datalink.html > > You can also look in the DB2 Technical library on the web for information on > the "datalinks" datatype in DB2 V5.2 manuals. > > Gene Kligerman -- Seth Grimes Alta Plana database & Web / design & development grimes@altaplana.com http://altaplana.com 301-891-2581