ForeSee Supports High Rate of Data Growth with Clustered, High-Performance Database Solution
 
 

ForeSee Supports High Rate of Data Growth with Clustered, High-Performance Database Solution

Printer View Printer View

As a pioneer in customer-experience analytics, ForeSee continuously measures satisfaction across customer touch points and delivers critical insights into where its customers can prioritize improvements for maximum impact. Because ForeSee’s superior technology and proven methodology connect the customer experience to the bottom line, executives and managers can drive future success by confidently optimizing the efforts that will achieve business and brand objectives. 

Over the last few years, ForeSee’s data volume has grown from 200 gigabytes to 8 terabytes. To support this growth, it needed a high performance solution to collect and process high volumes of customer satisfaction survey data, across various collection channels. At the same time, ForeSee’s customers demanded increased visibility into their data to support their business decisions. ForeSee deployed Oracle Database, Enterprise Edition 11g with Real Application Clusters, Oracle Partitioning, and Oracle Active Data Guard to support its data growth and ensure rapid processing and viewing of data. It also implemented Oracle FGAC to provide each customer with secure access to their own data inside a multitenant database.

 
 

 
 

Challenges

A word from ForeSee

  • “We have experienced rapid data growth over the last few years—including a 45% growth over the last year alone. Oracle Database Enterprise Edition 11g with Real Application Clusters provide the scalability and processing performance we need to support our customers with actionable data for improved decision-making.” – Ranjay Kumar, Director of Database Operations, ForeSee

  • Deploy a solution to collect, process and store high volumes of customer-satisfaction survey data for clients across many industries and various channels—including mobile, online, call center, and in-store
  • Allow customers to rapidly view and segment this data across many dimensions and attributes in near real-time, so the company could achieve its goal to “cut anything by anything”

Solutions

Oracle Product and Services

  • Collected customer satisfaction survey data in an online transaction processing database and moved it into a data warehouse for reporting, analysis, and long-term storage
  • Integrated data from numerous collection channels—mobile, online, call center, and in-store—and enabled the processing of gigabytes of this data in just a few hours
  • Used Oracle Real Application Clusters for high availability within the data center and to seamlessly scale performance as data volume grows
  • Deployed Oracle Partitioning to enable improved query performance and more efficient data lifecycle management practices
  • Used Oracle Active Data Guard for disaster recovery across data centers and to extend its high availability solution
  • Used FGAC to create Virtual Private Databases for its clients in side its multitenant database

Why Oracle

“We chose Oracle because it is the clear market leader,” said Ranjay Kumar, director of database operations, ForeSee. “We looked at other options, but they all fell short of our requirements.”

Implementation Process

After careful consideration for growth, scalability, and security, ForeSee redesigned the database infrastructure to use Oracle. To accommodate the rapid expansion of data, the company recently increased its Oracle Database 11g footprint, which now includes Oracle Active Data Guard, to provide customers with online access to survey data and reports, while ensuring data protection and high availability. ForeSee completed its implementations in house, with the help of Oracle Premier Support.

Resources