Re(2): images in databases
Re(2): images in databases
- Subject: Re(2): images in databases
- From: "Robert Snyder" <email@hidden>
- Date: Sat, 26 Feb 2005 16:15:29 -0500
- Organization: Penn State World Campus
On Sun, Feb 27, 2005, LD wrote:
>The question is: Of what relational significance is any 'single' field
>of data? Unless it has an associated meaning it is not relational but
>singular (and without meaning).
>
>Take Key Value coding as an example. Are the keys meaningful without
>associated values or values meaningful without associated keys? No. But
>together they form a whole. The BLOB may not be index-able, but an
>associated string & foreign key can.
>
>More to the point, relationships are defined by two or more of any
>subtype of Object, no? Therefore, BLOB's can't be excluded from best
>practices of db storage on this basis (seeing as the theory doesn't
>seem to hold true) - but possibly because of other reasons as b.bum
>points out.
>
How is the relationship between the image and an "associated string &
foreign key" improved by using a blob over a file system path entry that
points to the image? Data bases are good for storing and recovering data,
file systems and file servers, Apache included, are good at storing and
serving files.
I think it really comes down to using the best tool for the job. And I
cannot see where putting an image in a database gets you any benefit--or
conversely any reduction in the efficiency of the data model--over a file
system pointer to an image. But I can see a lot more efficiency in using
a file system and file server for the task of actually serving the file.
____________________________________________
Robert Snyder, Director
World Campus Data Management Services
The Pennsylvania State University
105 Mitchell Building
University Park PA 16802
Phone: 814-865-0912 Fax: 814-865-4406
E-mail: email@hidden
URL: http://www.worldcampus.psu.edu
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden