Modelling Sub Types with Neo4j

A commonly asked question is how to model sub types in a graph so this project shall aim to answer that question!

The Data

Our data set is a list of animals processed by Animal Services in Louiseville, Kentucky.

Importing into Neo4j

First we need to unpack the animal data set:

tar -xzf data/Animal_Tag_DATA.tgz -C data

which should leave us with a CSV file in the data directory:

ls -alh data/

total 507696
drwxr-xr-x   4 markneedham  staff   136B  7 Oct 18:00 .
drwxr-xr-x  10 markneedham  staff   340B  7 Oct 18:00 ..
-rw-r-----@  1 markneedham  staff   215M  2 Oct 17:06 Animal_Tag_DATA.csv
-rw-r--r--   1 markneedham  staff    33M  7 Oct 17:41 Animal_Tag_DATA.tgz

Interesting links

• Pull in more data on different breeds - http://www.thekennelclub.org.uk/activities/dog-showing/breed-standards/

• Hierarchies / Sub Types - http://www.cs.utexas.edu/~cannata/dbms/Class%20Notes/02%20Categories%20in%20RDBMs.pdf