Desert Rock bands analysis with JSON, GraphQL, and SQL/PGQ
Conference (BEGINNER level)
Is there any relation between Queens of the Stone Age and Kyuss? Josh Homme played in both bands. That’s an easy one. What about more complex paths between desert rock bands? Or musical artists in general? In this 100% demo session, we’ll get semi-structured data about musical artists from Wikipedia, convert it to JSON, store it as relational for more robust data validation and easier integration, and analyze it as a graph through the SQL/PGQ syntax. It sounds like lots of code to write, but it is damn easy when using the right tools.
Ludovico is a database specialist and seasoned speaker with two decades of experience in several relational databases. He’s been a consultant and trainer for most of his career, focusing on performance, high availability, and data modeling before joining Oracle as a product manager for Oracle Data Guard and Flashback technologies.