Căutarea dvs. nu a identificat niciun rezultat.
Pentru a găsi ceea ce căutați, vă sugerăm să încercați următoarele:
- Verificați ortografia cuvintelor cheie ale căutării.
- Utilizați sinonime pentru cuvântul cheie pe care l-ați introdus; de exemplu, încercați “aplicație” în loc de “software”.
- Încercați una dintre căutările populare prezentate mai jos.
- Începeți o căutare nouă.
Oracle JSON Document Database
Oracle Database fully supports schemaless application development using the JSON data model. This allows for a hybrid development approach: all of the schema flexibility and speedy application development of NoSQL document stores, combined with all of the enterprise-ready features in Oracle Database.
Oracle Database stores, manages, and indexes JSON documents. Application developers can access these JSON documents via document-store APIs. Oracle Database provides sophisticated SQL querying and reporting over JSON documents, so application developers can easily join JSON documents together as well as integrate JSON and relational data.
Simple Oracle Document Access (SODA)
Oracle Database provides a family of SODA API's designed to support schemaless application development. Using these API's, developers can work with JSON documents managed by the Oracle Database without needing to use SQL. SODA is supported across a number of platforms and languages including REST, Java, Node.js, Python, PL/SQL, and OCI.
SQL Access to JSON Documents
Oracle database provides a comprehensive implemention of SQL, for both analytics and batch processing. JSON held in the Oracle Database can be directly accessed via SQL, without the need to convert it into an intermediary form. JSON collections can be joined to other JSON collections or to relational tables using standard SQL queries.
ACID Transactions over JSON Documents
JSON documents held in the Oracle Database can leverage ACID transactions between documents. This provides consistent results when documents are accessed by long running processes. Users updating JSON documents do not block users reading the same or related documents.
Fully Integrated into Oracle's Database Platform
Users of Oracle Database no longer need to choose between ease of development and enterprise data management features. By using the Oracle Database as a Document Store with JSON, Oracle delivers a complete platform for document store applications, including but not limited to: secure data processing through encryption, access control, and auditing; horizontal scalability with Real Application Clusters; consolidation with Oracle Multitenant; and high availability functionality that means JSON stored within the Oracle Database benefits from unparalleled levels of uptime.
Resources
- LiveSQL Tutorial: Working with JSON content in Oracle Database
- JSON Sample Code on GitHub
- Technical Report: Application Development with SODA (PDF)
- Presentation: Oracle Database JSON - Technical Overview (PDF)
- Presentation: Oracle Database SODA - Technical Overview (PDF)
- Demonstration: Oracle Movie Ticketing : Using SODA for REST and Node.js with Oracle Database (PDF)
- Querying JSON Report (PDF)
- SODA support in SQLcl
- JSON Performance features in Oracle 12c Release 2 onwards (PDF)
SODA Implementations
- SODA for Java - open source on Github
- SODA for Node.js, built into Oracle Database Node.js driver - open source on Github
- SODA for Python, built into Oracle Database Python driver - open source on Github
- SODA for REST, ships with Oracle REST Data Services (ORDS)
- SODA for PLSQL ships with Oracle Database
- SODA for C, part of Oracle Call Interface (OCI)
- ODPI-C library - implements SODA, open source on Github
- SQLcl - supports SODA
Examples and Sample Code
- Livesql tutorial on SQL/JSON in 12.2
- Livesql script giving an overview of SQL/JSON in 18c
- JDBC examples with SQL/JSON (github)
- Livesql script on JSON Object Types
- Livesql script on using JSON Object types
- Livesql script on JSON Array Types
- Getting started with SODA Node.js (doc)
- SODA Node.js basic - SODA Node.js (github)
- SODA Node.js on AJD - SODA Node.js application (blog)
- SODA Node.js on ATP - Hands-on Lab
- Getting started with SODA Python - Examples (doc)
- SODA Python with ATP - SODA Python on a
Jupyter notebook connected to ADB
- Getting started with SODA PLSQL - Examples (doc)
- Livesql tutorial for SODA PL/SQL in 19c
- Livesql script for SODA PLSQL in 18c
-
MuShop shopping cart - microservice on ADB built
using SODA Java, Helidon framework -
Wine demo - Docker Image of application showing CRUD
on a wine collection using SODA Node.js -
Social media microservice - microservice on ADB using SODA
Node.js, express framework - JaJSON app - Python app using Flask, SODA Python
-
Swift mobile app with ADB - Swift application using
SODA REST with ADB
-
19c JSON - workshop showing how to use JSON in
Oracle Database 19c -
JSON in the converged database
- Using JSON with other datatypes -
JSON with Database Python - Using Database Python driver
to load and query JSON
SODA Driver Downloads
NOTE:
• ADB users should refer to their specific ADB documentation for more information about required versions for each SODA driver:
→ SODA driver version information related to Autonomous Transaction Processing on Shared Infrastructure click here.
→ SODA driver version information related to Autonomous Data Warehouse on Shared Infrastructure click here.
Download Location |
Instructions |
Documentation |
|---|---|---|
| Installation Guide | ||
| Installation Guide | ||
|
SODA for REST
|
Installation Guide | |
|
SODA for PL/SQL
No need to download |
Installation Guide | |
|
SODA for Node.js (works with TypeScript)
See install guide for downloads |
Installation Guide | |
|
SODA for Python
See install guide for downloads |
Installation Guide |