Linked Open Data for Database Formats

Databases are structured information that is accessed and updated through a database management system that has been organized, structured, and stored so that it can be manipulated, searched, and extracted for various purposes.

The significant properties of database records are documented in the Structured Data: Databases Preservation Plan, which can be used as test criteria for tools and processes used in format transformations.

NARA makes its Linked Open Data available in Resource Description Framework Terse RDF Triple Language or RDF Turtle (.ttl files). These files can be opened in any text editor. The Digital Preservation Framework as Linked Open Data includes the same elements as are available in the version of the Preservation Plans on GitHub.

These plans are not exhaustive nor universally applicable proposed actions and recommended or endorsed tools: these represent file formats and variant versions in NARA holdings, the current NARA risk assessment, processing capabilities, and tools in use at NARA.

Format Name	File Extension(s)	Digital Preservation Framework Category/Categories	NARA Format ID	NARA Linked Open Data TTL
AutoCAD component: dbConnect Template Set	dbt	Digital Design and Vector Graphics\|Databases	NF00126	https://www.archives.gov/files/lod/dpframework/id/NF00126.ttl
BSON	bson	Databases	NF00594	https://www.archives.gov/files/lod/dpframework/id/NF00594.ttl
Btrieve 5.1	btr	Databases	NF00137	https://www.archives.gov/files/lod/dpframework/id/NF00137.ttl
Btrieve 6.0	btr	Databases	NF00541	https://www.archives.gov/files/lod/dpframework/id/NF00541.ttl
Btrieve 6.1	btr	Databases	NF00542	https://www.archives.gov/files/lod/dpframework/id/NF00542.ttl
CouchDB	json	Databases	NF00550	https://www.archives.gov/files/lod/dpframework/id/NF00550.ttl
db file: Paradox; Oracle; dBASE IV; dbvista; dBFast; XTreeGold; XoftSpySE	db	Databases	NF00152	https://www.archives.gov/files/lod/dpframework/id/NF00152.ttl
dBase Index File	ndx\|mdx	Databases	NF00154	https://www.archives.gov/files/lod/dpframework/id/NF00154.ttl
dBASE or FoxBASE+Text Memo	dbt	Databases	NF00155	https://www.archives.gov/files/lod/dpframework/id/NF00155.ttl
dBase Table for Windows 5	dbf	Databases	NF00551	https://www.archives.gov/files/lod/dpframework/id/NF00551.ttl
dBase Table II	dbf\|db2	Databases	NF00153	https://www.archives.gov/files/lod/dpframework/id/NF00153.ttl
dBase Table III	dbf\|db3	Databases	NF00552	https://www.archives.gov/files/lod/dpframework/id/NF00552.ttl
dBase Table III+	dbf	Databases	NF00553	https://www.archives.gov/files/lod/dpframework/id/NF00553.ttl
dBase Table IV	dbf	Databases	NF00554	https://www.archives.gov/files/lod/dpframework/id/NF00554.ttl
dBase Table unspecified version	dbf	Databases	NF00784	https://www.archives.gov/files/lod/dpframework/id/NF00784.ttl
dBase Table V	dbf	Databases	NF00555	https://www.archives.gov/files/lod/dpframework/id/NF00555.ttl
Filemaker Pro 3.0	fp3\|fmp\|fp\|fm	Databases	NF00857	https://www.archives.gov/files/lod/dpframework/id/NF00857.ttl
Filemaker Pro 5.0	fp5\|fmp\|fp\|fm	Databases	NF00858	https://www.archives.gov/files/lod/dpframework/id/NF00858.ttl
FileMakerPro 7	fp7	Databases	NF00192	https://www.archives.gov/files/lod/dpframework/id/NF00192.ttl
FoxPro 2.0	dbf	Databases	NF00194	https://www.archives.gov/files/lod/dpframework/id/NF00194.ttl
FoxPro 2.5	dbf	Databases	NF00564	https://www.archives.gov/files/lod/dpframework/id/NF00564.ttl
FoxPro 2.6	dbf	Databases	NF00565	https://www.archives.gov/files/lod/dpframework/id/NF00565.ttl
FoxPro Memo	fpt	Databases	NF00275	https://www.archives.gov/files/lod/dpframework/id/NF00275.ttl
FoxPro Report	frx	Databases	NF00663	https://www.archives.gov/files/lod/dpframework/id/NF00663.ttl
Framework Database II	fw2\|fw	Databases	NF00197	https://www.archives.gov/files/lod/dpframework/id/NF00197.ttl
iCalendar	ics\|ical\|ifb\|icalendar	Databases\|Calendars	NF00209	https://www.archives.gov/files/lod/dpframework/id/NF00209.ttl
Lotus Approach 97 Database View File	apr	Databases	NF00234	https://www.archives.gov/files/lod/dpframework/id/NF00234.ttl
Lotus Approach Database View File	apt	Databases	NF00579	https://www.archives.gov/files/lod/dpframework/id/NF00579.ttl
Lotus Notes Database 2	nsf\|ns2	Databases	NF00237	https://www.archives.gov/files/lod/dpframework/id/NF00237.ttl
Lotus Notes Database 3	nsf\|ns3	Databases	NF00238	https://www.archives.gov/files/lod/dpframework/id/NF00238.ttl
Lotus Notes Database 4	nsf\|ns4	Databases	NF00239	https://www.archives.gov/files/lod/dpframework/id/NF00239.ttl
Lotus Notes Database unspecified version	nsf	Databases	NF00785	https://www.archives.gov/files/lod/dpframework/id/NF00785.ttl
MarkLogic	json\|rdf	Databases	NF00581	https://www.archives.gov/files/lod/dpframework/id/NF00581.ttl
Microsoft Access (.accdb) unspecified version	accdb	Databases	NF00835	https://www.archives.gov/files/lod/dpframework/id/NF00835.ttl
Microsoft Access (.mdb) unspecified version	mdb	Databases	NF00834	https://www.archives.gov/files/lod/dpframework/id/NF00834.ttl
Microsoft Access 2	mdb	Databases	NF00498	https://www.archives.gov/files/lod/dpframework/id/NF00498.ttl
Microsoft Access 2000	mdb	Databases	NF00253	https://www.archives.gov/files/lod/dpframework/id/NF00253.ttl
Microsoft Access 2002	mdb	Databases	NF00256	https://www.archives.gov/files/lod/dpframework/id/NF00256.ttl
Microsoft Access 2007	mdb\|accdb	Databases	NF00254	https://www.archives.gov/files/lod/dpframework/id/NF00254.ttl
Microsoft Access 2010	accdb	Databases	NF00494	https://www.archives.gov/files/lod/dpframework/id/NF00494.ttl
Microsoft Access 2013	accdb	Databases	NF00495	https://www.archives.gov/files/lod/dpframework/id/NF00495.ttl
Microsoft Access 2016	accdb	Databases	NF00496	https://www.archives.gov/files/lod/dpframework/id/NF00496.ttl
Microsoft Access 2019	accdb	Databases	NF00497	https://www.archives.gov/files/lod/dpframework/id/NF00497.ttl
Microsoft Access 95	mdb	Databases	NF00499	https://www.archives.gov/files/lod/dpframework/id/NF00499.ttl
Microsoft Access 97	mdb	Databases	NF00255	https://www.archives.gov/files/lod/dpframework/id/NF00255.ttl
Microsoft Schedule+ Contacts	scd	Databases\|Calendars	NF00404	https://www.archives.gov/files/lod/dpframework/id/NF00404.ttl
Microsoft Visual FoxPro database container	dbc\|dct\|dcx	Databases	NF00586	https://www.archives.gov/files/lod/dpframework/id/NF00586.ttl
Microsoft Works Database for DOS 1.05	wdb	Databases	NF00315	https://www.archives.gov/files/lod/dpframework/id/NF00315.ttl
Microsoft Works Database for DOS 1.12	wdb	Databases	NF00316	https://www.archives.gov/files/lod/dpframework/id/NF00316.ttl
Microsoft Works Database for DOS 2.0	wdb	Databases	NF00317	https://www.archives.gov/files/lod/dpframework/id/NF00317.ttl
Microsoft Works Database for DOS 3	wdb	Databases	NF00318	https://www.archives.gov/files/lod/dpframework/id/NF00318.ttl
Microsoft Works Database for DOS 3a	wdb	Databases	NF00319	https://www.archives.gov/files/lod/dpframework/id/NF00319.ttl
Microsoft Works Database for DOS 3b	wdb	Databases	NF00320	https://www.archives.gov/files/lod/dpframework/id/NF00320.ttl
Microsoft Works Database for Macintosh 3	wdb	Databases	NF00321	https://www.archives.gov/files/lod/dpframework/id/NF00321.ttl
Microsoft Works Database for Macintosh 4	wdb	Databases	NF00322	https://www.archives.gov/files/lod/dpframework/id/NF00322.ttl
Microsoft Works Database for Windows 2.0	wdb	Databases	NF00323	https://www.archives.gov/files/lod/dpframework/id/NF00323.ttl
Microsoft Works Database for Windows 2.0a	wdb	Databases	NF00324	https://www.archives.gov/files/lod/dpframework/id/NF00324.ttl
Microsoft Works Database for Windows 2000	wdb	Databases	NF00325	https://www.archives.gov/files/lod/dpframework/id/NF00325.ttl
Microsoft Works Database for Windows 3.0	wdb	Databases	NF00326	https://www.archives.gov/files/lod/dpframework/id/NF00326.ttl
Microsoft Works Database for Windows 3.0a	wdb	Databases	NF00327	https://www.archives.gov/files/lod/dpframework/id/NF00327.ttl
Microsoft Works Database for Windows 3.0b	wdb	Databases	NF00328	https://www.archives.gov/files/lod/dpframework/id/NF00328.ttl
Microsoft Works Database for Windows 4	wdb	Databases	NF00329	https://www.archives.gov/files/lod/dpframework/id/NF00329.ttl
Microsoft Works Database for Windows 4.0a	wdb	Databases	NF00330	https://www.archives.gov/files/lod/dpframework/id/NF00330.ttl
Microsoft Works Database for Windows 4.5	wdb	Databases	NF00331	https://www.archives.gov/files/lod/dpframework/id/NF00331.ttl
Microsoft Works Database for Windows 4.5a	wdb	Databases	NF00332	https://www.archives.gov/files/lod/dpframework/id/NF00332.ttl
MySQL Form Definition	frm	Databases	NF00340	https://www.archives.gov/files/lod/dpframework/id/NF00340.ttl
MySQL InnoDB Database	ibd	Databases	NF00598	https://www.archives.gov/files/lod/dpframework/id/NF00598.ttl
MySQL MyISAM Database	myd\|myi	Databases	NF00599	https://www.archives.gov/files/lod/dpframework/id/NF00599.ttl
SAS Data File	ssd	Databases	NF00399	https://www.archives.gov/files/lod/dpframework/id/NF00399.ttl
SAS for MS-DOS Database	ssd	Databases	NF00400	https://www.archives.gov/files/lod/dpframework/id/NF00400.ttl
SAS Transport File Format (xport) 5	xpt	Databases	NF00615	https://www.archives.gov/files/lod/dpframework/id/NF00615.ttl
SAS Transport File Format (xport) for Windows 8.x	xpt	Databases	NF00616	https://www.archives.gov/files/lod/dpframework/id/NF00616.ttl
SAS Transport File Format (xport) for Windows 9.1	xpt	Databases	NF00617	https://www.archives.gov/files/lod/dpframework/id/NF00617.ttl
SIARD 1.0	siard	Databases	NF00406	https://www.archives.gov/files/lod/dpframework/id/NF00406.ttl
SIARD 2.0	siard	Databases	NF00618	https://www.archives.gov/files/lod/dpframework/id/NF00618.ttl
SIARD 2.1	siard	Databases	NF00619	https://www.archives.gov/files/lod/dpframework/id/NF00619.ttl
SIARD 2.2	siard	Databases	NF00797	https://www.archives.gov/files/lod/dpframework/id/NF00797.ttl
Structured Query Language	sql	Software and Code\|Databases	NF00416	https://www.archives.gov/files/lod/dpframework/id/NF00416.ttl
vCalendar Electronic Calendaring and Scheduling Exchange Format	vc\|vcs	Databases\|Calendars	NF00620	https://www.archives.gov/files/lod/dpframework/id/NF00620.ttl
vCard	vcf\|vcard	Databases	NF00432	https://www.archives.gov/files/lod/dpframework/id/NF00432.ttl
VisiCalc	vc\|vcs	Databases\|Spreadsheets	NF00435	https://www.archives.gov/files/lod/dpframework/id/NF00435.ttl
Visual FoxPro Database Table File 5	dbf	Databases	NF00622	https://www.archives.gov/files/lod/dpframework/id/NF00622.ttl