Re: FN-FORUM: Strategy for image and data storage

date posted 10th August 2004 18:51

At 19:24 on Tuesday, 10 Aug 2004, Paul Evans wrote:

>
>> an image can be "described" more than once.
>
>> (might get huge, unless I have a search facility)
>
> isn't the purpose of the description, to have some means of searching
> and finding the object?
>
>> image can be "described" more than once.
>
> This i understand
>
>> This means I think I need to offer the choice between files already
>> uploaded and upload a new file.
>
> This I don't understand?
>
>> any one got any views?
>
> the approach I'd take is to...
>
> 1. require keywords/description to be included in any object upload
> 2. Get a search working, to find objects based on keywords or part of
> the description. - or just present the sequential list
> 3. Provide an edit mechanism to allow you to add/edit
> descriptions/keywords for a selected image
>
> Admin -> Display a table [UID: Image : Keywords : Description] of the
> search results - paginate if there are loads. User never needs to see
> the temp filename - means nothing. User clicks an image to edit it and
> all its associated data records?
>
> Edit either on second screen, or if using ASP.NET - set up edit handlers
> on the data-grid.
>
> I guess it depends how well structured the cms is?


probably not explaining it very well.

The user has a collection of digital images. he's entering them into the
database. he creates a record (categories, keywords, desc etc) for image
A (man on horse) uploads it - thumbnails and websized images are created
(filenames created unique to the record and stored in the record). He
then wants to add another unique record for the same image, this time its
the horse that's interesting, rather than the man.

e.g Wellington riding his horse is record one. Arthur, Wellington's black
horse is record 2

am I going to make him upload the image twice? or does he have to search
through the entire collection of images (might be thousands) to find the
one he uploaded yesterday.

I think I'm answering my own question.

if he wants to re-use an image, he knows which one it is - it's on his
disk, with his filename convention and he can view it before uploading...
I'll make him upload it again....


;o)


The wonderful power of writing to crystallise thought, never ceases to
amaze me.

Cheers

Tony