Using the Merge and Unique commands in Cypher

…In this video, we're going to explore some…more advanced concepts: using merge, unique as well…as some of the variables that we can pull up or include inside of our Cypher.…Consider the merge clause.…We can merge.…It's basically the same as saying match or create if we use merge.…And it uses indexes, constraints and locks to guarantee unique lookup or creation.…In this case, we're merging a person, the name Clint…Eastwood returning the person back, so we know that it succeeded.…

But there's more to it that we can use.…In this Cypher query you can see that on the first…line, we've used the Merge command with the person named Clint…Eastwood, and then on the second line, there's some new Cypher…that you have not seen yet, on create and then set.…And this is used to execute whatever follows afterwards.…It's sort of like an event handler,…if you're familiar with other programming languages.…And now it's looking for the person that was created and it's adding a time stamp.…

So let's step back for a second and look at some of these commands.…

Resume Transcript Auto-Scroll

Author

Released

5/29/2014

Why are people abandoning their RDMS databases and switching to graph databases like Neo4j? It's more than a "big data" trend. Graph databases can handle more complex data and relationships, which are baked in at the record level. Take a trip through the nuances of the most popular graph database, Neo4j, with Duane Nickull and find out if it's right for your data. He covers key concepts, like transitions, searches, and traversals, and shows you how to work with nodes, the relationships between nodes, and navigate large graphs of information. Developers will be interested in the chapters devoted to Cypher, the query language for finding, creating, modifying, and deleting Neo4J data. There are ten coding challenges sprinkled throughout the course, allowing you to test your Cypher skills, and the exercise files feature a fun, interactive mini "IMDB" that explores data from your favorite movies.