Learning Cypher : write powerful and efficient queries for Neo4j with Cypher, its official query language / Onofrio Panzarino ; cover image by Jaroslaw Blaminsky.

Format:

Book

Author/Creator:

Panzarino, Onofrio, author.

Contributor:

Blaminsky, Jaroslaw, cover designer.

Series:

Community experience distilled.

Community Experience Distilled

Language:

English

Subjects (All):

Database management.

Physical Description:

1 online resource (162 p.)

Edition:

1st edition

Place of Publication:

Birmingham, England : Packt Publishing, 2014.

Language Note:

English

System Details:

text file

Biography/History:

Panzarino Onofrio: Onofrio Panzarino is a programmer with 15 years experience working with various languages (mostly with Java), platforms, and technologies. Before obtaining his Master of Science degree in Electronics Engineering, he worked as a digital signal processor programmer. Around the same time, he started working as a C++ developer for embedded systems and PCs. Currently, he is working with Android, ASP. NET or C#, and JavaScript for Wolters Kluwer Italia. During these years, he gained a lot of experience with graph databases, particularly with Neo4j. Onofrio resides in Ancona, Italy. His Twitter handle is (@onof80). He is a speaker in the local Java user group and also a technical writer, mostly for Scala and NoSQL. In his spare time, he loves playing the piano with his family and programming with functional languages.

Summary:

An easy-to-follow guide full of tips and examples of real-world applications. In each chapter, a thorough example will show you the concepts in action, followed by a detailed explanation.This book is intended for those who want to learn how to create, query, and maintain a graph database, or who want to migrate to a graph database from SQL. It would be helpful to have some familiarity with Java and/or SQL, but no prior experience is required.

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Querying Neo4j Effectively with Pattern Matching; Setting up a new Neo4j database; Neo4j running modes; Neo4j Server; An embedded database; HR management tool - an example; Creating nodes and relationships using the Java API; A querying database; Invoking Cypher from Java; Finding nodes by relationships; Filtering properties; Filtering relationships; Dealing with missing parts; Working with paths; Node IDs as starting points; Query parameters; Passing parameters with Java

SummaryChapter 2: Filter, Aggregate, and Combine Results; Filtering; The book store - an example; Text search; Working with regular expressions; Escaping the text; Value comparisons; The IN predicate; Boolean operators; Working with collections; Paging results - LIMIT and SKIP; Sorting; A descending sort; Dealing with null values using the COALESCE function; Aggregating results; Counting matching rows or non-null values; Summation; Average; Maximum and minimum; Standard deviation; Collecting values in an array; Grouping keys; Conditional expressions; Separating query parts using WITH

The UNION statementSummary; Chapter 3: Manipulating the Database; Using Neo4j Browser; Creating nodes and relationships; Labels and properties; Multiple labels; Properties; Creating multiple patterns; Creating relationships; Creating full paths; Creating relationships between existing nodes using read-and-write queries; Modifying existing data; Creating unique patterns; Complex patterns; Setting properties and labels; Cloning a node; Adding labels to nodes; Merging matched patterns; Idempotent queries; Deleting data; Removing labels; Removing properties; Deleting nodes and relations

Clearing the whole databaseLoops; Working with collections; Summary; Chapter 4: Improving Performance; Performance issues; Best practices and recommendations; Using parameterized queries; Parameterized queries with the REST API; Reusing ExecutionEngine; Finding the optimum transaction size; Avoiding unnecessary clauses; Specifying the direction of relationships and variable length paths; Profiling queries; Profiling using the Java API; Inside the execution plan description; Profiling with Neo4j Shell; Profiling with the REST API; Indexes and constraints; SCAN hints; Index hints; Constraints

SummaryChapter 5: Migrating from SQL; Our example; Migrating the schema; Labels; Indexes and constraints; Relationships; Migrating the data; Entities; Relationships; Migrating queries; CRUD; Searching queries; Grouping queries; Summary; Appendix: Operators and Functions; Operators; Comparison operators; Ordering operators; Equality operators; NULL equality operators; Mathematical operators; The concatenation operator; The IN operator; Regular expressions; Functions; COALESCE; TIMESTAMP; ID; Working with nodes; NODES; LABELS; Working with paths and relationships; TYPE; ENDNODE and STARTNODE

SHORTESTPATH and ALLSHORTESTPATHS

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed May 30, 2014).

ISBN:

9781783287765

1783287764

OCLC:

880409743