Talk:Database preservation
![]() | This article is rated C-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | |||||||||||||||||||||||||||||||||||||||||
|
Wiki Education Foundation-supported course assignment
editThis 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
editThis 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.
Bibliography of Potential Sources
editHi 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)