Oracle Database 23c Features Overview
• JavaScript Stored Procedures:
Expands database flexibility and capabilities.
• Property Graph Analysis: Enhances
support for property graph analysis on operational data.
• Automated Handling of Distributed
Microservices Transactions (Sagas): Simplifies transaction
management across distributed microservices.
• Enhanced Automatic Materialized
Views: Improves performance and efficiency in managing materialized
views.
• Real-Time SQL Plan Management: Optimizes
SQL execution plans in real-time.
• True Cache: Improves data retrieval
speeds.
• ML-Enhanced Prediction
of Data Statistics: Optimizes SQL execution.
• Native Replication of Database
Shards: Improves replication capabilities for distributed
databases.
JSON Relational Duality feature.
Oracle Database
23c's JSON Relational Duality Features
• Unified Data Model: Allows for seamless storage, querying, and manipulation
of both JSON and relational data.
• Flexibility: Allows for the selection of the best data model for applications,
enhancing performance for queries involving both data types.
• Simplified Development: Allows for familiar SQL syntax to work with JSON
data, reducing the learning curve and simplifying the development process.
• Data Integrity: Ensures data integrity by defining constraints and
relationships between JSON and relational data, maintaining consistency and
reliability.
What are
some common scenarios where this feature is beneficial?
• Benefits Hybrid
Applications:
Suitable for e-commerce platforms handling both structured and
semi-structured data.
• Enhances Microservices Architectures: Facilitates seamless
data exchange and integration between services using JSON and relational
databases.
• Simplifies
Data Integration and ETL Processes: Facilitates merging and querying of data
from various sources.
• Enhances API Development: Provides efficient storage and querying of JSON
data in backend systems.
• Enhances
Content Management Systems (CMS): Allows efficient
querying and manipulation of content in JSON format.
• Enhances IoT Applications: Enables efficient
storage and analysis of JSON data.
• Enhances
Real-Time Analytics: Allows complex queries and analyses on mixed data types.
• Enhances Data
Warehousing: Enhances flexibility
and performance in data warehousing.
.jpg)
