Changes between Version 3 and Version 4 of EthnomusDatabase


Ignore:
Timestamp:
Apr 30, 2007 9:35:54 PM (7 years ago)
Author:
olivier
Comment:

Started to describe the collection fields and their mappings

Legend:

Unmodified
Added
Removed
Modified
  • EthnomusDatabase

    v3 v4  
    11= Ethnomusicology Database = 
    22 
    3 This document presents the structures of the original [http://www.4d.com 4D] database of the [http://www.ethnomus.org CNRS Ethnomusicology laboratory]. 
     3This document presents the structures of the original [http://www.4d.com 4D] database of the [http://www.ethnomus.org CNRS Ethnomusicology laboratory] (LEM). 
    44 
    55== 4D database structure == 
     
    99[[Image(ethnomus4D.png, 150)]] 
    1010 
    11 == Data table names == 
     11== Data tables == 
    1212 
    13 The Ethnomusicology database contains tables with obsolete/obscure names. We also need to translate them from french to english. Here follows a proposition for this translation: 
     13The Ethnomusicology database contains tables with obsolete/obscure names. We also need to translate them from french to english. Additionally, some tables are themselves obsolete, and some contain unstandardized informations which we might replace with ISO standards and the like.  
    1414 
    1515||'''old table name'''||'''new table name'''||'''comment'''|| 
     
    3535||Images||?||4D-specific?|| 
    3636 
     37== Support/Collection fields == 
     38 
     39These are fields for the collection table (old name: Support). 
     40 
     41||'''old table name'''||'''new table name'''||'''Type'''||'''Dublin Core mapping'''||'''comment'''|| 
     42||Réf||publication_reference||String||||This field contains the reference assigned by a publishing company, ''when the collection has been published''. If it hasn't been published, it contains a reference assigned by the LEM, which somewhat duplicates the information contained in the field "Cote". In this later case, it has the form BM.XXX.XXX, where X are digits (note: some published references also start by "BM", but have a different form)|| 
     43||Format||original_format||Enumeration||||Format of the original physical support, historical data. Can't be standardized, mixes a lot of physical details (disk diameter, whatever...).|| 
     44||Cote||identifier||String||identifier||This is a unique identifier for the collection. It is currently of the form "BM.YYY.NNN" where YYY is the year and NNN a serial number. It will evolve to CNRSMH_I_YYYY_NNN|| 
     45||Titre||title||String||title|||| 
     46||Transcript_trad||native_title||String||title||This is either the translation from the native title, or its phonetic transcription. We might simply consider it as an alternative title, this is Dublin Core compliant, a resource can have several titles.|| 
     47||Nb_de_pieces||physical_items_num||Integer||||If the collection is on a magnetic tape this is the number of tapes. If it is on a disk it is the number of tracks. This is historical data. We can keep it, but will also display a more reliable computed number of related items.|| 
     48||Réédition||publishing_status||Enumeration||||Wether the collection was fully/partially published, reedited, or not|| 
     49||Original||is_original ||Boolean||||Whether this is an genuine/original collection, as opposed to copied ones|| 
     50