Oracle Database 23c, Oracle Corporation’s most recent release, includes a slew of new features and changes designed to provide organizations with expanded capabilities and improved performance.
Overview:
- Enhanced machine learning capabilities for in-database analytics.
- Introduction of blockchain tables for secure transactional data management.
- Native JSON supports the seamless integration of JSON and relational data.
- Automated database tuning using machine learning algorithms.
- Sharding enhancements for improved scalability and efficiency.
In this blog article, we’ll look at some of the interesting new features available in Oracle Database 23c.
Machine Learning Capabilities:
Oracle Database 23c adds expanded machine learning capabilities, allowing businesses to employ sophisticated analytics right within the database. Data scientists and developers can design and deploy machine learning models using in-database machine learning algorithms and APIs, eliminating the need for data transfer or complicated interfaces. This enables organizations to draw more useful insights from their data in a more efficient manner.
Blockchain Tables:
Blockchain technology has found popularity in a variety of businesses. Oracle Database 23c contains blockchain tables, which allow for the simple and safe storage and management of tamper-proof transactional data within the database. Blockchain tables may be used by businesses to track and verify transactions, improve transparency, and provide a reliable system of record.
Native JSON Support:
JSON (JavaScript Object Notation) is a well-known data transfer format. Oracle Database 23c adds native JSON support, allowing for the seamless integration of JSON and relational data. SQL may now be used by developers to deal with JSON data, allowing for easier data integration and querying between JSON and relational databases.
Oracle Database 23c includes a number of enhancements for working with JSON data, including support for the new SQL JSON data type and the ability to index JSON documents.
Automated Database Tuning:
Database performance optimization is a fundamental part of database management. To automate performance tweaking, Oracle Database 23c contains powerful machine learning techniques. The Autonomous Database Optimization function analyses database workloads, detects performance bottlenecks, and implements optimizations autonomously to improve overall performance. This function makes tweaking easier and requires less human work.
Sharding Enhancements:
Sharding allows for horizontal data division over many databases, which improves scalability and performance. Oracle Database 23c includes sharding features such as dynamic shard resizing and cross-shard queries. These innovations increase the flexibility and efficiency with which shared databases may be managed.
- Accelerated Secure Files LOB write performance: Secure Files is a new type of large object (LOB) storage that provides better performance and security than traditional LOB storage. In Oracle Database 23c, Secure Files write performance has been accelerated by up to 200%.
- Automatic Secure Files shrink: Secure Files LOBs can now be automatically shrunk to reclaim unused space. This can help to improve database performance and reduce storage costs.
- Automatic transaction abort: In Oracle Database 23c, transactions can now be automatically aborted if they exceed a certain time limit or resource usage threshold. This can help to prevent long-running transactions from impacting the performance of other users.
- SQL*Plus updates: SQL*Plus, the command-line interface for Oracle Database, has been updated with a number of new features, including support for the new SQL BOOLEAN data type and the DESCRIBE command.
Conclusion:
Oracle Database 23c has several new features and updates that provide organizations with increased capabilities, greater performance, and easier management. Oracle Database 23c enables organizations to use cutting-edge technologies and drive innovation in their data management strategies with in-database machine learning, blockchain tables, native JSON support, automated database tuning, and sharding upgrades. Upgrade to Oracle Database 23c to gain access to these fascinating features and move your company ahead.
