book

Learning Cypher

by Onofrio Panzarino

May 2014

Intermediate to advanced

162 pages

3h 24m

English

Packt Publishing

Read now

Unlock full access

Support files, eBooks, discount offers, and moreWhy subscribe?Free access for Packt account holders
What this book covers

Downloading the example codeErrataPiracyQuestions
Setting up a new Neo4j databaseNeo4j running modesNeo4j ServerAn embedded databasePreparing the development environmentCreating an embedded databaseConfiguration
Creating nodes and relationships using the Java APIA querying databaseInvoking Cypher from JavaFinding nodes by relationshipsFiltering propertiesFiltering relationshipsDealing with missing partsWorking with pathsNode IDs as starting pointsQuery parametersPassing parameters with Java
FilteringThe book store – an exampleText searchWorking with regular expressionsEscaping the textValue comparisonsThe IN predicateBoolean operatorsWorking with collectionsPaging results – LIMIT and SKIP
A descending sortDealing with null values using the COALESCE function
Counting matching rows or non-null valuesSummationAverageMaximum and minimumStandard deviationCollecting values in an arrayGrouping keysConditional expressionsSeparating query parts using WITH
Using Neo4j Browser
Labels and propertiesMultiple labelsPropertiesCreating multiple patternsCreating relationshipsCreating full pathsCreating relationships between existing nodes using read-and-write queries
Creating unique patternsComplex patternsSetting properties and labelsCloning a nodeAdding labels to nodesMerging matched patternsIdempotent queries
Removing labelsRemoving propertiesDeleting nodes and relationsClearing the whole database
Working with collections
Performance issues
Using parameterized queriesParameterized queries with the REST APIReusing ExecutionEngineFinding the optimum transaction sizeAvoiding unnecessary clausesSpecifying the direction of relationships and variable length paths
Profiling using the Java APIInside the execution plan descriptionProfiling with Neo4j ShellProfiling with the REST API
SCAN hintsIndex hintsConstraints
Our example
LabelsIndexes and constraintsRelationships
EntitiesRelationships
CRUDSearching queriesGrouping queries
OperatorsComparison operatorsOrdering operatorsEquality operatorsNULL equality operatorsMathematical operatorsThe concatenation operatorThe IN operatorRegular expressions
COALESCETIMESTAMPIDWorking with nodesNODESLABELSWorking with paths and relationshipsTYPEENDNODE and STARTNODESHORTESTPATH and ALLSHORTESTPATHSRELATIONSHIPSWorking with collectionsHEAD, TAIL, and LASTLENGTHEXTRACTFILTERREDUCERANGEWorking with stringsSUBSTRING, LEFT, and RIGHTSTRREPLACETrimming functionsLOWER and UPPERAggregation functionsCOUNTSUMAVGPERCENTILEDISC and PERCENTILECONTSTDEV and STDEVPMIN and MAXMathematical functions

Overview

"Learning Cypher" provides an in-depth look into Cypher, the functional query language for Neo4j, the powerful graph database. Whether you're transitioning from relational databases or exploring graph technology for the first time, this book offers practical guidance to help you write efficient, clear, and reusable queries.

What this Book will help me do

Master the Cypher declarative query syntax for graph databases.
Write optimized Cypher queries for better application performance.
Transform relational database data to graph database structures with ease.
Understand the nuances of transitioning from SQL to graph paradigms.
Learn the common pitfalls in Neo4j programming and how to avoid them.

Author(s)

Onofrio Panzarino is an experienced database developer specializing in graph technologies and Neo4j. He is passionate about teaching industry best practices to developers and has extensive experience in designing graph-based solutions. Through his approachable style, he empowers readers to excel in using graph databases effectively.

Who is it for?

This book is for database developers, data analysts, and software engineers who want to expand their knowledge into graph databases. If you work with large-scale connected data or are transitioning from SQL to a graph model, this book is ideal for you. Prior experience with any database query language will be helpful. The book is also suitable for students and professionals looking to integrate graph technology into their projects.