Limit search to available items
Record 17 of 29
Previous Record Next Record
Book Cover
E-book
Author Panzarino, Onofrio

Title Learning cypher : write powerful and efficient queries for Neo4j with Cypher its official query language / Onofrio Panzarino
Published Birmingham, U.K. : Packt Pub., 2014

Copies

Description 1 online resource (1 volume) : illustrations
Series Community experience distilled
Community experience distilled.
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
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
Summary Chapter 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
Chapter 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
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
Notes Includes index
English
Online resource; title from cover (Safari, viewed June 09, 2014)
Subject Non-relational databases.
Databases -- Development
Database design.
Databases -- Programming
Query languages (Computer science)
COMPUTERS -- Data Processing.
COMPUTERS -- Programming -- Open Source.
COMPUTERS -- Programming Languages -- SQL.
Database design
Non-relational databases
Query languages (Computer science)
Form Electronic book
ISBN 9781783287765
1783287764
1783287756
9781783287758