Data Warehouse Alternatives Make a Hit in India and Europe - 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.

IoT
IoT
Software // Information Management
News
6/20/2008
03:12 PM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

Data Warehouse Alternatives Make a Hit in India and Europe

Telco Reliance scales with DW appliances. Web marketer TradeDoubler loads and queries faster, cuts cost with a column-store database.

Demand for ever-larger data warehouses and ever-faster access to the data is a worldwide phenomenon. Take the examples of Reliance Communications of India and Sweden's TradeDoubler, a pan-European digital marketing firm. Both companies have replaced legacy data warehouses with alternative technologies that have one thing in common: lower cost and better performance than conventional technologies could offer. Reliance needed a highly scalable solution for call data records, so it's building a massive store on data warehouse appliances. TradeDoubler needed faster load speeds and analytic performance, but it also wanted to spend less time rebuilding and tuning the database, so it chose a column-store database.

The Need for Scale

Data volumes are mushrooming around the globe, and particularly in the telco sector in India. "For the last few months, telecom in India has been the fastest-growing market in the world, adding about 10 million customers per month," says Raj Joshi, Vice President of Decision Support Systems at Reliance Communications, one of the country's top mobile, land line and long distance providers. "We've been adding as many as 1.5 million customers per month, and we were looking for a solution that would help us optimize storage, efficiency and cost."

After an extensive review in early 2007, Reliance chose and implemented a 60-terabyte Greenplum data warehouse appliance last summer. That deployment was successful, so it now has a 120-terabyte appliance Greenplum coming online. All 180 terabytes of capacity will be dedicated to storing and retrieving call data records (CDRs), an application that was previously supported by an Oracle data warehouse. With nearly one billion new calls made every day and government requirements to retain call records for 13 months, the 50-terabyte conventional warehouse was quickly running out of headroom.

"We chose an appliance for the CDR application because it was the fastest-growing piece of our warehouse," Joshi explains. "Access to CDRs in not very frequent, but they need to go in a big database… we needed fast loading and fast retrieval for large amounts of data."

As is common for many first-time appliance deployments, Reliance is essentially offloading a high-volume, data-mart style application from the conventional data warehouse, which continues to support analysis of subscriber demographics and market trends. "Pre-paid [calling cards] account for almost 85 percent of our business, so analysis of recharges, customer user behavior and payment behavior remains in Oracle," says Joshi. "Greenplum was really new technology for us, so the idea was that once the CDR application is proven, we could expand [use of appliances] into other areas."

Reliance is thus far pleased with the Greenplum deployment in two key respects, says Joshi: "I can't comment on our final costs, but the savings were substantial… As far as performance goes, it's about three to five times faster [than our old warehouse], so the queries that were taking a couple of hours now take 30 minutes."

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Previous
1 of 2
Next
Comment  | 
Print  | 
More Insights
News
The State of Chatbots: Pandemic Edition
Jessica Davis, Senior Editor, Enterprise Apps,  9/10/2020
Commentary
Deloitte on Cloud, the Edge, and Enterprise Expectations
Joao-Pierre S. Ruth, Senior Writer,  9/14/2020
Slideshows
Data Science: How the Pandemic Has Affected 10 Popular Jobs
Cynthia Harvey, Freelance Journalist, InformationWeek,  9/9/2020
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
IT Automation Transforms Network Management
In this special report we will examine the layers of automation and orchestration in IT operations, and how they can provide high availability and greater scale for modern applications and business demands.
Slideshows
Flash Poll