Welcome to All Things Warehouse Builder

eRewards finds Oracle Database 10g and Warehouse Builder Rewarding

Guest Author

Here's a customer success story about using Warehouse Builder for near-real-time data warehousing.


PRNewswire-FirstCall/ -- eRewards, Inc., the leading provider of

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


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.