Tango.info database: Difference between revisions
Jump to navigation
Jump to search
| Line 19: | Line 19: | ||
## ---add data to---> other MySQL tables | ## ---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) | ##* 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) | ||
# --use on --> website | # 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)