Global Performing Arts Database (GloPAD) - Preservation version
No Access Until
Permanent Link(s)
Collections
Other Titles
Abstract
A preservation copy of the data from GloPAD expressed as a compressed, Postgres database dump file called "glopad3.sql.gz" To work with this file, researchers will need to download, reimport/reestablish the file as a working Postgres database. After this, the record metadata can be explored natively. The database was built without foreign keys in the tables. During preservation, Cornell University Library Preservation Services refined a python script that injects the foreign keys into the tables of the database. The code that creates the foreign keys is called create_fk.py and the code to inject them is called add_foreign_keys.sql. The resulting improved database (dumped and compressed) is called glopad3_fk.sql.zip. All three files are also offered in addition to the original database export in case the researcher finds these more suitable for the research need. The full description and rationale for the preservation strategy is provided in the file "Preservation_of_GloPAD.docx".
Journal / Series
Volume & Issue
Description
The data in this project is from ca.2003, preservation files are from 2023.
Sponsorship
Date Issued
Publisher
Cornell University Library
Keywords
Location
Effective Date
Expiration Date
Sector
Employer
Union
Union Local
NAICS
Number of Workers
Committee Chair
Committee Co-Chair
Committee Member
Degree Discipline
Degree Name
Degree Level
Related Version
Related DOI
Related To
Related Part
Based on Related Item
Has Other Format(s)
Part of Related Item
Related To
Related Publication(s)
Link(s) to Related Publication(s)
References
Link(s) to Reference(s)
Previously Published As
Government Document
ISBN
ISMN
ISSN
Other Identifiers
Rights
Rights URI
Types
software