Software // Information Management
Commentary
1/5/2011
02:59 PM
Doug Henschen
Doug Henschen
Commentary
Connect Directly
LinkedIn
Twitter
Google+
RSS
E-Mail
50%
50%

AOL Taps Vertica Database

Column-store platform edges out IBM Netezza, Oracle and others to provide self-service data sets for advertizing optimization and internal traffic analysis.

"We've got data, and we're not afraid to use it."

This is how AOL describes the mission of its "armies of researchers, engineers and other thick-framed-glasses types" who deliver sought-after online audiences. To let customers and internal business users do more of this work on their own, AOL has added Vertica to its portfolio of data warehousing tools, it was announced on Tuesday.

Vertica was selected to replace MySQL as the database of choice for delivering online data sets and reporting applications. As these data sets have grown, the company was running into performance problems including data sharding and difficulty replicating information across multiple servers, according to Mark Ettrich, senior technical director at AOL.

"Vertica will help us support robust reporting and data consumption whether it's through front-end Web services, APIs or direct SQL queries against Vertica boxes," Ettrich told InformationWeek.

If your last frame of reference on AOL was the 1998 romantic comedy "You've Got Mail" or even the subsequent flame out and divorce from Time Warner in 2009, it might surprise you to learn that AOL's Advertising.com is said to be the number in network in online advertising, reaching 74 out of comScore's top 100 Web sites. AOL has also morphed from a dial-up Internet access provider into an original content publisher, with rising sites including Engadget, Politics Daily, AOL Music and Black Voices.

AOL will deploy Vertica over the coming year to power both external and internal self-service query and reporting applications, Ettrich said. AOL Advertising and Advertizing.com customers, for example, want to measure brand awareness and analyze the success of advertising campaigns. Internal customers might want to examine traffic sources and trends, or revenue scenarios.

Vertica's column-store database supports massively parallel processing (MPP) on commodity hardware. The column-store approach -- an architecture shared by competitors Sybase IQ and ParAccel -- maximizes data compression and speeds analytic queries that typically interrogate only selected dimensions across rows of data. MPP further enhances performance by spreading workloads across tens, hundreds or even thousands of nodes.

AOL was already using (and continues to use) Oracle and Netezza for data warehousing, but the company considered products from Aster Data, Greenplum, Oracle, Netezza and Vertica in the MySQL-replacement evaluation.

AOL's requirements included the ability to serve up multiple 10-to-15 terabyte data stores with continuous data loading for near-real-time reporting. The company also tested the ability to support at least 300 concurrent users.

"One of the stand-out features of Vertica that appealed to me was the ability to run on true commodity hardware," Ettrich said. "Some vendors say they run on commodity hardware, but they stipulate particular configurations, interfaces and configurations to get optimum performance."

AOL uses reverse auctions to purchase its hardware, and it specs out several commodity (White) boxes that can be used to run the Vertica database with stand-out performance, Ettrich said.

Asked if AOL intends to consolidate data warehousing platforms, Ettrich demurred, "I don't want to make any statements about that at this point."

Founded in 2005, Vertica was among a handful of upstart analytic database providers that emerged and made inroads against data warehousing incumbents Oracle, IBM, Microsoft and Teradata in recent years. Consolidation in 2010 saw two early pioneers, Netezza and Greenplum, acquired by IBM and EMC, respectively. Aster Data, InfoBright, Kognitio, ParAccel and Vertica are among the independents remaining.

AOL raises Vertica's customer count to 328 firms, according to the company, and it lists Bank of America, BlueCross BlueShield, Comcast, Sunoco, and Verizon among other prominent customers.

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest September 18, 2014
Enterprise social network success starts and ends with integration. Here's how to finally make collaboration click.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
The weekly wrap-up of the top stories from InformationWeek.com this week.
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.