Join William Lyon for an in-depth discussion in this video Refactor the data model, part of Database Clinic: Neo4J.
- [Instructor] Let's now add this data…to our existing Neo4j database.…So I'm going to open a new tab,…I have Neo4j running,…so I can simply switch to localhost: 7474…to switch to Neo4j Browser.…Before we can import our data…we need to refactor our data model…by pulling the year property out of PopulationPrediction…and creating year nodes…with a FOR_YEAR relationship connecting…PopulationPrediction nodes and our new year nodes.…
The first step is to create a uniqueness constraint…on our new Year node label,…asserting that the year property is unique.…And now we can create year nodes for each distinct year…that we have by matching on our PopulationPrediction nodes,…finding the distinct years,…we'll alias these to pop_year,…so it's clear what that is.…
These are all of the distinct years that we've found…from our PopulationPrediction nodes.…And then we can use the merge keyword…to create new year nodes,…setting the year property equal to pop_year.…So let's run this.…This will take a moment to complete,…because we need to first match…
- Strengths and weaknesses of Neo4j
- Data modeling
- Creating a database
- Joining data sets
- Modeling data for joining data sets
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Intermediate
1. Neo4j in Five Minutes
A brief overview of Neo4j3m 23s
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
Next steps1m 44s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.