tags:

views:

55

answers:

1
+1  Q: 

Storing Documents and associating Metadata

This question is somewhat related to this.

I want to have document storage along with some complex metadata. I am not using sharepoint. I have a very simple directory structure that goes 2 levels deep. (One folder and documents underneath). I want to store metadata associated with each file....tags, popularity (# of times accessed), creator name, etc...

What is the best way to achieve this? I am leaning towards the relational database with the link to the file but I have to think this problem has been solved before.

+1  A: 

Your approach sounds just fine to me. Just store the folder and filename as one of the columns values and all the other metadata in other columns.

Do you have any concerns about this approach? Or perhaps a specific part of this approach that you're not sure of how to implement?

Eilon  2010-02-12 03:26:48
My main concern is updating the database if a file moves. When a document is uploaded, updating the database is fine, but since the database is completely separate from the file, keeping the two in sync seems to be the tricky part.
Holograham  2010-02-12 15:18:38

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL