Skip to content

Instantly share code, notes, and snippets.

@RyanRosario
Last active January 17, 2024 21:09
Show Gist options
  • Save RyanRosario/8ae2ff19c4543d714d59e5785f1b513d to your computer and use it in GitHub Desktop.
Save RyanRosario/8ae2ff19c4543d714d59e5785f1b513d to your computer and use it in GitHub Desktop.
group: ucla examples
description[[ the data for this dataset was generated using {'<'}http://www.generatedata.com/>
* the relation _Video_ contains basic information about YouTube videos.
* the relation _Comment_ contains the basic information of a YouTube comment. A video can have multiple comments.
]]
youtube_video = {
video_id title channel cat_id views likes dislikes
XpVt6Z1Gjjo "1 YEAR OF VLOGGING" "Logan Paul Vlogs" 24 4394029 320053 5931
cLdxuaxaQwc "My Response" Pewter 22 5845909 576597 39774
Ayb_2qbZHm4 "Honest College Tour" CollegeHumor 23 859289 34485 726
EVp4-qjWVJE "Chargers vs. Broncos" NFL 17 743947 6126 352
}
youtube_comment = {
video_id comment_id comment likes replies
cLdxuaxaQwc xl418Pq1 "Love you Pooter don't apologize your fine" 0 0
cLdxuaxaQwc yV7x88ba "Yo this was funny af" 0 0
Ayb_2qbZHm4 UB0bn1zz "That word is not okay to say because.." 0 0
Ayb_2qbZHm4 mBb7991a "Yo this was funny af" 0 0
}
Instructor = {
InsID name
1 "Smallberg, D. A."
2 "Reinman, G. D."
3 "Eggert, P. R."
4 "Xu, H"
5 "Lu, S"
6 "Reiher, P. L."
7 "Rosario, R. R."
8 "van Den Broeck, G."
9 "Ostrovsky, R."
10 "Campbell, M. L."
}
Teaches= {
InsID course
1 "COM SCI 31"
1 "COM SCI 32"
2 "COM SCI 33"
3 "COM SCI 35L"
3 "COM SCI 130"
3 "COM SCI 131"
4 "COM SCI 111"
5 "COM SCI 118"
6 "COM SCI 136"
7 "COM SCI 143"
8 "COM SCI 161"
9 "COM SCI 180"
10 "COM SCI 181"
}
Foo = {
A B
1 2
1 8
1 6
}
Bar = {
C D
3 4
2 4
}
Teaches2 = {
InsID course
1 "201031"
1 "201032"
2 "201033"
3 "20135L"
3 "201130"
3 "201131"
4 "201111"
5 "201118"
6 "201136"
7 "201143"
8 "201161"
9 "201180"
10 "201181"
}
Course2= {
course course_name
"201031" "COM SCI 31"
"201032" "COM SCI 32"
"201033" "COM SCI 33"
"20135L" "COM SCI 35L"
"201130" "COM SCI 130"
"201131" "COM SCI 131"
"201111" "COM SCI 111"
"201118" "COM SCI 118"
"201136" "COM SCI 136"
"201143" "COM SCI 143"
"201161" "COM SCI 161"
"201180" "COM SCI 180"
"201181" "COM SCI 181"
}
ThetaJoinExR1 = {
A B
"alpha" "beta"
"beta" "beta"
}
ThetaJoinExR2 = {
A C
"beta" "alpha"
"alpha" "gamma"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment