JSON enhancements functionalities
Oracle has been forced over time to adopt the new NoSQL trend because of the competition and also the fact that the concept of storage type document as JSON came to be much more practical at the management level; for some companies that have architectures such as big data, this became more of a constraint at the application level.
For these reasons, Oracle introduced for the first time in MySQL 5.7.8, the JSON data type, which is a type of specialized binary column, similar to a blob, but with additional features to optimize storage and recover the values of a JSON type column.
In the new version of MySQL 8.0, Oracle has added great features such as automatic validation, JSON document normalization, and automatic ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access