Image Gallery: Yahoo!'s Hadoop Implementation
|(click for larger image and for full photo gallery)|
"Today it's a very non-trivial task to write a query across SQL and NoSQL data sources. You need to understand both and then you need to write a lot of code," said Bosworth. As a matter of fact, when he tells older DBAs that Toad for Cloud will enable them to bridge systems, they ask, "Why in the world would you want to do that? They have a dazed look in their eyes."
Knowledgeable relational database users charge that NoSQL systems "take normalization beyond any level I've ever heard of before," noted Bosworth. Toad for Cloud "brings a level headed calmness to that storm," he said, while giving NoSQL users who aren't DBAs a tool they can use to address relational systems. Early work on bridging the Oracle database system and Hadoop, a system for mapping and sorting files across large clusters, was co-developed by Quest and Cloudera, a specialist in Hadoop front ends and management. The project was called Ora-Oop and has produced freely downloadable software to get the two to work together.
Toad for Cloud Databases provides query writing tools and tools for extracting reports that work with Amazon SimpleDB, Microsoft Azure Table Services, Apache HBase and any relational system that can be accessed by the standard Open Database Connectivity (ODBC) interface. Cassandra was supported the second beta of the tool.
Bosworth said there is no pricing on Toad Extensions for Eclipse or Toad for Cloud Databases. Quest's strategy has been to get its tools distributed and in use, "then figure out how to monetize them," he said. Quest claims 100,000 customers worldwide.