Home

Appendix 4: Database documentation

1. RGB 0 0 0 Article Title Text Author Firstname Text Author l Surname Text Author2Firstname Text Author2Surname Text Author3Firstname Text Author3Surname Text Author4Firstname Text Author4Surname Text BiblAbbrev Text Allow user to override validation Unique values only bibliographyKey Number Serial Number on creation with Current Value 4459 Increment 1 Required value Unique values only Only allow values of type Nu meric Only BookTitle Text chapter_in_book Text 25 degree dissertation DONE editing_history Editor Firstname Editor Surname Editor2Firstname Editor2Surname Editor3Firstname Editor3Surname Editor4Firstname Editor4Surname Festschrift FINDfield FullBibliography Text FullText_calculated Text Text Text Calculation Text Text Text Text Text Text Text Text Text Text Global Text Calculation Text from Bibliography If IsEmpty logged_in_as editing_history Get AccountName amp amp modification date amp YJ amp editing_history Text Unstored from Bibliography If IsEmpty DONE FullBibliog raphyText TextFont TextSize If Length Author Surname 2 and Length Editor Surname 2 l lf IsEmpty Author Surname Au thor Surname amp amp Author Firstname amp If IsEmpty Author2 Surname i amp Author2 Surname amp amp Author2Firstname amp If IsEmpty Au thor3Surname
2. 2 0 amp Right RIS Mimagefilename 3 Length Right RISMimagefilename 3 43 pageNextRISM 2 pagePreviousCCM pagePreviousCCM_2 pagePreviousRISM Calculation Calculation Calculation Calculation 1 00 amp Right RISMimagefilename 3 Whoops you ve run out of pages in this volume Case Length Right RISMimage filenamel 4 4 Right RISMimagefilename 4 Length Right RISMimagefilename 4 3 0 amp Right RISMimage filenamel 4 I Length Right RISMimagefilename 4 I 2 00 amp Right RISMimagefilename 4 Length Right RIS Mimagefilename 4 1 000 amp Right RISMimagefilename 4 Whoops you ve run out of pages in this volume Text Unstored from Source Left RISMimagefilename2 2 amp If Length RISMimagefilename2 5 Case Length Right RISMimage filename 3 3 Right RISMimagefilename2 3 Length Right RISMimagefilename 3 2 0 amp Right RISMimage filename2 3 Unstored from Source Left RISMimagefilename2 2 amp If Length RiISMimagefilename2 5 Case Length Right RIS Mimagefilename 3 3 Right RISMimagefilename2 3 Length Right RISMimagefilename l 3 2 0 amp Right RIS Mimagefilename2 3 Length Right RISMimagefile
3. amp Author3Surname amp amp Author3Firstname amp translator info If IsEmpty Translator Surname If IsEmpty Au thor Surname trans amp Translator Firstname amp amp Translator Sur name amp trans amp Translator Firstname amp amp Translator Surname amp amp lf IsEmpty Author Surname amp Editor Surname amp Translator Sur name amp lf IsEmpty chapter_in_book amp chapter_in_book amp amp in amp f IsEmpty BookTitle lt em gt amp TextStyleAdd Book Title Italic amp lt em gt amp If IsEmpty no_of_volumes amp no_of_vol umes amp vols amp If IsEmpty series_title amp series_title amp lf IsEmpty vol_no_in_series Vol amp vol_no_in_series amp amp If IsEmpty Editor Surname edited by amp lf IsEmpty Editor Surname i Editor Firstname amp amp Editor Surname amp If lsEmpty Editor4 Sur name If IsEmpty Editor3Surname If IsEmpty Editor2Surname and amp Editor2Firstname amp amp Editor2Surname amp Editor2Firstname amp amp Editor2Surname amp and amp Editor3Firstname amp amp Editor3Sur name amp Editor2Firstname amp amp Editor2Surname amp amp Editor3First name amp amp Editor3Surname amp and amp Editor4Firstname amp amp Editor4Surname
4. RGB 196 5 5 Bold Italic Arial 13 sTextColor This MS has moved RGB 196 5 5 amp LOTS OF TEXT TextSize TextFont TextStyleRemove TextStyleRemove TextColor Archive siglum RGB 18 118 18 amp amp Archive city amp amp Archive archiveName amp amp shelfMark_alone amp amp If IsEmpty source Name amp sourceName amp amp lf IsEmpty olim olim amp olim amp amp TextColor If IsEmpty dateOfSource NO DATE GIVEN amp dateOfSource RGB 18 118 18 amp TextColor If IsEmpty CCMabbrev amp CCMabbrev amp lf IsEmpty RISMab brev amp RiISMabbrev amp lf IsEmpty altRISMabbrev amp al tRISMabbrev RGB 196 5 5 Bold Italic Arial 13 Global 4 completeMS containerKey dateComments dateOfSource description description_author description_CCM description_DIAMM description_RISM done editing_history enddate external_URLs FlagCCM FlagCCM 2 FlagRISM Text Calculation Text Text Calculation Text Text Text Text Text Calculation Text Text Calculation Calculation Calculation says whether the MS is complete or a bit of one Number from Source 999 Lookup When an entry in MOTET to source sourceKey is made copy the first matching value from Motetten Datenbank 07 Date Comments If no match Do
5. SOPE ESS SE JEES S XT S SVT goombas L Ap pendix Times New Roman Lookup When an entry in Source sourceKey is made copy the first matching value from Motetten Datenbank 03 CC Sigla If no match Do not copy don t copy Motetten Datenbank 03 CC Sigla if empty Text Text Text Text from Source If IsEmpty CCMimagefilename _delete CCM Auto enter Calculation from Source CCMimagefilename _delete Auto enter Calculation from Source CCMimagefilename2_delete Lookup When an entry in Source archiveKey is made copy the first matching value from Archive city If no match Do not copy don t copy Archive city if empty Text Unstored from Source If IsEmpty moved TextSize Text Font TextStyleRemove TextStyleRemove TextStyleRemove TextColor Archive siguum RGB 18 118 18 amp amp Archive city amp amp Archive archiveName amp amp shelfMark_alone amp amp If IsEmpty source Name amp sourceName amp amp lf IsEmpty olim olim amp olim amp amp TextColor If IsEmpty dateOfSource NO DATE GIVEN amp dateOfSource RGB 18 118 18 amp TextColor If IsEmpty CCMabbrev amp CCMabbrev amp If IsEmpty RISMab brev amp RiISMabbrev amp If IsEmpty altRISMabbrev amp al tRISMabbrev
6. alGenre Genre if empty Global Number Auto enter Calculation from Text 999 Global field used in rela tionship between Item and Text to show all records imageKey Text Lookup When an entry in Text incipitfilename is made copy the first matching value from Text to Itemlmage imageKey If no match Do not copy don t copy Text to Itemlmage imageKey if empty incipitfilename Text Lookup When an entry in Text itemKey is made copy the first match ing value from Itemzincipitfilename If no match Do not copy don t copy Item incipitfilename if empty itemKey Number mensurationKey Number orderNo Number Serial Number on creation with Current Value 27237 Increment positiononPage Text Lookup When an entry in Text incipitfilename is made copy the first matching value from Text to Itemlmage positiononPage If no match Do not copy don t copy Text to Itemlmage positiononPage if empty sourceKey Number Lookup When an entry in TextzitemKey is made copy the first match ing value from Item sourceKey If no match Do not copy don t copy Item sourceKey if empty standardspellingFulltext Text standardspellinglncipit Text textincipit Text 47 TextKey Number Serial Number on creation with Current Value 27278 Increment 1 Required value Unique values only Only allow values of type Nu m
7. Motetten Datenbank 32a Motet incipit Standard If no match Do not copy don t copy Motetten Daten bank 32a Motet incipit Standard if empty Motetten Datenbank THIS TABLE DOES NOT APPEAR IN THE SQL DATABASE This is the original table supplied from the MOTET database project and is linked to the Source and Item tables which derive some data from this table via relationship and lookups When this table is redundant it will be deleted from the database It is kept in place for the moment in case any data has failed to copy over correctly Numbered fields are those originally in the MOTET database which was not relational unnumbered fields have been added for data transfer purposes Most of these fields turned out to be empty Field Name Field Type Formula Entry Option OI SourceName Text 02 RISM abbrev Text 03 CC Sigla Text 04 Startdate Text 05 Enddate Text 06 Intdate Text 07 Date Comments Text 08 Dedicatee Text 09 Dedicator Text 10 Dedication text Text I Liminary Text Text 2 Scribe Publisher Text 13 Editor Text 14 Establishment Patron Text 5 Source City Text 6 Source Country Text 7 Source Region Text 8 Source Citation Text 19 Contributor Text Auto enter value from last visited record 20 Source Comments Text 21 Source type Text 22 Composer original Text 22a Conflicting attributions Text 23 Composer standard Text 24 Catalog designation Text 25 Order in sou
8. amp If IsEmpty address5 address5 amp J amp If IsEmpty address6 address6 amp YJ amp If IsEmpty address7 address7 22 address address2 address3 address4 address5 address6 address address8 addressrunon alCityKey alCountryKey appendixofsources archiveKey archiveName avallableOnWebsite banner_URL CDcopiessent CDschecked city copyrightholder correspondencestatus currentstatus daysrequired DONE email emailed fax ftp fulladdressrunon furthercorrespondence g Key g_libraryName imagesarchived imagesfromthisarchive imagesordered imagesreceived invoicepaid invoicequeried invoicereceived letter_content Text Text Text Text Text Text Text Text Calculation Number Number Calculation Number Text Text Text Text Text Text Text Text Text Number Text Text Text Text Text Text Text Number Text Text Number Text Text Text Text Text Calculation Text linear version of address used in inputting to google search en gine in automated search for library URL or map from Archive ad dress amp amp address2 amp amp address amp amp address4 amp amp address5 amp amp address6 amp amp address7 amp amp address8 Lookup When an entry in Archive alCityKey is made copy the first matching value from alCountry alcountryKey If no match Do not copy don t copy
9. Allow user to override validation Required value Unique values only Only allow values of type Numeric Only SourceProvenance_IS Intersection between the Source and alProvenance tables implemented in order to limit the Provenance authority list to coun tries only the intersection set contains more detailed information about provenance where that is known such as region pro tectorate city and institution Field Name Field Type Formula Entry Option city Text institution Text protectorate Text provenanceKey Number region Text sourceKey Number sourceProvenance_IS_KEY NumberSerial Number on creation with Current Value 3008 Incre ment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only uncertain Text SourceSet_I S The intersection set between the Source and Set tables allowing sources to belong to more than one set 46 Field Name Field Type Formula Entry Option setKey Number sourceKey Number sourceSet_IS_KEY Number Serial Number on creation with Current Value 1065 Increment Text Allow user to override validation Required value Unique values only Only allow values of type Numeric Only This table contains the text records Inked to items in the Item table The records include primarily text incipits in original and standardised spelling but also contain a number of complete text transcriptions
10. D Cnn Page ssourcel attribution_uncerain personkey personRelationshipkey E s s e z EEDA Journal p EJ modification_dare gt ia affiliationkey o MOTETincipithlename no_of volumes bibliographyKe aliases f not p firstNames s MotetSourceComments it Chapter fi author_editor Alinan Feafhiiationkey MusicalGenre pan TEAR authorKey S musicalincipit_score omi_Year_from_c bibhographyKe oen ort musicNotation_styleKey a persorkelaionshipkey pkey Feauthorkey BersonRelationshipkey arcom relationshipType Athe authorkey firstname surname copyistkey D copyistTypekey sourcek attribution unc ertain copyistkey copyistTypeKey sourcexe affiliationKey copyistkey copyistame An examination was undertaken at this point of the type of data expressed in prose descriptions with a view to editing the descriptions we had so that all supplied the same level of information The information might then be divided into separate fields so that it might appear under consistent headings e g copyists date prove nance dimensions contents owners binding watermarks gathering information etc A brief study was under taken of the way in which scholars had approached the description of these documents in the printed catalogues one entry might discourse at length on the history and ownership of a manuscript and entirly omit any description of its biding while another would give leng
11. One type is that of the intentional origin of a book such as members of a set of partbooks Another type links fragments that are now geographically separated but belonged originally to the same MS while another type is a modern connection made between groups of MSS for geographical or other reasons The list currently is fairly short partbooks fragments that form part of one MS or collection Special Music collection e g Machaut MSS Alamire scriptorium MSS copyist or scribal concordance single source bound in separate volumes A further definition Special non Music collection allows the database to include groups of MSS not related to the remit of the DIAMM project but display these MSS using the DIAMM webapp Field Name Field Type Formula Entry Option description Text 21 set TypeKey Number Serial Number on creation with Current Value 8 Increment Allow user to override validation Required value Unique values only Only allow values of type Numeric Only Altincipit This table creates a connection between the Item table in which a field links the item to a musical incipit file and secondary incipits cited in the original incipit information To save space and typesetting costs RISM would often cross refer from the in stance of a work in one manuscript to its listing for that work in the entry for another MS hence incipit as for xxxx This table gives the alternative source for the incipit informa
12. PlacePublication Publisher series title sourceKey university Vol vol_no_in_series Year author_editor authorKey bibliographyKe authorKey firstname surname copyistKey copyistTypeKey sourceKe copyistKey copyistTypeKey sourceKe copyistType copyistTypeKey GREEN tables already in the SQL version RED new master tables YELLOW intersection sets BLUE authority lists BLACK KCL tables attribution_uncertain MusicNotation notation_type notationTypeKe alt_numbering_source altRISMabbrev archiveKey authority bibliography CCMabbrev CCMimagefilenamel CCMimagefilename2 CCMimagefilename3 CMME_id completeMS dateComments dateOfSource dedicationText description DIAMM_description enddate folio format intDateMotet inventory liminaryText notation notes numbering_source olim pageMeasurements ProvenanceCitation provenanceComments RISMabbrev RISMCCM RISMimagefilename1 RISMimagefilename2 RISMimagefilename3 shelfMark sortorder sourceKey sourceName sourceType startdate staveGauge surface Tags watermark webpermission affiliationKey copyistKey istName personKey personRelationshipKey attribution_uncertain personKey personRelationshipKey sourceKe affiliationKey apersonKey _ affiliationKey aliases firstNames fullname personKey surname personRelationshipKey personRelationshipKey relationshipType bibliography cluste
13. Sometimes a secunda pars of a work would appear in an other source as an independent work in its own right complete Text_original completeText_standard composerComplete composerKey This gave rise to two problems the simple practical one of how to express the fact that a composition might be part of a cycle within the database but more difficult to manage the problem of reading the data provided by a cataloguer whereas cataloguer A might treat a piece and all its constituent pars as one work cataloguer B might prefer to treat each pars as an indi misses vidual work in its own right Further individual definitions of cataloguers might lead one to regard a section of a work as a pars while another would es not Often we did not know which method prevailed in our source data E so the content of this table at the point of writing may need significant suntan editorial input The simple quantity of data too makes this a thorny issue compositionkey genreke The Composition table thus accrued a further satellite the Composi tion_Cycle Connected to the Composition table by an intersection set serra and also governed by an authority list that defined the type of cycle Returning to the Item master table and its expression in terms of a musical incipit each item is clearly extremely rich in data par ticularly material that might need to be searchable in the web app The richest source of inform
14. and is only linked to those sources that need to be allocated to one or more sets There are various types of set and these are defined in the author ity list alSetType Field Name Field Type Formula Entry Option bibliography Text clusterShelfMark Text description Text setKey Number Serial Number on creation with Current Value 25 1 Increment 1 Allow user to override validation Required value Unique values only set ypeKey Number Source This is a PRIME table and is the most heavily populated of the dataset At the moment all of the online data revolves around this table and its content the master list of manuscripts Field Name Field Type Formula Entry Option _PracticeDBwarning abbrevs_checked alt_numbering_source altRISMabbrev archive archiveKey authority bibliography Calculation Text Unstored from Archive TextColor If Right Get FileName 7 RUBBISH YOU ARE IN THE PRACTICE DATABASE RGB 0 0 0 Text Text Text Text Lookup When an entry in Source archiveKey is made copy the first matching value from Archive archiveName If no match Do not copy don t copy Archive archiveName if empty Number Text Calculation Text from Source lt p gt amp Substitute If IsEmpty bibliography_gathered bibliography_orig_abbrevs bibliography_gathered o T G lt ip gt lt p gt amp lt ip gt amp If iEmpy
15. CCMimagefilename _delete and IsEmpty CCMimagefilename2_delete and IsEmpty RISMimagefilename and IsEmpty RISMimagefilename2 and IsEmpty RISMimagefilename3 lt p gt This manuscript is not listed in RISM or CCM Please notify the Project Manager by e mail of any informa tion to supplement that displayed here All contributions to information about manuscripts are acknowledged lt p gt lt p gt Bibliographical information displayed has been taken from RISM and or the Census Catalogue and may 40 BIBLIOGRAPHY_DONE Text bibliography_gathered Text bibliography_orig_abbrevs bibliographyParas Calculation block Text Blue Dogs Text CCMabbrev Text CCMimagefilename Text CCMimagefilename _delete CCMimagefilename2 Text CCMimagefilename2_delete CCMimagefilename3 Text CCMimagefilename3_delete CCMpresence Calculation CCMreset Text CCMreset_2 Text city Text Complete Library info Calculation Complete Library info_g Text therefore be out of date though any more recent items notified to us have been included We would be very grateful to be notified by e mail of new items for inclusion in the bibliography lists and general information for any manuscript All contributions to information about manuscripts are ac knowledged lt p gt Text Text from Source TextSize TextFont Substitute bibliography_orig_abbrevs 11 TGP YT TT ET TT Pe S LX Zoombas X EE eT 5 Appendix
16. CCMimagefilename2_delete and Vol amp Substitute Left CCMimagefilename2_delete 4 CCM oN amp p amp Right CCMimagefilename2_delete 3 p 00 p p O p amp J amp lt strong gt This information is reproduced here by kind permission of the publishers Itis COPYRIGHT and copying reproduction of any of this content without permissionmay result in legal action lt strong gt amp T amp description CCM amp J amp If IsEmpty description_RISM TextStyleAdd lt strong gt RISM description lt strong gt Bold amp J amp de scription_RISM amp J amp If IsEmpty inventory lt strong gt Please send corrections or new information todiamm at music ox ac uk lt strong gt TextStyleAdd lt strong gt TABLE OFCONTENTS lt strong gt Bold amp T amp inventory amp J amp lt strong gt Please sendcorrections or new information to diamm at music ox ac uk lt strong gt FT J Text Unstored from Source If IsEmpty logged_in_as edit ing_history Get AccountName amp amp modification date amp YJ amp edit ing_history Text from Source If IsEmpty CCMimagefilename _delete CCM entry Text from Source If IsEmpty CCMimagefilename2_delete CCM second entry Text from Source If IsEmpty RISMimagefilename RISM 42 FlagRISM 2 folio format g_bibliogAbbrev g_Key invent
17. Each record represents one voice part Where a voice part exists but is untexted it is nevertheless created in this table as this allows a voice part to be linked to clefs men surations and voice designations all satellite tables to this one There is also a further satellite authority list alLanguage which allows us to define the language or languages used in a particular voice part via an intersection set TextLanguage_IS Field Name Field Type Formula Entry Option alGenreKey Number Lookup When an entry in TextzitemKey is made copy the first match ing value from Item genreKey If no match Do not copy don t copy Item genreKey if empty canon Text clef Text clefKey Number completeLibrarylnfo Text Lookup When an entry in Text itemKey is made copy the first match ing value from Item to Source Complete Library info If no match Do not copy don t copy Item to Source Complete Library info if empty editorial_voicepart Text folios Text Lookup When an entry in Text itemKey is made copy the first match ing value from Item Folios If no match Do not copy don t copy Item Folios if empty fullltern Text Text fullttemText_authority Text g_voiceKey Calculation Number from Text 999 Genre Text Lookup When an entry in Text itemKey is made copy the first match ing value from alGenre Genre If no match Do not copy don t copy
18. IsEmpty Composers lastname Com posers lastname composerNameOriginal Text compositionKey Number date Text Lookup When an entry in Composerlink_IS composerKey is made copy the first matching value from Composers dates_public If no match Do not copy don t copy Composers dates_public if empty firstname Text Lookup When an entry in Composerlink_IS composerKey is made copy the first matching value from Composers firstname If no match Do not copy don t copy Composers firstname if empty itemKey Text Lookup When an entry in Composerlink_IS compositionKey is made copy the first matching value from Item itemKey If no match Do not copy don t copy ltem itemKey if empty notes_attribution Text sourceKey Text Lookup When an entry in Composerlink_IS compositionKey is made copy the first matching value from Item sourceKey If no match Do not copy don t copy Item sourceKey if empty Composers The master list of composers whose works appear in the manuscripts of the dataset Composers from this period often had vari ant spellings of their name or went under numerous aliases when linked to their compositions Often we know so little of their biography that we can only give approximate dates for their activity and information varies from the specific to the vague The content of this database is l
19. Numeric Only voice Text voiceKey Number Serial Number on creation with Current Value 94 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only Archive This is the main table listing details of modern archives in which the MSS in the Source table are housed It gives practical in formation such as the address and contact details for the library but it also gives internal information that is not displayed on line such as the status of negotiations for licensing and or information about the progress of digitization activity It also gives the correct copyright statement to be shown with MSS from that collection The address fields involve various types of compilation formats the fields are not included in DIAMM_Shell to allow the data to be inserted into form letters generated by the data base There are a number of other fields particularly calculation fields which are used to facilitate letter writing and other in ternal activities Field Name Field Type Formula Entry Option _PracticeDBwarning Calculation Text Unstored from Archive TextColor If Right Get FileName 7 RUBBISH YOU ARE IN THE PRACTICE DATABASE RGB 0 0 0 address Calculation Text from Archive librarianA amp YJ amp address amp YJ amp address2 amp J amp If IsEmpty address3 address3 amp J amp If IsEmpty address4 di address4 amp J
20. Source to ID inoofimages if empty Number Unstored from Source Get FoundCount Text Unstored from Source Left CCMimagefilename _delete 5 amp Case Length Right CCMimagefilename _delete 4 4 Right CCMimagefilename _delete 4 Length Right CCMimagefile name _delete 3 3 Right CCMimagefilename _delete 3 Length Right CCMimagefilename _delete 3 I 2 0 amp Right CCMimagefilename _delete 3 Length Right CCMimagefile name _delete 3 1 00 amp Right CCMimagefilename _delete 3 Whoops you ve run out of pages in this volume Text Unstored from Source Left CCMimagefilename2_delete 5 amp Case Length Right CCMimagefilename2_delete 4 4 Right CCMimagefilename2_delete 4 Length Right CCMimagefile name2_delete 3 3 Right CCMimagefilename2_delete 3 Length Right CCMimagefilename2_delete 3 2 0 amp Right CCMimagefilename2_delete 3 Length Right CCMimagefile name2_delete 3 1 00 amp Right CCMimagefilename2_delete 3 Whoops you ve run out of pages in this volume Text Unstored from Source Left RISMimagefilename 2 amp If Length RISMimagefilename 5 Case Length Right RISMim agefilename 3 3 Right RISMimagefilename l 3 Length Right RISMimagefilename 3
21. Text notes Text numberFound Calculation Number Unstored from Bibliography Get FoundCount omit_Chapter_from_calculation Text omit_Year_from_calculation Text Page Text PlacePublication Text Publisher Text selfReference Number series_title Text university Text Vol Text vol_no_in_series Text Year Text BibliographyPage_IS The table that links the bibliography to the Source table This table as well as providing that connection contains information about specific page numbers within an article or book that refer to the MS to which it is connected in addition further infor mation such as whether images are reproduced what type of information the article might contain and whether it includes edi tions of the music is entered in the CCM_info field This table also allows the user to define a bibliographical item as being of primary importance in describing the source manuscript and the field Marked_up_bibliography is the one that appears in the bibliography list on the website either in bold or normal font depending on whether the item has been marked as important by the database editor Field Name Field Type Formula Entry Option BiblAbbrev Text bibliographyKey Text Lookup When an entry in BibliographyPage_IS BiblAbbrev is made copy the first matching value from Bibliography bibliographyKey If no match Do not copy don t copy Bibliography bibliographyKey if empty bibliograph
22. alAffiliation This table lists the affiliations of persons linked to a manuscript i e listed in the manuscript description At present it connects to the Source table but can be used to refer to to individual works It is linked to the source database via the person author ity list alPerson Field Name Field Type Formula Entry Option affiliation Text affiliationKey Number Serial Number on creation with Current Value 424 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only alAuthor This table gives a list of names of authors of secondary source material It is related to the Bibliography database through an intersection set which gives the relationship of the person named to the bibliographical item i e author editor compiler pub lisher Festschrift dedicatee translator collaborator later editor Field Name Field Type Formula Entry Option Author_complete Calculation Text surname amp If IsEmpty firstname amp firstname authorKey Number Serial Number on creation with Current Value 2085 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only firstname Text g Key Number Indexed Auto
23. amp amp If IsEmpty PlacePublication Pla cePublication amp If IsEmpty Publisher amp lf IsEmpty Publisher 3 Publisher amp amp If IsEmpty Year n d Year amp amp If IsEmpty Page amp Page amp If IsEmpty notes amp notes amp If IsEmpty Author Surname Author Surname amp amp Author First name amp If IsEmpty Author2Surname amp Author2Surname amp amp Author2Firstname amp If IsEmpty Author3Surname amp Author3Sur name amp amp Author3Firstname amp If IsEmpty Editor Surname Ed itor Surname amp amp Editor Firstname amp If IsEmpty Editor2 Surname 0 amp Editor2Surname amp amp Editor2Firstname amp lf IsEmpty Editor3Sur name amp Editor3Surname amp amp Editor3Firstname amp lf IsEmpty Editor Surname If IsEmpty Editor2Surname ed eds amp translator info If IsEmpty Translator Surname If IsEmpty Au thor Surname amp Editor Surname trans amp Translator Firstname amp amp 26 Translator Surname amp trans amp Translator Firstname amp amp Trans lator Surname amp amp If IsEmpty Author Surname amp Editor Surname amp Translator Surname amp lf IsEmpty omit_Chapter_from_cal culation If sEmpty chapter_in_boo
24. bibliography fields in the Source table These fields are calculated and collate information from a number of other fields Therefore edits to these fields will have to be copied manually to the SQL version This should not be a problem and can be scripted to a button click 15 2 CONTENT 2 1 Layouts As described in 3 above the working database includes a number of relationships table duplications and re dundant fields that facilitate the creation of layouts that show information from a number of tables without the user having to keep a number of tables open at one time Further non essential fields in data content terms were introduced to allow the user to see lists within a form layout these are global fields which have the same value across the dataset They are not essential to the functioning of the database but are essntial to the func tioning of certain layouts They have been removed from the DIAMM_Shell version of the database as have most of the layouts used for data input in the working database The variety of different tasks undertaken with the content has led to a proliferation of layouts of varying com plexity An attempt was made to standardise down to three or four master layouts which showed all the in formation for a table and much of the information relating to it that was populated from the master table but these layouts became too complex in many cases for clerical clerical staff to navigate and had to be slimmed d
25. contents of a book The Image table can at this point be considered to represent pages in a book although it also includes pic tures of bindings and other material related to a MS as a physical entity An item may run over many pages or a page contain many items so an intersection set is used to connect the Item table to the Image table The web app was still yielding information basically at the level of the source since that was our primary unit at this point particularly as the data sources were variable in the amount of information they supplied so that the level of the source was the only one at which we could provide a parity of information even though it would range in content detail between sources 10 notationTypekey gt S fenotationTypekey aleourtyxey_ source imaeheaen abbreviation notation TypeKey notation_type L alcountrykey sourceKey notation TypeKey setkey f description Count 2iProvenance Ip setTyp SerTypekey alProvenancexe 5 bibliography ay 5j E f dustersheitmark soan a s description protectorate serkey ae Bt Se alcityKey source de city al_numbering_source EJ countryKey altRiSMabbrev local_spelling ch reniveker i authority E nn P y bibliography BiblAbbrey co nam Se a archivek CMimaget BiblAbbrev image zan _ bibliographyKey MME id bibliographypageKey CCM_garbage Pree Fe personkelationshipk Marked_up_bibliogr
26. correctly contain only the data set belonging to the city concerned but in FM the data delivered tends to be scrambled so the image list delivered is not reliable This means that in order to mine data in the Image table from the City table it is necessary to short circuit the relationship manifest above by creating a link directly between the City and Image tables Since FM will refuse to make a relationship between tables where one already exists it is necessary to create a secondary relationship bypassing the intervening tables In the ERD Entity Relationship Diagram this creates a prolifer ation of tables and in the actual data It involves the creation of some otherwise redundant fields City has a unique identifier cityKey field Archive connects to City using the cityKkey data Archive has a unique identifier archiveKey field Source connects to Archive using the archiveKey data Source has a unique identifier sourceKey field Image connects to Source using the sourceKey data and has it s own unique identifier imageKey field In order to bypass the interim relationships in the Archive and Source tables the Image table has to contain the cityKey data allowing the user to create a direct relationship between Image and City via the cityKey fields in each table This is long winded and should be unnecessary but has been used as a workaround when cre ating layouts that display data related to the master record being viewed often essen
27. different versions of primary images it allows us to link UV IR detail and enhanced images to the pri mary image of a folio and shows on the web interface in the image viewer tool called Alternative images It connects only to the Image table Field Name Field Type Formula Entry Option 39 archivedfilename caption datemodified filename ImageKey imagetype notes SecondarylmagesKey Set Text Text Allow user to override validation Maximum number of characters 255 Date Auto enter Modification Date Text Number Text Text Number Serial Number on creation with Current Value 1350 Increment I Allow user to override validation Required value Unique values only Only allow values of type Numeric Only Manuscripts or fragments may belong to sets e g a set of partbooks where the individual members are listed as individ ual sources in the Source table The Set table is placed hierarchically above the Source table but not between Archive and Source where it might be expected to reside since this would have involved allocating every manuscript to a set even if this was a set of only one Also since sources may belong to more than one set e g partbooks and Alamire books the connection between Set and Source has to be made through an intersection set SourceSet_IS which would cause fur ther redundancy if every source was included Therefore this table is tangentially above Source
28. its repetitive nature could simply have been entered in the Source_Copyist_IS but creating this as an authority list table was done to facilitate searching in the webapp Field Name Field Type Formula Entry Option copyist lype Text copyist lypeKey Number Serial Number on creation with Current Value 7 Increment Allow user to override validation Required value Unique values only Only allow values of type Numeric Only alCountry The country list refers only to the list of countries in which manuscripts are presently located This list could not be used also as an authority list for the provenance of manuscripts since that list would include countries that no longer exist or regions that are now part of another country This created a problem in presenting the data in the webapp since when a user was browing for manuscripts by country city they would see an entry for e g Burgundy which was nonsense Field Name Field Type Formula Entry Option abbreviation Text abbreviated form of the country name alcountryKey Number auto enter serial unique Country Text full name of country alCycleType When compositions are linked together it is necessary to define what type of connection links them e g a group of motets may actually be individual parts of one larger motet or may be individual motets linked together as a group by the composer or a later editor publisher Individual mass movements form part of a diffe
29. not copy don t copy Motetten Daten bank 07 Date Comments if empty Text Indexed from Source Substitute If IsEmpty external_URLs i TextStyleAdd lt strong gt External data sources lt strong gt Bold amp external_URLs amp J amp If IsEmpty description DIAMM amp descrip tion_RISM amp description _CCM Noonline description for this MS is cur rently available amp YJ amp If you would like to submit a description for this MS please send it to lt strong gt diamm at music ox ac uk lt strong gt for con sideration by the editorial board Authorship will be acknowledged amp Qlf IsEmpty description_DIAMM TextStyleAdd lt strong gt DIAMM in formation this information supersedes that given in RISM or CCM lt strong gt Bold amp If IsEmpty description_author amp description_author amp amp J amp description_DIAMM amp J amp If IsEmpty description_CCM _ TextStyleAdd lt strong gt Census Catalogue De scription lt strong gt Bold amp FJ amp See lt em gt Census Catalogue of Man uscript Sources of Polyphonic Music 400 1 550 lt em gt 5 vols Renaissance Manuscript Studies Neuhausen Stuttgart American nstitute of Musicology H nssler Verlag 1979 1988 amp Vol amp Substitute Substitute Left CCMimagefilename _delete 4 CCM amp p amp Right CCMim agefilename _delete 3 amp If IsEmpty
30. orderNo pars piecenumber PositioninMS nonPage jatureconfig RISMabbrev scribalhabit sourceKey StdTextSource text_incipit_source text_incipit_standard textNotation_styleKey textnotationcolour textType mensurationKey mensurationSign mensurationText A bibliographyKey itemKey notes F composerKe D biblAbbrev bibliographyKey composerKey notes attribution_uncertain composerKey compositionKey notes_attribution sourceKey attribution_authority attribution_uncertain composition_name compositionKey isorhythmic max_number_of_voices notes_concordances composition_cycleKey compositionKey order_in_cycle position_title bibliographyKey compositionKey notes a fe composerkey a aj dl AbbrevPosn AbbrevPosn altincipitfilename altincipitKey altitemKey incipitfilename itemKey PositioninMS RISMabbrev composerComplete composerKey date_earliest date_floruit_earliest date_florui date_latest dates_public firstname info info_source itemKey lastname sourceKey variantspellings compositionKey genreKey itemKey textKen composition_cycleKey composerKey composition_cycleKey cycleTypeKey title title_model_compositionKe IscycleTypeKey cycleType cycleTypeKey 3 USER INFORMATION Introduction An understanding of the way a relational database works is essential to understanding how data is managed within t
31. out of pages in this volume Length Right RISMimagefile namel 4 1 4 Right RISMimagefilename 4 Length Right RISMimagefilename 4 3 0 amp Right RISMimagefilename 54 Length Right RISMimagefilename 4 I 2 00 amp Right RISMimagefilename 4 Length Right RISMimagefilename 4 1 1 000 amp Right RISMimagefilename 4 Whoops you ve run out of pages in this volume Calculation Text Unstored from Source Left RISMimagefilename2 2 amp If Length RISMimagefilename2 5 Case Length Right RISMim agefilename 3 3 Right RISMimagefilename2 3 Length Right RISMimagefilename 3 1 2 0 amp Right RISMimage filename2 3 Length Right RISMimagefilename 3 1 1 00 amp Right RISMimagefilename2 3 Whoops you ve run out of pages in this volume Case Length Right RISMimagefilename 4 1 4 Right RiISMimagefilename2 4 Length Right RIS Mimagefilename 4 3 0 amp Right RISMimagefilename2 4 Length Right RISMimagefilename 4 2 00 amp Right RISMimagefilename2 4 Length Right RISMimagefilename 4 1 1 000 amp Right RISMimagefilename2 4 Whoops you ve run out of pages in this volume Text Text Text Text Text Text Text C
32. pressed by a series of authority lists related to the Source table through intersection sets The growing population of the database which by now had far exceeded just those sources for which we had images led to what had previously been managed in fields being migrated to authority lists notably information about the type of notation used in the document Although strictly this might not have needed to be treated this way the authority list improves searching in the web app but more importantly would allow the academic con tributors to look at the source descriptions and bring terminilogy up to date across the board with this method of data management gt e s notationTypekey Gam OOOO fr aicoumryxey a kals MusicNotation abbreviation aa notation TypeKey notation_type alcountrykey sourcekey notation TypeKey Co alProvenance a alProvenancekey aty SAE e country a rotectorate aad countrykey alcityKey composerkey Marked_up_bibliogr Page Festschrift FullText_calculated InformationSource Journal no_of volumes lt ography notes omit_Chapter fro affiliationKey copyistkey opyistName r jesetTypekey E Peescription vp gt setTypexey The discussion surrounding the categorisation of sources into sets gave rise also to the addition of an author ity list to manage scribes copyists with a further authority list attached to the intersection set that
33. thing as a null value in FM the SQL end has to be set up so that fields allow the FM content i e no character limit Unfortunately one problem remained in version 0 that of export character sets i e Unicode export which quickly manifested itself in accents common to e g German and Polish place names and texts FM version fixed this problem but because version has some significant bugs most data input is still done in v 10 Although FM allows the user to format field content e g bold italic fonts colours etc that formatting is not carried over when exporting to SQL since SQL does not recognise formatting Field lengths in the DIAMM dataset vary massively from single character Y N or numeric fields to fields which contain a discursive text description of a document that can run to many paragraphs and thousands of char acters This is because much of the DIAMM data was created outside a database environment e g printed cat alogue descriptions of documents and never intended for a database environment These field lengths and content aspects can be a problem when communicating with SQL which is designed for smaller content parcels e g it has a default field length setting for new fields of 256 characters The most difficult problem that arises when exporting FM tables to SQL is that FM allows broken dependen cies In other words if we create a source record and link bibliographical items and inventory items
34. DIAMM database documentation April 201 Julla Craig McFeely l HISTORY I I Software l 1 2 Data 2 1 3 Deficiencies and workarounds 2 1 4 Sharing data with MySQL 3 I 5 Bugs 5 1 6 Evolution and Development 6 2 CONTENT 2 1 Layouts l6 2 2 Data l6 23 Tables and Fields 17 2 4 Entity Relationship Diagram ERD 49 3 USER INFORMATION 3 1 Editing existing records 50 3 2 Creating new records 5I HISTORY l l Software The DIAMM database was originally constructed and populated in Filemaker Pro version 4 0 This version of Filemaker henceforward FM although claiming to be relational actually created data tables in individual files and these files were linked via relationship fields Version 7 0 however changed the software drastically making it truly relational so all tables of a database now exist within a single file or document Filemaker is a very forgiving medium allowing the user to create a custom workspace that many other soft wares would not allow The GUI allows the creation of custom layouts to suit numerous different types of task facilitating quick and easy data input for all types of job The software is also cross platform Mac PC which was a major reason for its selection early on in the proj ect since participants used both platforms Primary platform Mac 1 2 Data The core data was originally created to allow the team to control information about libaries that it was visit ing to und
35. Formula Entry Option attribution_uncertain Text copyistkey Number copyist TypeKey Number item_Copyist_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only itemKey Number Item_Person_IS Just as the Source table links manuscripts to individuals or institutions via the Source_Person_lS this intersection allows in dividual items to be linked to entries in the alPerson table Field Name Field Type Formula Entry Option attribution_uncertain Text itemKey Number rtem_Person_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only personKey Number personRelationshipKey Number Itemlmage_IS As its name suggests this table connects the Item and Image tables generating a connection that allows us to see which im ages match which items This intersection is necessary because there may be more than one item on a page or an item may run for several pages Field Name Field Type Formula Entry Option altincipitfilename Text Lookup When an entry in Itemlmage_IS itemKey is made copy the first matching value from Item altincipitfilename If no match Do not copy don t copy Item altincipitfilen
36. RE IN THE PRACTICE DATABASE RGB 0 0 0 AbbrevPosn Calculation Text from Item RiISMabbrev amp amp PositioninMS alt_numbering Text altincipitfilename Text altincipititemKey Number Lookup When an entry in ltem itemKey is made copy the first matching value from altincipit by ttemKey altitemKey If no match Do not copy don t copy altincipit by ttemKey altitemKey if empty blueDog Text catalogDesignation Text Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 24 Catalog designation If no match Do not copy don t copy Motetten Datenbank 24 Cata log designation if empty commentsonhands Text complete Library Info Calculation Text Unstored from Item Source Complete Library info complete Text_original Text Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 36 Complete Text Orig inal If no match Do not copy don t copy Motetten Datenbank 36 Complete Text Original if empty complete lext_standard Text Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 37 Complete Text Stan dard If no match Do not copy don t copy Motetten Datenbank 37 33 composerOriginal composerStandard composition_gathered compositionKey concordances dateComposed
37. Source dateOfSource amp amp If IsEmpty sourcelype sourcelype amp amp If IsEmpty provenance provenance unknown provenance amp provenance amp If IsEmpty sourceName amp sourceName useDescription_for_tag Text webpermission Text Auto enter N Source_Copyist_IS Intersection between the Source and alCopyist tables The type of copyist e g music text illuminator etc is defined in al Copyist Type which is connected to these tables via this intersection set since a copyist may appear in various books but not always in the same role so the information has to be contained in the intersection Field Name Field Type Formula Entry Option attribution _uncertain Text copyistKey Number copyist lypeKey Number source_Copyist_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only sourceKey Number Source_Person_IS intersection between Source and alPerson allowing more than one person to be linked to any source and more than one source to be linked to a person Field Name Field Type Formula Entry Option attribution_uncertain Text personKey Number personRelationshipKey Number sourceKey Number source_Person_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1
38. ade copy the first matching value from Motetten Datenbank 32a Motet incipit Stan dard If no match Do not copy Auto enter Calculation from Item If IsEmpty Motetten Daten bank 25 Order in source 0 Motetten Datenbank 25 Order in source IFnodremxeudla A Eutnot reyn Otepr tciaolnculation from ltem If IsEmpty Motetten Datenbank 25 Order in source O Motetten Datenbank 25 Order in source Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 24 Catalog designation If no match Do not copy don t copy Motetten Datenbank 24 Cata log designation if empty Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 30 Motet comments If no match Do not copy don t copy Motetten Datenbank 30 Motet comments if empty Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank motetKey If no match Do not copy don t copy Motetten Datenbank motetKey if empty Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank MOTET shelfmark If no match Do not copy don t copy Motetten Datenbank MOTET shelf mark if empty Lookup When an entry in Item MOTETkey is made copy the firs
39. alCountry alcountryKey if empty Text Unstored from Archive Source shelfMark alone amp amp Source folio amp Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only Indexed Indexed Auto enter calculation from Archive 99 replaces existing value Allow user tooverride validation Required value Only allow values of type Numeric Only Global Indexed Indexed Text lt The full text of this field is not displayed here as it changes de pending on the needs of the letter to be written to the library This is a calculated field that draws on the list of sources for the library and is 23 Phase postprocessingdone preliminary readyforvisit replyreceived requiresPAT C responsefrom responsefromdate salutation SelfGlobal siglum someoutstanding sourcesfromthisarchive statuslist telephone telephoned totalcity totaldays totalimages updated url url_original visitdates worthprodding written AuthorBibliography_ S dependent on information provided by other fields gt Text Text Text Text Text Text Text Text Text Indexed Number Global Text Indexed Text Number of MSS in the archive in which we are interested Calculation Text from Archive city amp amp archiveName amp amp currentstatus Text Date Text Number n
40. alculation Text from Source If IsEmpty RISMimagefilename RISM Text Auto enter Calculation from Source RISMimagefilename Number Calculation Text from Source shelfMark alone amp amp Tags amp Text Number Allow user to override validation Required value Calculation Text from Source shelfMark alone amp If IsEmpty sourceName amp N amp sourceName amp amp If IsEmpty olim olim amp olim Number Serial Number on creation with Current Value 3863 Increment 1 Required value Unique values only Only allow values of type Nu meric Only Text Lookup When an entry in MOTET to source sourceKey is made copy the first matching value from Motetten Datenbank 0 Source Name If no match Do not copy don t copy Motetten Daten bank 01 SourceName if empty Calculation Text from Source shelfMark alone amp fols amp folio Text Text Text Text Number Auto enter Calculation from Source Sum noofimages Calculation Text Unstored from Source TextFont TextColor city amp amp archive amp amp shelfMark alone amp amp folio amp If IsEmpty noofimages total images amp noofimages amp RGB 255 255 255 Arial 45 surface Text Tags Calculation Text from Source If useDescription_fortag I description_DIAMM If IsEmpty dateOf
41. allows more than one notational type to be defined for each MS and for individual items to have their notation specified although that table is not yet populated As with the genre list above this list contains items of varying gran ularity based on the information available In some cases a term as general as mensural is the only information while in oth ers information such as black full and black void mensural and minim replaces undifferentiated semibreves is available The content of this list is based solely on the descriptions provided by the printed catalogues and some 80 musical notation types are presently defined Field Name Field Type Formula Entry Option alNotation TypeKey Number Serial Number on creation with Current Value 87 Increment 1 Allow user to override validation Required value Unique values only g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only 20 notation_type Text alPerson The Person table lists names of people associated with manuscripts who were not copyists These could range from an owner or dedicatee to the person who discovered the book in modern times lt does not however include the names of composers found in the book unless a composer was also an owner It is linked to the Source table by an intersection set Source_Per son_IS which is informed by a further authority list alPer
42. also allow us to create information about the connection between information in two tables For example the intersection set between master tables and the bibliography connect a source item composition composer etc to the bibliographical item but the intersection set indicates the page relevant to the master item The following information is colour coded Table names Field names Link field names used in relationships Fields in the Filemaker database that are not included in the SOL database The following lists show the table and field content of the working DIAMM database filename DIAMM with a short explanation of the content of the table Field names in this colour are those omitted from the DIAMM_Shell database which eliminates redundant fields and tables Calculation fields in DIAMM are Text only in DIAMM_ Shell The database can be copied and renamed DIAMM_RUBBISH for the purpose of creating a practice database the name of the file is crucial as the use of the word RUBBISH in the title triggers a conditional formatting script that will automatically place a warning flag on all layouts reminding users that they are not working in the main database Table names prefaced by al are authority lists Table names suffixed by _IS are intersection sets field names suffixed _g are global fields Key number fields usually these are the fields are the ones used for creating re lationships are suffixed Key
43. ame if empty folio Text Lookup When an entry in Itemlmage_IS itemKey is made copy the first matching value from Item Folios If no match Do not copy don t copy Item Folios if empty imageKey Text incipitfilename Text Lookup When an entry in Itemlmage_IS itemKey is made copy the first matching value from Item incipitfilename If no match Do not copy don t copy Item incipitfilename if empty itemimage_IS_KEY Number Serial No on creation with Current Value 3782 Increment Required value Unique values only Only allow values of type Numeric Only itemKey Text orderNo Number Serial Number on creation with Current Value Increment sourceKey Text Lookup When an entry in Itemlmage_IS imageKey is made copy the Lost Motets first matching value from Image sourceKey If no match Do not copy don t copy Image sourceKey if empty THIS TABLE DOES NOT APPEAR IN THE SQL DATABASE This is a list of motets found in the MOTET database that don t ap 37 pear to have an analog in our DB or existing inventories They have therefore been removed from the DIAMM item table and placed here rather than deleting them altogether Field Name Field Type Formula Entry Option motetKey Number notes Text title Text Lookup When an entry in Lost Motets motetKey is made copy the first matching value from
44. argely not available online it is reasonably easy for a user to find out more about a composer from e g GroveOnline and this resource is not intended to provide a composer biography for every composer in the period However for administrative purposes it is useful to have biographical information as a way of assisting us in working out which composer 29 might be intended by an ascription that is not clear The table is linked to the Composition table via an intersection set that al lows us to define whether an ascription is certain or dubious and is also connected to the Bibliography table via intersection set Field Name Field Type Formula Entry Option composerComplete Calculation Text from Composers lastname amp If IsEmpty firstname amp firstname amp If IsEmpty variantspellings amp variantspellings amp composerComplete_reverse Calculation Text Indexed from Composers TextFormatRemove last name amp If IsEmpty firstname amp firstname amp If lsEmpty variantspellings amp variantspellings amp composerKey Number Serial Number on creation with Current Value 1082 Increment 1 Required value Unique values only Only allow values of type Nu meric Only date_earliest Text date_floruit_earliest Text date_floruit_latest Text date_latest Text dates_public Text firstname Text g Key Number Indexed Auto enter 99 Al
45. ase country and city tables were added and the data was adjusted to utilise these new tables Shortly after this the project received funding to deliver the image content online and it was clear that it would be necessary to accompany the images with a metadata framework in which to nest the images so that they could be viewed not simply as isolated images but components of a clearly described object It made sense to utilise an extended version of the existing database and this led to the first major extension to content The descriptions were available in two printed catalogues RISM and the Census Catalogue both well known to scholars of the period Permission was obtained to put the catalogue entries in the RISM volumes into the data base and the Source table was expanded considerably to allow this inclusion The catalogue information contained lengthy bibliographies expressed in the printed books in the form of a list of abbreviations which referred to a master bibliography appended to the volumes Rather than simply re produce these relatively meaningless lists a bibliography table was added and related to the Source table via an intersection set and using the bibliographical abbreviation to connect the tables Funding allowed the creation of an Item table to represent musical compositions within each source This was the first table that fell outside the simple top down hierarchical model that had been used hitherto and since many items c
46. at are split into internal sections that may sometimes appear as individual works in different sources Field Name Field Type Formula Entry Option composer Text Lookup When an entry in Composition_cycle composerKey is made copy the first matching value from CompCycle_Composer lastname If no match Do not copy don t copy CompCycle_Composer last name if empty composerKey Number Lookup When an entry in Composition_cycle composition_cycleKey is made copy the first matching value from Composers composerKey If no match Do not copy don t copy Composers composerKey if empty composition_cyclekey Number Serial Number on creation with Current Value 24 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only cycle TypeKey Number title Text titlke_composer Calculation Text title amp amp composer title_model_compositionKey Number CompositionGenre_IS Intersection set between Composition and Genre This allows us to designate more than one genre per composition the term genre is used quite loosely allowing us to designate both large and small groups of works to which a composition belongs For example a work entitled Ave Regina is designated both motet and ave regina since ave regina is an antiphon text set very widely and by many composers Similar
47. ation is the text Unlike later orks certain genres in this period might have different texts in each voice and so the Item table was far from sufficient in itself to express the individual information about each voice part in the iteration of the item Since an item might have a different i number of voices in disparate sources this also made it neces wem sary to differentiate the voice part information from the overal Item information A Text table was introduced to handle the con tent of each voice part and that table required a number of au thority lists to govern its content in turn The text underlay required the definition of language and this is semen linked via intersection set as some texts particularly troped texts use more than one Language Since the Text table repre sents a voice part there should be a text record for each voice in an item information about clef mensuration and voice des ignation are given in this table These are also managed with sim ple authority lists No attempt is made to indicate changes of mensuration or clef during the course of a piece only those shown at the start mensurationkey mensurationsign mensurationText 14 Finally three intersection sets were added between the Bibliography table and other tables where individual bibliographical information about more granular content was available Composer Item and Composition shown below in black and h
48. ationships and fields were eliminated creating an intelligible ERD which although still complex is sufficiently concise that it can be understood by a database technician This is the ERD in use in this document 1 4 Sharing data with MySQL The web delivery of data is from a SQL database which means that all FM content must be exported from FM and imported to SQL Compared to SQL FM is extremely forgiving allowing redundant relationships see above and various other character and content oddities which blew out the SQL version when the data was exchanged In earlier versions of FM exchanging data caused some considerable problems since ODBC support in FM even in versions 7 9 was shaky to say the least Exchange was managed through perl scripts that first exported 3 the data from FM then imported it to SQL a tedious and time consuming process which had its own prob lems caused by e g default field character limits in SQL Later versions of Filemaker improved communication radically version 10 and not only allowed a Filemaker front end to display data from a SQL back end but also to import export data seamlessly between the two platforms This however requires that the SQL end to be set up in a very specific way Since FM allows certain types of data that SQL does not e g empty content in fields defined as numeric no default character limit on field lengths and does not recognise certain types of data e g there is no such
49. be tolerant of these variations A web browser will also change some fonts despite the use of web compatible fonts throughout but this has not created any immediate problems One caveat regarding versions FM v 9 will run most scripts in the database and should run all the scripts How ever we have found that many of the editorial board layouts require FM v 10 to run the scripts in that section which are more complex in order to simply access to the end user correctly The main visual difference be tween v 9 and v 10 is that the toolbar in v 9 appears on the left edge of the view and has been moved to the top of the view in v 10 This is something of an annoyance in layouts that were optimised for vertical screen real estate since they now appear chopped off at the bottom edge This section of the database documentation does not provide a user manual as such since the layouts ac cessed from the entry layout or database Home page are documented with instructions for use on the lay out so that instructions for each step are available at the point of access The Editorial Board should access the 50 database from the Editorial Board button and more experienced users from the Admin button jek mai roven Clicking the Editorial Board button F takes users into the heavily scripted apart of the database where all activ Hk ity is carefully guided from a series of Home XPlicit buttons At any point the user can
50. ber of voices in a work can vary sometimes by design and sometimes because the piece is preserved incomplete The Item table show the number of voices shown in that instance of a composition but this table shows the maximum number of voices Field Name Field Type Formula Entry Option attribution_authority Text composerAttribution Text Lookup When an entry in Composition compositionKey is made copy the first matching value from Item composerOriginal If no match Do not copy don t copy Item composerOriginal if empty composition_name Text Lookup When an entry in Composition compositionKey is made copy the first matching value from Item composition_name If no match Do not copy don t copy Item composition_name if empty compositionKey Number Serial Number on creation with Current Value 5 1254 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only compositionModelkey Number Auto enter 0 isorhythmic Text max_number_of_voices Number notes_concordances Text 30 TITLE Text Composition_cycle This table allows us to create a governing cycle which a set of compositions may belong to Cycles range from groupings of mass movements which may not be copied consecutively in a MS to motet cycles created by a publisher It is also used to link pars items in motets or other works th
51. blioqraphyKey falitemTet authority eee notes DyistTyp itemkey i ey annotKey fullannot shone lingincipit mensurationkey mensuratior mensurationText A new strategy regarding data input and layout content will be adopted on conclusion of the 201 data input work the upload process is slow and clumsy has to be done in a certain order and is liable to problems if an upload fails that need to be fixed by a server administrator Uploads of the entire dataset are therefore unde sirable particularly if they are being done simply to implement minor changes in one table or even one record When data input ceases therefore a single master upload will take place and then the content of the work ing layouts will be changed so that the fields users edit in the database will actually be fields in the SQL data base not FM fields When corrections are done they will appear immediately in the web app on the live staging server and can be checked there and then that version of the SQL data can be pushed to the live server This circumvents any upload from FM to SQL and eliminates the risk of loss or corruption of the master data base following a crash As this means that there would be no local record of changes to the master dataset the relevant fields in the FM database will become lookups that will copy data from the SQL fields providing a local backup for the content The major exceptions to this will be the description and
52. ching value from Source sourceKey If no match Do not copy don t copy Source sourceKey if empty The Item table is one of the primary tables in the database it lists the individual items within a mansucript i e the inventory and hierarchically would come immediately below the Source table The items represent the individual and specific appearance of a work in a manuscript not the intellectual concept of the work so each entry is unique Each work in a manuscript is de scribed as an inventory ITEM However we do not list non musical contents of manuscripts or at least not consistently Occasionally a source might contain blocks of monophonic chant interleaved with polyphonic items In this case the first item might say items 1 37 mass proper chants and the next item would refer to the first polyphonic work in the manuscript This table has one of the widest set of interconnections to other tables the most important one being to the Composition table in which each instance of a work entry in the item table is linked to the intellectual concept of a composition the idealised form of the work to which all individual instances of that work are linked The Item and Image tables are linked via an intersection set Itemlmage_IS Field Name Field Type Formula Entry Option _PracticeDBwarning Calculation Text Unstored from Archive TextColor If Right Get FileName 7 RUBBISH YOU A
53. d or will appear online so extensive editing will be lost Creating a new Archive Check to see that the country and city for your archive already exist before attempting to create a new archive There is no point in creating archives unless they contain sources so do not create archive records just because the library exists in the real world the dataset ONLY includes archives in which there are manuscripts relevant to this dataset Creating a new Source Check to see that the Archive you want to put your source in already exists before you create the new Source record You will need the archiveKey number in order to link the new manuscript record to that library Do not add printed sources to this dataset unless they are unique or contain manuscript additions Creating new Bibliographical citations Check first that the citation does not already exist be careful to ensure that you do a sufficiently broad search that you will find any possible matches Creating new Inventory Items Inventories will be sorted by the order number of the items so each piece in an inventory needs to be num bered The foliation is not sufficient since foliations vary so much that there is no consistent sort order that can be applied Julia Craig McFeely Oxford April 201 52
54. data so providing the user with searchable information would involve the textualised transcription of much of the data encapsulated in the music into text fields and tables This formed the basis for what would later become the Item table and its satellite and related tables and authority lists The analysis shown below concentrated only on the text parts of the information the markup omits data such as clef men suration key signature layout or primary pitch manifest in the musical notation many of which were subse quently transcribed into the database Jf last line of aG with the following Expi contains 4 known composition there are in score with 7 i however while Das the same These include f 1v 2v 4v 7 8v 9v 11 hysical make up gatherings sections divisions SA f 15v 10 Fol 17 20 contained BIBLIOGRAPHY Music I ApelF no 69 transcription of CA 1328 44 type of ruling rastrum hand stave height initials on page y n historiated or plain initial letters composers clefs mensurations key signature general notes Books and Articles extracted by eye from RISM incipit unless described in text information may have to be taken from image if not detailed in th text Items represent an isolated instance of a composition an intellectualised idea of a musical wor
55. dateCopied DIAMMink EarpDesignation editing_history edition foliationPagination folio_end folio_end_alt folio_end_serial folio_end split folio_start folio_start_alt folio_start_serial folio_start spilt Folios g_composerkey g_Key genre genreKey Global incipitfilename Text Text Calculation Number Text Text Text Text Calculation Calculation Text Text Text Text Calculation Calculation Text Text Calculation Calculation Text Calculation Number Text Number Number Text Complete Text Standard if empty Text from Item Substitute composition_gathered J untexted untexted composition_name Calculation Text Unstored from Item If IsEmpty useMotet_DB_title If IsEmpty useGenre If IsEmpty composition_gathered Motet_incipit_standard composition_gathered alGenre Genre Motet_incipit_standard Lookup When an entry in ltem MOTETkey is made copy the first matching value from Motetten Datenbank DIAMMink If no match Do not copy don t copy Motetten Datenbank DIAMM ink if empty Text Unstored from Item Item to Source EarpDesignation Text from Item If IsEmpty logged_in_as editing_history Get AccountName amp amp modification date amp YJ amp editing_history from ltem If IsEmpty logged_in_as editing_history Get Acco
56. e implemented online at a later date for RISM Field Name Field Type Formula Entry Option AZ Text 28 archiveKey Number catalogueindexesKey Number Serial Number on creation with Current Value 1 196 Increment 1 Allow user to override validation Required value Unique values only CCMvol Text CCMvol2 Text CCMvel3 Text CCMvol4 Text countryKey Number RISM_BIV_I Text RISM_BIV_2 Text RISM_BIV_3 Text RISM_BIV_4 Text RISM_BIV_5 Text RISM_BIV_supplement Text Composerlink_IS This table links compositions to composers In the period covered by the sources in this dataset it is not uncommon to find works ascribed to more than one composer or for an ascription to be uncertain The connection between the two tables is made using this intersection set which is also used to define whether the connection is only an uncertain one and allows for a note to be added to the attribution Many of the fields in this database are redundant copies of fields from the connected tables to facil itate display in the working database Field Name Field Type Formula Entry Option attribution_uncertain Text composerKey Number composerlink_IS_KEY Number Serial Number on creation with Current Value 2 169 1 Increment 1 Required value Unique values only Only allow values of type Nu meric Only Composername Calculation Text Unstored If IsEmpty Composers firstname Com posers firstname amp amp If
57. eKey ion f gs notation yp setKey E Paescription setTypekey setTypekey bibliography clusterShelfMark 5S description anue T Ue cekey sce e archive website personkey aas S Tont jigitised e io Journal modification date olim affiliationkey E no_of volumes aliases n ena rstNames omit Chapter fro ae tation fullname Famiianonkey rromi and provenanceCom 0 ta ha nc she ries _tithe oor e SEO relationshipType MotetSourceComments M text incipit _source text_incipit standard textNotation_styleKey textnotationcolour textTyp The Composition table is in turn linked via intersection set to a Composer e table which manages alternative or multiple attributions of a work to a num iip altincipititemkey catalogDesignation ber of composers Each composition is also linked by intersection set to a sms Genre authority list which categorises works in both general and specific i terms allowing any work to be allocated a number of genres info_source The following diagrams for the sake of clarity deal mainly with a master men ee table and its satellites generated following analysis of the otherwise un searchable data provided by a musical incipit At the time of writing this sit BEER variantspellings MoterSourceComments uation is changing but since so much music would need to be typeset in r Pieci order to create a searchable bod
58. eferences in each citation and any other notes pertinent to the instance of the reference in the Source description One of the key search areas online was the provenance field in the Source table and this was inefficiently managed by a repetitive text field The addition of a simple provenance authority list was first implemented but as the content grew in complexity an intersection set was added to allow more detail about provenance to be added where it was available without unnecessarily expanding the main provenance authority list which 7 was limited to countries at that point Given that the intention was eventually allow users to search on the au thors of bibliographical items an Author authority list with intersection set was also added With the expansion in data content and the increased involvement of a larger number of researchers in cre ating and using the data we found that there was a need for a facility that would allow us to group manuscripts together in different types of Sets Some groups of sources that were spread over many libraries and coun tries belonged together since they were fragments that had been dispersed over time This was one type of set Another type was of members of partbooks groups of books copied separately and each providing a single voice part for a multi voice work Some of these books were shelved together in one library while oth ers had been dispersed much as the fragments had been Up to th
59. enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only surname Text alCity The listing for archives and libraries has two parent tables alCountry and alCity alCity acts as an intersection set between Archive and alCountry It simply lists all cities for which the database lists a library City can mean a much smaller location such as a village if the library is not located in a major urban centre Field Name Field Type Formula Entry Option alcityKey Number auto enter serial required value unique city Text name of city countryKey Number Key field used in relationship to alCountry g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only alClef A simple authority list with lists all the clef types in use and relates to the Text table since that table effectively represents the individual voice parts of a piece even when these are untexted Field Name Field Type Formula Entry Option clef Text clefKey Number Serial Number on creation with Current Value 87 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only alCopyist The copyist authority list
60. eric Only voiceKey Number voicepart Text TextLanguage_I S Intersection set between Text and Language allowing the text of a voice part to be linked to more than one language e g a latin sacred text that has a vernacular trope Field Name Field Type Formula Entry Option languageKey Number textKey Number textLanguage_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only db_globals In order to facilitate navigation around the database for editors this table and its fields have been added to operate back and forward buttons placed in layout headers The scripting and calculations of this table are not reproduced here as they are the intellectual property of Robin Ledward 2 4 Entity Relationship Diagram ERD The historical development of the database has been described in section above together with various ver sions of the Entity Relationship Diagram The final ERD at the cessation of development and content input work in May 2011 is represented by the database table and field descriptions above and the complete ERD given below This ERD represents the idealised database structure The structure of the working database includes numerous links and relationships not shown here that are used solely to facilitate the construction of working layouts that create speci
61. ertake photographic work it held contact information summaries of corresponence and licensing agreements and lists of manuscripts basic descriptions of the material to be photographed and once the pho tographs were taken a list of image filenames and the pages to which they referred It was not originally con ceived as the back end to an online delivery system The database grew organically with need and was therefore not planned from the outset at the level of com plexity that it now shows The original core tables were Archive which included country and city information now migrated to separate authority lists and informa tion about licensing and correspondence dates of visits and other information relating to imaging in that library or collection Source related to Archive which contained only very basic physical information such as page extent and measurements to give the photographer information to allow for planning of imaging work Image related to Source and containing information about the images taken at the archive Photographer information about the photographer who created the images this table is no longer included in the data structure The first change to the content was necessitated by the growth in the number of archives and countries being visited originally the dataset was only designed for UK libraries and so there was no need to indicate the coun try When the project extended into Europe in its second ph
62. ey notation_type z Key notation Typ w v counteyKe local_spelling a B i be notationTypeKey d notationT J alcountryKey Source gt abbreviation ai alcountnyKey f sourcel Pcescrpnion Count sitrovenence _ JP p P setTypexey alProvenancekey f bibliography ity E chustersheitmark country a gt s description oo a dse O Uie cout Elet archivekey cgi pr soe BiblAbbres BiblAbbres CCM_gar p cpersenkey I lt nersonRelationshinkey ssourceKey attribution_uncertain personkey personRelationshipKey sourcekey notes numbering source E olim inf ri r Journal no_of volumes bibliographykey pageMeasurements notes provenance nar omit_Chapter_fro omit_Year_from_ lt RiSMimagefilenamel RiSMimagefilename personRelationshipk copyistkey copyistTypeKey sourceKe affiliationKey copyistKey opyistName In terms of timing these satellite tables actually post dated the expansion of data content to increase the base granularity from the level of the Source or manuscript to that of the Item within the manuscript but it is de scribed here in relation to the base table since this makes it easier to understand the overall structure Since items within a manuscript i e musical compositions do not correlate with images or pages within a source a new table Item was introduced to the structure which enabled us to list the
63. fic environments for different types of data input such as the inclusion of portal list ings of content from other related tables shown in a master table layout These redundancies have not been removed because they all perform some function in assisting non expert users to populate read and use the Filemaker database It might be useful at some future time to reconstruct the database from scratch to try and eliminate some of these additional structures as well as some of the lay outs that were designed for particular tasks now completed but they have been left in place for the time being 48 abbreviation alcountryKey Count alcityKey city countryKey local_spelling address address1 address2 address3 address4 addressS address6 address7 address8 address9 alCityKey archiveKey archiveName 5 city copyrightholder emai fax librarianA librarianB notes siglum telephone url_original gl archiveKey _ AZ archiveKey catalogueindexesKey CCMvol1 CCMvol2 CCMvol3 CCMvol4 countryKey RISM_BIV_1 RISM_BIV_2 RISM_BIV_3 RISM_BIV_supplement Key alProvenance notationTypeKey sourceKey alProvenanceKe country BiblAbbrev bibliographyKey bibliographypageKey composerKey Marked_up_bibliog notes ArticleTitle BiblAbbrev bibliographyKey BookTitle chapter_in_book degree dissertation Festschrift FullText_calculated InformationSource Journal no_of_volumes notes Page
64. ge allanguage TextLanguage_I S TextLanguage BiblText_IS Bibliography Text Itemlmage_IS ltemlmage 1 5 Bugs When uploading to the SQL database the server will crash if the upload returns an error message IF copies of any databases on the server are open on any computer other than the one where the upload is being man aged This also unfortunately happens if another database is open on the server which has a connection to the same ODBC data source An attempt to replace some fields in FM layouts with their SQL counterparts had to be abandoned since this caused the Filemaker server to crash when an upload to the SQL database was done It also apparently caused entire table uploads to fail FM v I Layout Menu system if folders or dividers are introduced the menu fails to display the complete or partial list of layouts either in browse or layout view and hides foldered sets of layouts even when they are removed from the folders The effect of this problem took some time to fix 1 6 Evolution and Development The DIAMM database evolved over a very long period approx 2 years and changed in content to reflect both the changing needs of the users of the data and the changing purpose for which the database is used The following diagrams show original tables for the first DIAMM web app in green new master tables in red authority lists in blue and intersection sets in yellow The full ERD slightly larger appears on the last page of thi
65. his database The foregoing documentation should explain this sufficiently Working with a database is VERY DIFFERENT from working with work processed files if you want to add a bibliography item to a source description you cannot simply cut and paste it into the source description The bibliographical ttem has to be created in the bibliography database assuming It is not there already so that has to be checked too marked up by distributing the information into individual fields title authors journal date etc that record has to be linked to the Author database and only then can the bibliography record be linked to the source you wanted it to link to In the same way deleting material is not simply a question of hitting delete If you delete a source record you must first delete all dependent records items images bibliography items etc that are connected to the source record You cannot delete items without also first deleting the text clef language voice designation etc de pendencies to each of those records and in many cases this means also chasing down bibliographical references to item records and deleting those dependencies as well before you can delete the item Records are connected by unique key numbers but if you inadvertently change a key number you can com pletely disconnect and corrupt the data that flows from it For example if in editing a Source record you ac cidentally delete or change the ArchiveKey numbe
66. ighlighted along with the existing Source to Bibliography intersection The ex isting intersection set betwen the Source table and Bibliography was not used for this purpose to retain clar ity between the relationships The intersection sets include notes fields that allow the user to indicate pages etc This is the only relationship where the key numbers are not currently used to connect tables the bibliog raphy intersection sets were set up to allow users to link from a bibliographical abbreviation to the master bib liography record and for this reason the relationship is currently managed via this field Given the prevalence and widespread usage of the abbreviations it is not presently practical to change that connection to a simple numeric one although the numeric connection is in place and is used by the SQL version of the database i n notatonTypekey lt fenotatonTypekey P E MusicNotation notationTypeKey notation _type sourceKey notation TypeKey 5 TA alRiSMabbrev Si E anori je BiblAbbre CCMabbrev ss grees ser lareOfSource soure Mi ou BiblAbbrev l rcoke BiblAbbrev EJH biblicgraphykey e CCM_garbage arkes journal modification_date no_of volumes composi order _in_cycle position title tad v gt cop a clefKey Catimagefiename on io editorial_voic o mposi keyNo_order an biun bi
67. in a different language that usage is dealt with by each voice part or Text having its own language designation Field Name Field Type Formula Entry Option language Text languageKey Number Serial Number on creation with Current Value 12 Increment 1 Allow user to override validation Unique values only Only allow val ues of type Numeric Only alMensuration This table provides the first mensuration for a voice part that appears in a work It is linked to individual voice parts of individ ual instances of a work since different voices may use a different mensuration and a work may be copied using a different men suration in a second source We did not attempt to define mensuration changes that occur during the course of a piece This would make the content extremely complex since it might be considered necessary to define at what point a mensuration changes That information was considered unnecessary for this level of data presentation Field Name Field Type Formula Entry Option mensurationKey Number Serial Number on creation with Current Value 29 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only mensurationSign Text mensuration Text Text alNotationType A simple list of types of musical notation in use in a manuscript It is linked both to the Source table and the Item table via intersection sets which
68. is point we had listed sets of partbooks in a library under one shelfmark as a single source However it became evident when dealing with descriptions that in some cases each book might require its own description rather than sharing a blanket description with the whole set The decision was taken therefore that a each entry in the Source table should represent a sin gle book or manuscript item and that sets should be linked together by causing them to belong to a master item in a Set authority list There was briefly a question as to whether the Set table should act as an inter section set between the Archive and Source tables but as this would have meant that the great majority of sources would belong to a set of one this option was quickly abandoned As it turned out the necessity for some sources to belong to more than one set necessitated the insertion of an intersection set in any case be tween the Source and Set tables A further authority list was required to define the type of set alSetType that the source belonged to since this would affect the way in which the MS was displayed in the web app for members of partbook sets we wished to show the master or group shelfmark in the main MS listing with the constituent parts of that set inset as a list below perhaps as a collapsible list If some members of the partbook set were lodged in a dif ferent library this would require a link to the other books The same display was n
69. isted e g UV or restored versions of a page The new structure was sufficient to cope with all the information necessary for managing a collection of images Fields were added to the Source table so that searching was more efficient in a number of key areas such as date format size and so on Around this time the source descriptions were also expanded to include the com plete data provided by the printed catalogues RISM and CCM Although out of date sometimes by 30 50 years these catalogues were the primary source of physical and content information about manuscripts and the de tail they provided was extremely useful in cases where a librarian could not easily locate a manuscript in their collection In some cases the shelfmark had changed so a facility was necessary to record alterations to shelf marks both for administrative use and sometimes as the only source of that information available to scholars The database was still not being used to form the back end to an online delivery system but around this time it also became clear that the quantity of images and the demand for online delivery would need a database management system to handle a web delivery mechanism Rather than discarding the existing database which was populated in considerable detail by this point the web design team at the then Centre for Computing in the Humanties at King s College London decided to work from the Filemaker database already in use A SOL analog was crea
70. k amp chapter_in_book amp amp in in amp lf IsEmpty BookTitle lt em gt amp TextStyleAdd BookTitle Italic amp lt em gt amp If IsEmpty no_of_volumes amp no_of_volumes amp vols amp If IsEmpty series_title amp series_title amp If IsEmpty vol_no_in_series Vol amp vol_no_in_series amp If IsEmpty ArticleTitle amp TextFormatRemove ArticleTitle amp amp lf IsEmpty Journal lt em gt amp TextStyleAdd Journal Italic amp lt em gt amp If IsEmpty Vol amp Vol amp If IsEmpty dissertation lt em gt amp TextStyleAdd dissertation Italic amp lt em gt amp degree amp amp uni versity amp If IsEmpty omit_Year_from_calculation amp lf IsEmpty PlacePublication PlacePublication amp lf IsEmpty Publisher amp If IsEmpty Publisher Publisher amp If IsEmpty Publisher and IsEmpty PlacePublication amp lf IsEmpty omit_Year_from_cal culation If IsEmpty Year n d Year amp amp If IsEmpty Page dis amp Page amp If IsEmpty notes amp notes amp InformationSource Text Journal Text logged_in_as Calculation Text from Bibliography Get AccountName modification dateText Auto enter Modification Timestamp Date and Time no_of_volumes
71. k based on all the known instances of it In later repertories the composition achieved a fixed and final form when the com poser chose to publish it thus creating his own idealised version of it and discarding variant or sketch versions in favour of the final form The idea of a final or finished form of a work was growing through the period rep resented by these manuscripts but without mass market publishing the concept of a single version of a work was undeveloped Some works appear in one manuscript with four voices and in another with three for ex ample with added parts possibly contributed by a different composer This fluidity has led to considerable ar gument about the purpose of a modern edition of a work in this period which often draws on a number of sources to create a concatenated idealised version that did not represent any performance or transmission of the work that its composer might recognise Regardless of the pitfalls of this modern view of musical compo sition the existence of concordant sources for a work means that we need to find a way to express the fact that there are items which are versions or copies of other items For this reason the Item table is governed by a Composition table which represents this idealised intellectual version of a work Each iteration of the com position is connected to a master record in the Composition table rnotationTypekey gt fenotationTypexey ss ep s InsetTyp
72. ks the Item table to the Bibliography Field Name Field Type Formula Entry Option biblAbbrev Text biblltem_IS_ KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only bibliographyKey Number Lookup When an entry in Biblltem_IS biblAbbrev is made copy the first matching value from Bibliographyltem bibliographyKey If no match Do not copy don t copy Bibliographyltem bibliographyKey if empty itemKey Number Lookup When an entry in Biblitem_IS itemKey is made copy the first matching value from Item itemKey If no match Do not copy don t copy Item itemKey if empty notes Text Catalogue_Pictures This table serves one function only to tell the SQL database for the webapp what the order of page images should be for the printed catalogue page images Field Name Field Type Formula Entry Option Cat_imagefilename Text keyNo_order Number Serial Number on creation with Current Value 9488 Increment Allow user to override validation Unique values only Only allow val ues of type Numeric Only Cataloguelndexes This table does not appear in the online resource it is used to allow easy navigation through the printed catalogue images and is for internal use for those populating the back end database It may b
73. lation to a folio number Field Name Field Type Formula Entry Option archive Text Lookup When an entry in Image sourceKey is made copy the first matching value from Source archive If no match Do not copy don t copy Source archive if empty archiveddetailfilename Text archivedfilename Text archivedUVfilename Text archivedVRfilename Text archivedwatermarkfilename Text availwebsite Text Lookup When an entry in Image sourceKey is made copy the first matching value from Archive availableOnWebsite If no match Do not copy don t copy Archive availableOnWebsite if empty bibliography Text brightness Text captureconditions Text capturedevice Text city Text Lookup When an entry in Image sourceKey is made copy the first matching value from Source city If no match Do not copy don t copy Source city if empty completesourcetitle Calculation Text Unstored from Image city amp amp archive amp amp source amp f amp folio amp amp Archive copyrightholder copyrightstatement Text Lookup When an entry in Image sourceKey is made copy the first matching value from Archive copyrightholder If no match Do not copy don t copy Archive copyrightholder if empty currentmeasurements Text dateCopied Text dateCreated Date Auto enter Creation Date dateModified Date Auto ente
74. ld Type Formula Entry Option g Key Number Indexed Auto enter Data 99 REquired Value Numeric Only Allow override personRelationshipkey Number Serial Number on creation with Current Value 34 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only relationship lype Text alProvenance The provenance of a book is one of the most important pieces of information about its history and content This authority list is based on the level of information that is usually available about any manuscript it s country of origin The majority of manu scripts have no more detailed knowledge than that The country of origin can include countries that no longer exist with mod ern boundaries or which do not fit country boundaries as we know them now such as Burgundy or the Low Countries In order to allow a more finely grained defintion of the origins of a book where that is known this authority list links to the Source table via an intersection set SourceProvenance_I S which allows the inclusion of data about the region within a country city and or institution within a city when that is also known Field Name Field Type Formula Entry Option alProvenanceKey Number country Text alSetType Sets allow manuscripts to be grouped but the type of grouping needs to be defined as there are a number of different con structs that scholars use to connect mansucripts
75. les relate to them so the content delete has to be done in the correct sequence as well The list below gives the correct upoad sequence The delete se quence follows this list in reverse The uploads have all been scripted in the upload database in the correct se quence as has the delete sequence FM table name equivalent SQL table name alCountry alCountry alCity alCity alProvenance alProvenance alAuthor alAuthor alCopyist alCopyist alCopyist Type alCopyist Type 4 alSettype alAffiliation alPersonRelationship alPerson alSettype alAffiliation AlPersonRelationship alPerson alGenre alGenre alVoice alVoice alClef alClef alLanguage alLanguage alNotation Type alNotation Type A Mensuration alMensuration Archive Archive Cataloguelndexes Cataloguelndex Set Set Bibliography Bibliography Composition Composition Source Source Item Item Image Image Secondarylmages Secondarylmage Composers Composer Text Text SourceProvenance_IS SourceProvenance AuthorBibliography_IS BibliographyPage_IS Source_Copyist_IS SourceSet_IS SourcePerson_IS Biblittem_IS BiblComposer_IS AuthorBibliography BibliographySource SourceCopyist SourceSet SourceAlPerson Bibliographyltem BibliographyComposer CompositionGenre_IS CompositionGenre BiblComposition_IS BibliographyComposition Composerlink_IS CompositionComposer alCycle Type alCycle Type Composition_cycle CompositionCycle Cycle_ltem_IS CompositionCycleComposition alLangua
76. links a list of copyists or scribes to the Source table via an intersection set Source_Copyist_IS since one copyist may have worked in a number of different sources and vice versa The copyist list has been treated separately from the list of persons associated with manuscripts because copyists are defined differently since they may have undertaken differ 18 ent types of copying activity see alCopyistType As well as being defined as a particular type of copyist they may also require an affiliation so the relationship is more complex than that of person which only requires a name and then a relationship type Field Name Field Type Formula Entry Option affiliationKey Number copyistKey Number Serial Number on creation with Current Value 375 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only copyistName Text g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only alCopyistType This authority list allows the copyist of a source to be classified as a copyist of music text indexer liminary text illuminator or text and music together It relates to the copyist list via the Source_Copyist_IS since the same copyist may undertake differ ent types of activity in a different manuscript This authority list may appear redundant since the information regardless of
77. llographyKey Text Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only Lookup When an entry in BiblComposer_IS biblAbbrev is made copy the first matching value from BiblComposer_link bibliogra 24 Number phyKey If no match Do not copy don t copy BiblComposer_link bibliographyKey if empty composerKey Number Lookup When an entry in BiblComposer_IS composerKey is made copy the first matching value from Composers composerKey If no match Do not copy don t copy Composers composerKey if empty notes Text BiblComposition_ S Links the bibliography to the list of compositions The blue dog field allows users to flag up potential problems with the data in a particular record Field Name Field Type Formula Entry Option biblAbbrev Text bibIComposition_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only bibliographyKey Number Lookup When an entry in BiblComposition_IS biblAbbrev is made copy the first matching value from Bibl_Edition bibliographyKey If no match Do not copy don t copy Bibl_Edition bibliographyKey if empty blue dogs Tex
78. low user to override validation Required value Only allowvalues of type Numeric Only info Text info_source Text lastname Text variantspellings Text Composition Most pieces of music surviving from this period are recorded in more than one manuscript some in many manuscripts In the case of partbooks the same composition appears in each book but each book has a different voice part It is necessary there fore to create a master list of compositions which uses a standardised form of title spelling to which all instances of this com position or individual voice parts belonging to it can be linked The composition is therefore not a eal entity but the intellectualised version of any number of individual items in a variety of manuscript and printed sources In many ways this is what is represented by an editor s published modern edition of a work which usually collates all the individual instances into a single idealised version of the work which does not represent any original reading or single source for the work The composi tion links individual items in manuscripts with the Composers with the Composition_cycle to which individual items may belong to the genre of the work alGenre to the Composition_model e g a mass may be based on a motet which will also be listed in the Composition table or a work may use a plainchant for its basis or tenor part and to Bibliography re lation to that particular composition The num
79. lues of type Numeric Only NotationSource_I S This table links the Source table to the authority list of music notation types alNotation Field Name Field Type Formula Entry Option notationSource_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only notation TypeKey Number sourceKey Number RISM_CCMlink Not used in SQL The table lists countries and cities with the relevant page number in both RISM and CCM where the entry for that country or city starts Field Name Field Type Formula Entry Option RISM_CCMimagefilename Text RISM_CCMlinkKey Number Serial Number on creation with Current Value 770 Increment 1 Allow user to override validation Unique values only Only allow val ues of type Numeric Only RISMpicturesKey Text Lookup When an entry in RISM_CCMlink RISM_CCMimagefilename is made copy the first matching value from RISM_CCMlink to RISMpictures lt Field Missing gt If no match Do not copy don t copy RISM_CCMlink to RISMpictures lt Field Missing gt if empty SourceKey Number Lookup When an entry in RISM_CCMlink SourceKey is made copy the first matching value from Source sourceKey If no match Do not copy don t copy Source sourceKey if empty Secondarylmages Secondary images are
80. ly works such as mass movements would be designated both kyrie and mass ordinary Field Name Field Type Formula Entry Option compositionGenre_IS_KEYNumber Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only compositionKey Number genre Calculation Text Unstored alGenre Genre genreKey Number Cycle_item_IS Musical works compositions can belong to cycles but can also belong to more than one cycle so this intersection set connects individual items to a defined cycle The table name is slightly misleading since it does not connect cycles to individual items in the Item table but rather to the intellectual construct composition and therefore connects the two tables Cycle and Composi tion Cycles take a variety of forms this may be a set of mass movements that together form a complete mass setting but this may also refer to individual pars within a motet which have been recorded as individual compositions and items since one pars may appear in a source as a work in its own right divorced from its cycle companions Complete motets also may belong to cy cles of motets The cycle therefore is a broadly defined connection between two or more musical works or compositions Field Name Field Type Formula Entry Option composition_cyclekey Number compositionKey Number L
81. magefilename2_delete 3 2 0 amp Right CCMimagefilename2_delete 3 Length Right CCMimagefile name2_delete 3 1 00 amp Right CCMimagefilename2_delete 3 1 Whoops you ve run out of pages in this volume Text Unstored from Source Left RISMimagefilename 2 amp If Length RISMimagefilename 5 Case Length Right RISMim agefilename 3 3 Right RISMimagefilename 3 Length Right RISMimagefilename 3 2 0 amp Right RISMimage filenamel 3 Length Right RISMimagefilename 3 1 1 00 amp Right RISMimagefilename 3 Whoops you ve run out of pages in this volume Case Length Right RISMimagefilename 4 1 4 Right RISMimagefilename 4 Length Right RIS Mimagefilename 4 3 0 amp Right RISMimagefilename 4 Length Right RISMimagefilename 4 1 2 00 amp Right RiSMimagefilename 4 Length Right RISMimagefilename 4 44 pagePreviousRISM 2 Phase provenance RISMabbrev RISMCCM RISMimagefilename RISMimagefilename2 RISMimagefilename3 RISMpresence RISMreset setKey shelfMark shelfMark_tagged sortorder sourceDisplayName sourceKey sourceName sourcesummary source lype startdate status staveGauge summary summaryfield 1 1 000 amp Right RISMimagefilename 4 Whoops you ve run
82. namel 3 1 00 amp Right RISMimagefilename2 3 Whoops you ve run out of pages in this volume Case Length Right RISMimagefile name 4 4 Right RiISMimagefilename2 4 Length Right RISMimagefilename 4 3 0 amp Right RISMimagefile name2 4 Length Right RISMimagefilename 4 2 00 amp Right RISMimagefilename2 4 Length Right RISMim agefilenamel 4 1 000 amp Right RISMimagefilename2 4 Whoops you ve run out of pages in this volume Text Unstored from Source Left CCMimagefilename _delete 5 amp Case Length Right CCMimagefilename _delete 4 4 Right CCMimagefilename _delete 4 Length Right CCMimagefile name _delete 3 3 Right CCMimagefilename _delete 3 Length Right CCMimagefilename _delete 3 2 0 amp Right CCMimagefilename _delete 3 Length Right CCMimagefile name _delete 3 1 00 amp Right CCMimagefilename _delete 3 1 Whoops you ve run out of pages in this volume Text Unstored from Source Left CCMimagefilename2_delete 5 amp Case Length Right CCMimagefilename2_delete 4 4 Right CCMimagefilename2_delete 4 Length Right CCMimagefile name2_delete 3 3 Right CCMimagefilename2_delete 3 Length Right CCMi
83. no larger than a postage stamp In each case this is considered a source Each source usually has a shelf mark designation which identifies it to the librarian though often in private collections there is no library mark and perhaps only a colloquial name by which the document is known Whatever the designation this is the form under which a visitor would ask to see the source and must be kept accurate and up to date as far as possible A significant proportion of libraries and collections have undertaken recataloguing during which shelf marks were changed Surprisingly few archives that have recatalogued their collections kept a cross reference docu ment listing old and new shelfmarks and DIAMM may in many cases be the only resource that does this Many of the printed catalogues dealing with our sources predate changes in shelfmarking systems so it is important for the database to keep a record of previous shelf marks to ensure users coming to the resource from one 16 of the older printed catalogues can still find the manuscript they seek This is managed using the olim field in the Source table More complex are the group of sources that have moved from one archive to another sometimes physically the sources are actually in the same place but the archive has been renamed but in some cases particularly with German and Polish libraries where manuscript collections moved around Europe during the Second World War the manuscripts have changed l
84. ocation Sometimes the original shelf mark is retained but often a new shelfmark is allocated In the case of books that have actually or apparently moved changed ownership a record is created for both sources for the books the out of date location pointing to the new current location 2 3 Tables and Fields There are three types of table Master or Primary tables these tables are the master reference tables and contain multiple fields in each record Because of the way that the database is structured some master tables behave like authority lists or intersection sets Their formal designation is not important but classifying them in this way al lows the user to better understand the structure of the information provided Authority lists simple lists of data that would otherwise be repeated in a master table They provide the user with a predefined set of data from which to choose e g a list of clefs a list of countries a list of authors These may be linked directly to Master tables or connected via an intersection set Intersection sets These are used in cases where the relationship between a master table and an au thority list is many to many rather than one to many The relationship betwen Text and Language might be considered as one to many i e one language for each text record but in fact some texts are constructed using more than one language so these two tables are linked by an intersection set Intersection sets
85. ookup When an entry in Cycle_item_IS compositionKey is made copy the first matching value from Composition compositionKey If no match Do not copy don t copy Composition compositionKey if empty cycle_item_IS_KEY Number Serial Number on creation with Current Value 601 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only order_in_cycle Number 3 position_title Text Image The Image table is one of the primary tables in the database it lists the individual pages flyleaves covers and any other items that would have been photographed while making a record of a mansucript Hierarchically it would come immediately below the Source table since each record would belong to a single source This table does not in fact simply list the images taken when photographing a MS but instead lists the pages folios endpapers boards covers etc Therefore if more than one image was taken of a page there would be only one record in this table but the additional images such as UV IR or detail shots are recorded in the Secondarylmages table This includes images that have been digitally restored or otherwise manipulated The Item and Image tables are linked via an intersection set Itemlmage_I S The content includes information about the storage of images but mainly allows the online delivery system to find the correct image in re
86. ory last edited by letter_info logged_in_as modification date MOTETshelfmark moved moved_Y noofimages noofimages_editable notation notes numberFound numbering_source olim pageMeasurements pageNextCCM pageNextCCM_2 pageNextRISM Calculation Text Text Text Calculation Text Text Calculation Calculation Text Text Calculation Text Calculation Number Text Text Calculation Text Text Text Calculation Calculation Calculation entry Text from Source If IsEmpty RISMimagefilenamez RISM sec ond entry Global Number from Source 99 Text from Source If done Y If webpermission Y DIAMM has images of this MS online DIAMM has images of this Ms Text from Source Get AccountName Auto enter Modification Timestamp Date and Time Lookup When an entry in MOTET to source sourceKey is made copy the first matching value from Motetten Datenbank MOTET shelfmark If no match Do not copy don t copy Motetten Daten bank MOTET shelfmark if empty Text from Source If moved _Y Y Please note this document has been moved to another library INCORPORATE INTO DESCRIPTION Number Unstored from Source Count Image source Lookup When an entry in Source archiveKey is made copy the first matching value from Source to ID noofimages If no match Do not copy don t copy
87. ot however required for sources grouped together e g because they had been copied by the same scribe These sources might never have been intended to remain together and are usually widely dispersed Their connection however is clearly important and needs to be manifest in some way visually In this case each listing in the browse sources display might show a link that would take the user to a list or popup list of the other manuscripts in that set One further facility was envisioned for this addition to the data and that was the intention that at some point users might be able to come to DIAMM and search or study only a particular group of sources perhaps a subset of the music manuscripts but also in thinking about long term sustainability of the project and the wider 8 exploitation of the web app we might want to include non music collections or sets of sources related to a particular research project within DIAMM The set definition would allow us to do this For this reason the type of set is absolutely crucial and must always be defined when a manuscript set is created estschrift FullText calculated InformationSource Journal modification_date no_of volumes notes omit_Chapter _fro omit_Year_from_c Once we started to address how manuscripts might be related to each other in non musical as well as musi cal ways it was clear that in order to search efficiently on these criteria those relationships needed to be ex
88. ould appear on a page which was the same as an image and many pages could comprise an item it was at the same level as the Image table but connected to that via intersection set A data merge between DIAMM and the Motet database of Thomas Schmidt Beste led to the creation of a full text table Text and its associated satellite tables language etc and led to a formalisation of the Item infor mation involving the creation of numerous intersection sets and authority lists including relating items composers composition models individual compositions etc to the Bibliography table he Bibliography table was also re engineered and had an Author authority list added via an intersection set to allow the biblio graphical items to be delivered using a house style 1 3 Deficiencies and workarounds A major defect in Filemaker by comparison with e g MySQL is that relationships between data in tables at more than one remove are not reliable For instance if the user wishes to see all images in a city regardless of the archive the data would need to be mined via the following set of relationships 2 City Archive Source i e manuscript Image Thus requiring navigation through three tables Because all these tables are relatedto each other the software should return a list of images related only to the master table in this case the City table but in FM it does not or at least not reliably In MySQL the data delivered seems to
89. own into custom layouts for specific tasks 2 2 Data The DIAMM data is centred around manuscript sources known as Sources which means that all other data either more or less granular radiates from that central point Other databases of music from this period may take a composition known in this dataset as an Item or a composer as its starting point and list manuscript sources where that composition or where that composer s works may be found Still others may be library based and to some extent the DIAMM dataset is also library based since the locations of the MSS are crucial to the core data about each source The starting point for the database is therefore the Source manuscript and where it is found The primary tables in this respect are Country City Archive Source Country and City are self explantory and City is a subset of Country Archive is a subset of Country and covers any type of repository from major national libraries to local archive offices and private collections of individuals The document of interest may be the only document in the col lection or the only musical document but is more often one of a reasonably large collection Source refers to the manuscript within the library collection It may range in extent from a complete bound book with many pages to a group of fragmentary leaves perhaps bound in a modern guard book with other unrelated documents and sometimes to fragments of parchment or paper
90. r Modification Date detail Text detailfilename Text digitised Text EECMno Text existingimages Text filename Text folio Text folio_alt Text imageKey Number Serial Number on creation with Current Value 26789 Increment 1 Required value Unique values only Only allow values of type Nu meric Only imagetype Text incipitimagefilename Text Lookup When an entry in lt unknown gt is made copy the first match ing value from lt Table Missing gt If no match Do not copy don t copy 32 notes orderNo RISMimagefilename RISMimagefilename2 source sourceKey surfaceMaterial TSM watermark Item Text Number Text Text Text Number Text Text Text lt Table Missing gt if empty something to do with ALTINCIPIT Serial Number on creation with Current Value 204 Increment 1 Allow user to override validation Required value Only allow values of type Numeric Only Lookup When an entry in Image sourceKey is made copy the first matching value from Source RISMimagefilename If no match Do not copy don t copy Source RISMimagefilename if empty Lookup When an entry in Image sourceKey is made copy the first matching value from Source shelfMark alone If no match Do not copy don t copy Source shelfMark alone if empty Lookup When an entry in Image sourceKey is made copy the first mat
91. r that manuscript may end up linked to the wrong library or linked to no library at all so it will no longer appear where it should nor will any of its dependencies items text transcriptions bibliography images etc Key numbers can however be used to make quick changes very easily a new source record is placed in the correct library and city and country simply by inserting the rele vant archiveKey number into the Source record Warning DO NOT at any time attempt to change the Key number of a record Just don t 3 1 Editing existing records This is relatively simple and only really involves finding the right record and editing the relevant field s The data base has an entry page which will gives users less experienced with databases a step by step process to find the records they want to edit and work on them without requiring an intimate understanding of the workings of the database The layouts can be used both in web publishing format to be accessed through a normal web broser and for users accessing the database through Filemaker software but only those designed for the edi torial board are optimized for web use Although Filemaker is cross platform there are issues with variable font sizes between Mac and PC which mean that some fonts appear larger on the PC than they do on a Mac making field heights look wrong in some layouts Since adjusting every field in every layout would be an inefficient use of time we ask PC users to
92. rShelfMark description setKey setTypeke archive availwebsite bibliography copyrightstatement digitised filename folio imageKey imagetype notes orderNo sourceKe eaffiliationKey affiliation affiliationKey languageKey language languageKey bibliographyKey notes textKe description setTypeKey decorationColour decorationStyle imageKey itial initialColour itemKey orderNo positiononPage archivedfilename caption datemodified filename ImageKey imagetype notes Seconda voiceKey ImagesKe aclefKey itemKey mensurationKey atextKey evoiceKey clef clefKey editorial_voicepart fullltemText fullltemText_authority Global itemKey itemTextKey mensurationKey orderNo sourceKey standardspellingFulltext standardspellingIncipit textincipit textKey voiceKey voicepart AbbrevPosn compositionKey AbbrevPosn It_numbering altincipitfilename altincipititemKey catalogDesignation commentsonhands completeText_original completeText_standard composerOriginal compositionKey copyingstyle corrections dateComposed dateCopied foliationPagination folio_end folio_end_alt folio_start folio_start_alt incipitfilename incipittranscription itemKey layout local_attribution Motet_incipit_standard MOTET_order MotetComments MOTETincipitfilename MotetSourceComments MusicalGenre musicallncipit_score musiccolour musicNotation_styleKey notes noVoices
93. rce Number 26 Foliation Pagination Text 27 Musical genre Text 28 Text type Text 29 Motet source comments Text 30 Motet comments Text 31 Edition Text 32 Pars Text 32a Motet incipit Standard Text 33 Text Incipit Source Text 34 Text Incipit Standard Text 35 Voices Text 38 36 Complete Text Original Text 37 Complete Text Standard Text 38 Musical incipit Score Container DIAMMlink Calculation Text Unstored from Motetten Datenbank MOTET to source RIS Mabbrev amp amp 25 Order in source DIAMMsourceKey Number editing_history Calculation Text from Motetten Datenbank If IsEmpty logged_in_as edit ing_history Get AccountName amp amp modification date amp YJ amp edit ing_history incipitFilename Text itemKey Number Lookup When an entry in Motetten Datenbank motetKey is made copy the first matching value from Item itemKey If no match Do not copy don t copy ltem itemKey if empty list fields Calculation Text Unstored from Motetten Datenbank FieldNames DIAMM Thomas logged_in_as Calculation Text from Motetten Datenbank Get AccountName modification date Text Auto enter Modification Timestamp Date and Time MOTET shelfmark Text motetKey Number Serial Number on creation with Current Value 15173 Increment 1 Allow user to override validation Required value Unique values only Only allow va
94. rent type of cycle The table defines the type of cycle to which a composition belongs if it is part of a cycle This is a short list and could have simply been managed as a limited set of values in the Cycle_item_IS table but has been managed here to facilitate web searching Field Name Field Type Formula Entry Option cycle lype Text cycle TypeKey Number Serial Number on creation with Current Value 5 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only alGenre The definition of the content of this table is a little vague a genre can be defined either as something very broad such as litur gical work or something more specific such as Motet or Mass movement The table is used here to provide both broad and specific categories that are applied to individual compositions and under which users might wish to search Because a composi tion may therefore belong to more than one of these categories it is related to the composition table via an intersection set A 19 work entitled Kyrie might therefore belong to the following genres Kyrie Mass proper Liturgical work Canon It has also been used to group works in which a common text is used that has been set many times such as Alma Redempto
95. return to this master layout A practice database basically a copy of the master database is available for inexperienced users to try out edit ing processes without worrying that they are affecting the master data Home gt 1 2 ed New Users please review Introduction and try your hand on the Practice Ms rere logged in as Bibliography Database before jumping into the main database Direct access to various sections of the database is available via the Red Please check that you correct account If not fteventory patiaa Transcription Users must be logged in with their correct name and user de RID ai tails This allows the admin side to EED keep track of edits and if it is You are logged in as found that one user consistently makes a particular mistake their activity can be tracked and corrected Similarly if a problem arises in the data it is easy to see with which user it originated Finally if the database crashes following an edit and the user was not able to record the record ID where they were working the audit trail saved by the login information enables an administrator to find the problem and correct it without record ID numbers Editorial Board Welcome to the database Edit suite Editing is based around the four main tables in the database Archive Source Item and Bibliography Content from other related tables is for the most part visible from the master layouts for these source
96. ris Mater which is not a genre in itself but the grouping is useful for searching purposes At present more than 90 genres are defined in this table lt might simplify matters to redefine this table as the most granular type of work with authority lists above it in the hierarchy that would allow lower level genre types to be grouped under that heading e g Kyrie is a child of Mass proper which is in turn a child of Liturgical Work However that would present a problem with Canon where would that level of definition appear Field Name Field Type Formula Entry Option g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only Genre Text genreKey Number Serial Number on creation with Current Value 101 Increment 1 Required value Unique values only Only allow values of type Nu meric Only itemKey Text Lookup When an entry in alGenre genreKey is made copy the first matching value from Item itemKey If no match Do not copy don t copy Item itemKey if empty alLanguage A relatively simple authority list giving the language of the text underlaid in a single voice part of a composition This had to be linked to the Text table via an intersection set as some single voice parts have texts that are written in more than one lan guage distinct from a work such as a Motet where each voice part may be
97. s enabling users to edit content without constantly changing layout or opening new windows Global Key fields in each table allow complete table content lists to be shown on any related layout as well as lists of data related specifically to the record being viewed edited Country 3 2 Creating new records City Creating records in a relational database is more complex than editing because the user must not attempt to create a record until the authority l i we i Archive lists preceding it have been populated correctly Thus if a new MS Source is to be added to the database the user must first check that the required Archive is already in the database and if not that must be created Like Source wise a new Archive cannot be created unless its Country and City are al ready in those authority lists The BASIC hierarchy map shown here should Image Item Bibliography therefore always be kept in mind when creating new records in the data base before creating any of the information shown in the lower subject T xt Composition Composer areas the information above it must be in place 5I All of these processes are guided in the Editorial Board layouts in the database If using the database it is im portant to read through all the instructions and make sure that they are fully understood before proceeding If in doubt the practice database can be used but it is essential to remember that nothing done in the prac tice database will be save
98. s document Originally the database was constructed as an efficient way of keeping a list of a relatively small number of man uscripts that were to be photographed for a publication There were three tables Archive Source and Image The Archive table gave details of libraries addresses contact names information about copyright and corre spondence regarding a visit from the project photographer the progress of negotiations etc The Source table simply listed the manuscripts with their dimensions and gave the photographer a description so that they had some idea of what they would be looking at when they got to the library and how much time to allow for the work The Image table simply listed the image filenames originally but was expanded to include information about photographers now omitted The first ERD then would have looked something like this At this point since all the libraries concerned were in one country there was no need for Country or City authority lists These were added later when the project s imaging activity extended outside the UK Originally second shots of a leaf were listed as separate images but this was clearly not a good way to deal with differ ent types of shots of the same page and as the dataset began to extend to become an information resource about the manuscripts the need for proper management of image information as it related to pages or folios led to the creation of a Secondary Image table which l
99. sonRelationship which defines the relationship that the person had with the manuscript alPerson also has an authority list alAffiliation which lists any connections that the person had e g with an institution So Johannes Barbla may be listed as the owner of a book and his affiliation would be Chaplain of St Catherine s Choir in Aachen The table s content definition is broader than simply individual people despite its name to allow more gen eral connections to be expressed so that a person may be the Church of St Gudule for whom the MS was commissioned and who owned the book Field Name Field Type Formula Entry Option affiliationKey Text fullname Text g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only personKey Number Serial Number on creation with Current Value 1998 Increment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only alPersonRelationship As describe in alPerson above this table defines the relationship that a person or institution as broadly defined in alPerson had with a manuscript or source There are currently 30 relationshps defined including owner dedicatee dedicator binder pa tron author of treatise in which music is interpolated used as model for decoration style discoverer keeper translator etc Field Name Fie
100. st matching value from Motetten Datenbank 32 Pars If no match Do not copy don t copy Motetten Datenbank 32 Pars if empty Lookup When an entry in Item sourceKey is made copy the first matching value from Item to Source RISMabbrev If no match Do not copy don t copy Item to Source RISMabbrev if empty Lookup When an entry in Item sourceKey is made copy the first matching value from Item to Source sourceDisplayName If no match Do not copy don t copy Item to Source sourceDisplayName if empty Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 33 Text Incipit Source If no match Do not copy don t copy Motetten Datenbank 33 T e x t Inciprt Source if empty Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 34 Text Incipit Standard If no match Do not copy don t copy Motetten Datenbank 34 T e x t Inciprt Standard if empty 36 useMotet_DB title Item_Copyist_I Text Intersection set betwen Item records and the Copyist table Although the Source table is also linked to the Copyist table by an intersection set this intersection allows us to indicate which of the individual items in a manuscript were the work of a par ticular copyist since often MSS are the work of a number of compilers Field Name Field Type
101. t compositionKey Number Lookup When an entry in BiblComposition_IS compositionKey is made copy the first matching value from Composition composition Key If no match Do not copy don t copy Composition composi tionKey if empty notes Text Bibliography Contains the modern bibliographical resource linked mainly at this stage to manucript descriptions The field names are rea sonably self explanatory The table has only one satellite table alAuthor linked to it via an intersection set The Bibliography table is however linked to a number of other tables all of which may need to refer to a bibliographical item The following ta bles connect to the Bibliography database via intersection sets Source Item Composers Composition Text Model_text Although not currently linked to other tables it should probably in the future also be linked to alCopyist alPerson and alNo tationType The author fields defined here repeat the information available in the alAuthor table to facilitate the calculation that generates the full bibliographical citation The BiblAbbrev field is in this case used as the linking field to the other tables since this is the form of the book that is usually cited in catalogue entries Field Name Field Type Formula Entry Option _PracticeDBwarning Calculation Text Unstored from Archive TextColor If Right Get FileName 7 RUBBISH YOU ARE IN THE PRACTICE DATABASE
102. t matching value from Motetten Datenbank 27 Musical genre If no match Do not copy don t copy Motetten Datenbank 27 Musical genre if empty Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 38 Musical incipit Score If no match Do not copy don t copy Motetten Datenbank 38 Mu sical incipit Score if empty Global 35 orderNo pageNextRISM pagePreviousRISM pars pars Title piecenumber PositioninMS PositiononPage RISMS_text RISMabbrev scribalhabit Source sourceKey StdTextSource text_incipit_source text_incipit_standard useGenre Number Calculation Calculation Text Text Text Number Text Text Text Text Text Number Text Text Text Text Serial Number on creation with Current Value 328 1 Increment 1 Allow user to override validation Required value Text Unstored from Item Left incipitfilename 2 amp If Length in cipitfilename 5 Case Length Right incipitfilename 3 3 Right incipitfilename 3 Length Right incipitfilename 3 2 0 amp Right incipitfilename 3 Length Right incipitfilename 53 1 1 00 amp Right incipitfilename 3 Whoops you ve run out of pages in this volume Case Length Right incipitfilename 54 4 Right incipitfilename 4 Leng
103. ted that mirrored the following structure in order to run the online database delivery system for the existing and expanding image collection Since the working FM database was constantly being updated this was kept separate from the delivery database but updates were run at regular intervals when new MSS had to be added to the online collection a city fey alcityKey counteyke local_speliin Structural change then began to happen very fast information input from the printed catalogues included bib liographies for the MSS but to save print space since many of these were repetitious these had been pro vided as algebraic abbreviations with a key list giving the full citation In order to be of better use to end users the database was expanded so that the full bibliographical citation in the Bibliography table could be keyed to the abbreviation given in each MS listing alcityKey count akcitykey city counteyKey local_spelling alt_numbering_source altRiSMabbrev archiveKey authority bibliography CCMabbrev CCMimagefilename BiblAbbrev sourcekey BiblAbbrev bibliographyKey bibliographypageKey CCM_garbage composerkey Marked_up_bibliogr Page BibiAbbrey sourceKey bibliographyKey BookTitle chapter_in_book Gegree dissertation Festschrift FullText_calevlated InformationSource Journal modification date An intersection set allowed for individual page r
104. th Right incipit filename 4 3 0 amp Right incipitfilename 4 Length Right incipitfilename 4 2 00 amp Right incipitfilename 4 Length Right incipitfilename 4 1 000 amp Right incipit filename 4 Whoops you ve run out of pages in this volume Text Unstored from Item Left incipitfilename 2 amp If Length in cipitfilename 5 Case Length Right incipitfilename 3 3 Right incipitfilename 3 Unstored from Item Left incipitfilename 2 amp If Length incipitfilename 5 Case Length Right incipitfile name 3 3 Right incipitfilename 3 Length Right incip itfilename 3 2 0 amp Right incipitfilename 3 Length Right incipitfilename 3 00 amp Right incipitfilename 3 Whoops you ve run out of pages in this volume Case Length Right incipitfilename 4 4 Right incipitfilename 4 Length Right incipitfilename 4 1 3 0 amp Right incipitfilename 4 Length Right incipitfilename 4 1 2 00 amp Right incipitfilename 4 Length Right incipitfilename 4 000 amp Right incipitfile name 4 Whoops you ve run out of pages in this volume Lookup When an entry in Item MOTETkey is made copy the fir
105. thy information about the binding and collation but no information at all about ownership or copyists Even descriptions of the same manuscript in the two dif ferent catalogues could show surprising disparities between even such information as might be expected to be consistent such as measurements A single document description was analysed to show the different types of data that the prose supplied The first and most obvious point to note was that because free prose is rich and complex in the way it expresses information dividing that information into separate fields or headings might involve significant repetition which in data terms is very inefficient Returning to the basic description this first analysis identified some 26 infor mation areas When that model was applied to other descriptions the number increased almost with every de scription that we examined up to something in the region of 80 different descriptive areas Clearly attempting to mark up the prose text or divide it into fields was going to be extremely difficult massively time consum ing and possibly ultimately pointless since the richness continuity and overall effect of the prose description would be lost in the process More useful was the examination of the information provided by the RISM catalogue musical incipits At this point musical incipits cannot be meaningfully searched and early searchable transcription softwares require the reinputting of a mass of
106. tial when dealing with complex information This example is only one of many which means that the working database that is used for populating content has an untenably complex ERD and many redundant fields in each table in order to fa cilitate these relationships In addition to these redundant structures work of the data team was supported by including access to the image content both images of the catalogues and images of manuscripts in layouts This allowed e g a tech nician proof reading OCR from a printed catalogue to see the relevant page image from the catalogue in the same layout as the text being proofed Rather than contain these images in the master databsae which would make it extremely large and unwieldy two external datasets were created both around 6 8 GB in size one containing catalogue images and one manuscript images and the primary textual dataset was connected to them via external relationship It is worth noting at this point that PC files have a size limit of 4GB which means that both the image databases in constant use for DIAMM would not have been possible to manage on a PC platform This together with the better graphics management of Mac vs PC was one reason for the choice of the Mac platform at the proj ect outset 1998 In order to manage the expression of the dataset outside the project therefore a cut down version of the data base was created known as DIAMM_ Shell in which the redundant rel
107. tion and is a self intersection set for the Item table it links to another entry in the same table It looks up the Field Name Field Type Formula Entry Option AbbrevPosn Text altincipitfilename Calculation Text Unstored from Altincipit ltem incipitfilename altincipitkey Number Serial Number on creation with Current Value 2617 Increment 1 Required value Unique values only Only allow values of type Nu meric Only altitemKey Number Lookup When an entry in AbbrevPosn is made copy the first match ing value from itemKey lf no match Do not copy don t copy ttemKey if empty itemKey Number Lookup When an entry in Altincipit AAbbrevPosn is made copy the first matching value from Item itemKey If no match Do not copy don t copy Item itemKey if empty alVoice This table defines the name of a voice or individual part of a polyphonic composition Often parts have no names and there fore are not defined but this allows both the definition of voice names e g Cantus Tenor Motetus and unnamed parts where required e g Il Ill and uses the terminology as given in the original source rather than a standardised form There are cur rently over 70 defined voice parts Field Name Field Type Formula Entry Option g Key Number Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type
108. to enter Calculation from Item If IsEmpty incipitfilename Item to Source RISMimagefilename 34 item_gathered itemKey Last edited by layout local_ attribution logged_in_as modification date MOTET Motet_incipit_standard MOTET_order MOTETcatalog MotetComments MOTETincipitfilename MOTETkey MOTETshelfmark MusicalGenre musicallncipit_score notes noVoices null_value numberGarbage_RISM5 Calculation Text Unstored from Item If IsEmpty PositioninMS Position Number Text Text Text inMS amp amp If IsEmpty folio_start folio_start amp If folio_start folio_end If IsEmpty folio_end amp folio_end amp amp If IsEmpty useMotet_DB_title composition_name Substitute Motet_incipit_standard amp If IsEmpty composerStandard If IsEmpty Composerlink_IS Composername amp Com poserlink_IS Composername amp composerStandard Serial Number on creation with Current Value 6 1653 Increment 1 Always validate Required value Unique values only Only allow values of type Numeric Only Calculation Text from Item Get AccountName Text Auto enter Modification Timestamp Date and Time Text Text Number Text Text Text Text Text Text Text Text Text Text Text Lookup When an entry in Item MOTETkey is m
109. to it via an intersection set or direct relationship then we delete the source record the dependency records in the other tables remain and do not cause the FM database to choke If we then run an upload of these tables to SQL the SQL database will not accept records with orphan dependencies so the upload registers failed records or fields In order to fix this a manual integrity check has to be run on all intersection sets and dependent tables before attempting an upload and the orphan records deleted In fact the failure of these records to upload is not a problem since they are no longer required but if the upload returns a failure message we need to know whether there is a rogue record that has to be chased down so it is best to delete the orphans and then if there is an upload error we know that there is a real fault in the data It is possible to upload single tables in the database as updates to the existing content so the upload system looks for records in the table that match the key number of the source database and rewrites the data in those records This is a quick way of registering content updates to existing records but will not work if new records have been created unless an update is run on ALL tables in the correct order The safest way to deal with new records is to delete the content and upload every table in the correct sequence so that failures are not caused by orphan dependencies Tables cannot be deleted if other tab
110. umber of days required to digitize the sources on our list Number Date Auto enter Modification Date Calculation Text Indexed from Archive http amp url_original Text Text Text Date The intersection set between the alAuthor and Bibliography tables that defines the relationship of an author with the book in the bibliography i e author editor compiler publisher Festschrift dedicatee translator collaborator later editor Field Name Field Type Formula Entry Option authorBibliography_IS_KEY author_editor authorKey bibliographyKey BiblComposer_IS NumberSerial Number on creation with Current Value 601 Incre ment 1 Allow user to override validation Required value Unique values only Only allow values of type Numeric Only Text Number Lookup When an entry in AuthorBibliography_IS authorKey is made copy the first matching value from alAuthor authorKey If no match Do not copy don t copy alAuthor authorKey if empty Number Lookup When an entry in AuthorBibliography_IS bibliographyKey is made copy the first matching value from Bibliography bibliogra phyKey If no match Do not copy don t copy Bibliography bibliog raphyKey if empty Links the Bibliography table to the list of composers Field Name Field Type Formula Entry Option biblAbbrev biblIComposer_IS_KEY Number bib
111. untName amp amp modification date amp J amp editing_history Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 3 Edition If no match Do not copy don t copy Motetten Datenbank 3 Edition if empty Lookup When an entry in Item MOTETkey is made copy the first matching value from Motetten Datenbank 26 Foliation Pagination If no match Do not copy don t copy Motetten Datenbank 26 Folia tion Pagination if empty Number Unstored from Item folioend to foliossourceKey amp folioend to folio orderNo Number from Item If PatternCount Folios Middle Folios Position Folios 1 1 999 Substitute Folios p Number Unstored from Item foliostart to foliosourceKey amp foliostart to folio orderNo Text from Item If PatternCount Folios Middle Folios Position Folios 1 Folios Number from Item 99 Indexed Auto enter 99 Allow user to override validation Required value Only allowvalues of type Numeric Only Lookup When an entry in ltem compositionKey is made copy the first matching value from alGenre Genre If no match Do not copy don t copy alGenre Genre if empty Auto enter 0 Global field used in relationship between Item and Text to show all records Au
112. would de fine the type of copying work e g music text illumination etc The next stage added a Person table which was treated separately from the copyist list since the relationship to the document had to be managed dif ferently and for technical as well as taxonomic reasons needed to be kept separate The Person table deals not only with people but also with a wider definition of those related to a book so one MS might have been owned by Abbot X but another might have been owned by the Abbey ofY It seemed un necessary to differentiate here between a person or a place and the name of the table was largely irrelevant However linking a person or persons to a MS required as with the scribes a definition of the type of rela tionship that the person had with the MS giving rise to an authority list linked to the intersection set that linked Source to Person Further it became clear that another authority list was required that allowed us to list the af filiation of a person So a MS might be owned by the monk Boniface who was the abbot of a particular mon stery described in the affiliation table who gave the MS to another monk on his death also affiliated to the same monastery The connection of both monks to the same record in the Affiliation table ensures the rela tionship between the two monks is made explicit although the resulting data structure is slightly complex ionTyp z MusicNotation PsetTypekey notation TypeK
113. y of data the DIAMM dataset relies on 28 ae text searchability for the basic information and access to images of tran usw Seo scribed incipits for a large part of the existing corpus where the user can a see information that cannot be usefully translated The point about musical notation is of course that it is a system that expresses information which cannot be expressed in text so any attempt to transcribe it in such a way Is egregious 13 Like manuscripts compositions can cluster together in sets or cycles Sometimes these are sets of composi tions gathered together because they are intended to be used together such as music for a saint s day or be cause a compiler feels they work well together for reasons of style or key These compositions are naturally individual but can be joined by being members of a set Other compositions were designed to exist together movements of a mass cycle for instance Still other types of cycles exist where we found the same data man agement problem as we had with partbooks originally listed as single ttems with constituent parts we found that each partbook in a set had to be treated as individual sources The analog to that situation in the Item table was the single musical work that was divided into sections Al though all those sections might be expected always to appear in the same _ seme order and complete whenever that composition was copied this was not r in fact the case
114. ypage_IS_KEY Number Serial Number on creation with Current Value 2507 Increment Required value Unique values only Only allow values of type Nu meric Only 27 CCM_info Text editing_history Calculation Text from BibliographyPage_IS If IsEmpty logged_in_as edit ing_history Get AccountName amp amp modification date amp YJ amp edit ing_history fullBibliography Text Text Lookup When an entry in BibliographyPage_IS BiblAbbrev is made copy the first matching value from Bibliography FullText_calculated If no match Do not copy don t copy Bibliography FullText_calculated if empty logged_in_as Calculation Text from BibliographyPage_IS Get AccountName Marked_up_bibliography Calculation Text Unstored from BibliographyPage_IS If IsEmpty primary_study Bibliography Fulllext_calculated amp If IsEmpty Page Us amp Page amp If IsEmpty CCML_info TextFont CCM de scriptor s amp CCM_info amp Times lt strong gt amp Bibliography Full Text_calculated amp If IsEmpty Page amp Page amp If IsEmpty CCM_info TextFont CCM descriptor s amp CCM_info amp Times amp lt strong gt modification date Text Auto enter Modification Timestamp Date and Time Page Text primary_study Text sortorder Number sourceKey Text Biblitem_IS Lin

Appendix 4: Database documentation

Contents

Download Pdf Manuals

Related Search

Related Contents