Mixing Relational with NoSQL - Heresy or Harmony ?
Track
Development & Middleware
Date and time
Thursday, 13. October 2022., 14:30
Room
Hall C
Duration
45'
This presentation will explore the mixing of relational and JSON data together to create "hybrid" data models. The presenter has over 30-years of experience modelling relational databases and has recently been involved in the design and implementation of some hybrid relational-JSON databases.Topics to be covered will include: • A short history of traditional relational data modelling and data normalisation • A quick intro to JSON document databases • Advantages and disadvantages of both the relational and the JSON-object models • Culture clash - the meeting of two worlds • Oracle's Converged DB vision • Modelling differences: application-independence vs. application-oriented • creating JSON objects from relational data • creating relational data from JSON objects • "The Best of Both Worlds" - Can relational and JSON live together in harmony? • What does a hybrid model look like? Some use-cases.
Lecture details
About speaker
Niall Mc Phillips, author
Niall Mc Phillips is an Oracle ACE and is the organiser of the Swiss APEX Meetup group. Niall has been developing using Oracle since 1989, has been using Oracle PL/SQL Web technologies since 1995, and has used Oracle APEX since 2005.He has developed a number of large, multilingual applications for multinational companies and organizations all over the world. He is a strong believer in APEX and PL/SQL solutions because of their stability, scalability, and rapid development speed.Niall has presented at conferences on different subjects including the use of Oracle technologies such as APEX, Oracle Text, SODA, Multimedia as well as on his experiences with the implementation of large Oracle APEX projects.