Transcript Tutorial: MySQL Database and Relational Data Processing

Tutorial: MySQL/SQL Server
Database and Relational Data
Processing
Dr. Jiaqi Yan
Oct 4, 2012
Objective
• We have raw data:
– Programmers’ personal information
– Projects they have participated
• We want to:
– Analyze the collaboration network of these
programmers
Task in this tutorial
Raw Data
VNA Data
SQL Data
Processing
Raw Data
• Tutorial_accounts.txt
–
–
–
–
Id
country_code
kudo_rank
Name
• Tutorial_contributor.txt
–
–
–
–
–
–
projectid
developercount
account_id (who has participated in the project)
man_months
primary_language_id
account_name
VNA Data
• Node data
–
–
–
–
id
Name
Country
…
• Tie data
– From (id of programmer A)
– To (id of programmer B)
– Strength (times of collaborations in the same projects)
Agenda
•
•
•
•
Downloading and installing MySQL server
Downloading the raw data
SQL data processing
Generation of VNA file