AOL Taps Vertica Database - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management
02:59 PM
Doug Henschen
Doug Henschen
Connect Directly

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 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 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.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
10 Ways to Transition Traditional IT Talent to Cloud Talent
Lisa Morgan, Freelance Writer,  11/23/2020
Top 10 Data and Analytics Trends for 2021
Jessica Davis, Senior Editor, Enterprise Apps,  11/13/2020
Can Low Code Measure Up to Tomorrow's Programming Demands?
Joao-Pierre S. Ruth, Senior Writer,  11/16/2020
White Papers
Register for InformationWeek Newsletters
Current Issue
Why Chatbots Are So Popular Right Now
In this IT Trend Report, you will learn more about why chatbots are gaining traction within businesses, particularly while a pandemic is impacting the world.
Flash Poll