Oracle Database 21c

2021: Availability of Oracle Database 21c DBMS

On January 13, 2021 the company Oracle announced availability DBMS of Oracle Database 21c - the current version convergent databases. Oracle Database 21c it is available in Oracle Cloud, including free cloud service Always Free Tier to the autonomous Oracle Autonomous Database database now. Oracle Database 21c includes more than 200 opportunities, including support of unchangeable blockchain- tables, built in DBMS support of language programming JavaScript, support of data type of JSON in a binary format which is built in a DB, automated machine learning (AutoML) for machine learning in the database (ML) and support of a non-volatile memory (Persistent Memory) and also improvement in technology Oracle Database in-Memory, performance of processing of geoinformation, sharding, technology of the connected databases (pluggable database) and security.

According to the company, Oracle Database 21c provides support of different data types (relational, JSON, XML, graph, etc.), different types of loading (transactional and analytical) and also support of multirent architecture (multitenant) — within uniform modern convergent DBMS as in a cloud, and on-Premise. Oracle also announced availability of Oracle APEX (Application Express) of Application Development, service in a cloud for development of Web applications with the minimum creation of the source code, for rapid and simple development and deployment of corporate applications, data-driven.

The current version of the convergent database - Oracle Database 21c, is designed to facilitate life both to users, and developers. It supports and integrates the expanded range of data models and types of loading and also includes the built-in machine learning which eliminates need for separate tools and services, allowing the organizations to perform machine learning directly in the database. More than ten different databases have this solution for the organizations which use solutions as in AWS and, each of which demands from customers of work with different API interfaces, different campaigns to implementation of ETL processes and data integration processes. Oracle Database 21c eliminates a barrier between several isolated and initially not convergent databases. Mark Peters, the top analyst and the director of practice, ESG told

Quinaryo XRing — an important component of our strategy of Internet of Things. We integrated the wearable device with the instrument of data protection on a basis a blockchain tables. In Oracle Database 21c DBMS the records protected from modification which can be integrated without effort with other applications without need to unroll difficult infrastructure allowed us to create a blockchain table. Oracle Database 21c DBMS contains tools familiar to us and also the updated functions, such as blockchain table which can be used together with XRing for collecting of useful data. Pietro Berretoni, the Chief Digital Officer and to innovations, Angelini Pharma told

Oracle Database 21c is DBMS which is the base for different local and cloud services of Oracle databases, including Oracle Autonomous Database, Oracle Exadata Database Service, Oracle Exadata Database Cloud Customer and Oracle Exadata Database Machine. This release of DBMS includes more than 200 opportunities which expand a database scope, help to increase performance and do work of analysts, developers and researchers of data (Data Scientist) of more productive.

Hybrid Columnar Scan

Key features include:

• Unchangeable blockchain table. The blockchain table is provided by advantages of blockchain technology in respect of security for corporate applications. The technology a blockchain tables is a part of the Oracle Crypto-Secure Data Management platform. A blockchain table are available only to an insert, and their lines are connected in a blockchain chain and ciphered that provides their invariance. Users can reveal attempts of data modification and prevent them directly in Oracle Database DBMS. Thus protection against unauthorized changes which the staff of the organization or hackers issuing themselves for administrators or users could enter is provided. A blockchain of the table are tables which are stored in the database, access to which is provided using standard SQL queries. Tables support all analytical means of Oracle Database DBMS and all technologies of accomplishment of transactions thanks to what it is more convenient to use these means, and their opportunities are wider, than at the existing implementations of blockchain technology.
• Built-in JSON support. For many years Oracle provides support of accomplishment of SQL queries and indexing of data in the JSON format. The built-in data type of JSON which allows to execute scanning 10 times faster is added to Oracle Database 21c, and updating — is 4 times faster. In general, these opportunities optimize work speed over this in the JSON format in Oracle Database DBMS twice in comparison with use of the MongoDB and AWS DocumentDB databases (according to test results of YCSB bencmark). As well as in the previous versions, it is possible to use data of JSON in combination with other data types, to index any JSON elements quicker to execute OLTP transactions, to use functions of parallel processing of data for any formats and to execute difficult associations of documents and the JSON collections, without need to use for this purpose the separate code at the level of the application.
• AutoML technology for machine learning in the database. This technology automatically creates and compares models of machine learning. Thanks to the user interface AutoML even users who are not experts can apply machine learning technologies in work with the database. Oracle also added the updated algorithms of detection of anomalies, regression analysis and deep learning to library of popular algorithms of machine learning in the database.
• Support of JavaScript in the database. Allows developers to work at the modern languages of programming. Thanks to Graal Multilingual Engine technology which is built in Oracle DBMS it is possible to start the data processing code on JavaScript directly in the database in which data are stored that eliminates need for expensive network interaction. Besides, users can execute SQL queries of the JavaScript code, and data types of JavaScript will automatically be transformed to the Oracle Database DBMS types.
• Support of a non-volatile memory. Saves data files and transaction logs in a non-volatile memory (Persistent Memory - PMEM) that optimizes performance of the transactions connected with input-output. SQL transactions work directly with the data which are stored in the PMEM file system with direct access, passing a buffer cache that eliminates input output and need for a big cache of the buffer. Besides, algorithms of the database prevent inconsistency of data in PMEM.
• Graph models with the updated performance. Allow to model data on the basis of the relations and also to investigate communications and patterns on social networks, Internet of Things, etc. Due to further optimization it is possible to reduce the volume of necessary RAM necessary for the analysis of large graph models that allows existing applications to work quicker without any changes. Besides, users can create or expand algorithms of processing of models using Java syntax which can be executed also effectively as the built-in algorithms as they are compiled with the same optimization.
• Database In-Memory automation. Oracle supports a lower case format and a format of columns in memory, for the same table therefore the analytics and transaction can be executed at the same time over one table. Oracle Database 21c enters functionality of completely automatic control of columns of tables in RAM. It allows to simplify work and to optimize efficiency due to automatic control of placement and removal of columns in In-Memory Columnar Store, and then to automatically trace use templates and to move and delete objects from memory. Besides, columns automatically contract depending on use templates. Oracle Database 21c also uses algorithms of connection of tables in memory (In-Memory Vector Join) for acceleration of advanced queries.
• Automation of sharding of data. The technology of sharding of data (Oracle Sharding) which is built in Oracle Database DBMS provides the scalable performance and availability, facilitating the international companies a problem of observance of requirements of the legislation and regulating authorities. Shards (data segments) have among themselves no general a component and can be located as locally, and in a cloud. To simplify design and use of Oracle Sharding, Oracle Database 21c includes the tool - Sharding Advisor Tool which analyzes the scheme of the current database and its profile of loading, and then creates reports with recommendations about the database structure supporting sharding, optimized for performance, scalability and availability. Backup and recovery of all shards is automated also now.