Graph Visualization Db Structure

Server Holds two Databases - one for each implementation
- IMDB DB
- DBLP DB
Overall structure of both DBs is similar, as described below:

IMDB Database Sturcture

Actors

Column Name DataType Comment
Actorid MEDIUMINT Primary Key
Name VARCHAR Indexed
Sex ENUM('M','F') -
IMDBid MEDIUMINT not populated

Movies

Column Name DataType Comment
Movieid MEDIUMINT Primary Key
Title VARCHAR Indexed
Year VARCHAR -
IMDBid MEDIUMINT not populated

Movies2Actors

Column Name DataType Comment
Movieid MEDIUMINT Indexed
Actorid MEDIUMINT Indexed
As_Character VARCHAR Indexed

Relations (Actor2Actor)

Column Name DataType Comment
Actorid1 MEDIUMINT Indexed
Actorid2 MEDIUMINT -
Strength MEDIUMINT -

DBLP Database Sturcture

Author2Id

Column Name DataType Comment
Author VARCHAR Indexed
Id MEDIUMINT Primary Key

Author2Paper

Column Name DataType Comment
Author VARCHAR Indexed
Paper VARCHAR -

Author2Author

Column Name DataType Comment
Author1 VARCHAR Primary Key* , Indexed
Author2 VARCHAR Primary Key*
Strength MEDIUMINT -

*Note - Primary Key Index is on ('Author1','Author2').

Author2Home
(holds Authors Homepage URLs).

Column Name DataType Comment
Author VARCHAR Primary Key
Home VARCHAR -
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License