Learning Cypher. Write powerful and efficient queries for Neo4j with Cypher, its official query language - Helion

ebook

Autor: Onofrio Panzarino
Tytuł oryginału: Learning Cypher. Write powerful and efficient queries for Neo4j with Cypher, its official query language
ISBN: 9781783287765
stron: 162, Format: ebook
Data wydania: 2014-05-14
Księgarnia: Helion

Cena książki: 89,90 zł

Osoby, które kupiły tę książkę, wybierały także »

Osoby które kupowały "Learning Cypher. Write powerful and efficient queries for Neo4j with Cypher, its official query language", wybierały także:

Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
DevOps w praktyce. Kurs video. Jenkins, Ansible, Terraform i Docker 190,00 zł, (39,90 zł -79%)
Przywództwo w świecie VUCA. Jak być skutecznym liderem w niepewnym środowisku 58,64 zł, (12,90 zł -78%)
Scrum. O zwinnym zarządzaniu projektami. Wydanie II rozszerzone 58,64 zł, (12,90 zł -78%)

Spis treści

Learning Cypher. Write powerful and efficient queries for Neo4j with Cypher, its official query language eBook -- spis treści

Learning Cypher
- Table of Contents
- Learning Cypher
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
  - Support files, eBooks, discount offers, and more
    - Why subscribe?
    - Free access for Packt account holders
- Preface
  - What this book covers
  - What you need for this book
  - Who this book is for
  - Conventions
  - Reader feedback
  - Customer support
    - Downloading the example code
    - Errata
    - Piracy
    - Questions
- 1. Querying Neo4j Effectively with Pattern Matching
  - Setting up a new Neo4j database
    - Neo4j running modes
      - Neo4j Server
      - An embedded database
        
        Preparing the development environment
        
        Creating an embedded database
        
        Configuration
  - 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
  - Summary
- 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 statement
  - Summary
- 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 database
  - Loops
    - Working with collections
  - Summary
- 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
- 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
- A. 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
      - RELATIONSHIPS
    - Working with collections
      - HEAD, TAIL, and LAST
      - LENGTH
      - EXTRACT
      - FILTER
      - REDUCE
      - RANGE
    - Working with strings
      - SUBSTRING, LEFT, and RIGHT
      - STR
      - REPLACE
      - Trimming functions
      - LOWER and UPPER
    - Aggregation functions
      - COUNT
      - SUM
      - AVG
      - PERCENTILEDISC and PERCENTILECONT
      - STDEV and STDEVP
      - MIN and MAX
    - Mathematical functions
- Index