Tango.info database

Structure

• tango.info music data structure

Changes

• tango.info music track metadata submissions

Usage

• tango.info music data usage

Workflow within tango.info

1. ODS -export as--> CSV
2. ---upload to--> Server
3. ---load into---> MySQL table
4. alter data via script
   1. ---add data via script---> to MYSQL table where data was loaded to
      • the statistics
      • the Tango.info az 09 name
   2. ---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)
5. output
   1. --use on --> website
   2. use for download (tango.info opendata)