Tango.info database: Difference between revisions
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 15: | Line 15: | ||
# alter data via script | # alter data via script | ||
## ---add data via script---> to MYSQL table where data was loaded to | ## ---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 | ## ---add data to---> other MySQL tables | ||
# --use on --> website | ##* 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)