What you may want to do is create a new namespace to store a couple key properties with your file's metadata, and have the properties be primary keys into a database that has all the non-document-related information (if the person changed their name, history tracker, etc).
This does add another 'application' to the project, but this may help keep it clean and separate the concerns between 'storing a document and metadata' versus 'external needed information'. Hope that helps! -D > -----Original Message----- > From: Lixin Chu [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 07, 2006 5:21 PM > To: Slide Users Mailing List > Subject: Re: common practice of managing metadata with Slide > > I am keen to see if Slide could manage everything for me. > Keeping folder and file metadata info in a DB is unnecessary. > > However, my concern arises when I think it again: > > You don't necessarily have to keep it in an external place. > Ideally yes. However, we typically need to keep a lot more > info with the user. For example, in the application I am > doing, we also need to keep user's org, dept, role, projects, > etc. Slide is ok to handle any type of data, but I am not > sure if it is a good idea to let Slide provide DB features, > such as indexing, sorting, etc. > > > And also, customer is asking more and more doc management > features, one example is doc tracking - users can track the > doc and get notification when there is any changes. So now I > need to maintaine the doc-tracker many-to-many relationship. > Is it also ok to let Slide keep this information or better > keep it in a DB ? > > That's why I was thinking if I should keep metadata in a DB > and let Slide handle these: > - file repository > - lock/unlock > - versioning and > - full text search > > the rest will be handled by DB. but it is just not a clean > solution. still doing more investigation .... > > thanks ! > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
