June 2023 - Webinar
Learn about SIARD’s large object handling (LOB, BLOB) capabilities in the third eArchiving Initiative training webinar.
The third eArchiving Initiative training webinar examines the large object (LOB) handling capabilities of SIARD (Software Independent Archiving of Relational Databases). Large objects are generally binary data in a database. Binary data is mainly referred to as a binary large object (BLOB), and large character-based data are named character large objects (CLOB). From version 2.0, the SIARD specification supports three possible archival scenarios for storing LOBs:
- Internal BLOBs – BLOBs contained in the database records
- External BLOBs – BLOBs stored outside the database records but within the SIARD file
- External BLOBs – BLOBs referenced from SIARD but stored as files outside the SIARD file
This tutorial is based on the use case of the SQL database archiving pilot by the Hungarian Digital Heritage National Laboratory and the Digital Humanities Department of Eötvös Loránd University, Budapest. Three research databases about XVIII–XIX century Hungarian novels, popular publications and literary correspondence have been preserved as SIARD files. The pilot uses several E-ARK/eArchiving specifications such as SIARD, E-ARK SIP, and CITS SIARD, as well as the Database Preservation Toolkit, RODA-in and RODA software components.
To download the slides of this webinar click here.