TradeDoubler
TradeDoubler is a global digital marketing company, serving more than 1600 online advertisers across Europe and Asia. TradeDoubler optimizes Web marketing campaigns by analyzing Web clicks, impressions and purchases. Analyzing terabytes of data about the results of its programs is central to the company’s success. TradeDoubler selected Infobright Enterprise Edition for its ability to produce analytical results rapidly, seamless interoperability with their MySQL database, and lower total cost of ownership.
Overview download as pdf
TradeDoubler is a global digital marketing company offering a range of performance-based marketing solutions. TradeDoubler's products and services provide companies with the tools and expertise to drive results online whether they are looking to generate sales or drive brand awareness. Headquartered in Sweden, the company boasts a unique global reach with local offices in 18 countries. With a breadth of expertise across multiple industry sectors and a network of more than 125,000 website publishers TradeDoubler helps deliver online results for over 1,600 advertisers globally including a mix of local and international companies such as Apple Store, Dell, Telia Sonera, eBay and Kelkoo.
Challenge
TradeDoubler’s services require them to execute complex analytic queries against as many as 3 billion rows of data, demanding extensive aggregation. What's more, since the firm studies constantly changing clickstream data, the database had to be continually rebuilt, re-indexed and tuned. Before Infobright, TradeDoubler found that it could not quickly produce the detailed statistics and business analysis required, and in the most extreme cases, could not resolve the queries at all.
“Each month we process and analyze data generated by 20 billion online transactions. We are pleased by Infobright’s performance and the fact that we now can get answers to questions we want to ask. Our IT group is impressed with how easy this solution is to maintain.”
- Ola Udén, CTO of TradeDoubler
Solution
TradeDoubler evaluated Infobright for a statistically intense project. Infobright’s analytic data warehouse software was loaded on a standard Dell SC1950 1U rack chassis server, demonstrating its ability to leverage the capabilities of off-the-shelf hardware. More than 3.2 billion rows of data were loaded into the Infobright solution at an average rate of more than 300,000 rows per second. Though data compression rates varied depending upon data type, Infobright compressed fact tables at a ratio of 20 to 30:1. Comparable operations performed on the company’s Oracle 9 Enterprise Edition database (with partition option) were terminated after approximately two hours of processing. TradeDoubler purchased Infobright for its ability to produce analytical results rapidly, seamless interoperability with their MySQL database, and lower total cost of ownership. Now in production, the Infobright solution has resulted in faster loading speeds, automated indexing, 30X data compression and faster query times.
“Infobright performed extremely well. It handled huge volumes of data and resolved queries faster than I have ever witnessed after years in this industry—and did so using standard hardware.” Read the case study on the TDWI web site HERE.
- Mats Johansson, senior consultant at Lincube Group AB, the organization that conducted the testing.
download as pdf
Infopliance Portal
Next Steps
Customer Stories
Xerox
The key benefit of using Infobright is improved marketing efficiency and effectiveness.
A New Approach
The Analytic Data Warehouse
Traditional data warehouse products put a tremendous burden on IT in order to create and maintain an environment that will allow users to query against large volumes of data.
