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:20, 27 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.

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;

Acknowledgements

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

jQuery JSHint CodeMirror MediaWiki MariaDB