/GraphQLConf 2025

-

Amsterdam, Netherlands
Back to Schedule

Shashank Gugnani

Revolutionizing Data Access Using GraphQL in the Oracle Database

-
Metropolitan A
GraphQL in ProductionSession Presentations

Shashank Gugnani

Software Development Manager, Oracle

I am an engineering manager in the Database Transactions team at Oracle, working on the design and implementation of next-generation Oracle database products. I hold a PhD in Computer Science from The Ohio State University and an undergraduate degree in Computer Science from BITS-Pilani. My research interests are related to storage systems and problems of scale in distributed systems. I have published several papers in top conferences and journals including VLDB, HPDC, SC, IPDPS, and BigData.

We will explore the revolutionary integration of GraphQL with the Oracle Database in this session. The way developers query and interact with the database has been greatly simplified by this integration. We will introduce the concept of Duality Views, a brand-new feature available in Oracle Database 23ai. Using Duality Views, data is still stored in relational tables in a highly efficient normalized format but is accessed by apps in the form of JSON documents. Duality Views are created using an intuitive and flexible GraphQL-like syntax, enhancing developer productivity. We will also demonstrate new capabilities in the database to automatically infer the GraphQL schema from existing relational schemas, making it easy to introspect and visualize the relational schema as well as write GraphQL queries against the database. Finally, we will talk about new GraphQL directives to allow calculations, reshaping, and transformations in a GraphQL query that can be executed on a relational database. Come learn how Oracle's support for GraphQL is transforming data access and providing a powerful and seamless solution for modern application development.