Preservation of databases is a complex task that has no evident and straightforward solutions available. At Mikkeli UAS we are researching and evaluating a preservation model called “Normalized Object Model”.We create the Object Model by extracting to an object the structure and metadata of the structure as well as the content and content metadata from databases at preservation. The Normalized Object Model reduces the complexity of the original database by preserving the structure as metadata. The Normalized Object Model relieves maintenance of preserved databases from knowledge on the original structure of them and resists technical quality problems at ingest.We achieve Normalization by creating one single object structure to contain all database structure elements and one single property structure to contain database content elements. Normalization makes it possible to query several preserved databases simultaneously regardless of structure.A library of object and property types shall be established to create rules for and assist at planning and designing future, standardized database structures.
Mårten Stenius, Citrus Oy, Osmo Palonen, "Preservation of databases – Normalized object model" in Proc. IS&T Archiving 2008, 2008, pp 47 - 49, https://doi.org/10.2352/issn.2168-3204.2008.5.1.art00010