8000 GitHub - adanilev/imdb-dbs: Loading and querying IMDB data with different DBs - PostgreSQL, MongoDB and Neo4j · GitHub
[go: up one dir, main page]

Skip to content
adanilevPublic

About

Loading and querying IMDB data with different DBs - PostgreSQL, MongoDB and Neo4j

Resources

Stars

2 stars

Watchers

1 watching

Forks

Latest commit

 

History

19 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

imdb-dbs

Download IMDB's public data from AWS, import it to different types of databases and query it.

...a work in progress...to help me learn stuff...

Prerequisites

  1. AWS account and credentials (to download the data from IMDB - requester pays for the download)
  2. Docker 17.12.0
  3. npm 5.6.0
  4. node 8.9.0

Setup

  • This is a monorepo, so check out the instructions in the relevant DB package (e.g. ./packages/imdb-dbs-mongo)

Databases

  1. MongoDB - pretty much there
  2. neo4j - next up
  3. PostgreSQL - one day

Queries

  1. Show the latest 10 movies a given actor has been in
  2. For a given actor, find their 5 most highly rated films
  3. Find the top rated 10 films with more than n votes
  4. Given two people, list what movies they appeared in together
  5. List all of the cast and crew in a given movie
  6. Find the most prolific actor is a given period
  7. Find the 5 most prolific actors in a given genre
  8. For a given person (actor or cast), find the 5 people they've worked with the most
  9. 6 degrees of Kevin Bacon - given 2 actors, find the shortest link between them

Information courtesy of IMDb (http://www.imdb.com). Used with permission.

About

Loading and querying IMDB data with different DBs - PostgreSQL, MongoDB and Neo4j

Resources

Stars

2 stars

Watchers

1 watching

Forks

Releases

Packages

Used by

Contributors

Languages

0