Niall Mc Phillips has been developing using Oracle since 1989, has been using Oracle PL/SQL Web technologies since 1995 and Oracle APEX since 2005.
Niall has developed a number of large, multilingual applications for multinational companies and organisations all over the world. He is a strong believer in PL/SQL and APEX solutions because of their stability, scalability, and rapid development speed.
Niall is an Oracle ACE and is the organiser of the Swiss APEX Meetup group and, in the past, 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.
During Contech2022, Nial will present Mixing Relational with NoSQL – Heresy or Harmony ?
|Mixing Relational with NoSQL – Heresy or Harm – Abstract|
This presentation will explore the mixing of relational and JSON data together to create “hybrid” data models. Multiple aspects will be covered, including the culture clash between the two approaches and the practical side of implementing with an Oracle database.
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.