Talk:Database preservation

Wiki Education Foundation-supported course assignment

This article was the subject of a Wiki Education Foundation-supported course assignment, between 2 September 2021 and 20 December 2021. Further details are available on the course page. Student editor(s): Mbruce21. Peer reviewers: Flanagan Institute Applicant, Gs4446, Lady Halfwolf.

Above undated message substituted from Template:Dashboard.wikiedu.org assignment by PrimeBOT (talk) 19:04, 16 January 2022 (UTC)

Some questions

This article raises a few obvious issues:

• Why is Database preservation different to Digital preservation?

One's obviously broader scope than the other, but what is there that's specifically related to the problems of a database?

• What is our definition of a "database" rather than a "collection"?

Presumably this would include a "census data database", but it would not seem to include "a collection of sound recordings of birdsong" or especially not "a library of collected, but unrelated, documents".

• What are the issues related to database preservation?

Are these similar to those around ETL and the notions of Class / Property / Instance eqivalence (see Semantic translation)? Or are they something else? Something related to the bulk nature of the set, not just the individual records?

• Standards based solutions vs. ontologies

A model like NIEM defines and standardizes a property model for a database. While the standard is still current, databases using it remain accessible. An ontological approach doesn't impose any standard property model, but it does use some ability to express the model in use (as a per-database description, or even per-entity) in a descriptive manner that sets the database properties within some broader-defined and long-lived concepts that might be expected to last for longer.

Andy Dingley (talk) 13:41, 1 July 2009 (UTC)

Bibliography of Potential Sources

Hi everyone!

I have created a bibliography of potential sources which can be utilized to enhance this article as well as add content regarding the topic. I would love any feedback about these sources and their viability as well as any suggestions of sources that I may not have come across and included. Here is the the link to my bibliography sandbox. And I will go ahead and paste the sources below as well for quick reference...

Abrams, B.L. (2016, December 6-8). NARA & SIARD 2 [presentation]. E-ARK Final Conference, Budapest, Hungary. https://www.eark-project.com/resources/conference-presentations/finconfpres/73-day-1-5an-external-evaluation-of-e-ark/05-E-Ark%20Final%20Conference%20-%20External%20evaluation%20by%20NARA.pdf#%3b%20filenam

Ashley, K. (2004). The preservation of databases: Very informal newsletter on library automation. Vine, 34(2), 66-70. https://doi.org/10.1108/03055720410551075

Brandl, S., & Keller-Marxer, P. (2007, March 23). Long-term archiving of relational databases with Chronos [Paper presentation]. First International Workshop on Database Preservation (PresDB'07), Edinburgh, Scotland. https://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.459.5158&rep=rep1&type=pdf

Brogan, M., & Brown, J. (n.d.). Challenges in digital preservation: Relational databases. School of Computer and Information Science, Edith Cowan University. https://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.89.886&rep=rep1&type=pdf

Bruggisser, H., Büchler, G., Dubois, A., Kaiser, M., Kansy, L., Lischer, M., Röthlisberger-Jourdan, C., Thomas, H., & Voss, A. (2013). eCH-0165 SIARD format specification. eCH E Government Standards.https://www.ech.ch/en/dokument/902c4ecb-70e8-49f7-943f-b63aaca1aac5

Bruggisser, H., Büchler, G., Dubois, A., Kaiser, M., Kansy, L., Lischer, M., Röthlisberger-Jourdan, C., Thomas, H., & Voss, A. (2015). eCH-0165 SIARD format specification 2.0 (draft). eCH E Government Standards. https://www.eark-project.com/resources/specificationdocs/32-specification-for-siard-format-v20/STAN_e_FINAL_2015-07-04_eCH-0165_V2%200_SIARD-Format.pdf

Christophides, V., & Buneman, P. (2007, September). Report on the First International Workshop on Database Preservation (PresDB'07). ACM SIGMOD Record 36(3), 55-58. https://doi.org/10.1145/1324185.1324197

Digital Preservation Testbed. (2003). From digital volatility to digital permanence: Preserving databases. ICTU Foundation. https://docs.google.com/a/datanetworkservice.nl/viewer?a=v&pid=sites&srcid=ZGF0YW5ldHdvcmtzZXJ2aWNlLm5sfG1peGVkfGd4OjMzN2IyZTJjMTZlZmM3MTU

Freitas, R., & Ramalho, J.C. (2021). Relational databases digital preservation. University of Minho. https://www.researchgate.net/publication/239928984_Relational_Databases_Digital_Preservation

Lindley, A. (2013, September 3-5). Database preservation evaluation report - SIARD vs. CHRONOS: Preserving complex structures as databases through a record centric approach? [Paper presentation]. iPRES 2013 - 10th International Conference on Preservation of Digital Objects, Lisbon, Portugal. https://doi.org/10.13140/2.1.3272.8005

Lux, Z., Szatucsek, Z., Mezei, J., Makovi, Z., & Kovacs, C. (2016, December, 6-8). Preserving relational databases - Hungarian use case [presentation]. E-ARK Final Conference, Budapest, Hungary. https://www.eark-project.com/resources/conference-presentations/finconfpres/81-day-2-4-using-e-ark-to-preserve-relational-d/13.%20E-Ark%20Hungary%20Use%20Case.pdf#%3b%20filename_%3dUTF-8%27%2713.%2520E-Ark%252

Mullins, C.S. (2007). The buffer pool: Regulatory compliance and database archiving. IDUG Solutions Journal 14(2). http://www.craigsmullins.com/bp15.htm

Ohnesorge, K., Merinat, T., & Buchler, M. (2015, October 14-15). The benefits of database preservation using SIARD Format Version 2.0 [presentation]. DLM Member Meeting, Luxembourg. https://www.eark-project.com/resources/conference-presentations/dlm-oct15/37-siard2eark-1/03_Database_Preservation_using_SIARD2.pdf

Ohnesorge, K.W. (2016, December 6-8). SIARD - The Swiss solution for archiving relational databases [presentation]. E-ARK Final Conference, Budapest, Hungary. https://www.eark-project.com/resources/conference-presentations/finconfpres/82-day-2-5-the-use-of-siard-in-e-ark/14.%20SIARD%20(CH).pdf#%3b%20filename_%3dUTF-8%27%2714.%2520SIARD%2520%2528CH%2529.pdf

Pereira Freitas, R.A., Ramalho, & J.C. (2010, August 31). Significant properties in the preservation of relational databases. Department of Informatics, University of Minho.https://core.ac.uk/display/55614406?utm_source=pdf&utm_medium=banner&utm_campaign=pdf-decoration-v1

Rahman, A.U., David, G., & Ribeiro, C. (2011, November 1-4). Transformation rules for model migration in relational database preservation [Paper presentation]. iPRES 2011 - 8th International Conference on Preservation of Digital Objects, Singapore. https://phaidra.univie.ac.at/view/o:294268

Ramalho, J.C., Faria, L., Helder, S., & Coutada, M. (2013, December 31). Database Preservation Toolkit: A flexible tool to normalize and give access to databases. University of Minho. https://core.ac.uk/display/55635702?source=1&algorithmId=15&similarToDoc=55614406&similarToDocKey=CORE&recSetID=f3ffea4d-1504-45e9-bfd6-a0495f5c8f9c&position=2&recommendation_type=same_repo&otherRecs=55614407,55635702,55607961,55613627,2255664

Ribeiro, C., & David, G. (2009, March 11). Database preservation. Digital Preservation Europe. https://digitalpreservationeurope.eu/publications/briefs/database_preservation_ribiero_david.pdf

van Essen, M., de Rooij, M., Roberts, B., & van den Dobbelsteen, M. (2011, July 12). Database preservation case study: Review. National Archives of the Netherlands. https://openpreservation.org/system/files/Database%20archiving%20review.pdf

Wollard, M. (2015, February 19). Why preserving databases matters and why it is harder than it sounds [presentation]. DPC / E-ARK Data Warehouse Workshop, Portsmouth, England. https://www.eark-project.com/resources/conference-presentations/dpc-eark-event/25-dpcwoollarddatabases/Woollard-UKDS.pdf

Thanks for any feedback!--Mbruce21 (talk) 13:02, 8 October 2021 (UTC)