UP FRONT: From the Editor
What Would You Do with a Million?By Tom Haunert
Organizations are doing more with Oracle Exadata and its 1 million I/Os per second.
We first featured Oracle Exadata V2 and the Sun Oracle Database Machine in the November/December 2009 issue of Oracle Magazine. We reported on the September 2009 product release announcement, and I wrote a few words in this column focusing on some significant product metrics.
One of those key metrics is the fact that Oracle Exadata V2 is twice as fast as Oracle Exadata V1 for data warehousing. Another metric: Oracle Exadata V2 is capable of executing 1 million random I/Os per second. Almost a year later, the numbers for Oracle Exadata V2 continue to impress—and so does what this game-changing technology is doing for business.
What’s in an I/O?I/Os have long been considered “expensive” operations in application and query design, and minimizing I/Os has been a key goal of a lot of application and query tuning. Keeping data in fast main memory, limiting slower disk-based I/Os, and avoiding I/O contention are all critical to the performance of high-volume online transaction processing (OLTP) applications and data-intensive query routines. But the information explosion continues, and keeping all your enterprise information in main memory is not always possible. What is possible is making the interconnect from main memory to storage better with InfiniBand technology; making persistent memory better with solid-state Flash storage; and making storage software that can optimize what the storage hardware and connections can do to prevent I/O bottlenecks. Along with InfiniBand and Flash technology, Oracle Exadata software is the key to delivering 1 million I/Os per second in Oracle Exadata V2.
Working with I/OsIn this issue, “Oracle Exadata at Work” presents the experiences of three organizations using Oracle Exadata and its unmatched I/O capacity. Executives and technologists from these companies describe getting more information about more information in data warehouses, storing and quickly accessing terabytes of information across millions of rows, and running more and faster calculations in OLTP applications. They also talk about the value of Oracle Exadata and the additional opportunities it presents for their organizations.
The question “What would you do with a million I/Os per second?” has been addressed by the many organizations that are currently using Oracle Exadata V2; “Oracle Exadata at Work” presents a small part of the answer.
In AdditionNote the addition of MySQL Sunday to the Oracle OpenWorld, Oracle Develop, and JavaOne triumvirate; it promises to be a great day. And I hope to see as many of you as I can at one of the many events taking place Sunday, September 19, through Thursday, September 23—not to mention Java University on September 24—in San Francisco, California.
Tom Haunert, Editor in Chief