Oracle Exadata – Data Warehouse

Oracle Exadata Storage Servers combine smart storage software from Oracle and industry-standard hardware from Sun to deliver the industry’s highest database storage performance. To overcome the limitations of conventional storage, Oracle Exadata Storage Servers use a massively parallel architecture to dramatically increase data bandwidth between the database server and storage. In addition, smart storage software offloads data-intensive query processing from Oracle Database 11g servers and does the query processing closer to the data. The result is faster parallel data processing and less data movement through higher bandwidth connections. This massively parallel architecture also offers linear scalability and mission-critical reliability.

Exadata Smart Flash Cache

Now with the newest release of the Oracle Exadata Storage Server, you can also achieve extreme performance for transaction processing and consolidated mixed application workloads. Exadata Smart Flash Cache addresses the disk random I/O bottleneck problem by transparently moving hot data to Sun FlashFire cards. You get ten times faster I/O response time and use ten times fewer disks for business applications from Oracle and third-party providers.

Sun Oracle Database Machine

The Oracle Exadata Storage Server provides the foundation for building dynamic storage grids, and is the building block for the Sun Oracle Database Machine. Designed for database systems of any size, the Sun Oracle Database Machine is a complete package of software, servers, and storage for data warehousing, transaction processing, and consolidated mixed application workloads. Simple and fast to implement, it has the power to process data immediately and can scale linearly as your database system grows.

Benefits:

• Extreme Performance for Data Warehouses - Improves both query performance and concurrency by offloading intensive query processing and data mining scoring from database servers and bringing it closer to the data.
• Extreme Performance for OLTP Applications - Addresses the disk random I/O bottleneck problem by transparently moving hot data to Sun FlashFire. You get ten times faster I/O response time and use ten times fewer disks for business applications from Oracle as well as third-party providers.
• Extreme Performance for Mixed Workloads - Allows you to consolidate data warehousing, transaction processing, and mixed workloads on a massively parallel server grid and eliminate the cost of third-party specialty hardware, security, and management solutions.

Sun Oracle Database Machine

The Sun Oracle Database Machine is the world’s fastest for any type of database workload, and the only database machine that runs transaction processing applications. It is a complete package of software, servers, storage and networking for all data management, including data warehousing, transaction processing and consolidated mixed application workloads. The Sun Oracle Database Machine also includes Sun’s new FlashFire technology to cache ‘hot’ data for dramatically improved transaction response times and throughput. With the Sun Oracle Database Machine, customers can consolidate all their database applications, store up to ten times more data, search data up to ten times faster, and make faster business decisions in real time without making changes to applications.

Oracle Exadata Storage Servers

At the heart of this system is the Oracle Exadata Storage Servers, which has smart storage software built in. The smart storage software offloads data-intensive query processing from Oracle Database 11g servers and brings it closer to the data. As a result, much less data travels over the server’s fast InfiniBand interconnects—dramatically improving both query performance and concurrency for transaction processing and data warehousing applications.

Benefits:

• Choice of Configurations
 - The Sun Oracle Database Machine is available in a choice of configurations that scale from a basic system to a 42-unit rack complete with 8 database servers and 14 Oracle Exadata Storage Servers.
• Extreme Performance for Data Warehouses – Improves both query performance and concurrency by offloading intensive query processing and data mining scoring from database servers and bringing it closer to the data.
• Extreme Performance for OLTP Applications - Addresses the disk random I/O bottleneck problem by transparently moving hot data to Sun FlashFire. You get ten times faster I/O response time and use ten times fewer disks for business applications from Oracle as well as third-party providers.
• Extreme Performance for Mixed Workloads - Allows you to consolidate data warehousing, transaction processing, and mixed workloads on a massively parallel server grid and eliminate the cost of third-party specialty hardware, security, and management solutions.