The latest version of the company’s converged database, Oracle Database 21c, is now available in Oracle Cloud, including the Always Free tier of Oracle Autonomous Database.
Oracle Database 21c contains over 200 updates, including:
Database 21c supports multi-model, multi-workload, and multi-tenant requirements within a single converged database engine.
In addition, Oracle announced the availability of Oracle APEX (Application Express) application development, a new low-code service for the rapid and easy development and deployment of data-driven enterprise applications.
Browser-based low-code cloud services allow developers to create modern web apps for desktop and mobile devices with an intuitive graphical interface.
Immutable blockchain table
Blockchain tables bring the key security benefits of blockchain technology to enterprise applications.
Blockchain Tables, part of Oracle’s Crypto-Secure Data Management, provides immutable insert-only tables with rows cryptographically chained.
By providing tamper detection and prevention capabilities directly to the Oracle database, customers can protect against unauthorized changes by insiders or hackers impersonating administrators or users.
Blockchain tables are part of a converged database, accessed by standard SQL, and support full analysis and transactions.
Blockchain tables are a free feature of all Oracle Database editions.
Native JSON data type
Database 21c adds a new JSON data type representation that allows up to 10x faster scans and up to 4x faster update operations.
Overall, these improvements make Oracle SQL / JSON twice as fast as MongoDB and AWS DocumentDB in the YCSB benchmark.
As in previous releases, users mix or combine JSON with other data types, index arbitrary JSON elements for fast OLTP, use declarative parallel SQL analysis in all formats, and custom applications. You can perform complex joins on multiple JSON documents and collections without code.
AutoML for in-database machine learning
Automatically build and compare large machine learning models, facilitating the use of machine learning by non-experts. The new AutoML user interface makes it easy for non-expert users to take advantage of machine learning in the database.
Oracle has also added new algorithms for anomaly detection, regression, and deep learning analysis to its extensive library of machine learning algorithms in popular databases.
Persistent memory support
Store database data and redo logs in local persistent memory (PMEM). This will significantly improve the performance of IO bound workloads. SQL runs directly on the data stored in the directly mapped persistent memory file system, eliminating the need for IO code paths and large buffer caches. In addition, a new database algorithm prevents partial or inconsistent stores in persistent memory.
High-performance graph model
It enables relationship-based data modeling and the investigation of connections and patterns such as social networks and IoT.
Further improvements in memory optimization reduce the amount of memory required to analyze larger graphs, allowing existing applications to run faster without modification.
In addition, users can create or extend graph algorithms using Java syntax. It is compiled with the same optimizations and can be run as a native algorithm.
Database in memory automation
Oracle supports both row and column formats on the same table, allowing analysis and transactions to run on the same table at the same time. Oracle Database 21c automatically manages the placement and deletion of objects in the in-memory column store, and simplifies and improves efficiency by tracking usage patterns and moving and deleting objects from the column store. A managed in-memory column store has been introduced. In addition, the columns are automatically compressed based on usage patterns. Oracle Database 21c also introduces a new in-memory vector join algorithm to speed up complex queries.
Native database sharding provides hyperscale performance and availability while allowing global companies to meet data sovereignty and data privacy regulations.
Data shards do not share hardware or software and can reside on-premises or in the cloud.
To simplify sharding design and use, Database 21c is a sharding advisor that evaluates the database schema and its workload characteristics and provides a sharding database design optimized for performance, scalability, and availability. Includes tools.
Backup and recovery between shards is also automated.
Oracle releases new version of converged database
Source link Oracle releases new version of converged database