Tango.info database: Difference between revisions
Jump to navigation
Jump to search
(→Tagger) |
|||
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
== | == Structure == | ||
* [[tango.info music data structure]] | * [[tango.info music data structure]] | ||
== | == Changes == | ||
* [[tango.info music track metadata submissions]] | * [[tango.info music track metadata submissions]] | ||
== | == Usage == | ||
* [[tango.info music data usage]] | |||
* [[tango.info music | |||
== | == Workflow within tango.info == | ||
* | # ODS -export as--> CSV | ||
* [[ | # ---upload to--> Server | ||
* | # ---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]]) |
Latest revision as of 2015-01-25T01:07:15
Structure
Changes
Usage
Workflow within tango.info
- ODS -export as--> CSV
- ---upload to--> Server
- ---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)
- ---add data via script---> to MYSQL table where data was loaded to
- output
- --use on --> website
- use for download (tango.info opendata)