See how JSON can help you handle complex structures in standard ways so everyone receives the same data from your database no matter how they consume the data (REST or function).
Omnis Studio works well with JSON. With a bit of a framework, you can model and build complex objects easily, fetch them with a single fetch from the database, have them keep track of themselves and then update the database as necessary using JSON!
Performance can be 25% to 50% faster compared to traditional database accessor models!
In this session we’ll cover:
See how advanced SQL itself can get data the way you want it with one fetch from the database and eliminate costly Omnis side workarounds like looping thought lists.
Bring your SQL challenges to this hands on session to work through advanced SQL topics like pivots, analytic functions, aggregations, inline views, Common Table Expressions (CTEs), and more and see how your challenges in getting data from the database with speed and efficiency can be handled.
In this session we’ll cover such topics as: