Cookies help us deliver our services. By using our services, you agree to our use of cookies. More information

Space Race/MATCH Tutorial

From NoSQLZoo
< Space Race
Revision as of 09:56, 28 November 2019 by ChrisHouston (talk | contribs)
Jump to: navigation, search

Visualisation

Click here for 3d graph visualisation

Institutions

Use MATCH and RETURN to return nodes. Use : to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes

Show Institutions instead of Astronauts

MATCH(n:Astronaut) RETURN n;
MATCH(n:Institution) RETURN n; 

Born in Russia

Use WHERE to specify conditions and the . operator to access individual properties of a node.

The item in [] represents a relationship between nodes, in this case the relationship possessing the label "BORN_IN"

Show the Surnames of Astronauts born in Russia, and the full name of Russia rather than the USA. Hint: Use the ISO 3166-1 Alpha-2 code in all caps

MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;
MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;

Neil Armstrong's Birthday

When simply matching based on properties of a node, an alternative to using WHERE is to use the {} with the format {property:value}

Return Neil Armstrong's date of birth

MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob;
MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob;


Acknowledgements

NoSQLZoo is made possible by the following open-source technologies:

jQuery JSHint CodeMirror MediaWiki MariaDB