Changes
Jump to navigation
Jump to search
no edit summary
*This page is protected so that only Ed, RaniUsha, Toby and Misiek can read or edit it.
I will be posting reports and other materials on the OK Cupid project here.
==Script Files==
There are two SQL script files that were written to process the data:
*[[:Image:OKC1.sql.asci|OKC1.sql]]
*[[:Image:OKC2.sql.asci|OKC2.sql]]
These files are self-documenting, and the second file builds out the current base table set containing: '''users''', '''views''', '''messages''', and '''delta'''.
==Setup Instructions for Usha==
See the [[Research Computing At HBS]] page for detailed information.
Quick quide:
#Go to vpn.hbs.edu and click Network Connect -> Start
#Using SSH client, connect to researchgrid.hbs.edu
#Connect the MYSql cluster: msyql -h rcsmysql.hbs.edu -u eegan -p --ssl-ca=rcsmysql
Useful commands:
mysql> SHOW Databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mpiskorski_tstuart |
| okcupid |
| okcupid_2 |
+--------------------+
4 rows in set (0.02 sec)
You'll have access to mpiskorski_tstuart
USE mpiskorski_tstuart;
(Misiek and Toby's working database)
SHOW TABLES;
There are two datasets: OKC1 and OKC2. We are now working with OKC2.
Both datasets have:
Users
Messages
Views
OKC2 also has ProfileDelta (changes to profiles).
Describe tables with:
DESC TableName
==Data Description from Misiek==
