This site requires Javascript to be turned on. Please enable Javascript and reload the page.

DHRI@A-State Main Menu About DHRI@A-State Curriculum Learn Skills, Share Resources Community Contact, Events The Faculty Center

Custom Database

31636

To learn how to create a custom database using the programing language R, consult Jeff Blackadar, "Introduction to MySQL with R," The Programming Historian 7 (2018), https://programminghistorian.org/en/lessons/getting-started-with-mysql-using-r; using R or Python, Abigail Cabunoc and Sheldon McKay (eds): "Software Carpentry: Using "LC4" Databases and SQL." Version 2017.08, August 2017,
https://github.com/swcarpentry/sql-novice-survey, https://doi.org/10.5281/zenodo.838776.

This page is referenced by:

Constructing Data Constructing a dataset, as Trevor Owens of the Library of Congress explains, "requires choices about what and how to collect and how to encode the information" [1].

How and What to Collect

How to Encode Information
For digital collections, object metadata is frequently encoded in relational databases. A relational database is a structured set of data that contains a series of formally described tables from which data can be queried or organized in different ways. This structure enhances search, browse, and exhibition functions by enabling users to access items or reassemble collections based on tabular information.

To build a digital collection, you can either create a custom database or select a digital publishing platform that functions as a relational database, such as Wordpress, Omeka, Scalar, and CollectiveAccess [2].