Skip to content

Data Integration Using Online Linked Database Architecture for Database Formats

Organized, structured information, accessible and modifiable through a database management system, is the essence of databases. This structured information is purposefully arranged and stored for manipulation, search, and extraction. The key attributes of database records are outlined in the...

Open Data Connected for Data Structures
Open Data Connected for Data Structures

Data Integration Using Online Linked Database Architecture for Database Formats

In an ongoing effort to preserve digital records for future generations, the National Archives and Records Administration (NARA) has expanded its Digital Preservation Framework to include several database formats as Linked Open Data (LOD).

Three versions of Btrieve, a popular database management system, have been added to the framework. Btrieve 6.1, 6.0, and 5.1, each using the file extension .btr, have been categorised as databases. Their NARA Format IDs are NF00542, NF00541, and NF00137, respectively, and their NARA Linked Open Data TTLs are available at specific URLs (links provided below).

Another database format included is dBase, which is used by various software applications such as Paradox, Oracle, dBASE IV, dbvista, dBFast, XTreeGold, and XoftSpySE. The .db file extension is associated with this format, and its NARA Format ID is NF00152. The NARA Linked Open Data TTL for dBase is also available at a specific URL (link provided below).

Additionally, the AutoCAD component dbConnect Template Set uses the .dbt file extension and falls under the Digital Design and Vector Graphics category. Its NARA Format ID is NF00126, and its NARA Linked Open Data TTL is available at a specific URL (link provided below).

Two specific database formats associated with dBase are also part of the framework. The dBase or FoxBASE+Text Memo uses the .dbt file extension and is categorised as a database. Its NARA Format ID is NF00155, and its NARA Linked Open Data TTL is available at a specific URL (link provided below). The dBase Table for Windows 5 uses the .dbf file extension and is categorised as a database. Its NARA Format ID is NF00551, and its NARA Linked Open Data TTL is available at a specific URL (link provided below).

Lastly, the dBase Index File uses the .ndx file extension and falls under the Index category. Its NARA Format ID is NF00154, and its NARA Linked Open Data TTL is available at a specific URL (link provided below).

Another database format included is BSON, which is used by MongoDB. Its file extension is .bson, and its NARA Format ID is NF00594. Its NARA Linked Open Data TTL is available at a specific URL (link provided below).

While specific details about the database formats included in the NARA Digital Preservation Framework as Linked Open Data could not be found in the search results, it is generally known that NARA works with a variety of archival and records database formats, including metadata schemas such as Dublin Core, EAD (Encoded Archival Description), METS (Metadata Encoding and Transmission Standard), PREMIS (Preservation Metadata), and standard archival data formats. For Linked Open Data, archival institutions frequently publish metadata in RDF (Resource Description Framework) formats using ontologies that describe archival collections, administrative metadata, and preservation details.

To obtain a precise list of specific database formats as Linked Open Data for NARA's Digital Preservation Framework, one would need to consult NARA's official technical documentation or digital strategy publications, which would specify the file formats, databases, and RDF vocabularies or ontologies used in their Digital Preservation Framework as Linked Open Data.

Links: - Btrieve 6.1: NF00542.ttl - Btrieve 6.0: NF00541.ttl - Btrieve 5.1: NF00137.ttl - db file: NF00152.ttl - AutoCAD component dbConnect Template Set: NF00126.ttl - dBase or FoxBASE+Text Memo: NF00155.ttl - dBase Table for Windows 5: NF00551.ttl - dBase Index File: NF00154.ttl - BSON: NF00594.ttl

This expansion of the Digital Preservation Framework will help to ensure the long-term preservation and accessibility of these important digital records.

Data-and-cloud-computing technology greatly aids the National Archives and Records Administration (NARA) where it facilitates the expansion of their Digital Preservation Framework, allowing for various database formats to be included as Linked Open Data (LOD). Among these formats are Btrieve, dBase, AutoCAD, BSON, and others, each featuring specific file extensions and NARA Format IDs, with their corresponding NARA Linked Open Data TTLs available online for access.

Read also:

    Latest