Oracle Database 11g

Oracle Database 11g is the database developed especially for work in networks of distributed computing Grid intended for effective deployment based on different types of the equipment from small servers to the powerful symmetric multiple server processor systems from separate clusters to corporate distributed computing systems. DBMS gives an opportunity of automatic adjustment and management.

2015: The Oracle Database platform on Oracle Exadata is certified by FSTEC of Russia

In January, 2015 the representative office of Oracle announced obtaining the certificate of the Federal Service for Technical and Export Control (FSTEC) of Russia on the software of Oracle Database (11g R2) to Enterprise Edition for the Oracle Exadata complex, showing commitment to data security provision of the customers using the pro-active measures implemented by the certified information security tools. Now it is simpler to the clients using the optimized hardware and software system Oracle Exadata to conform to requirements of standards of security of the Russian Federation.

The certificate confirms that Oracle Database 11g R2 Enterprise Edition for the Oracle Exadata complex with the installed optional Oracle Database Vault and Oracle Advanced Security components is the database management system with the built-in means of protecting from unauthorized access to information which is not containing the data which are the state secret and conforms to requirements of specifications. The built-in means of protecting implement functions of identification and authentication, access control, registration of events of security, ensuring availability of information.

The optimized hardware and software system Oracle Exadata Database Machine consists of a server cluster of databases, a storage system, Oracle Database DBMS. Besides, the complex includes the intellectual software of Oracle Exadata Storage Server which promotes the accelerated request processing with smaller loading of wide channels Infiniband thanks to processing and filtering of requests in close proximity to data.

Certificates of the Federal Service for Technical and Export Control confirm that clients can use the mechanisms which are built in products of Oracle for confidential information protection and personal data according to requirements of the Russian legislation. It allows the enterprises to avoid additional costs on third-party information security tools which are necessary at the organization of confidential information protection and also to exclude downside risks of performance or restriction of functionality.

The long-term program of local certification of security protections of Oracle expands possibilities of customers at creation of information systems according to requirements of the Russian legislation in the field of data protection. Confirming commitment to security of confidential data, Oracle proposes to clients the complete solution – the hi-tech products for implementation of business initiatives and means of protecting of the processed information considering requirements of the Russian market.

2012: Release of the option Oracle Advanced Analytics

The Oracle corporation announced release of Oracle Advanced Analytics, a new option for Oracle Database 11g DBMS which integrates the environment of statistical investigations Oracle R Enterprise and Oracle Data Mining.

The product Oracle Advanced Analytics implements the concept of the analytics which is built in the database, moving algorithms to the data which are stored in Oracle Database 11g and Oracle Exadata. It differs from the traditional approach based on data movement to algorithms and requiring additional costs on extraction of data from storages and their loading in notebooks or specialized servers explained in Oracle. On the basis of Oracle Advanced Analytics it is possible to create analytical applications in real time which help to receive answers to key questions of business, such as forecasting of outflow of clients, optimization of offers for customers, fraud warning.

In turn, accomplishment of analytical algorithms directly in the Oracle database of Database 11g, i.e. in the same place where data are stored, allows to increase performance of an analytical system and to ensure its safety on the scale of all enterprise, claim in corporation.

Using possibilities of Oracle Database 11g, the Oracle R Enterprise environment offers performance of a corporate class for the applications developed using language of statistical investigations and graphic visualization of R and also increases amounts of data with which these applications, says Oracle can work by several orders. The product gives to analysts the chance to apply various difficult computing methods to data sets in one billion lines in read seconds, doing the iterative, fast and high-quality analysis of Big Data by really feasible transaction, emphasized in Oracle.

Oracle R Enterprise reduces time of deployment of models of statistical analysis, saving from need to translate models into other programming languages before deployment and practical application. The product integrates an extensive set of the algorithms of the deep analysis (data mining), analytic and statistical functions which are built in Oracle Database and the accessibility to an OLAP cubes with programming language R for "transparent" use of all these technologies by users of environment R.

According to Oracle, the testing of Oracle R Enterprise held by clients for the analysis of "Big Data" on the optimized hardware and software system Oracle Exadata showed almost 100-fold performance improvement of statistical applications in comparison with their accomplishment in the Wednesdays existing at the enterprises.

In turn, the Oracle Data mining technology which became now a component of the option Oracle Advanced Analytics provides an extensive set of the algorithms of the class data mining allowing to solve a broad spectrum of business challenges. The predictive models received using these algorithms can be unrolled in Oracle Database 11g, using at the same time Oracle Exadata Smart Scan technologies for fast scoring of huge amounts of data.

Deep integration between R, Oracle Database 11g and Hadoop allows programmers to create one script in language R which then can be executed in three different environments: in freely extended environment R set on notebooks; in the environment of Apache Hadoop with the Oracle Big Data Connectors interfaces; and in Oracle Database 11g DBMS.

The new product Oracle Advanced Analytics in combination with the optimized hardware and software systems Oracle Big Data Appliance, Oracle Exadata Database Machine and Oracle Exalytics In-Memory Machine provides the integrated platform for the analysis of Big Data. Results of use of technologies and algorithms of the option Oracle Advanced Analytics can be browsed using the instrumental Oracle Business Intelligence Foundation Suite environment and the optimized hardware and software system Oracle Exalytics In-Memory Machine that allows to implement possibilities of the analysis of Big Data on the scale of all enterprise, concluded in Oracle.

2010: Delivery in four editions

For 2010 DBMS Oracle Database 11g is delivered in four different editions focused on different scenarios of development and deployment of applications. Besides, the Oracle corporation offers several additional software products expanding possibilities of Oracle Database 11g for work with specific applied packets. The existing editorial offices Oracle Database 11g DBMS are listed below:

Standard Edition One

Oracle Database 11g Standard Edition One is characterized by unprecedented simplicity of operation, power and profitable price relation and productivities for applications of scale of the working groups, separate divisions or applications working among the Internet/intranet. Working in different environments, beginning from one-server configurations for small business and finishing with distributed environments of large branches, Oracle Database 11g Standard Edition One has all functionality for ensuring work of applications, critical for business. Edition Standard Edition One is licensed only for the servers having no more than two processors.

Standard Edition (SE)

Oracle Database 11g Standard Edition (SE) provides so unprecedented simplicity of operation, power and performance, as edition Standard Edition One, supporting operation of more powerful computing systems using technology of a clustering of Real Application Clusters services. This edition is licensed for use on one server with the number of processors which is not exceeding four or on the server cluster supporting no more than four processors.

Enterprise Edition (EE)

Oracle Database 11g Enterprise Edition (EE) provides effective, reliable and safe data management of such applications, crucial for business, as the on-line environments executing large-scale transaction processing (OLTP), data warehouses with high intensity of a flow of requests and also resource-intensive Internet-applications. Edition Oracle Database Enterprise Edition provides the work benches and functions providing compliance to requirements of modern corporate applications in the field of availability and scalability. This edition contains all Oracle Database components and also allows expansion by means of acquisition of the add-on modules and applications described further in this article.

Personal Edition

Oracle Database 11g Personal Edition supports single-user development and deployment of the applications completely compatible to editions Oracle Database Standard Edition One, Oracle Database Standard Edition and Oracle Database Enterprise Edition. Having provided to certain users extensive functionality of a packet of Oracle Database 11g, Oracle corporation created the database combining power the most popular in the world DBMS and simplicity of operation which you have the right to expect from the application for the desktop PC.

Using Oracle Database 11g, the organizations will be able to manage all corporate information and more deeply to understand the business and also quickly and surely to adapt to more and more changeable competitive environment. To give such opportunities, in new release the unique mechanisms of Oracle providing a clustering of databases, automation of data processing centers and management of workloads are expanded. Using the protected, scalable grid-infrastructures based on inexpensive servers and storage systems providing the high levels of readiness clients of Oracle can create OLTP applications, data warehouses and content management systems with the highest requirements.

The module Real Application Testing reduces time, risks and costs on making changes.

Oracle Database 11g offers the advanced functions of self-government and automation to help the organizations to observe agreements on the service levels. For example, to the organizations which regularly perform updating of versions of DBMS and operating systems and also make changes to hardware and system configurations, Oracle Database 11g offers the module Oracle Real Application Testing, for the first time giving to clients the chance to quickly carry out test procedures and to manage changes in the IT environments - during the ensuring control and cost reduction.

Increase in an investment payback in solutions for disaster recovery

The Oracle Data Guard technology allows clients to use the reserve database for increase in efficiency of operational environments and also for protection against failures of systems and catastrophic failures in computer centers. Oracle Data Guard offers unique opportunities of simultaneous reading and recovery of the reserve database, providing upgradeability of the bases for data. Transferring workloads with the main to standby system, Oracle Data Guard provides increase in efficiency of production systems and proposes the cost-efficient solution for disaster recovery.

Advanced information lifecycle management and its storage

Oracle Database 11g offers important new opportunities in the field of sectioning and data compression, providing cost-efficient information lifecycle management and its storage. Oracle Database 11g allows to automate a set of manual transactions of sectioning of data, supplementing already existing sectioning methods (on range, according to the list and a hash sectioning) with sectioning methods on an interval, the link and a virtual column. Besides, Oracle Database 11g offers a full range of options of the combined sectioning, providing management of storage according to business rules. Oracle Database 11g provides effective compression as structured and unstructured (LOB) of data in OLTP applications, data warehouses and content management systems. The new advanced technologies implemented in Oracle Database 11g provide compression by 2-3 times and more for any data.

Complete rollback of the changes made to data

The new version of DBMS also offers the Oracle Total Recall mechanism allowing administrators to apply requests to tables on their status on certain timepoints in the past. Thus, the easy and convenient way of adding to data of measurement of time for change tracking, audit and observance of regulatory requirements is provided.

Maximum availability of information

Being always the leader of the industry in ensuring protection of applications for databases from scheduled and unplanned downtimes, Oracle strengthens leadership with Oracle Database 11g. Administrators became simpler to answer the expectations of users connected with the level of availability of information. In the new version there were new features of ensuring high reliability, such as: Oracle Flashback Transaction (simplifies transaction rollback, made by mistake and also any connected transactions), Parallel Backup and Restore (increases the speed of backup and recovery of databases) and Hot Patching (increases the level of availability of systems thanks to application of service packs without stopping of DBMS). Besides, the new Data Recovery Advisor component allows administrators to accelerate considerably procedures of recovery, automating process of a research of problems, offering the plan of recovery and considering the failures preceding this failure.

Oracle Fast Files

Oracle Fast Files is a technology of new generation for storage in the database of big objects (LOB), such as images and big text objects and also XML-these, medical pictures and three-dimensional objects. Oracle Fast Files allows to use applications for databases all range of functionality of file systems. An opportunity to store corporate information of different types and also simply and to quickly take it, helps the enterprises to understand better the business and to adapt quickly to changes.

The accelerated processing of XML

Oracle Database 11g offers considerably the advanced XML DB technology allowing clients to store XML-data in the own a format and was able to manage them. The support of binary XML implemented in this version allows clients to select options of storage XML according to specific requirements. Besides, XML DB provides management of XML-data with use of interfaces, standard for the industry, thanks to support of the standards XQuery, Java Specification Requests (JSR)-170 and SQL/XML.

Transparent enciphering

In Oracle Database 11g even more perfect are implemented, than before, security technologies. In the new version of means of Oracle Transparent Data Encryption go beyond enciphering at the level of columns. Oracle Database 11g offers opportunities of enciphering of tabular space which can be applied to enciphering of all tables, indexes or other objects stored in this tabular space. Enciphering is provided also for the objects of LOB which are stored in the database.

Built-in OLAP cubes

Oracle Database 11g offers innovations and for data warehouses. An advanced OLAP cubes works as the materialized representations in the database. It allows developers to apply the industry standard of SQL to accomplishment of requests, and at the same time to use the advantages of high performance provided with an OLAP cube. New features of Continuous Query Notification provide immediate sending to applications of notifications on entering of significant changes into database contents, without overloading the database with procedures of permanent polls.

Creation of pools of connections and caching of results of requests

In Oracle Database 11g functions which help the organizations to support high-performance, scalable infrastructure for providing service to users of the highest quality are developed. Oracle Database 11g strengthens positions of Oracle as industry leader on ensuring performance and scalability, offering such new features as Query Result Caches (performance improvement and scalabilities of applications thanks to caching and reuse of results of often executed database requests and functions at the levels of the database and applications) and Database Resident Connection Pooling increases scalability of web systems, providing creation of pools of connections for the applications which are not multithreaded).

Advanced development tools of applications

Oracle Database 11g offers different building tools and also the simple process of creating applications which is most effectively implementing key functionality of Oracle Database 11g. Among new features - Client Side Caching (caching on client side), Binary XML for acceleration of operation of applications, processing, storing and taking XML files. Besides, Oracle Database 11g offers new Just in time the Compiler Java, providing the accelerated execution of Java procedures of the database without need to use the compiler of the third-party supplier; the built-in integration with the Visual Studio of 2005 for application development of .NET in the environment of Oracle; support of export of data from Microsoft Access in Oracle Application Express; and function of simple creation of requests in SQL Developer for rapid development of SQL-and PL/SQL procedures. Expanded means of self-government and automation

Functions of ensuring controllability in Oracle Database 11g are designed to help by the organizations to manage easily corporate grid-infrastructures and to answer the expectations of users connected with the service levels. Oracle Database 11g offers expanded functions of self-government and automation which will help clients to reduce costs for systems management, increasing performance, scalability, availability and security of applications for databases. New means of ensuring of controllability include automatic adjustment of SQL and area of memory, the new Partitioning Advisor component offering to administrators of the recommendation about sectioning of tables and indexes for performance improvement and also the improved performance diagnostic aids for cluster databases in Oracle Database 11g. Besides, Oracle Database 11g includes the new Support Workbench component which offers idle time in use the interface representing to administrators of data on the problems arising during the work of DBMS together with information on how it is possible to solve these problems quickly.