Oracle NoSQL Database

Oracle NoSQL Database, using a simple data model like "key/value" (key-value), is scalable DBMS of high readiness which facilitates effective data storage in a simple and flexible format and optimum is suitable for rapid development and deployment of applications.

2019: Correction of 1 vulnerability

On October 17, 2019 it became known that the Oracle company corrected 219 dangerous vulnerabilities in different product lines. Oracle NoSQL Database received 1 correction. Read more here.

2018: Autonomous NoSQL Database Cloud

On October 3, 2018 the company Oracle announced Autonomous NoSQL Database Cloud, addition to a line cloud of solutions on the basis of autonomous DBMS Oracle Autonomous Database Cloud, intended for creation of not relational data warehouses. It means that the cloud NoSQL Database DBMS intended for effective work with unstructured data found property of self-controllability, i.e. capability to work in the mode of the minimum intervention from outside administrator.

According to the developer, service is held for use with applications, imposing increased requirements to response speed during the work with unstructured data. It can be, for example systems of identification of fraud, computer online games or services internet-advertizing.

As declare in Oracle, the autonomous service Oracle NoSQL Database allows developers to create modern applications with high availability and with smaller costs, than in DynamoDB, class NoSQL DBMS in the key value format, the offered Amazon as a part of a packet of AWS, – thanks to opportunities of machine learning the autonomous Oracle database is 70% cheaper (taking into account loadings "only reading") and provides higher reliability of the NoSQL database with availability of 99.95%.

Using simple API (Application programming interface is the program interface of the application), developers can directly concentrate on creating applications, without worrying about control of servers, expansion of capacity of the data warehouse, deployment of clusters, software installation or creation of backup copies. It is enough to set desirable operation parameters, and a system will undertake care of distribution and scaling of resources according to current demands, claim in Oracle.

DBMS supports several API, including simple declarative SQL (Structured queries language - "structured query language") of API, command line interfaces and also flexible models of data view, including relational, "key value" and JSON (Javascript object notation is the text interchange format data on the basis of the Javascript language).

The service offers not proprietary SQL language providing compatibility between standard relational models and standard data models of JSON. Users also have a possibility of deployment and start of the same application in a cloud or on the platform, without binding to the specific platform.

As reported in Oracle, the solution is delivered with tool kit of the developer and supports popular programming languages, including Python, Node.JS and Java. The mechanism of machine learning in Oracle Autonomous Database Cloud analyzes system event logs which contain information on everything that happens to networks, servers, the operating system, storage systems, virtual machines, programs and also the systems of analytics and databases.

Having collected enough information, self-governed DBMS will begin to find in data and events of an aberration automatically. It will be able to perform classification of requests and automatic adjustment of the database and also independently to define if the administrator logged in from the place, unusual to it. Autonomous DBMS is capable, without interrupting work, to monitor cyber attack and to try to reflect, or to apply new patches, emphasized in Oracle.^[1]

2014: Oracle NoSQL Database 3.0

On April 17, 2014 it became known of release by Oracle corporation of NoSQL Database of version 3.0.

Description

In the provided version of DBMS developers received the advanced solution of NoSQL for creation of high performance applications of the next generation - a combination of security, reliability, scalability, flexibility of a data model.

To Oracle NoSQL Database 3.0 it is available. In this version higher levels of safety and readiness for workloads of real time, scalable web applications are ensured.

The improvements implemented in the version of Oracle NoSQL Database 3.0 increase security and performance and simplify use that is necessary for support of IT requirements of the enterprises in application development.

The version of Oracle NoSQL Database 3.0 offers new maintaining in security issues. Independent of the operating system, password authentication on the scale of a cluster and integration of storage of the Oracle Wallet keys improve protection against unauthorized access to confidential data. Besides, enciphering under the Secure Sockets Layer (SSL) protocol during the session of the user and also restriction and control of network ports provide additional protection against invasions into network.

Support of tabular data models simplifies application design and provides smooth integration into usual SQL applications. Function of secondary indexing considerably increases performance of requests.

Function of hands-off processing of failures with switching to duplicative data processing centers helps to provide the continuity of business processes for applications. Secondary zones of servers can be applied also to unloading of primary servers — with transfer of a part of workloads which do not require rewriting of data (i.e. using data in the read-only mode — "only for reading"), such as analytics and generation of reports and also to data exchange for the purpose of improvement of management of workloads.

Editions NoSQL Database 3.0 Enterprise Editions and Oracle NoSQL Database 3.0 Community Edition are already available to loading in Oracle Technology Network.

2015:Oracle NoSQL Database 3.2.5

Oracle NoSQL Database 3.2.5 is the adaptable solution which allows developers to create high performance applications of new generation. This version provides a predictable low delay, RESTful API and API of language C based on Apache Thrift includes and it is integrated with the Oracle platform for processing of Big Data. The solution Oracle NoSQL Database 3.2.5 which is based on Oracle Big Data SQL also supports the Data Definition Language (DDL) language, even more simplifying use of SQL for accomplishment of requests to data of NoSQL.

2012: Oracle NoSQL Database 2.0

In the winter of 2012 the Oracle corporation announced release of the new version of Oracle NoSQL Database 2.0. "Key/value" DBMS with high scalability and the minimum delays allows to manage Big Data in real time.

This version of Oracle NoSQL Database 2.0 offers support of preserving and extraction of big objects, such as documents and images and also dynamic elasticity and automatic balancing for space allocation of storage and computing resources depending on change of requirements to data processing. At the same time, thanks to close integration with environments of Oracle databases and Hadoop the new version of Oracle NoSQL Database 2.0 can smoothly be built in a corporate IT stack.

"Oracle continues to enter innovations to a portfolio of the technologies covering all aspects of data management. Oracle NoSQL Database 2.0 provides to developers infrastructure of 'the last mile' for support of the major transactions in real time between applications of the organization and its clients — noted Vaishnavi Sashikanth, the vice president of Oracle for development. — It provides the enterprises with the key mechanism for the most effective use of Big Data".

In the whole Oracle NoSQL Database 2.0, the key component of the Oracle Big Data Platform platform, is the database management system of a corporate class like "key/value" with flexible models of transactions. It allows customers to manage easily dynamic transaction data which are generated by web applications, social networks, sensors, smart meters and telecommunication services.

"By Oracle NoSQL Database 2.0 it is created using well proved Oracle Berkeley DB DBMS as the main engine of storage — noted in Oracle. — Clients of Oracle developed a set of the crucial applications servicing millions of users on Berkeley DB".

Among the new and improved Oracle NoSQL Database 2.0 functions: automatic balancing — dynamic management of computing resources and space of storage for agreement performance about the service levels in the conditions of growth of requirements and change of requirements to processing; the improved controllability — the simple, convenient web console in use for management of all aspects of deployment and monitoring, unstructured and structured data in one product; new API interfaces — the new API interface C increases efficiency of developers, the new Large Object API interface supports efficient management of big objects, and new API interfaces for automatic serialization simplify application development; the improved support of management and monitoring — support of SNMP/JMX provides integration into management tools of Oracle and other suppliers; the improved integration with Hadoop — closer integration with Hadoop through an object of JSON and support of evolution of schemes for storage and serialization of data with Avro use.

At the same time, Oracle NoSQL Database 2.0 provides performance improvement — the elastic storage of a corporate class with almost linear scalability and a delay time no more than five milliseconds gives to users an opportunity to dynamically expand a cluster in process of growth of amounts of data trouble-free in service. So, in recent performance tests of Oracle NoSQL Database 2.0, according to developers, executed more than one million YCSB operations per second for the database with a capacity of 2.4 terabytes on a cluster of 18 standard nodes.

At last, Oracle NoSQL Database 2.0 differs in closer integration with Oracle DBMS. Users of Oracle DBMS can browse records in Oracle NoSQL DBMS and execute requests directly of the SQL environment through foreign tables that provides immediate data availability of NoSQL and their readiness for the integrated analysis.

To Oracle NoSQL Database 2.0 it is available to loading on Oracle Technology Network. The corporation also offers services of support of a corporate class, helping the organizations to unroll with smaller risks Oracle NoSQL Database in crucial technology environments.

2011: Availability of NoSQL Database on Oracle Technology Network

The corporation Oracle announced in October, 2011 that DBMS it of Oracle NoSQL Database, a crucial element in a solution portfolio of Oracle for processing "Big Data" (Big Data), is available to loading from the website Oracle Technology Network. Oracle NoSQL Database allows to manage with ease huge amounts of data with the dynamic schemes arriving from blogs, sensors, Web servers, smart meters, social networks and also data collected for personalisation.

As stated in the message of Oracle, many modern solutions based on NoSQL technology complicate applications writing, providing only final coordination of data (eventual consistency), i.e. final updating of a number of copies. Oracle NoSQL Database, on the contrary, manages coordination and offers developers a number of the corresponding settings for satisfaction of different requirements of the application.

Oracle NoSQL Database differs in simplicity of management and setup. In particular, simplicity of management is provided thanks to the console with the web interface and open API. The solution automatically manages and performs monitoring of topology, balancing of loading, performance, events and notifications, developers explained. At this Oracle NoSQL Database it is scaled almost linearly, providing to clients reliability and performance for the broad range of workloads and options of use.

Besides, Oracle will also deliver the new hardware and software system Oracle Big Data Appliance — the optimized platform for accomplishment of Oracle NoSQL Database and other offers of Oracle for processing of Big Data. The beginning of deliveries of Oracle Big Data Appliance is planned for the first quarter of 2012 calendar year.

"Oracle NoSQL Database is a crucial element of strategy of Oracle in the field of Big Data — Andrew Mendelsohn, the senior vice president of division of Oracle Server Technologies emphasized. — Clients look for ways of management of the amounts of data growing with an improbable speed, the arriving from the Internet, social networks, mobile applications and sensors, and Oracle helps them to benefit by these data, providing the reliable and scalable environment of databases NoSQL of high readiness".

Notes