Oracle IOT助web2.0大展身手
在Search Oracle看到一则新闻，Oracle IOT帮助bebo.com击败Myspace.com。点击bebo.com一看，原来是个web2.0；看来中小企业也可以使用Oracle RDBMS。
Web2.0应该是以User为中心的，User的Posts,User的Comments etc。IOT应该正好满足bebo.com对数据库设计的要求。
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.
“Performance is absolutely key to us,” he said, “so anything Oracle can do to improve that is always a bonus.”
不知道国内的web2.0企业是否有使用Oracle的，并且考虑多种feature.似乎bebo.com是使用online-redefinaion 来convert tables on the fly，我还真想不出其他的办法来。
.text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://my.poco.cn/fav/storeIt.php?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t)+'&img=http://www.h-strong.com/blog/logo.gif','keyit','scrollbars=no,width=475,height=575,status=no,resizable=yes'));keyit.focus(); "添加到 POCO 网摘"){kind=logo}
http://www.dbanotes.net/database/bebocom_oracle.html
single table hash cluster也不错的, 只是他们没有用而已.