Software AG Case Studies Global Leader in Media and Market Research Boosts Customer Satisfaction

Edit This Case Study Record

	Global Leader in Media and Market Research Boosts Customer Satisfaction Software AG

Global Leader in Media and Market Research Boosts Customer Satisfaction

Software AG

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Functions	Sales & Marketing
Use Cases	Real-Time Location System (RTLS)
Services	Data Science Services
Challenge	The company provides insight into the watching and buying habits of an estimated 10 million global consumers. Ad agencies and brand marketers rely on the company’s online measurement tools to maximize the effectiveness of fast-moving Internet advertising campaigns, so it’s critical that the company deliver ad performance reports quickly. Customers retrieved campaign performance reports through a web portal, which in turn queried a diskbound database to compile reports from tens of terabytes of ad-tracking data. However, customer satisfaction took a hit when slowdowns in data access began to degrade system performance. In some cases, customers had to wait as long as 20 seconds for campaign reports — an eternity in today’s need-itnow world. Even more troubling, slow database access caused an internal security system to time out on more than 50% of queries, and the problem only got worse as data volumes grew. Read More
About Customer	The customer is a leading ad tracking and market research firm that provides insight into the watching and buying habits of an estimated 10 million global consumers. Ad agencies and brand marketers rely on the company’s online measurement tools to maximize the effectiveness of fast-moving Internet advertising campaigns. The company's customers retrieve campaign performance reports through a web portal, which in turn queries a diskbound database to compile reports from tens of terabytes of ad-tracking data. Read More
Solution	The company needed a solution that would both accelerate data access and effectively manage fast-flowing, rapidly growing online campaign data. Following a successful Proof-of-Concept (POC) implementation, the company decided to use Terracotta BigMemory as an in-memory data management solution for daily data feeds. Every 24 hours, BigMemory’s in-memory store is refreshed with 200GB of fresh results (the data is also written to a database). The solution makes extensive use of BigMemory’s simple, powerful Search API, which supports complex, high-performance queries on large in-memory datasets. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Functions

Sales & Marketing

Use Cases

Real-Time Location System (RTLS)

Services

Data Science Services

Challenge

The company provides insight into the watching and buying habits of an estimated 10 million global consumers. Ad agencies and brand marketers rely on the company’s online measurement tools to maximize the effectiveness of fast-moving Internet advertising campaigns, so it’s critical that the company deliver ad performance reports quickly. Customers retrieved campaign performance reports through a web portal, which in turn queried a diskbound database to compile reports from tens of terabytes of ad-tracking data. However, customer satisfaction took a hit when slowdowns in data access began to degrade system performance. In some cases, customers had to wait as long as 20 seconds for campaign reports — an eternity in today’s need-itnow world. Even more troubling, slow database access caused an internal security system to time out on more than 50% of queries, and the problem only got worse as data volumes grew.

About Customer

The customer is a leading ad tracking and market research firm that provides insight into the watching and buying habits of an estimated 10 million global consumers. Ad agencies and brand marketers rely on the company’s online measurement tools to maximize the effectiveness of fast-moving Internet advertising campaigns. The company's customers retrieve campaign performance reports through a web portal, which in turn queries a diskbound database to compile reports from tens of terabytes of ad-tracking data.

Solution

The company needed a solution that would both accelerate data access and effectively manage fast-flowing, rapidly growing online campaign data. Following a successful Proof-of-Concept (POC) implementation, the company decided to use Terracotta BigMemory as an in-memory data management solution for daily data feeds. Every 24 hours, BigMemory’s in-memory store is refreshed with 200GB of fresh results (the data is also written to a database). The solution makes extensive use of BigMemory’s simple, powerful Search API, which supports complex, high-performance queries on large in-memory datasets.

Impact #1	Improved delivery of critical reporting information with data access times decreased from 20 seconds to 20 milliseconds
Impact #2	Increased customer confidence leading to longer-term contracts
Impact #3	Plans to increase BigMemory data store to several terabytes

Impact #1

Improved delivery of critical reporting information with data access times decreased from 20 seconds to 20 milliseconds

Impact #2

Increased customer confidence leading to longer-term contracts

Impact #3

Plans to increase BigMemory data store to several terabytes

Benefit #1	99.9% reduction in data access time
Benefit #2	Data access times have plunged by as much as 99.9% — from 20 seconds to as fast as 20 milliseconds

Benefit #1

99.9% reduction in data access time

Benefit #2

Data access times have plunged by as much as 99.9% — from 20 seconds to as fast as 20 milliseconds

Download PDF Version

Overview

Global Leader in Media and Market Research Boosts Customer Satisfaction

Operational Impact

Quantitative Benefit