Cornell University
Library
Cornell UniversityLibrary

eCommons

Help
Log In(current)
  1. Home
  2. National and International Organizations
  3. Global Performing Arts Consortium (GloPAC)
  4. Global Performing Arts Database (GloPAD)
  5. Global Performing Arts Database (GloPAD) - Preservation version

Global Performing Arts Database (GloPAD) - Preservation version

File(s)
Preservation_of_GloPAD.docx (28.41 KB)
glopad3.sql.gz (8.2 MB)
glopad3_fk.sql.zip (8.22 MB)
add_foreign_keys.sql (54.04 KB)
create_fk.py (3.82 KB)
  View More
Permanent Link(s)
https://hdl.handle.net/1813/113842
Collections
Global Performing Arts Database (GloPAD)
Author
Global Performing Arts Consortium
Paolillo, Michelle
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".

Description
Only the metadata from GloPAD is in these databases. The content files can be accessed in Archive-It. A direct list of records and Archive-It links is in the file "WaybackLinks.txt"
The data in this project is from ca.2003, preservation files are from 2023.
Date Issued
2023
Publisher
Global Performing Arts Consortium, Cornell University
Cornell University Library
Keywords
Global Performing Arts Database
•
GloPAD
•
digital preservation
Related Part
Global Performing Arts Consortium. (2023). "Japanese Performing Arts Research Center (JPARC) Database - Preservation version". Cornell University Library. https://hdl.handle.net/1813/113843. Note: JPARC metadata is reflected in full within the GloPAD database.
Related To
https://hdl.handle.net/1813/113843
Reference(s)
Global Performing Arts Consortium. (1998-2006, archived 2023). "Global Performing Arts Database (GloPAD) [archived]". Cornell University Archives Web Archive.
Link(s) to Reference(s)
https://wayback.archive-it.org/2566/*/http://glopad.org/pi/en/
Type
dataset
software

Site Statistics | Help

About eCommons | Policies | Terms of use | Contact Us

copyright © 2002-2026 Cornell University Library | Privacy | Web Accessibility Assistance