Oracle Database 21c is now available on Oracle Cloud, including the Always Free tier of Oracle Autonomous Database. The new release contains more than 200 new innovations, including immutable blockchain tables, in-database JavaScript, native JSON binary data type, AutoML for in-database machine learning (ML), and persistent memory store, as well as enhancements for in-memory, graph processing performance, sharding, multitenant, and security.
Oracle Database 21c provides support for multi-model, multi-workload, and multi-tenant requirements—all within a single, modern converged database engine. In addition, Oracle has announced the availability of Oracle APEX (Application Express) Application Development, a new low-code service for developing and deploying data-driven enterprise applications quickly and easily.
The browser-based, low-code cloud service enables developers to create modern web apps for desktops and mobile devices using an intuitive graphical interface.
“Oracle Database 21c continues our strategy of delivering the world’s most powerful converged database engine,” said Andrew Mendelsohn, executive vice president, database server technologies, Oracle. “It provides leading JSON document processing performance. It provides breakthrough operational database performance with Intel Optane Persistent Memory support. It provides industry-leading analytic database capabilities with new Self-Managing In-Memory Column Store, highest performance graph processing, and AutoML for simplest machine learning model development. It provides Immutable Blockchain Tables for tamperproof SQL tables. Competing vendors require separate JSON document, operational, analytic, graph, ML, and blockchain databases and services to support these capabilities. Oracle’s converged database approach makes developers far more productive when building new applications, and makes it easy to later evolve applications to meet new business requirements.”
Innovations in Oracle Database 21c
The latest release of Oracle Database includes more than 200 new innovations, which extend database convergence to new use cases, optimize performance, and improve developer, analyst, and data scientist productivity. Key features include the following:
- Immutable Blockchain Tables:Blockchain Tables bring the key security benefits of blockchain technology to enterprise applications. Part of Oracle’s Crypto-Secure Data Management, the Blockchain Tables feature provides immutable insert-only tables whose rows are cryptographically chained together. By providing tamper detection and prevention capabilities directly in the Oracle Database, customers can protect against unauthorized changes by insiders or hackers impersonating administrators or users. Blockchain Tables is a free feature in all Oracle Database editions.
- Native JSON Data Type:Oracle has provided SQL/JSON query and indexing support for many years. Database 21c adds a new JSON data type representation, enabling up to 10x faster scans and up to 4x faster update operations.
- AutoML for In-Database Machine Learning:Automatically builds and compares machine-learning models at scale, and facilitates the use of machine learning by non-experts. A new AutoML user interface makes it easier for non-expert users to leverage in-database machine learning. Oracle has also added new algorithms for anomaly detection, regression, and deep learning analysis to our extensive library of popular, in-database machine learning algorithms.
- In-Database JavaScript:Enables developers to work efficiently in modern programming languages. The embedded Graal Multilingual Engine allows JavaScript data processing code to run inside the database—where the data resides—eliminating expensive network round-trips. In addition, users can easily execute SQL from within JavaScript code, and JavaScript data types are automatically mapped to Oracle Database data.
- Persistent Memory Support:Stores database data and redo logs in local Persistent Memory (PMEM), which significantly improves the performance of IO-bound workloads. SQL runs directly on data stored in the direct-mapped Persistent Memory file system, eliminating the IO code path and the need for large buffer cache. In addition, new database algorithms prevent partial or inconsistent stores to Persistent Memory.
- Higher Performance Graph Models:Allows modelling of data based on relationships, and enables exploration of connections and patterns in social networks, IoT, and more. Further improvements in memory optimization reduce the amount of memory required to analyze larger graphs, which enables existing applications to run faster with no changes. In addition, users can create or extend graph algorithms using Java syntax, which can execute as native algorithms since they are compiled with the same optimizations.
- Database In-Memory Automation:Oracle supports both row and column formats in the same table to allow analytics and transactions to run simultaneously on the same table. Oracle Database 21c introduces a Self-Managing In-Memory Column Store that simplifies and improves efficiency by automatically managing the placement and removal of objects in the In-Memory Column Store, then tracks usage patterns and moves and evicts objects from the column store. Columns are also automatically compressed based on usage patterns. In addition. Oracle Database 21c also introduces new in-memory vector join algorithms to speed up complex queries.
- Sharding Automation:Native Database Sharding delivers hyperscale performance and availability while enabling global enterprises to easily meet data sovereignty and data privacy regulations. Data shards share no hardware or software, and can reside on-premises or in the cloud. Oracle Database 21c includes a Sharding Advisor Tool that assesses a database schema plus its workload characteristics and then provides a sharded database design optimized for performance, scalability, and availability. Backup and recovery across shards is also automated.
For more information, go to https://blogs.oracle.com/database/introducing-oracle-database-21c