Re:IMDB data
by notyourwork on Sunday April 24, 2011 @09:09PM
(#2480054)
That sounds like a great example database for database classes! Something a student could wrap their head around to understand the dataset. I found a lot of times students new to database concepts had trouble unless examples were given in terms of a dataset they could relate to or at least understand the relationships without the DB language.
At Stanford in CS107 we had to write an IMDB six degrees of separation, using this same database. Insert the names of 2 actors, and our app will calculate the degrees of separation between them. Kevin Bacon was highly connected :)
Re:IMDB data
by notyourwork on Monday April 25, 2011 @09:49AM
(#2481212)
Who doesn't love Kevin Bacon! What a great project, this would applicable as an enhancement to projects like xbmc.
Re:IMDB data
by bajsejohannes on Monday April 25, 2011 @06:13AM
(#2480891)
This is exactly how I learned SQL, too. Through http://sqlzoo.net/ . I agree it's a fun way to learn it.
I remember one question. List the directors that have directed at least 20 movies and acted in all of them. This is fairly tricky, and returns a list of mostly explicit movie directors.
What's more fun though is a sparql endpoint. So you can query it and link to it on your own sites. I found this one on a quick google search (couldn't find the one I looked at before). http://www.linkedmdb.org/