Comment DAM and Extensis Portfolio + Filemaker (Score 1) 438
Back in the 90's I helped create a media department for large textbook publisher. One of the first projects was an asset library and tracking system.
To this message brief.
We first needed a naming convention. Look for a constant throughout your products, ours was ISBN numbers. That became the main identity of the product/project and their main digital folder. Every item or product was dropped in a sub folder such as images, design, text, etc. From here the main folders were always scanned by Portfolio and it was told/programmed that the main descriptions should come from the folder names. This allowed anyone with knowledge of the product ISBN to find details on the project. It also greatly minimized keyboarding of metadata onto the files needlessly.
Portfolio then will allow check in and check out (versioning) to stay abreast of any edits or updates.
The whole metadata catalog would also be exported and brought into Filemaker for secondary backup.
Look to a constant for naming convention, keep it simple, look at ways to minimize keyboarding metadata, go over the counter (they are much easier to work with and you can experiment-they are also more than capable of handling 100K documents).
Last. Good luck and if needed look for help.