Tango.info database: Difference between revisions
No edit summary |
|||
| 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 | ||
##* 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/for download | # --use on --> website/for download | ||
Revision as of 2015-01-24T23:06:22
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
- --use on --> website/for download