Tag: JSON

Working Effectively with JSON in the Oracle Database
Premium

Presented at INSYNC 21

Session ID: 101670

JSON data is becoming increasingly prevalent in many enterprises today. As a result the world of data management now includes the need for storing JSON documents in a fast, reliable and secure way. What better place to store and manage this data then in the Oracle Database? ...and best of all it's totally free!

This session covers the different approaches to loading, storing, retrieving and managing JSON in the Oracle Database including the new native JSON datatype introduced in Database 21c.

The session will include live demonstrations.

IOUG Insider Studio with Arup Nanda: Big Data for Oracle Professionals
Premium

7.9.13 In this presentation Nanda will dive into: • The most popular topics from this year's COLLABORATE 13 conference • Answers to your real-time questions (via the Twitter hashtag #IOUGInsider) • Big Data for Oracle Professionals If you ever wondered what Big Data is but were inundated with buzzwords like Hadoop, MapReduce, Hive and Pig…

Managing Unstructured Data: LOBs in the World of JSON
Premium

One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure.

Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to CLOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue! This presentation attempt to fill that knowledge gap:

Core conceptual elements of how Oracle works with LOBs (multi-segment storage, IO mechanism, copy semantics/pointer semantics, etc.)
SecureFiles/BasicFiles implementation issues
Best practices of LOB manipulation (both generic and JSON-related)

Overall, this presentation gives database developers sufficient knowledge to be able to build efficient modern applications. Real-life examples will be included to pinpoint key ideas and solutions.

Design Flexible Data Models Using Oracle 12c JSON Capabilities
Premium

Oracle Database 12c introduced new capabilities for storing, indexing and querying JSON data.These capabilities allow organizations to build schemaless database models while at the same timemaintaining the full power of SQL. After a quick introduction to these capabilities, this sessionwill present examples of their usage and lessons learned from an actual application deployed to multiple…