{"id":1474,"date":"2017-03-21T19:41:40","date_gmt":"2017-03-21T19:41:40","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?page_id=1474"},"modified":"2017-04-01T22:21:43","modified_gmt":"2017-04-01T22:21:43","slug":"canal-st-tapes-database","status":"publish","type":"page","link":"https:\/\/www.mollieecheverria.com\/?page_id=1474","title":{"rendered":"Canal St Studios Tapes Database"},"content":{"rendered":"

Project Title:<\/h4>\n

Canal St Studios Tapes Database<\/p>\n

Course:<\/h4>\n

LIS-697 – Database Design and Development, Fall 2016, Pratt Institute<\/p>\n

Project Description:<\/h4>\n

This project was inspired by my work interning in the studio archives of artist and musician Laurie Anderson<\/a>. Over the past year, Anderson’s studio has been preparing for the opening of a new long-term exhibition space at MASS MoCA<\/a> that will serve in part as an audio archive of Anderson’s work. Part of this preparation involves the transfer of many of Anderson’s master analog audio tape recordings\u00a0to a digital format. Anderson’s studio has been keeping track of the progress of this project using an Excel spreadsheet. After enrolling in LIS-697, Database Design, I wondered if a relational database could provide a more secure, easier to expand alternative repository for organizing this data.<\/p>\n

Project Documentation<\/h4>\n

Download Presentation<\/a> – Download Database Design Documentation<\/a> – Download SQL Scripts<\/a> – Download Entity Relationship Diagram<\/a><\/p>\n

Methods:<\/h4>\n

I began the project by thinking about the specific user needs of Anderson’s studio and of the staff at MASS MoCA, and what problems a database could potentially solve in the context of an audio digitization project. I then created an entity-relationship diagram<\/a> to model how the data in my database would be stored. After receiving a copy of the Excel spreadsheet documenting the tape digitization project from Anderson’s technical director, Jason Stern, I used OpenRefine<\/a> to clean and normalize the data, standardizing spellings and field content, splitting multi-valued cells, and eventually creating separate sheets for each entity<\/a> documented in the database. After further refining my entity-relationship model, I eventually used MySQL Workbench<\/a> to create a relational database to input the spreadsheet data. Using SQL programming<\/a>, I created about 15 database tables<\/a>, along with sample queries<\/a>, transactions<\/a>, and triggers<\/a>.<\/p>\n

My Role:<\/h4>\n

I am the sole creator of this project (using data from the team at the MagicShop Archive & Restoration Studio<\/a>).<\/p>\n

Learning Objective Achieved:<\/h4>\n

Technology<\/p>\n

Rationale:<\/h4>\n

This project was created using SQL programming, along with digital tools including OpenRefine, MySQL Workbench, and draw.io<\/a>, which I used to create my entity-relationship diagram.<\/p>\n

Additional Learning Objective Achieved:<\/h4>\n

User-Centered Focus<\/p>\n

Rationale:<\/h4>\n

This project was created with the needs of specific users (Laurie Anderson’s studio staff, MASS MoCA) in mind. As explained in the design documentation for the project, I structured the design of my database around the breadth of different types of audio material it would document, the stages and day-to-day procedures involved in the tape digitization project, the type of data recorded by the audio restoration engineers at the MagicShop, and how and why that data might need to be accessed in the future.<\/p>\n","protected":false},"excerpt":{"rendered":"

Project Title: Canal St Studios Tapes Database Course: LIS-697 – Database Design and Development, Fall 2016, Pratt Institute Project Description: This project was inspired by my work interning in the studio archives of artist and musician Laurie Anderson. Over the past year, Anderson’s studio has been preparing for the opening of a new long-term exhibition […]<\/p>\n","protected":false},"author":1,"featured_media":1708,"parent":1603,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-1474","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\nCanal St Studios Tapes Database – Mollie Echeverr\u00eda<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mollieecheverria.com\/?page_id=1474\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474\",\"name\":\"Canal St Studios Tapes Database – Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/Screen-Shot-2016-12-13-at-6.15.01-PM-e1490988434455.png\",\"datePublished\":\"2017-03-21T19:41:40+00:00\",\"dateModified\":\"2017-04-01T22:21:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474#primaryimage\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/Screen-Shot-2016-12-13-at-6.15.01-PM-e1490988434455.png\",\"contentUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/Screen-Shot-2016-12-13-at-6.15.01-PM-e1490988434455.png\",\"width\":1242,\"height\":624},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1474#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Projects\",\"item\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1603\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Canal St Studios Tapes Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/\",\"name\":\"Mollie Echeverr\u00eda\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Canal St Studios Tapes Database – Mollie Echeverr\u00eda","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mollieecheverria.com\/?page_id=1474","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?page_id=1474","url":"https:\/\/www.mollieecheverria.com\/?page_id=1474","name":"Canal St Studios Tapes Database – Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?page_id=1474#primaryimage"},"image":{"@id":"https:\/\/www.mollieecheverria.com\/?page_id=1474#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/03\/Screen-Shot-2016-12-13-at-6.15.01-PM-e1490988434455.png","datePublished":"2017-03-21T19:41:40+00:00","dateModified":"2017-04-01T22:21:43+00:00","breadcrumb":{"@id":"https:\/\/www.mollieecheverria.com\/?page_id=1474#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?page_id=1474"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mollieecheverria.com\/?page_id=1474#primaryimage","url":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/03\/Screen-Shot-2016-12-13-at-6.15.01-PM-e1490988434455.png","contentUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/03\/Screen-Shot-2016-12-13-at-6.15.01-PM-e1490988434455.png","width":1242,"height":624},{"@type":"BreadcrumbList","@id":"https:\/\/www.mollieecheverria.com\/?page_id=1474#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Projects","item":"https:\/\/www.mollieecheverria.com\/?page_id=1603"},{"@type":"ListItem","position":2,"name":"Canal St Studios Tapes Database"}]},{"@type":"WebSite","@id":"https:\/\/www.mollieecheverria.com\/#website","url":"https:\/\/www.mollieecheverria.com\/","name":"Mollie Echeverr\u00eda","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mollieecheverria.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1474"}],"version-history":[{"count":15,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1474\/revisions"}],"predecessor-version":[{"id":2000,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1474\/revisions\/2000"}],"up":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/media\/1708"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}