Super App to use Oracle IOT's
According to
this article, Oracle will power 'Bebo"
a MySpace-like social networking application. Bebo must be
highly scalable and able to minimize disk I/O by accessing related
information in a single disk read.
"The IOT option allows users to store indexes and tables and
associated rows in the same place, reducing the amount of effort
necessary to "fetch" information, according to Birch.
Before Bebo.com started using IOT, records for individual site
users were stored in different places and on different discs,
and retrieving the information required a lot of physical I/O.
That dilemma led Bebo.com to IOT.
"We adopted IOT, and we converted our tables to it. You can
actually convert tables on the fly and it doesn't require
downtime," Birch said. "We converted a lot of tables and saw
huge gains in terms of the amount of discs we needed."
Things are currently running efficiently at Bebo.com, but Birch
says that -- going forward -- anything Oracle can do to help
improve database performance would be welcomed with open arms."
Contrary to the "pure" relational model which says that physical
disk organization should not matter, real-world DBA's frequently
reorganize tables to maximize I/O efficiency. IOT's and Oracle
Cluster tables allow for related rows to be stored adjacent to one
another on a single disk block, dramatically reducing disk I/O
overhead.
For more details on tuning with
sorted hash cluster tables, see my book "Oracle
Tuning: The Definitive Reference".
|
