Learning Cypher : write powerful and efficient queries for Neo4j with Cypher, its official query language / Onofrio Panzarino ; cover image by Jaroslaw Blaminsky.
- Other records:
- 1st edition
- Birmingham, England : Packt Publishing, 2014.
- Community experience distilled.
Community Experience Distilled
1 online resource (162 p.)
- Database management.
- Electronic books.
- System Details:
- text file
- 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.
- 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
- Includes index.
Description based on online resource; title from PDF title page (ebrary, viewed May 30, 2014).
- Blaminsky, Jaroslaw, cover designer.
|Location||Notes||Your Loan Policy|
|Description||Status||Barcode||Your Loan Policy|