Desert Rock bands analysis with JSON, GraphQL, and SQL/PGQ

Ludovico Caldara

14:40

Tuesday, 30 January 2024

Back to the Agenda

Desert Rock bands analysis with JSON, GraphQL, and SQL/PGQ

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 stronger data validation and easier integration, and analyze it as a graph through the new SQL/PGQ syntax.

It sounds like lots of code to write, but it is damn easy when using the right tools.

(this session is 1h30 long)

About Ludovico

Member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle, Ludovico is the product manager for Oracle Data Guard and Flashback technologies.

Before joining Oracle, Ludovico was a multi-platform DBA, consultant, and trainer for Oracle customers and partners for over twenty years, focusing on Oracle Database and high availability architectures.