However, as Marco reported from Oracle OpenWorld, native JSON support may be an upcoming new feature in Oracle Database 12c.
This new feature allows the storage of JSON documents in table columns with existing data types like VARCHAR2, CLOB, RAW, BLOB and BFILE.
A new check constraint makes sure only valid JSON is inserted.
For example: CHECK column IS JSON.
New built-in operators allow you to work with stored JSON documents. For example, JSON_VALUE enables you to query JSON data and return the result as a SQL value. Other operators include JSON_QUERY, JSON_EXISTS and JSON_TABLE.
Cool stuff!Comments Off | Filed in Oracle | Tags: 12c, json
The in-memory component duplicates data (specified tables – perhaps with a restriction to a subset of columns) in columnar format in a dedicated area of the SGA. The data is kept up to date in real time, but Oracle doesn’t use undo or redo to maintain this copy of the data because it’s never persisted to disc in this form, it’s recreated in-memory (by a background process) if the instance restarts. The optimizer can then decide whether it would be faster to use a columnar or row-based approach to address a query.Comments Off | Filed in Oracle | Tags: 12c, in-memory
The intent is to help systems which are mixed OLTP and DSS – which sometimes have many “extra” indexes to optimise DSS queries that affect the performance of the OLTP updates. With the in-memory columnar copy you should be able to drop many “DSS indexes”, thus improving OLTP response times – in effect the in-memory stuff behaves a bit like non-persistent bitmap indexing.
Speaking of new features, here is what’s new in Oracle Database, SQL and PL/SQL from 9iR1 until 12cR1.Comments Off | Filed in Oracle | Tags: 12c
What is the first thing you do when a new version of an Oracle database (or any software) is released? You immediately look for the “what’s new” document, right?
I believe that the “What’s new” document is very important because it informs you of new (or modified) features that is supposed to make your life easier and your applications more powerful.
Take advantage of “what’s new”. After all, you’re paying for these new features (I assume), so use them or lose them.
To that end, here is a list of “what’s new” links. They will take you straight to the corresponding section of the Oracle documentation:
What’s new in Oracle Database version:
What’s new in SQL in Oracle Database version:
What’s new in PL/SQL in Oracle Database version:3 Comments | Filed in Oracle, Tips | Tags: 10g, 11g, 12c, 9i, Documentation