RDTEX offers a work package to ensure a successful migration to the Oracle Exadata Database Machine high-performance integrated hardware and software complex. Whereas software application is still capable of efficiently managing the computer resources, the disk subsystems are seen as an abstracted environment with the possibility of performing only primitive I/O operations. The usual solution for increasing the disk arrays performance is to increase their capacity by adding new disks, controllers and communication channels despite the overall decrease in their efficiency.
Oracle Exadata Database Machine
Oracle Exadata Database Machine is a new generation of storage systems that have the intelligence to recognize the data they work with. This is a specialized hardware-software complex based on Oracle Database, Exadata Software, and Sun hardware designed to provide the highest performance compared with the “normal” architectures used to deploy Oracle Database.
The complex of services for migrating to Oracle Exadata Database Machine offered by RDTEX:
Identification of database readiness to migrate to Oracle Exadata Database Machine
Development of the methodology of migrating to Oracle Exadata Database Machine, which includes:
- A methodology of Oracle database management systems migration;
- Creating a clustered environment (Oracle Real Application Cluster deployment methodology);
- The methodology for migrating to the Linux platform;
- Development of recommendations for the applications migration;
- The methodology of load testing
Performing load testing of an application in a new configuration (new platform, Oracle Database 11g R2 version, cluster configuration). The service includes:
- Anonymization of confidential data by using Oracle Data Masking Pack;
- Capturing of production workloads by using the option Oracle Real Application Testing
Industrial migration to Oracle Exadata Database Machine
Technical support after migration
Key Features of Oracle Exadata Database Machine:
High performance. Multiple increases in performance for data warehouses and OLTP applications.
Linear scalability. Performance grows linearly with the addition of new Exadata cells.
Ready for use. An available and fully equipped solution containing all the necessary software and hardware. A single support point from Oracle for software and hardware.
Compliance with the current standards. Oracle Exadata is transparent to existing applications. Management of the database and applications does not change.
Key features of Oracle Exadata Database Machine software:
Exadata Smart Scans.
Multiple reductions in data amount towards the database servers
Exadata Storage Indexes
Eliminates unnecessary I/O disk operations
Hybrid Columnar Compression (HCC)
Compression improves the efficiency of disk space and increases the data scanning speed by one order of magnitude
Exadata Smart Flash Cache
Eliminates the arbitrary I/O operations restrictions increasing their number by 20 times. It doubles data scanning performance
I/O Resource Manager (IORM)
Gives priority to I/O operations to ensure predictable performance
Since applications work with the “regular” Oracle 11g database management systems, there is no need to rewrite applications and queries when migrating to Exadata. There is also a possibility of data migration to Exadata architecture without stopping the server.
Solved business problems:
Search for more productive and cost-effective platform
Communication hardware update with the end of service equipment life
Maintaining online access to larger data volumes without expensive storage costs
Reduction of time spent on solving problems related to the integration and servicing of complex systems
Lack of experienced IT professionals able to diagnose complex problems that go beyond the specific product and supplier
A single provider, who takes care of the problems associated with databases, servers, storage systems, and network infrastructure
Results:
Acceleration of query execution of and other operations by tenfold
Reduction in data “pumping” – unloading the database server
A significant amount of query processing is transferred to the storage system
The processing is paralleled both at the level of Exadata cell array and at the level of a database cluster