|
|
| (21 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| == Data types ==
| |
| * [[tango.info name]]
| |
| * [[tango.info identifier]] also id (short for identifier)
| |
| * [[tango.info date]] -> subset of [[ISO 8601]]
| |
| * quantity
| |
|
| |
|
| === Misc === | | == Structure == |
| * [[tango.info music links]] | | * [[tango.info music data structure]] |
|
| |
|
| === Events === | | == Changes == |
| * [[tango.info music performance]] (a [[tango.info event]] where an acoustic signal that is music is created. Either live or [[playback]])
| |
| ** [[tango.info music performance id]] (a type of [[tango.info event id]])
| |
| ** [[tango.info music performance date]]
| |
| ** [[tango.info music performance genre]] (property of a performance)
| |
| | |
| === Products ===
| |
| * [[tango.info musical work]] (composition?, consisting of a score and lyrics)
| |
| | |
| * [[tango.info music fixation]] (information that a music player can convert into an audio signal)
| |
| | |
| * [[tango.info music recording]] (information that a music player can convert into an audio signal)
| |
| ** [[tango.info music recording id]] (e.g. [[ISRC]])
| |
| | |
| * [[tango.info music track]] (information that a music player can convert into an audio signal)
| |
| ** [[tango.info music track id]] -> [[TINT]]
| |
| ** [[tango.info music track date]] (property of a music track, currently inherited from music performance. Could in future be the music performance date mentioned by the music publisher, or the music track creation date.)
| |
| ** [[tango.info music track format]] (property of a music track)
| |
| ** [[tango.info music track genre]] (property of a music track, currently inherited from music performance. Could in future be the music genre mentioned by the music publisher)
| |
| ** [[tango.info music track instrumentalist]] (an acting entity)
| |
| ** [[tango.info music track vocalist]] (an acting entity)
| |
| | |
| * [[tango.info music album part]] (contains one or more music tracks, usually ordered)
| |
| ** [[tango.info music album part id]] -> [[TINP]]
| |
| | |
| * [[tango.info music album]] (contains one or more music album parts, usually ordered)
| |
| ** [[tango.info music album id]] -> [[TIN]]
| |
| ** [[tango.info music album comment]]
| |
| | |
| * [[tango.info music album collection]] (a group of music albums, contains one or more music albums)
| |
| ** [[tango.info music album collection name]]
| |
| ** [[tango.info music album cover art]]
| |
| | |
| * tango.info music copy (a copy of an music work, music track, music album part, music album or music album collection)
| |
| | |
| === Acting entities ===
| |
| * [[tango.info person]] (either human or non-human, not music specific)
| |
| ** [[tango.info person id]]
| |
| ** [[tango.info person code]]
| |
| ** [[tango.info person name]]
| |
| * human person (=natural person)
| |
| ** human person gender (either male or female)
| |
| * non-human (artificial or legal person)
| |
| | |
| Roles
| |
| * [[tango.info music performer]] (either a person or a group of persons, giving a performance)
| |
| * instrumentalist (a music performer)
| |
| * vocalist (a music performer)
| |
| * [[tango.info orchestra]] (a group of performers that are persons, a group of persons, usually instrumentalists)
| |
| ** [[tango.info orchestra code]]
| |
| | |
| == Data changes ==
| |
| * [[tango.info music track metadata submissions]] | | * [[tango.info music track metadata submissions]] |
|
| |
|
| == Data delivery == | | == Usage == |
| === http interface ===
| | * [[tango.info music data usage]] |
| * [[tango.info music track search]]
| |
| * [[tango.info music track based discographies]] | |
|
| |
|
| === Tagger === | | == Workflow within tango.info == |
| * [[tango.info music tagger]] | | # ODS -export as--> CSV |
| * [[tango.info music tagger format string]] | | # ---upload to--> Server |
| * [[tango.info music tagger track references]]
| | # ---load into---> MySQL table |
| | # alter data via script |
| | ## ---add data via script---> to MYSQL table where data was loaded to |
| | ##* the statistics |
| | ##* the [[Tango.info az 09 name]] |
| | ## ---add data to---> other MySQL tables |
| | ##* table person_role, person_track, person_work to avoid using searches with LIKE %...%, since the ODS contains fields that contain comma-separated values (not 1NF) |
| | # output |
| | ##--use on --> website |
| | ##use for download ([[tango.info opendata]]) |