3.9. Innovative technologies of Oracle company
In recent years, Oracle has developed several innovative solutions for virtualization and cloud computing, as well as a number of storage and management systems: Oracle llg, Oracle Exadata, RM AN, Oracle NFS , solutions Sun ZFS Backup Appliance, Oracle Optimized Solution for Enterprise Cloud Infrastructure and Oracle Pillar Axiom 600, tape drive StorageTek T10000S, etc.
Oracle Database llg. Based on research conducted by Gartner in 2011, Oracle Database llg was the leader in the field of databases. It allows you to reduce costs and improve the quality of services as a result of:
- clustering and consolidating enterprise application databases into fast, reliable and scalable private cloud systems;
- increase the availability and eliminate redundancy of the information center;
- performance growth by compressing data in low-cost storage partitions
- ensuring security and consistency of information;
doubling the productivity of the database administrator and reducing the risk associated with making changes.
The Oracle Exadata hardware and software
(full name is Oracle Exadata Database Machine). It contains both hardware and software components. This comprehensive package includes servers, storage systems, network and software that are highly scalable, secure and highly resilient. For example, the database engine - Oracle Database Machine X2-2 - includes eight dual-processor database servers, 14 Oracle Exadata Storage Server servers and InfiniBand switches. It is offered in a variety of configurations, from a quarter of the rack to a rack of 42 cells.
The basis of all the complexes of the Exadata line is the Oracle Database version llg with the Real Application Cluster option. It allows several physical servers to work with shared storage as a single database without software modifications of application software. Especially for Exadata, Oracle Database is designed as a hybrid columnar compression.
Server nodes are running a 64-bit edition of the Oracle Linux operating system. In the middle of 2011 the servers of the X2-2 and X2-8 complexes installed the Solaris Express 11 operating system. It provides the highest performance for both data banks and online transaction processing. With it, customers can reduce IT costs by consolidating and managing large amounts of data at several compressed levels, and improving the productivity of all applications and making business decisions in real time.
The Exadata parallel processing network is ideal for combining data banks and OLTP applications, and Exadata's resource management and quality assurance functions ensure fast response times for all users.
The RMAN backup and recovery program (Oracle Recovery Manager). It appeared in the DBMS
Oracle version 8, and in version 9 was significantly simplified while maintaining the main design, and it was also easier to write commands. With the integration with the main management utility Oracle Enterprise Manager with it you can perform:
- full redundancy and redundancy of changes;
- cold and hot backup, and in the second case table spaces are not transferred to the backup mode, which avoids additional load on the log;
- detection of damaged blocks;
- Parallel I/O operations
- automatic logging of copy and restore operations.
The advantages of the program include the ability to process large amounts of data, making it indispensable in some cases. Recovery is performed under the control of either the user or the server. In the first case, you can have closed backup and restore, restore from an open backup, duplicate the database, create a backup database, restore the table space at a certain point in time.
NFS solution in Oracle Database 11 g. Network storage systems (NAS) are widely used in corporate data centers. This model is simpler and cheaper than the model using block-protocol technology for organizing a networked data warehouse (for example, FCP SAN or iSCSI SAN). New types of NAS, in particular clustered ones, offer a higher level of availability, not implemented in direct access (DAS) systems.
DAS (direct-attached storage) systems. These systems directly connected to the server were preceded by NAS and SAN. For example, one of them is a data store on a disk array directly connected t