Tango.info database: Difference between revisions
No edit summary |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
== Usage == | == Usage == | ||
* [[tango.info music data usage]] | * [[tango.info music data 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) | |||
# output | |||
##--use on --> website | |||
##use for download ([[tango.info opendata]]) | |||
Latest revision as of 2015-01-24T23: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)