MTC Atlanta

Aflac Speeds Queries by up to 95 Percent and Compresses Data with Data Warehouse

Aflac needed to update its data warehouse to improve performance, enhance data availability, and accommodate change. To achieve this, the company implemented Microsoft SQL Server Fast Track Data Warehouse built on the HP technology platform. With its solution, Aflac can speed system queries by as much as 95 percent, refresh data in the warehouse two to three hours faster, compress data to occupy up to 10 times less space, and increase business agility.

…

“With SQL Server Fast Track Data Warehouse, we’ve realized up to a 95 percent reduction in data query times.” - Eric Hunter, Senior Manager of Business Intelligence and Marketing, Aflac

…

Between January and March 2010, IT employees responsible for databases, storage, and business intelligence designed the new solution. This process included a trip to the Microsoft Technology Center in Atlanta, Georgia. “Working with the Microsoft Technology Center was a significant accelerator for us,” says Hunter. “We talked through everyone’s concerns and gained a collective philosophy.”

Read The Case Study