Endre søk
RefereraExporteraLink to record
Permanent link

Direct link
Referera
Referensformat
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annet format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annet språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf
Automated Culling of Data in a Relational Database for Archiving
Blekinge Tekniska Högskola, Fakulteten för datavetenskaper, Institutionen för programvaruteknik.
2019 (engelsk)Independent thesis Advanced level (professional degree), 20 poäng / 30 hpOppgave
Abstract [en]

Background. Archiving of legacy information systems is challenging. When no options exist for extracting the information in a structured way, the last resort is to save the database. Optimally only the information that is relevant should be saved and the rest of the information could be removed.

Objectives. The goal is to develop a method for assisting the archivist in the process of culling a database before archiving. The method should be described as rules defining how the tables can be identified.Methods. To get an overview of how the process works today and what archivists think can be improved, a number of interviews with experts in database archiving is done. The results from the interviews are then analysed, together with test databases to define rules that can be used in a general case. The rules are then implemented in a prototype that is tested and evaluated to verify if the method works.

Results. The results point to the algorithm being both faster and able to exclude more irrelevant tables than a person could do with the manual method. An algorithm for finding candidate keys has also been improved to decrease the number of tests and execution time in the worst case.

Conclusions. The evaluation shows results that point to the method working as intended while resulting in less work for the archivist. More work should be done on this method to improve it further.

sted, utgiver, år, opplag, sider
2019. , s. 46
Emneord [en]
digital preservation, Information Systems, legacy systems, database reverse engineering
HSV kategori
Identifikatorer
URN: urn:nbn:se:bth-18261OAI: oai:DiVA.org:bth-18261DiVA, id: diva2:1332882
Eksternt samarbeid
Sydarkivera
Fag / kurs
Degree Project in Master of Science in Engineering 30,0 hp
Utdanningsprogram
PAACI Master of Science in Game and Software Engineering
Presentation
2019-06-05, 11:00 (engelsk)
Veileder
Examiner
Tilgjengelig fra: 2019-08-19 Laget: 2019-06-28 Sist oppdatert: 2022-05-12bibliografisk kontrollert

Open Access i DiVA

fulltext(795 kB)720 nedlastinger
Filinformasjon
Fil FULLTEXT01.pdfFilstørrelse 795 kBChecksum SHA-512
f069b5db1c7d5124f5f203c6f1662d017ca883f873cff3ea0bcd57a1f8bade7fed238bf30b85925426ae05a0ae92bd43d6f0604767e45ef31d78269bd82c61d3
Type fulltextMimetype application/pdf

Av organisasjonen

Søk utenfor DiVA

GoogleGoogle Scholar
Totalt: 720 nedlastinger
Antall nedlastinger er summen av alle nedlastinger av alle fulltekster. Det kan for eksempel være tidligere versjoner som er ikke lenger tilgjengelige

urn-nbn

Altmetric

urn-nbn
Totalt: 713 treff
RefereraExporteraLink to record
Permanent link

Direct link
Referera
Referensformat
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Annet format
Fler format
Språk
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Annet språk
Fler språk
Utmatningsformat
  • html
  • text
  • asciidoc
  • rtf