AOL Taps Vertica Database - InformationWeek
Software // Information Management
02:59 PM
Doug Henschen
Doug Henschen
Connect Directly
[Dark Reading Crash Course] Finding & Fixing Application Security Vulnerabilitie
Sep 14, 2017
Hear from a top applications security expert as he discusses key practices for scanning and securi ...Read More>>

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.

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of IT Report
In today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.
Twitter Feed
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.
Flash Poll