The First OAIS -c ompliant Ingest of Digital Records

1. The First OAIS-compliant Ingest of Digital Records Zoltán Lux The National Archives of Hungary Email: luxz@iif.hu web:www.mol.gov.hu DLM Forum, Budapest

2. The Task • Transfer of data (ingest)fromthe BÜR system (datasystemscoveringpersonsaccused of orchargedwithcrimes). • Preparation of a format for long-term storage. • Development of a suitablestructure. • Preparation of a format for utilization and searchable. • Doingallthiscompatiblewith OAIS. • Making SIP, AIP and DIP packages. • Installation of frame systems at the Hungarian National Archives and the Budapest City Archives.Ensuringthatfurtherdatacan be incorporatedasrequired. DLM Forum, Budapest

3. The OAIS Model DLM Forum, Budapest

4. Database of the Hungarian Prosecution Service • DOS-based application, dBASE IV files and user program in Clipper 5 and withthedevelopment of itby the Chief Prosecutor’s Office. • How digital storage suitable for long-term archiving and usecan be produced from this. • Results of the BÜR I. project(datasystemscoveringpersonsaccused of orchargedwithcrimes): • Selection of the SIARD format and planning for the upcomingSIARD SUITE application for relational databases (MSSQL, Oracle, MS Access). • Preparation of submission specifications. • Creating a new/modifieddatamodel • Loadingdatainto an Oracle database • UsingtheSIARD SUITEtoconvertdataintothe SIARD format DLM Forum, Budapest

5. Submission specification DLM Forum, Budapest

6. Planning the ingest • Creating CSV files from dBase files. • Appropriate format and packaging of these for long-term preservation. • Adding document files. • Adding metadata in XML format. • Appropriate structure. • Packing in ZIP format: SIP and/or AIP. • Making a searchable DIP. DLM Forum, Budapest

7. Implementation I • Submission specification. • Submission of the CSV data files along with special information on the data, other documents on software functionality, and some metadata. • Loading this information into an Oracle database • With an SQL program • Applying SIARD SUITE to the database and creating a SIARD package. • Creating an appropriate AIP by adding documents and metadata in specific and EAD XML format, all in an appropriate structure, and packaging them in a ZIP file. • Manually • Making an anonymous DIP by developing a web application with APEX. DLM Forum, Budapest

8. Implementation I DLM Forum, Budapest

9. Implementation II • Submission specification • Creating SIP packages. • With SIPka application software • Loading data into an Oracle database with the information on the data from the submission specifications. • With BÜRke application software • Applying SIARD SUITE to the database and creating a SIARD package. • With SIARD SUITE called up by BÜRke application software • Creating an AIP by adding documents, metadata in specific and EAD XML format, putting them into a structure, and zipping them. • With SIPka application software • Making an anonymous DIP with a devised APEX web application. DLM Forum, Budapest

10. Implementation II. DLM Forum, Budapest

11. Data for submission DLM Forum, Budapest

12. Creating an SIP DLM Forum, Budapest

13. Creating an SIP • Loading data into the Oracle database . • Assembly of various schemes in line with the task. Generating database schemes (META, STAGE, DW, SIARD, PUBLIC). • Preparing PL/SQL programs. • Loading data and journals, and preparing statistics. DLM Forum, Budapest

14. Applying the SIARD SUITE • Producing a SIARD package for preparing SIP and AIP with SIARD SUITE. DLM Forum, Budapest

15. Applying SIARD SUITE • Why we think SIARD FORMAT is appropriate for our task. • Well-designed database. • Tables and views. • A lot of data-connection information can be stored in the database, e. g. with foreign keys, check constraints, triggers etc. • Ability to store information about user program logic with their routines. • Ability to add comments to almost every database object. • These information vehicles can be transferred to the SIARD PACKAGE with other supplementaryinformation on the database and userprogram. • The format is package-independent. 12-13. May 2011 DLM Forum, Budapest 15

16. From SIP to AIP • Producing the AIP with an application software (BÜRke). • SIARD package, addicional documents, metadata information in XML format, appropriate structure, ZIP format. DLM Forum, Budapest

17. Producing the DIP • Web-based user interface developed with APEX. DLM Forum, Budapest

18. Producing the DIP DLM Forum, Budapest

19. Producing the DIP DLM Forum, Budapest

20. Outcomes • Completing the ingest process. • Making the DIP searchable. • Gaining experience with the SIARD SUITE, preparing the Hungarian version of it, and making some corrections to the software. • Developing the software tools for ingest and long-term preservation of further BÜR records. • Making the software tools applicable to other relational databases. • Gaining experience with archiving digital records. • Some further tasks and remaining problems. DLM Forum, Budapest

21. Thank you for your attention! DLM Forum, Budapest