OOW13: JSON Support in the Oracle 12c Database (upcoming feature)

Marco Gralike 2
0 0
Read Time:1 Minute, 28 Second

Currently I am attending the “Schema less data management using SQL/JSON” session during Oracle OpenWorld. This session demonstrated the new upcoming feature (=not in the current release) in the 12c database which supports JSON data handling in the database. That is, of course, with the nowadays common disclaimer, it probably will, but is not guaranteed by Oracle that they actually also will do so as presented… Nether the less it would be, could be a welcome new functionality. Without going into the flame wars between the XML and JSON communities, JSON is widely used and probably therefor has its merits in current build solutions.

JSON, JavaScript Object Notation has fairly the same kind of structures as XML. Due to it’s growing use JSON support is the logical next step for, in this case the Oracle XMLDB development team, to implement this support in the database. The XMLDB team mentioned the following goals.

20130925-171355.jpg

There will not be a new datatype, like the XMLType for XML content, but make current datatypes supportive for JSON data, following the current JSON standards, while creating a standard for these relational / JSON needs in a query method currently called SQL/JSON.Oracle’s vision in all of this is to be flexible enough and not support only one JSON datatype. Therefore the multiple datatype storage options.

20130925-172016.jpg

The streaming method will, for example support the JSON_VALUE operator, which enable you to access and query the JSON data and (a bit like the XMLTABLE operator) return the data in the needed data format.

20130925-172300.jpg

Another operators will be, behold the disclaimer of course, JSON_QUERY, JSON_EXISTS, JSON_TABLE rowsource…

20130925-172936.jpg

20130925-172952.jpg

The following show a few examples of the demonstrations given on how it will, could work, in one of the next database versions…

20130925-180226.jpg

20130925-180246.jpg

20130925-180630.jpg

About Post Author

Marco Gralike

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance.He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

2 thoughts on “OOW13: JSON Support in the Oracle 12c Database (upcoming feature)

Comments are closed.

Next Post

OOW13 and JavaOne 13: Notes from a Conference - Part One

In this article a first brain dump with observations from the Oracle OpenWorld and JavaOne conferences. These are fairly raw notes – primarily for my own consumption. They may be useful to you as well. OOW13: 1824 sessions, 3104 speakers J1: 523 sessions, 557 speakers Related posts: Oracle Enterprise Linux […]
%d bloggers like this: