Speaking of database models, would anyone be willing to share METS rdms
implementations or strategies.
My organization has an in-house CMS of sorts, but I've been looking at
making us METS interoperable. One possibility is to replace our highly
customized MSSQL2000 system with a native METS database. I've been tinkering
a little with an MSSQL db I built from the LoC's DAVRS prototype metadata
capture database spec (there is a diagram and a excel spreadsheet describing
the rev10 schema at: http://lcweb.loc.gov/rr/mopic/avprot/avlcdocs.html#md).
For the most part, it is faithful to the spec, though I did replace some of
the enumerated types with lookup tables.
Before I got too much deeper (or waste more time) I thought I'd check in
with the experts...
Cheers,
Geoff Froh
Technical Manager
Densho
1416 S. Jackson St.
Seattle, WA 98144
US
(v) 206.320.0095
(f) 206.320.0098
(w) www.densho.org
|