4 ms·
We use it at the University in Oslo as a realistic database for practicing sql. It's great fun. I remember one question. List the directors that have directed
by hmottestad 16y ago
We use it at the University in Oslo as a realistic database for practicing sql. It's great fun.
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/ http://www.linkedmdb.org/
- notyourwork 16y agoThat 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.
- maneesh 16y agoAt 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 :)
- notyourwork 16y agoWho doesn't love Kevin Bacon! What a great project, this would applicable as an enhancement to projects like xbmc.
- bajsejohannes 16y agoThis is exactly how I learned SQL, too. Through http://sqlzoo.net/ http://sqlzoo.net/ . I agree it's a fun way to learn it.