Development & Middleware
Thursday, 13. October 2022., 14:30
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.