NoSQLZoo - User contributions [en-gb]

https://nosqlzoo.net/w/api.php?action=feedcontributions&feedformat=atom&user=ChrisHouston NoSQLZoo - User contributions [en-gb] 2026-04-17T02:03:38Z User contributions MediaWiki 1.43.0 https://nosqlzoo.net/w/index.php?title=Space_Race/Cypher_Cheat_Sheet&diff=1417 Space Race/Cypher Cheat Sheet 2020-02-19T08:54:46Z

<p>ChrisHouston: </p> <hr /> <div>=Cypher Cheat Sheet=<br /> ==Match==<br /> <code>MATCH</code></div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Cypher_Cheat_Sheet&diff=1416 Space Race/Cypher Cheat Sheet 2020-02-19T08:53:07Z

<p>ChrisHouston: /* Cypher Cheat Sheet */</p> <hr /> <div>=Cypher Cheat Sheet=<br /> ==Match==</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Schema&diff=1415 Space Race/Schema 2019-12-09T09:20:33Z

<p>ChrisHouston: </p> <hr /> <div>==Space Race Schema==<br /> <p>Node labels and related properties:<br /> * <code>:Person:Astronaut{first_name, middle_names, surname, nickname, dob, unique_achievement, wiki_link}</code><br /> * <code>:Component{name, translation, notes, launched, wiki_link}</code><br /> * <code>:Country{name, abbrev, wiki_link}</code><br /> * <code>:Institution{name, abbrev, formed, wiki_link}</code><br /> * <code>:LaunchVehicle{name, notes, first_flight, last_flight, wiki_link, launches, failures, successes, reusable, is_rocket}</code><br /> * <code>:Mission{name, start_date_time, end_date_time, type, wiki_link, notes}</code><br /> * <code>:Program{name, goal, translation, wiki_link}</code><br /> * <code>:SpaceStation{name, wiki_link, launched, reentry, is_modular}</code><br /> </p><br /> <br /> <p> Relationships and properties<br /> *<code>:CREWED</code> Astronauts ''Crew'' Missions<br /> *<code>:BORN_IN</code>Persons are ''Born in'' Countries<br /> *<code>:RUN_BY</code>Institutions are ''Run by'' Countries, Programs are 'Run by' Institutions<br /> *<code>:LAUNCHED_ON</code> Missions are ''Launched on'' Launch Vehicles, non modular Space Stations can be ''Launched on'' Launch Vehicles, Components can be ''Launched on'' Launch Vehicles<br /> *<code>:PART_OF</code> Missions are ''Part of'' Programs<br /> *<code>:EMPLOYED_BY</code>Astronauts are ''Employed by'' Institutions<br /> *<code>:RENDEZVOUSED_WITH{distance_in_metres}</code>Missions can ''Rendezvous with'' other Missions<br /> *<code>:DOCKED_WITH{date_time}</code>Missions can ''Dock with'' other Missions<br /> *<code>:RENDEZVOUSED_AND_DOCK_WITH{successful_dock, start_dock, end_dock}</code>Missions can ''Rendezvous and dock'' with Space Stations<br /> *<code>:FORMERLY</code>Institutions can be ''Formerly'' other Institutions, Countries can be ''Formerly'' other Countries <br /> *<code>:IS_COMPONENT_OF</code>Each Component ''Is component of'' a Space Station<br /> *<code>:OPERATED_BY</code>LaunchVehicles are ''Operated by'' Institutions<br /> </p></div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Schema&diff=1414 Space Race/Schema 2019-12-09T09:19:06Z

<p>ChrisHouston: Created page with "==Space Race Schema== <p>Node labels and related properties: * <code>:Person:Astronaut{first_name, middle_names, surname, nickname, dob, unique_achievement, wiki_link}</code>..."</p> <hr /> <div>==Space Race Schema==<br /> <p>Node labels and related properties:<br /> * <code>:Person:Astronaut{first_name, middle_names, surname, nickname, dob, unique_achievement, wiki_link}</code><br /> * <code>:Component{name, translation, notes, launched, wiki_link}</code><br /> * <code>:Country{name, abbrev, wiki_link}</code><br /> * <code>:Institution{name, abbrev, formed, wiki_link}</code><br /> * <code>:LaunchVehicle{name, notes, first_flight, last_flight, wiki_link, launches, failures, successes, reusable, is_rocket}</code><br /> * <code>:Mission{name, start_date_time, end_date_time, type, wiki_link, notes}</code><br /> * <code>:Program{name, goal, translation, wiki_link}</code><br /> * <code>:SpaceStation{name, wiki_link, launched, reentry, is_modular}</code><br /> </p><br /> <br /> <p> Relationships and properties<br /> *<code>:CREWED</code> Astronauts 'Crew' Missions<br /> *<code>:BORN_IN</code>Persons are 'Born in' Countries<br /> *<code>:RUN_BY</code>Institutions are 'Run by' Countries, Programs are 'Run by' Institutions<br /> *<code>:LAUNCHED_ON</code> Missions are 'Launched on' Launch Vehicles, non modular Space Stations can be 'Launched on' Launch Vehicles, Components can be 'Launched On' Launch Vehicles<br /> *<code>:PART_OF</code> Missions are 'Part of' Programs<br /> *<code>:EMPLOYED_BY</code>Astronauts are 'Employed by' Institutions<br /> *<code>:RENDEZVOUSED_WITH{distance_in_metres}</code>Missions can 'Rendezvous with' other Missions<br /> *<code>:DOCKED_WITH{date_time}</code>Missions can 'Dock with' other Missions<br /> *<code>:RENDEZVOUSED_AND_DOCK_WITH{successful_dock, start_dock, end_dock}</code>Missions can 'Rendezvous and dock' with Space Stations<br /> *<code>:FORMERLY</code>Institutions can be ':Formerly' other Institutions, Countries can be ':Formerly: other Countries <br /> *<code>:IS_COMPONENT_OF</code>Each Component 'Is component of' a Space Station<br /> *<code>:OPERATED_BY</code>LaunchVehicles are 'Operated by' Institutions<br /> </p></div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1413 Space Race/MATCH Tutorial 2019-12-09T08:53:42Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Cypher Cheat Sheet==<br /> [[Space_Race/Cypher_Cheat_Sheet]]<br /> ==Database Schema==<br /> [[Space_Race/Schema]]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Institutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, ((toFloat(m.failures)/toFloat(m.launches))*100) AS PercentageFailureRate ORDER BY PercentageFailureRate DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1412 Space Race/MATCH Tutorial 2019-12-09T08:49:48Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Cypher Cheat Sheet==<br /> [[Space_Race/Cypher_Cheat_Sheet]]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Institutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, ((toFloat(m.failures)/toFloat(m.launches))*100) AS PercentageFailureRate ORDER BY PercentageFailureRate DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1411 Space Race/MATCH Tutorial 2019-12-09T08:48:41Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Cypher Cheat Sheet==<br /> [/Space_Race/Cypher_Cheat_Sheet]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Institutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, ((toFloat(m.failures)/toFloat(m.launches))*100) AS PercentageFailureRate ORDER BY PercentageFailureRate DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1410 Space Race/MATCH Tutorial 2019-12-09T08:48:18Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Cypher Cheat Sheet==<br /> [Space_Race/Cypher_Cheat_Sheet]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Institutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, ((toFloat(m.failures)/toFloat(m.launches))*100) AS PercentageFailureRate ORDER BY PercentageFailureRate DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Cypher_Cheat_Sheet&diff=1409 Space Race/Cypher Cheat Sheet 2019-12-09T08:47:28Z

<p>ChrisHouston: Created page with "==Cypher Cheat Sheet=="</p> <hr /> <div>==Cypher Cheat Sheet==</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1408 Space Race/MATCH Tutorial 2019-12-09T08:45:05Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Institutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, ((toFloat(m.failures)/toFloat(m.launches))*100) AS PercentageFailureRate ORDER BY PercentageFailureRate DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Relationships_Tutorial&diff=1407 Space Race/Relationships Tutorial 2019-12-09T08:43:33Z

<p>ChrisHouston: </p> <hr /> <div><p>Relationships are the most powerful part of graph-based databases. While some of the functionality these provide is possible under SQL using join tables for many to many relationships, certain queries can be constructed which would require many joins in SQL. A good example is the number of connections required to link one node to another.</p><br /> <p>All relationships in Neo4j are directional, that is they have a start and end node. They can only possess a single <code>TYPE</code>, rather than multiple labels, but they can also possess properties similar to nodes</p><br /> <br /> == Visualisation ==<br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> <br /> ==Relationship types==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The <code>Type()</code> function can return the type of a relationship</p><br /> <p class='strong'>Return the type of the relationship between Astronaut and Mission</p><br /> <pre class="def"><nowiki>MATCH(:Astronaut)-[r]->(:Country) RETURN DISTINCT type(r);</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(:Astronaut)-[r]->(:Mission) RETURN DISTINCT type(r);</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p>Note the <code>(startNode)-[:LABEL_NAME]->(endNode)</code> format. The direction the arrow points shows which node is the end point.</p><br /> <p>It is perfectly valid to express this relationship as <code>(endNode)<-[:LABEL_NAME]-(startNode)</code></p><br /> <p>If you are not concerned about the direction of the relationships, you can also <code>MATCH</code> based on <code>(node1)-[:LABEL_NAME]-(node2)</code></p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Flight Colleagues==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Numerous relationships can be strung together. <code>DISTINCT</code> can be used to only display a result once if that node is linked to multiple times</p><br /> <p class='strong'>Show the names of everyone that James Lovell flew with.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Armstrong"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Lovell"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Saturn V Missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Aggregate functions can also be used on the result of relationships queries</p><br /> <p class='strong'>Show how many missions were launched on the Saturn V.</p><br /> <pre class="def"><nowiki>MATCH(n:LaunchVehicle{name:"Saturn V"})RETURN DISTINCT n; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(:LaunchVehicle{name:"Saturn V"})<-[r:LAUNCHED_ON]-(:Mission) RETURN count(r);</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1406 Space Race/MATCH Tutorial 2019-12-01T12:42:44Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Insitutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, ((toFloat(m.failures)/toFloat(m.launches))*100) AS PercentageFailureRate ORDER BY PercentageFailureRate DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1405 Space Race/MATCH Tutorial 2019-12-01T12:42:25Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Insitutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, ((toFloat(m.failures)/toFloat(m.launches))*100) AS PercentageFailureRate ORDER BY PercentageFailureRate;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1404 Space Race/MATCH Tutorial 2019-12-01T12:41:57Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Insitutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, toString(((toFloat(m.failures)/toFloat(m.launches))*100))+'%' AS PercentageFailureRate ORDER BY PercentageFailureRate;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1403 Space Race/MATCH Tutorial 2019-12-01T12:40:56Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p>Using AS can alias the result column to whatever you wish, as long as it does not have spaces</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n AS Astronauts;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n AS Insitutions; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob AS DateOfBirth;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname AS Surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name AS FirstName, n.surname As Surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names AS MiddleNames; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname AS Nicknames ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Counting up the missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>As in SQL, aggregate functions can be applied to the results of the MATCH query. Unlike SQL you do not need to group by other non-aggregate parameters </p><br /> <p>Functions include <code>count()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code> and many more</p><br /> <p class='strong'>Return the number of missions that took place in the Space Race.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN count(m) AS Count; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:Mission) RETURN count(m) AS Count;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Arithmetic and string operations can also be used in the return statement. Strings can be parsed in to integers or floats using the <code>toInteger()</code> or <code>toFloat()</code> functions</p><br /> <p>The reverse can be done using the <code>toString()</code> function.<br /> <p class='strong'>Return the name and percentage failure rate for each LaunchVehicle, ordered by number of failures in descending order.</p><br /> <pre class="def"><nowiki>MATCH(m:LaunchVehicle)RETURN m.name, toInteger(m.launches); </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(m:LaunchVehicle) RETURN m.name AS Name, toString(((toFloat(m.failures)/toFloat(m.launches))*100))+'%' AS PercentageFailureRate;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Relationships_Tutorial&diff=1402 Space Race/Relationships Tutorial 2019-12-01T12:14:00Z

<p>ChrisHouston: </p> <hr /> <div><p>Relationships are the most powerful part of graph-based databases. While some of the functionality these provide is possible under SQL using join tables for many to many relationships, certain queries can be constructed which would require many joins in SQL. A good example is the number of connections required to link one node to another.</p><br /> <p>All relationships in Neo4j are directional, that is they have a start and end node. They can only possess a single <code>TYPE</code>, rather than multiple labels, but they can also possess properties similar to nodes</p><br /> <br /> == Visualisation ==<br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> <br /> ==Relationship types==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The <code>Type()</code> function can return the type of a relationship</p><br /> <p class='strong'>Return the type of the relationship between Astronaut and Mission</p><br /> <pre class="def"><nowiki>MATCH(:Astronaut)-[r]->(:Country) RETURN DISTINCT type(r);</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(:Astronaut)-[r]->(:Mission) RETURN DISTINCT type(r);</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p>Note the <code>(startNode)-[:LABEL_NAME]->(endNode)</code> format. The direction the arrow points shows which node is the end point.</p><br /> <p>It is perfectly valid to express this relationship as <code>(endNode)<-[:LABEL_NAME]-(startNode)</code></p><br /> <p>If you are not concerned about the direction of the relationships, you can also <code>MATCH</code> based on <code>(node1)-[:LABEL_NAME]-(node2)</code></p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Flight Colleagues==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Numerous relationships can be strung together. <code>DISTINCT</code> can be used to only display a result once if that node is linked to multiple times</p><br /> <p class='strong'>Show the names of everyone that James Lovell flew with.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Armstrong"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Lovell"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Saturn V Missions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Aggregate functions can also be used on the result of relationships queries</p><br /> <p class='strong'>Show how many missions were launched on the Saturn V.</p><br /> <pre class="def"><nowiki>MATCH(n:LaunchVehicle{name:"Saturn V"})RETURN DISTINCT n; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(:LaunchVehicle{name:"Saturn V"})<-[r:LAUNCHED_ON]-(:Mission) RETURN count(r);</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1401 Space Race/MATCH Tutorial 2019-12-01T12:04:38Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth, from oldest to youngest.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Failure Rate==<br /> <div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Relationships_Tutorial&diff=1400 Space Race/Relationships Tutorial 2019-11-29T09:40:59Z

<p>ChrisHouston: </p> <hr /> <div><p>Relationships are the most powerful part of graph-based databases. While some of the functionality these provide is possible under SQL using join tables for many to many relationships, certain queries can be constructed which would require many joins in SQL.</p><br /> <p>All relationships in Neo4j are directional, that is they have a start and end node. They can only possess a single <code>TYPE</code>, rather than multiple labels, but they can also possess properties similar to nodes</p><br /> <br /> == Visualisation ==<br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Relationship types==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The <code>Type()</code> function can return the type of a relationship</p><br /> <p class='strong'>Return the type of the relationship between Astronaut and Mission</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[r]->(c:Country) RETURN type(r);</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[r]->(m:Mission) RETURN type(r);</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p>Note the <code>(startNode)-[:LABEL_NAME]->(endNode)</code> format. The direction the arrow points shows which node is the end point.</p><br /> <p>It is perfectly valid to express this relationship as <code>(endNode)<-[:LABEL_NAME]-(startNode)</code></p><br /> <p>If you are not concerned about the direction of the relationships, you can also <code>MATCH</code> based on <code>(node1)-[:LABEL_NAME]-(node2)</code></p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Flight Colleagues==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Numerous relationships can be strung together. <code>DISTINCT</code> can be used to only display a result once if that node is linked to multiple times</p><br /> <p class='strong'>Show the names of everyone that James Lovell flew with.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Armstrong"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Lovell"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Relationships_Tutorial&diff=1399 Space Race/Relationships Tutorial 2019-11-29T09:38:57Z

<p>ChrisHouston: </p> <hr /> <div><p>Relationships are the most powerful part of graph-based databases. While some of the functionality these provide is possible under SQL using join tables for many to many relationships, certain queries can be constructed which would require many joins in SQL.</p><br /> <p>All relationships in Neo4j are directional, that is they have a start and end node. They can only possess a single <code>TYPE</code>, rather than multiple labels, but they can also possess properties similar to nodes</p><br /> <br /> == Visualisation ==<br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Relationship types==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The <code>Type()</code> function can return the type of a relationship</p><br /> <p class='strong'>Return the type of the relationship between Astronaut and Mission</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[r]->(c:Country) RETURN type(r);</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[r]->(m:Mission) RETURN type(r);</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p>Note the <code>(startNode)-[:LABEL_NAME]->(endNode)</code> format. The direction the arrow points shows which node is the end point.</p><br /> <p>It is perfectly valid to express this relationship as <code>(endNode)<-[:LABEL_NAME]-(startNode)</code></p><br /> <p>If you are not concerned about the direction of the relationships, you can also <code>MATCH</code> based on <code>(node1)-[:LABEL_NAME]-(node2)</code></p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Flight Colleagues==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Numerous relationships can be strung together. <code>DISTINCT</code> can be used to only display a result once if that node is linked to multiple times</p><br /> <p class='strong'>Show the names of everyone that James Lovell flew with.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Armstrong"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Lovell"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Relationships_Tutorial&diff=1398 Space Race/Relationships Tutorial 2019-11-29T09:38:27Z

<p>ChrisHouston: </p> <hr /> <div><p>Relationships are the most powerful part of graph-based databases. While some of the functionality these provide is possible under SQL using join tables for many to many relationships, certain queries can be constructed which would require many joins in SQL.</p><br /> <p>All relationships in Neo4j are directional, that is they have a start and end node. They can only possess a single <code>TYPE</code>, rather than multiple labels, but they can also possess properties similar to nodes</p><br /> <br /> == Visualisation ==<br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Relationship types==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The <code>Type()</code> function can return the type of a relationship</p><br /> <p class='strong'>Return the type of the relationship between Astronaut and Mission</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[r]->(c:Country) RETURN type(r);</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[r]->(m:Mission) RETURN type(r);</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p>Note the <code>(startNode)-[:LABEL_NAME]->(endNode)</code> format. The direction the arrow points shows which node is the end point.</p><br /> <p>It is perfectly valid to express this relationship as <code>(endNode)<-[:LABEL_NAME]-(startNode)</code></p><br /> <p>If you are not concerned about the direction of the relationships, you can also <code>MATCH</code> based on <code>(node1)-[:LABEL_NAME]-(node2)</code></p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Flight Colleagues==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Numerous relationships can be strung together. <code>DISTINCT</code> can be used to only display a result once if that node is linked to multiple times</p><br /> <p class='strong'>Show the names of everyone that James Lovell flew with and the mission he flew with them on.</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Armstrong"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Lovell"})-[:CREWED]->(a:Mission)<-[:CREWED]-(m:Astronaut) RETURN DISTINCT m.surname, m.first_name</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=NoSQL_Zoo&diff=1397 NoSQL Zoo 2019-11-29T09:04:16Z

<p>ChrisHouston: </p> <hr /> <div>Learn NoSQL using MongoDB.<br /> <div class="q nonum" data-lang="mongo"><br /> What is the capital of France?<br /> <pre class="def"><nowiki>db.world.findOne({name: "France"}, {capital: 1});</nowiki></pre><br /> </div><br /> {{TopTenTips}}<br /> <div style="min-height:25em"><br /> ==Tutorials: Learn NoSQL in stages==<br /> <br /> ===MongoDB===<br /> ; 1 [[FIND Tutorial|FIND Tutorial]]:Using Find.<br /> ; 2 [[AGGREGATE Tutorial|AGGREGATE Tutorial]]:In which we query the world collection and make use of aggregate functions. (extra: [[AGGREGATE Movies Tutorial|AGGREGATE Movies Tutorial]])<br /> ; 3 [[MAPREDUCE Tutorial]]:Using MapReduce.<br /> ; 4 [[MAPREDUCE Elite]]:MapReduce questions using the Elite Dangerous dataset.<br /> ; 5 [https://goo.gl/forms/ep8rBbCQSa381ic82 Survey]:Do you have thoughts about this website that you would like to share? Help improve NoSQLZoo!<br /> ===Neo4j===<br /> ; 1 [[Space_Race/MATCH_Tutorial|MATCH Tutorial]]: Using MATCH<br /> ; 2 [[Space_Race/Relationships_Tutorial|Relationships Tutorial]]: Understanding Relationships<br /> </div><br /> <br /> ==Reference: How to...==<br /> ; [[AGGREGATE examples | AGGREGATE Examples]]<br /> ; [[Find|FIND]]<br /> ; [[FIND Examples]]<br /> ; [[JavaScript: Fundamentals]]<br /> ; [[JavaScript: Computed Properties]]<br /> ; [[MapReduce | MAPREDUCE]]<br /> ; [[Elite Document Structure|NOSQLZOO: 'elite' dataset schema]]<br /> ; [[RegEx Pattern Matching]]<br /> <br /> ==MongoDB resources==<br /> ;Manuals: [http://docs.mongodb.org/manual/ MongoDB Documentation] [https://github.com/mongodb/docs MongoDB Documentation GitHub]<br/>[https://docs.python.org/3/ Python 3 Documentation] [http://api.mongodb.org/python/current/ PyMongo API Documentation]<br/> Karl Seguin's [http://openmymind.net/mongodb.pdf The Little MongoDB Book]<br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1396 Space Race 2019-11-29T09:03:49Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> <p>[[/MATCH_Tutorial]]</p><br /> <p>[[/Relationships_Tutorial]]</p><br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=NoSQL_Zoo&diff=1395 NoSQL Zoo 2019-11-29T09:03:05Z

<p>ChrisHouston: </p> <hr /> <div>Learn NoSQL using MongoDB.<br /> <div class="q nonum" data-lang="mongo"><br /> What is the capital of France?<br /> <pre class="def"><nowiki>db.world.findOne({name: "France"}, {capital: 1});</nowiki></pre><br /> </div><br /> {{TopTenTips}}<br /> <div style="min-height:25em"><br /> ==Tutorials: Learn NoSQL in stages==<br /> <br /> ===MongoDB===<br /> ; 1 [[FIND Tutorial|FIND Tutorial]]:Using Find.<br /> ; 2 [[AGGREGATE Tutorial|AGGREGATE Tutorial]]:In which we query the world collection and make use of aggregate functions. (extra: [[AGGREGATE Movies Tutorial|AGGREGATE Movies Tutorial]])<br /> ; 3 [[MAPREDUCE Tutorial]]:Using MapReduce.<br /> ; 4 [[MAPREDUCE Elite]]:MapReduce questions using the Elite Dangerous dataset.<br /> ; 5 [https://goo.gl/forms/ep8rBbCQSa381ic82 Survey]:Do you have thoughts about this website that you would like to share? Help improve NoSQLZoo!<br /> ===Neo4j===<br /> ; 1 [[Space_Race/MATCH_Tutorial|MATCH TUTORIAL]]: Using MATCH<br /> ; 2 [[Space_Race/Relationship_Tutorial|RELATIONSHIP TUTORIAL]]: Understanding Relationships<br /> </div><br /> <br /> ==Reference: How to...==<br /> ; [[AGGREGATE examples | AGGREGATE Examples]]<br /> ; [[Find|FIND]]<br /> ; [[FIND Examples]]<br /> ; [[JavaScript: Fundamentals]]<br /> ; [[JavaScript: Computed Properties]]<br /> ; [[MapReduce | MAPREDUCE]]<br /> ; [[Elite Document Structure|NOSQLZOO: 'elite' dataset schema]]<br /> ; [[RegEx Pattern Matching]]<br /> <br /> ==MongoDB resources==<br /> ;Manuals: [http://docs.mongodb.org/manual/ MongoDB Documentation] [https://github.com/mongodb/docs MongoDB Documentation GitHub]<br/>[https://docs.python.org/3/ Python 3 Documentation] [http://api.mongodb.org/python/current/ PyMongo API Documentation]<br/> Karl Seguin's [http://openmymind.net/mongodb.pdf The Little MongoDB Book]<br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1394 Space Race 2019-11-29T09:02:14Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> <p>[[/MATCH_Tutorial]]</p><br /> <p>[[/Relationship_Tutorial]]</p><br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1393 Space Race 2019-11-29T09:01:50Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> [[/MATCH_Tutorial]]<br /> [[/Relationship_Tutorial]]<br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/Relationships_Tutorial&diff=1392 Space Race/Relationships Tutorial 2019-11-29T09:01:24Z

<p>ChrisHouston: Created page with "<p>Relationships are the most powerful part of graph-based databases. While some of the functionality these provide is possible under SQL using join tables for many to many re..."</p> <hr /> <div><p>Relationships are the most powerful part of graph-based databases. While some of the functionality these provide is possible under SQL using join tables for many to many relationships, certain queries can be constructed which would require many joins in SQL.</p><br /> <p>All relationships in Neo4j are directional, that is they have a start and end node. As well as being also able to possess labels, they can also possess properties similar to nodes</p><br /> <br /> == Visualisation ==<br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p>Note the <code>(startNode)-[:LABEL_NAME]->(endNode)</code> format. The direction the arrow points shows which node is the end point.</p><br /> <p>It is perfectly valid to express this relationship as <code>(endNode)<-[:LABEL_NAME]-(startNode)</code></p><br /> <p>If you are not concerned about the direction of the relationships, you can also <code>MATCH</code> based on <code>(node1)-[:LABEL_NAME]-(node2)</code></p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1391 Space Race/MATCH Tutorial 2019-11-29T08:47:13Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth from earlier to later</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1390 Space Race/MATCH Tutorial 2019-11-28T17:32:57Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual properties of a node.</p><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth from earlier to later</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather than empty properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> function</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1389 Space Race/MATCH Tutorial 2019-11-28T09:31:55Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p class='strong'>Show Institutions instead of Astronauts</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual properties of a node.</p><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p class='strong'>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</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. Adding <code>DESC</code> instead orders the result in descending order</p><br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth from earlier to later</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Nicknames==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>In Neo4j, rather empty than properties being assigned a value of <code>NULL</code> like in SQL, properties which are not assigned a value do not exist at all </p><br /> <p> This can be checked using the <code>EXISTS()</code> comparator</p><br /> <p class='strong'>Return the nicknames of the Astronauts who have them in reverse alphabetical order</p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.middle_names) RETURN n.middle_names; </nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)WHERE EXISTS(n.nickname) RETURN n.nickname ORDER BY n.nickname DESC;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1388 Space Race/MATCH Tutorial 2019-11-28T09:19:11Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual properties of a node.</p><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p class='strong'>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<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> ==The Young and Old==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p><code>ORDER BY</code> works similarly to SQL, defaulting to ordering from low to high value. <br /> <p class='strong'>Return the names of the Astronauts ordered by their date of birth from earlier to later<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut) RETURN n.first_name, n.surname ORDER BY n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1387 Space Race/MATCH Tutorial 2019-11-28T08:56:18Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual properties of a node.</p><br /> <p>The item in <code>[]</code> represents a <strong>relationship</strong> between nodes, in this case the relationship possessing the label "BORN_IN"</p><br /> <p class='strong'>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<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]->(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> ==Neil Armstrong's Birthday==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>When simply matching based on properties of a node, an alternative to using <code>WHERE</code> is to use the <code>{}</code> with the format <code>{property:value}</code><br /> <p class='strong'>Return Neil Armstrong's date of birth<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut{surname:"Gagarin",first_name:"Yuri"})RETURN n.dob;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut{surname:"Armstrong",first_name:"Neil"})RETURN n.dob;</nowiki><br /> </pre><br /> </div><br /> <br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=NoSQL_Zoo&diff=1386 NoSQL Zoo 2019-11-28T08:36:17Z

<p>ChrisHouston: </p> <hr /> <div>Learn NoSQL using MongoDB.<br /> <div class="q nonum" data-lang="mongo"><br /> What is the capital of France?<br /> <pre class="def"><nowiki>db.world.findOne({name: "France"}, {capital: 1});</nowiki></pre><br /> </div><br /> {{TopTenTips}}<br /> <div style="min-height:25em"><br /> ==Tutorials: Learn NoSQL in stages==<br /> <br /> ===MongoDB===<br /> ; 1 [[FIND Tutorial|FIND Tutorial]]:Using Find.<br /> ; 2 [[AGGREGATE Tutorial|AGGREGATE Tutorial]]:In which we query the world collection and make use of aggregate functions. (extra: [[AGGREGATE Movies Tutorial|AGGREGATE Movies Tutorial]])<br /> ; 3 [[MAPREDUCE Tutorial]]:Using MapReduce.<br /> ; 4 [[MAPREDUCE Elite]]:MapReduce questions using the Elite Dangerous dataset.<br /> ; 5 [https://goo.gl/forms/ep8rBbCQSa381ic82 Survey]:Do you have thoughts about this website that you would like to share? Help improve NoSQLZoo!<br /> ===Neo4j===<br /> ; 1 [[Space_Race/MATCH_Tutorial|MATCH TUTORIAL]]: Using MATCH<br /> </div><br /> <br /> ==Reference: How to...==<br /> ; [[AGGREGATE examples | AGGREGATE Examples]]<br /> ; [[Find|FIND]]<br /> ; [[FIND Examples]]<br /> ; [[JavaScript: Fundamentals]]<br /> ; [[JavaScript: Computed Properties]]<br /> ; [[MapReduce | MAPREDUCE]]<br /> ; [[Elite Document Structure|NOSQLZOO: 'elite' dataset schema]]<br /> ; [[RegEx Pattern Matching]]<br /> <br /> ==MongoDB resources==<br /> ;Manuals: [http://docs.mongodb.org/manual/ MongoDB Documentation] [https://github.com/mongodb/docs MongoDB Documentation GitHub]<br/>[https://docs.python.org/3/ Python 3 Documentation] [http://api.mongodb.org/python/current/ PyMongo API Documentation]<br/> Karl Seguin's [http://openmymind.net/mongodb.pdf The Little MongoDB Book]<br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1385 Space Race/MATCH Tutorial 2019-11-27T09:20:43Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to return nodes. Use <code>:</code> to specify what label(s) you wish the returned nodes to have. Not specifying any label will return ALL nodes</p><br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual properties of a node.</p><br /> <p class='strong'>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<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country{}) WHERE c.abbrev ='USA' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.abbrev= 'RU' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1384 Space Race/MATCH Tutorial 2019-11-27T09:11:51Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to show nodes that are Institutions rather than Astronauts</p><br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual properties of a node.</p><br /> <p class='strong'>Show the Surnames of Astronauts born in Russia rather than the USA <p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.abbrev ='usa' RETURN n.surname, c.name;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.abbrev= 'ru' RETURN n.surname;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1383 Space Race/MATCH Tutorial 2019-11-27T09:08:24Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>MATCH</code> and <code>RETURN</code> to show nodes that are Institutions rather than Astronauts</p><br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> <p>Use <code>WHERE</code> to specify conditions and the <code>.</code> operator to access individual</p><br /> <p class='strong'>Show the Surnames of Astronauts born in Russia rather than the USA <p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.name = 'United States of America' RETURN n.surname;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.name = 'Russia' RETURN n.surname;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1382 Space Race/MATCH Tutorial 2019-11-27T09:04:19Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Visualisation ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> and <code>RETURN</code> to show nodes that are Institutions rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>WHERE</code> to specify conditions<br /> <p class='strong'>Show Astronauts born in Russia rather than the USA <p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.name = 'United States of America' RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.name = 'Russia' RETURN n;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1381 Space Race/MATCH Tutorial 2019-11-27T09:03:46Z

<p>ChrisHouston: </p> <hr /> <div><br /> == MATCH ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ==Institutions==<br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> and <code>RETURN</code> to show nodes that are Institutions rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> ==Born in Russia==<br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>WHERE</code> to specify conditions<br /> <p class='strong'>Show Astronauts born in Russia rather than the USA <p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.name = 'United States of America' RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Astronaut)-[:BORN_IN]-(c:Country) WHERE c.name = 'Russia' RETURN n;</nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1380 Space Race 2019-11-26T18:11:16Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> [[/MATCH_Tutorial]]<br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1379 Space Race/MATCH Tutorial 2019-11-26T18:01:02Z

<p>ChrisHouston: </p> <hr /> <div><br /> == MATCH ==<br /> <br /> <br /> <br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <br /> ===MATCH===<br /> <div class="q nonum" data-lang="neo4j"><br /> Use MATCH and RETURN to show nodes that are Institutions rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race/MATCH_Tutorial&diff=1378 Space Race/MATCH Tutorial 2019-11-26T17:55:35Z

<p>ChrisHouston: Created page with "I am error"</p> <hr /> <div>I am error</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1377 Space Race 2019-11-26T09:40:27Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <div class="q nonum" data-lang="neo4j"><br /> Use MATCH and RETURN to show nodes that are Institutions rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1376 Space Race 2019-11-26T09:18:25Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php Click here for 3d graph visualisation]<br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1375 Space Race 2019-11-26T09:17:37Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> [http://nosqlzoo.net/mw/visproject/visualisation.php]<br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1374 Space Race 2019-11-22T10:36:04Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronaut) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institution) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1373 Space Race 2019-11-22T10:31:01Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronauts) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institutions) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1372 Space Race 2019-11-22T10:30:02Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronauts) RETURN *;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institutions) RETURN *; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1371 Space Race 2019-11-22T10:29:12Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronauts) RETURN properties(n);</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institutions) RETURN properties(n); </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1370 Space Race 2019-11-22T10:28:21Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronauts) RETURN n.*;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institutions) RETURN n.*; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston https://nosqlzoo.net/w/index.php?title=Space_Race&diff=1369 Space Race 2019-11-22T10:26:05Z

<p>ChrisHouston: </p> <hr /> <div><br /> == Learn how to use Neo4j using data from the Space Race. ==<br /> <br /> <div class="q nonum" data-lang="neo4j"><br /> Use <code>MATCH</code> to show nodes that are Countries rather than Astronauts<br /> <p class='strong'>Show Institutions instead of Astronauts<p><br /> <pre class="def"><nowiki>MATCH(n:Astronauts) RETURN n;</nowiki><br /> </pre><br /> <pre class="ans"><nowiki>MATCH(n:Institutions) RETURN n; </nowiki><br /> </pre><br /> </div><br /> <br /> {{Acknowledgements}}</div>

ChrisHouston