cleishm

US Flights & Airports: Delays, Cancellations, & Diversions

---

Table of Contents

• Inspiration

  • Included Variables

  • Included Airports

cleishm

Royalty in Europe

The Royal families generaly have long histories and are often closely related. This citation from wikipedia can give you better idea:

Maternally, Nicholas was the nephew of several monarchs, including King Frederick VIII of Denmark, Queen Alexandra of the United Kingdom (queen consort of King Edward VII), and King George I of Greece. Nicholas, his wife, Alexandra, and Kaiser Wilhelm II of Germany were all first cousins of King George V of the United Kingdom. Nicholas was also a first cousin of both King Haakon VII and Queen Maud of Norway, as well as King Constantine I of Greece. While not first cousins, Nicholas and Kaiser Wilhelm II were second cousins, once removed, as each descended from King Frederick William III of Prussia, as well as third cousins, as they were both great-great-grandsons of Emperor Paul I of Russia.

The rulers of Great Britain, Germany and Russia at the beginning of World War I were actually cousins

cleishm

= Working examples for the 'Graph Databases' book 

image::http://assets.neo4j.org/img/books/graphdatabases_thumb.gif["frontpage thumbnail",align="left"]

The examples in the 'Graph Databases' book don't work out of the box. I've modified them, so that they do work (for chapter 3, that is). 

This is a graphgist version of my https://baach.de/Members/jhb/working-examples-for-the-graph-databases-book/[blog post]. 

If you click one of the green play buttons in the examples below, they will show in this console. Usually the code formatting is messed up, so it might be a bit ugly.

cleishm

= graphGist generated from spock test Neo4jCypherSameSchoolInfluence.groovy

graphGist asciiDoc file for use at http://gist.neo4j.org/ [GitHub Gist]

Generated on Sun Jul 28 08:03:44 PDT 2013

//console


Initialize Graph

cleishm

= graphGist generated from spock test Neo4jCypherOneRelationship.groovy

graphGist asciiDoc file for use at http://gist.neo4j.org/ [GitHub Gist]

Generated on Mon Jul 29 07:11:04 PDT 2013

//console


query to create plato with philosopher label

cleishm

= graphGist generated from spock test Neo4jCypherOneLabel.groovy

graphGist asciiDoc file for use at http://gist.neo4j.org/ [GitHub Gist]

Generated on Sun Jul 28 08:03:43 PDT 2013

//console


query to create plato with philosopher label

cleishm

Orienteering Gist

This is the Orienteering Dataset based on the blog.neo4j.org post.

It’s a simple, three-leg training course in an Antwerp park. Setting this up as a graph in neo4j was easy enough:

cleishm

= Last.fm Dataset Gist =

Earlier this month, I published http://blog.neo4j.org/2013/07/fun-with-music-neo4j-and-talend.html[a blog post] about my fun with some self-exported http://last.fm[Last.fm] data. With this Gist, I would like to provide a bit more practical detail on the dataset and how you could use it.

Let's first create an overview graph of the model.

image::http://2.bp.blogspot.com/-uNPggNP9A3c/Ud7HDhwpkbI/AAAAAAAAAK4/AZd25Q0h-j4/s640/Screen+Shot+2013-07-11+at+16.52.59.png[]

[source,cypher]
----

cleishm

= Business Rule / Recommendation gist =
 
In this simple example, we want to highlight the power of graphs to describe, discover, visualise and implement powerful business rule-based recommendations.

In the example, we will create a simple graph containing
	- a +person+ ("Rik")
	- a +city+ ("London")
	- an +age+ ("39")
	- a +child+ ("Toon")
and all the required relationships from the person to the city, to his age, and his child. 

cleishm

= Why JIRA should use Neo4j

== Introduction

There are few developers in the world that have never used an issue tracker. But there are even fewer developers who have ever used an issue tracker which uses a graph database. This is a shame because issue tracking really maps much better onto a graph database, than it does onto a relational database. Proof of that is the https://developer.atlassian.com/download/attachments/4227160/JIRA61_db_schema.pdf?api=v2[JIRA database schema].

Now obviously, the example below does not have all of the features that a tool like JIRA provides. But it is only a proof of concept, you could map every feature of JIRA into a Neo4J database. What I've done below, is take out some of the core functionalities and implement those. 

== The data set