Global performing arts database l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 27

Global Performing Arts Database PowerPoint PPT Presentation


  • 101 Views
  • Uploaded on
  • Presentation posted in: General

Global Performing Arts Database. Paul Houle Library Systems Cornell University Library. Thanks To James Reidy Joshua Young Chip Goines Susan Specter Karen Brazell Ron Rice Derek Messie. www.glopad.org. Vietnamese Water Puppets.

Download Presentation

Global Performing Arts Database

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Global performing arts database l.jpg

Global Performing Arts Database

Paul Houle

Library Systems

Cornell University Library

Thanks To

James Reidy Joshua Young

Chip Goines Susan Specter

Karen Brazell Ron Rice

Derek Messie


Www glopad org l.jpg

www.glopad.org


Vietnamese water puppets l.jpg

Vietnamese Water Puppets


Gertrude stein repertory theatre l.jpg

Gertrude Stein Repertory Theatre


Circus arts l.jpg

Circus Arts


Meyerhold theatre l.jpg

Meyerhold Theatre


Www glopac org l.jpg

www.glopac.org


Slide8 l.jpg

Individuals

Museums

PA Organizations

University Departments

GLOPAD

JPARC

TeenPARC


Three generations of glopad l.jpg

Three Generations of GloPAD

Filemaker

JSP / PostgreSQL

PHP / PostgreSQL


The glopad galaxy l.jpg

The Glopad Galaxy

digdoc

component

source object

performance

performing art

production

performing arts group

piece

person

place

collection

date

part of body

function

instrument

role

era

named genre

language

frame rate

country

sound field type


Component types 25 of 106 l.jpg

Component Types (25 of 106)


Multilingual text strategies l.jpg

Multilingual text strategies

  • Multiple columns in one table (title_en, title_ja, title_ru,…)

  • Multiple tables with hardcoded names (d_digdoc_en)

  • Satellite table (d_digdoc_ml) with (language_id) column

  • RDF store (see http://vivo.library.cornell.edu/)


Tools used for 3 rd generation l.jpg

Tools used for 3rd generation


Finding the text l.jpg

Finding the text

Country

Country: Japan

Digdoc2

Title:

Notes:

Production

Name:

Performance 2

Notes:

Piece

Title:

Notes:

Performance

Notes:

Place

Name:

Digdoc

Title:

Notes:

Component

Name:

Material:

Function

Function: Author

Person

Title:

Notes:

Component_type

Type: Costume

Country 2

Country: United Kingdom

Place:

Name:


Slide15 l.jpg

Full-text system: objects

glo_search_searcher

glo_search_indexer

glo_path_builder

glo_path

glo_node

glo_digdoc_policy

glo_traversal_policy

glo_source_object_policy

glo_friends_policy

glo_component_policy

glo_table

glo_link

glo_performance_policy

glo_direct_link

glo_indirect_link


Move to production l.jpg

Move to production

  • Standardize file organization

  • Reorganize CVS repository

  • Ability to run multiple instances

  • Develop db dump & restore procedure

  • Fix showstopper bugs

  • Friendly URLs


Slide17 l.jpg

Standard File Layout for Virtual Hosts

/arts-lib/

/sites/

/www.glopad.org/

/bin

/conf

/docs

/htdocs

/lib

/logs

/templates

/var


Friendly urls l.jpg

Friendly URLs

http://www.glopad.org/pi/record/digdoc/2122

http://www.glopad.org/pi/full_record.php?obj=digdoc&id=2122

Based on Apache URL rewriting

RewriteEngine on

RewriteRule ^/$ /pi/ [R]

RewriteRule ^/ei/$ /ei/php [R]

RewriteRule ^/pi/record/(digdoc)/([0-9]*)$ /pi/full_record.php?obj=$1&id=$2


Slide20 l.jpg

Clone tool

Bulk Upload

glopad_batch.txt

upload.zip


Project initiation plan l.jpg

Project Initiation Plan

  • Change History

  • Project Purpose

  • Success criteria/Requirements

  • Scope and Dependencies

  • Key Deliverables and Time Frames

  • Stakeholders

  • Resources

  • Risks

  • Communication Plan


Requirements format l.jpg

Requirements format

(1) Facility (i) will involve adding a button on the bottom of the digital object record screen that will clone an object. (2) The cloning process will create a copy of the metadata records of the object, but will not copy the associated media file(s); it will copy the contents of the d_digdoc row and any rows in the r_ tables associated with other fields (other than performance and component) (3) The user will be left at the object edit screen for the new object, where they have the option of uploading the files for the new DO and of editing selected fields

(4) The user will have the option of doing a “deep copy” of the associated Performance and Component records – this will copy the fields contained in the d_performance and d_component records, along with any r_ table rows, and create the r_table records linking the new Digdoc to the new Performance and Component records. (5) If the user chooses not to “deep copy” these records, there will be no linked Performance and Component records.

(6) The source object record associated with a digital object will be shallow copied: new digital objects will be linked to the same source object as the template digital object


Release 3 1 l.jpg

HEAD

Release 3.1

Paul Houle

Bulk Upload

Jim Reidy

Google Sitemaps

branch: release_3_1

Clone tool

Tag: release_3_1_0

branch: release_3_0

Move to production

Tag: release_3_0_0


Cvs commit m 0000647 give english error message when user forgets to select file upload php l.jpg

$ cvs commit –m “0000647: give english error message when user forgets to select file” upload.php


Status report l.jpg

Status Report

The following items from the PIP are not yet implemented:

. (16) Access to the batch upload facility will be controlled by Apache access control

(17e) Check for files not listed in glopad_batch.txt

(24) Shallow copy Source Object records.

(29) A note will be inserted into the d_digdoc.notes field documenting the bulk import.

I am proposing that we remove the following items:

(27) All new records will be tagged with a unique bulk upload id in a new field of the d_digdoc record.

(28) The new field will be indexed by the full-text search, so that editors will be able to pull out all of the records linked to the digdoc.

And add one more item:

(31) Create a cron job that removes old files left by the batch upload process


Release 3 2 l.jpg

HEAD

Release 3.2

branch: release_3_2

Bulk upload

Tag: release_3_2_0

Tag: release_3_1_1

Google Sitemaps

branch: release_3_1

Clone tool

Tag: release_3_1_0

branch: release_3_0

Move to production

Tag: release_3_0_0


Global performing arts database27 l.jpg

Global Performing Arts Database

Any Questions?

Image credits: Meyerhold Theatre, Russia; San Francisco Performing Arts Library & Museum; Thang Long Water Puppet Theatre of Hanoi, Vinh Qui ; Gertrude Stein Repertory Theatre


  • Login