Oracle announced the availability of the 21C Database worldwide on Oracle Cloud, including Oracle Autonomous Database’s Always Free service.
Unlike other cloud or on-premise databases, Oracle Database 21c supports requests for multi-model, multi-load and multi-tenant environments; all within a single, modern convergent database engine.
In addition, Oracle today also announced the availability of Oracle APEX (Application Express) Application Development, a new low-code service to develop and implement enterprise data-driven applications in a fast and easy way. This browser-based low code cloud service allows developers to create modern web apps for desktop and mobile devices using an intuitive graphical interface.
The innovations of Oracle Database 21c
Oracle Database 21c is the database engine that feeds Oracle databases in cloud and on-premises, including Oracle Autonomous Database, Oracle Exadata Database Service, Oracle Exadata Database [email protected] The new release includes over 200 new features, which expand the database convergence for new cases of use, optimize performance, improve the productivity of developers, analysts and data scientists.
The main innovations: Immutable Blockchain Tables • Blockchain Tables bring in enterprise applications the most important security advantages of blockchain technology. As part of Oracle Crypto-Secure Data Management, the Blockchain Tables feature provides unchangeable tables…insert-only… whose lines are packed together in a encryption manner. Thanks to the features to detect tampering and prevent them directly in the Oracle database, customers can protect themselves from changes that are unlawfully made by internal personnel or hackers who impersonate administrators or users. Blockchain Tables are part of the convergent database; you access them with standard SQL language and fully support analysis and transactions • making them extremely easy to use and more functional than existing blockchain implementations Blockchain Tables is a free feature in all Oracle database editions.
Native JSON Data Type: Oracle has been offering SQL/JSON query and indexing support for years. The Database 21c adds a new JSON Data Type representation, allowing you to scan 10 times faster and upgrade operations up to 4 times faster than in the past. Overall, these improvements make SQL/JSON twice as fast as MongoDB and AWS DocumentDB according to the YCSB benchmark. As in previous releases, users can mix or merge JSON data and other data types; index any JSON element to make transactional operations faster; use declarative and parallel SQL analysis on all formats; manage complex joins between Js
AutoML for In-Database Machine Learning • Builds and compares large-scale machine learning models automatically, and facilitates the use of machine learning by untrained staff. A new AutoML user interface makes it easier for non-experts to use the machine learning in-database. Oracle has also added new algorithms to the Database 21c for the detection of anomalies, regression and deep learning analysis to its already widely-appreciated library of machine learning algorithms in-database.
Persistent Memory Support • Archive database data and redo logs into a local persistent memory (PMEM), which significantly improves workload performance. The LMXL directly runs on data stored in the file system with a direct mapping of the Persistent Memory, eliminating I/O’s tortuous patterns and the need to equip itself with a large cache buffer. In addition, new database algorithms prevent partial or inconsistent storage within the Persistent Memory.
Higher Performance Graph Models Features a modeling of databases based on representation of relationships and allows you to explore connections and patterns on social networks, IoT and more. Further improvements in memory optimization reduce the amount of memory needed to analyze larger graphs, which allows you to run existing applications faster without making changes. In addition, users can create or extend graph algorithms using Java syntax, performing them as native algorithms, as they are compiled with the same optimizations.
In-Memory Database Automation: Oracle supports both rows and columns formats in the same table to allow simultaneous analysis and transaction management. Oracle Database 21c introduces the In-Memory Column Store, which simplifies and improves efficiency by automatically managing the placement and removal of objects in the In-Memory Column Store. In addition, columns are automatically compressed based on usage patterns. Oracle Database 21c also introduces a new algorithm of vector join in-memory to accelerate the execution of complex queries.
Sharding Automation: the native features of Database Sharding offer high performance and availability, in compliance with data sovereignty and data privacy regulations. Data partitions do not share hardware and software and can reside on-premises or in the cloud. To simplify the design and use of these partitioning features, Oracle Database 21c includes a Sharding Advisor Tool that evaluates a database scheme plus its load features and offers Design DB Partitioning to improve performance, scalability and Backup and Recovery functions on partitions are also automated.