eRewards finds Oracle Database 10g and Warehouse Builder Rewarding
By antonio romero on Aug 21, 2007
Here's a customer success story about using Warehouse Builder for near-real-time data warehousing.
online market research, relies on an Oracle(R) Database infrastructure
to conduct online market research. With an opinion panel of more than
three million members, eRewards uses a family of Oracle Database
products as the foundation for its online transaction processing (OLTP)
and data warehouse systems to achieve a positive member experience and
fast, accurate results for clients.
As the industry's first "by-invitation-only" consumer opinion panel,
eRewards uses Oracle Database 10g to power its program which rewards
members for the time they spend answering online surveys that have been
selected to match their interests, demographics, and life
circumstances. Through this program, members earn e-Rewards currency,
which can be redeemed for a variety of rewards including dining,
entertainment, travel and retail rewards. To process its influx of
data, eRewards depends on Oracle Database 10g, Oracle Real Application
Clusters, Oracle Automatic Storage Management, Oracle Data Guard and
Oracle Warehouse Builder 10g.
At the heart of eRewards' Web site is a powerful OLTP system
supported by Oracle Database 10g and Oracle Real Application Clusters
for online interaction with eRewards members. Complementing eRewards'
OLTP systems is a multi-terabyte data warehouse also running on Oracle
Database and Oracle Real Application Clusters. eRewards uses the
flexibility of Oracle Data Guard, traditionally a disaster recovery
feature, to keep its data warehouse up-to-date with the latest
information captured by the OLTP system. The data warehouse is used to
manage survey panels and provide valuable real-time analysis and
reporting captured from member response data. Additionally, eRewards
uses Oracle Warehouse Builder 10g to design, build and populate its
data warehouse and business intelligence systems.
"We evaluated competitive offerings and nothing could match the
combination of functionality, performance, manageability and the cost
structure offered by Oracle," said Joel Davis, Senior Vice President of
Technology, eRewards. "Near real-time synchronization of our data
warehouse with our OLTP system enables eRewards to more effectively
scale our environment to meet the needs of members, clients, and