{"@context":"http://iiif.io/api/presentation/3/context.json","id":"https://arsc.aviaryplatform.com/iiif/0000001f6p/manifest","type":"Manifest","label":{"en":["Implementing a Nickelodeon Music Roll Database"]},"logo":"https://d9jk7wjtjpu5g.cloudfront.net/organizations/logo_images/000/000/019/original/ARSC_Full_Logo_RGB_K.jpg?1605438091","metadata":[{"label":{"en":["Agent"]},"value":{"en":["Matthew Jaro (Presenter)"]}},{"label":{"en":["Date"]},"value":{"en":["2009-05-29 (Created)"]}},{"label":{"en":["Format"]},"value":{"en":["Audio"]}},{"label":{"en":["Description"]},"value":{"en":["\u003cp\u003eCoin-operated nickelodeons were an important source of entertainment in the early Twentieth Century. Recorded music on records using the acoustic process did not have enough volume to be a feasible source of music for bars, dance halls, ice-cream parlors and other public places. Pneumatically-operated nickelodeons filled that need. Actual instruments (piano, xylophone, organ pipes, drums, triangle, etc.) were played by means of pneumatic bellows and valves controlled by paper rolls. There is a great legacy of music on these rolls (often never recorded on disk). The performances were taken and arranged from some of the best artists of the day. Since there is a declining interest in these rolls, the author wishes to preserve the information concerning their contents. This presentation describes and demonstrates a database of these rolls. Normalization and the use of pull-down lists are important aspects of database design in order to remove redundant information and reduce the probability of duplication. Each roll has a manufacturer, a roll number, and a number of selections. Each selection has a song title and arranger/performer (if known). Each song has a publication date, composer, song type and one or more possible aliases. “Private” tables are used to enter information pertaining to an individual collection. Original rolls may be “re-cut” by other companies. This information is also recorded. The design of the database, the implementation (using Microsoft Access), the collection of information, data entry, example queries and reports will all be discussed.\u003c/p\u003e"]}},{"label":{"en":["Language"]},"value":{"en":["English"]}},{"label":{"en":["Publisher"]},"value":{"en":["Association for Recorded Sound Collections"]}},{"label":{"en":["Rights Statement"]},"value":{"en":["\u003cp\u003eCopyright Association for Recorded Sound Collections\u003c/p\u003e"]}}],"summary":{"en":["\u003cp\u003eCoin-operated nickelodeons were an important source of entertainment in the early Twentieth Century. Recorded music on records using the acoustic process did not have enough volume to be a feasible source of music for bars, dance halls, ice-cream parlors and other public places. Pneumatically-operated nickelodeons filled that need. Actual instruments (piano, xylophone, organ pipes, drums, triangle, etc.) were played by means of pneumatic bellows and valves controlled by paper rolls. There is a great legacy of music on these rolls (often never recorded on disk). The performances were taken and arranged from some of the best artists of the day. Since there is a declining interest in these rolls, the author wishes to preserve the information concerning their contents. This presentation describes and demonstrates a database of these rolls. Normalization and the use of pull-down lists are important aspects of database design in order to remove redundant information and reduce the probability of duplication. Each roll has a manufacturer, a roll number, and a number of selections. Each selection has a song title and arranger/performer (if known). Each song has a publication date, composer, song type and one or more possible aliases. \u0026ldquo;Private\u0026rdquo; tables are used to enter information pertaining to an individual collection. Original rolls may be \u0026ldquo;re-cut\u0026rdquo; by other companies. This information is also recorded. The design of the database, the implementation (using Microsoft Access), the collection of information, data entry, example queries and reports will all be discussed.\u003c/p\u003e"]},"requiredStatement":{"label":{"en":["Attribution"]},"value":{"en":["\u003cp\u003eCopyright Association for Recorded Sound Collections\u003c/p\u003e"]}},"provider":[{"id":"https://arsc.aviaryplatform.com/aboutus","type":"Agent","label":{"en":["Association for Recorded Sound Collections"]},"homepage":[{"id":"https://arsc.aviaryplatform.com/","type":"Text","label":{"en":["Association for Recorded Sound Collections"]},"format":"text/html"}],"logo":[{"id":"https://d9jk7wjtjpu5g.cloudfront.net/organizations/logo_images/000/000/019/original/ARSC_Full_Logo_RGB_K.jpg?1605438091","type":"Image"}]}],"thumbnail":[{"id":"https://d9jk7wjtjpu5g.cloudfront.net/public/images/audio-default.png","type":"Image","format":"image/png"}],"items":[{"id":"https://arsc.aviaryplatform.com/collections/2671/collection_resources/128448/file/240046","type":"Canvas","label":{"en":["Media File 1 of 1 - ARSC_conf_2009_Jaro_audio.mp3"]},"duration":2051.45613,"width":640,"height":360,"thumbnail":[{"id":"https://d9jk7wjtjpu5g.cloudfront.net/public/images/audio-default.png","type":"Image","format":"image/png"}],"items":[{"id":"https://arsc.aviaryplatform.com/collections/2671/collection_resources/128448/file/240046/content/1","type":"AnnotationPage","items":[{"id":"https://arsc.aviaryplatform.com/collections/2671/collection_resources/128448/file/240046/content/1/annotation/1","type":"Annotation","motivation":"painting","body":{"id":"https://aviary-p-arsc.s3.wasabisys.com/collection_resource_files/resource_files/000/240/046/original/ARSC_conf_2009_Jaro_audio.mp3?1714691344","type":"Audio","format":"audio/mpeg","duration":2051.45613,"width":640,"height":360},"target":"https://arsc.aviaryplatform.com/collections/2671/collection_resources/128448/file/240046","metadata":[]}]}],"annotations":[]}]}