Loading…
GraphConnect 2020 has ended
Back To Schedule
Tuesday, April 21 • 2:15pm - 2:55pm
Contrasting Neo4j vs RDBMS, a Performance Deep Dive

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

If you came to Neo4j from the RDBMS world, you've likely noticed that conventions around queries is dramatically different between them. Not just in syntax, but in structure. For example, a SQL query with 7 JOINs in it will likely terrify a DBA, but connecting that many different entity types is commonplace in Cypher.During this talk, we'll explore how Neo4j and PostgreSQL store data on disk and send it over the wire, and use that insight to analyze the performance profiles of both databases in various query scenarios.
This presentation contains pretty advanced topics, as we'll be examining logistics of data at rest and in motion, but I will endeavor to present these topics in a way that will be easier to understand for beginner-level data engineers and intermediate-level solution engineers.The RDBMS implementation we will be discussing is PostgreSQL. It's not THE most popular RDBMS but it's the one I have the most intimate knowledge of, it's common enough that the audience is likely to have worked with it, and other implementations such as MySQL are close enough in their performance profiles (since SQL is prescriptive enough to coerce implementations into similar structures) that most RDBMS details mentioned in the talk are usable as at least a foundation for evaluating performance.

Speakers
JG

Jamie Gaskins

Jamie Gaskins is a software architect at Snapdocs, Inc. where he uses his distributed-systems expertise to bring the real estate industry into the 21st century. Jamie is a Neo4j Certified Professional and the creator and maintainer of the Crystal language Neo4j driver.


Tuesday April 21, 2020 2:15pm - 2:55pm EDT
Room 4