Hi Jon,


Am 21.09.2009 um 17:39 schrieb Jon Richfield:

Hi Keith


I take your point, but I reckon that with a bit of definition of canonical fields and formats one should be able to clean the lot up with the exception of cases where previous manual record entry had violated sensible rules. Most of the problems could be cleaned up automatically, and only the horrible examples (basically errors) need get special manual treatment. Trying to construct special rules for your data base to negotiate, would fall foul of the ingenuity of fools.

Whether you really need a "formal data base" or not is an open question. Some direct access to properly sorted and indexed files can be startlingly effective.
Basically, I was not saying we need a "formal database" or system. The fact is information in the files basically constitute
a database, albeit the information is structured. As I mentioned due to restrisction defined for the metadata the desired
features are not possible in the present form and could be easily overcome.

regards
Keith.