Sybase is latest RDB maker to embrace MapReduce
Google's 'NoSQL' technology continues to attract relational database developers
Computerworld - Who says there is a war raging between traditional SQL database vendors and the upstarts touting the so-called 'NoSQL' technology?
A slew of relational database vendors, ranging from startups touting massively-parallel data warehousing appliances to grizzled veterans of the online transaction processing (OLTP) wars, are moving to support the MapReduce data processing technology invented by Google Inc.
Sybase Inc. is the latest vendor to jump on the NoSQL bandwagon -- CTO Irfan Khan disclosed that the veteran database vendor is now working on adding MapReduce functionality inside its popular Sybase IQ analytic database.
The new functionality should help Sybase IQ crunch more data faster, says Khan. Sybase IQ is the most established of the column-based databases that have become trendy for BI and analytics applications.
"By incorporating MapReduce in a user-defined function (UDF) approach, we'll be able to break down the complexity of a problem [and] push processing closer to where the data resides while keeping the friendly SQL-like exterior," Khan said.
Startups Aster Data Inc. and Greenplum Inc. kicked off the trend last year by announcing plans to add the MapReduce technology to their respective data warehousing apps in order to accelerate the crunching of large analytical data sets.
Proponents claim that MapReduce, along with its Java-based open-source sibling, Hadoop, are faster than relational databases that hold huge amounts of data -- think hundreds of terabytes or even petabytes -- spread out over large-scale server grids like Google's search server installations.
MapReduce and Hadoop usage began among Web-centric companies like Yahoo, Facebook, and LinkedIn, all with data processing needs similar to Google's.
Meanwhile, SQL proponents argue that the advantages of MapReduce andHadoop are limited only to certain types of data-crunching, such as text indexing or data mining, and that the SQL language and tools are faster and better-suited for wide-ranging needs of most enterprises.
Judging by the companies presenting at the first HadoopWorld conference, held in October, though, interest in the new technology is widespread. The list included speakers from Visa, JP Morgan Chase, Booz Allen, the New York Times and China Mobile.
Relational database pioneer Michael Stonebraker co-authored a paper earlier this year contending that that SQL technology still beats MapReduce in most cases. But that conclusion didn't stop Vertica Systems Inc., the startup where he serves as CTO, , from adding Hadoop functionality to its new Vertica 3.5 database.
Meanwhile, data warehouse appliance supplier Netezza and longtime data warehousing firm Teradata Inc. are working on adding MapReduce functionality.
Also, a team of researchers led by Yale researcher Daniel J. Abadi have developed HadoopDB, which melds PostgreSQL, Hadoop and Facebook's version of Hadoop, called Hive.



- Excel 2010 Cheat Sheet
- Register for this Computerworld Insider Cheat Sheet and gain access to hundreds of premium content articles, guides, product reviews and more.
- X-Ray of the PCI Process-4 Proactive Steps
- This white paper from Forrester Research Inc., helps break PCI into understandable components. Security and risk professionals will gain knowledge and insight into...
- Forrester: Economic Impact of Switching to Google Apps
- Content provided by Google
Read this Forrester report on the "total economic impact" of Google Apps, and learn how switching to Google Apps creates... - Intelligent Systems: Unlocking Hidden Business Value with Data
- An intelligent system enables data to flow across an enterprise infrastructure, spanning the devices where valuable data is gathered from employees and customers,...
- Concepts of NonStop SQL/MX
- For DBAs and developers who are familiar with Oracle solutions and want to learn about NonStop SQL/MX, this whitepaper provides an overview of...
- HP Advanced Information Services for SAP In-Memory Appliance (SAP HANA)
- Organizations are eager to connect the vast amounts of data available within and outside their businesses to compete more effectively and make better... All BI and Analytics White Papers
- Quantifying the Business Value of VMware View - Webcast
- Many enterprises have discovered that the use of virtualization to support desktop workloads creates a range of significant benefits. These benefits include price...
- Good to Great - How to Take Business Analytics to the Next Level
- By attending this webcast you will learn how you can implement an effective BA strategy that will deliver maximum strategic value to your...
- Supporting Mobile Productivity With A Limited IT Budget
- Join us and hear from Kaseya mobile IT management experts as we discuss core strategies for supporting the mobile revolution on a shoestring...
- User Experience Monitoring
- In this webinar, you will learn hints & tips for improving end-user response times from Forrester Research analyst, Jean-Pierre Garbani.
- Hints & Tips Cisco
- Overwhelmed by tracking your Vblock, Flexpod or Cisco UCS performance? Spend one hour with Nimsoft to learn how you can eliminate the overhead... All BI and Analytics Webcasts