JSON is extremely popular: what started as a serialization format for JavaScript objects and moved on to the de-facto messaging format for web applications has become the main data model for many new applications - including the database tier.
Developers love JSON because it supports dynamic schemas and hence makes schema changes easy. Instead of normalizing data into a fixed relational schema with tables and columns, developers can use JSON documents to also gain agility on the data tier when making application changes.
Oracle identified the benefits and requirements of JSON very early: in 2014, Oracle Database delivered the first enterprise class implementation of SQL/JSON - an open standard that Oracle initiated and that has since been adopted by many other commercial and open-source database products.
While SQL is a great language for analytics or complex reporting, many developers prefer a simpler and more flexible way to interact with JSON data. Consequently, Oracle added a native, open-source document store API called SODA (Simple Oracle Document Access) for common programming languages including Java, JavaScript and Python. Developing applications with JSON and SODA is as easy with Oracle as it is with NoSql databases like MongoDB.
With Oracle Release 20c and the Autonomous JSON Database cloud service we keep innovating in this space: we added a new binary data type so store, query and update more efficiently JSON. Also, with the new operator JSON_TRANSFORM we now allow to perform piece-wise updates of JSON data.
This presentation gives a technical overview of the current JSON and SODA features in the Oracle database. It also shows some common customer use-cases and migration stories from NoSQL products to Oracle Database.
2 окт 2024