Users speed feeds to data warehouses

BI tools are playing a more prominent role in operational decision-making

By Heather Havenstein

August 8, 2005 12:00 PM ET

Computerworld - As business intelligence becomes a critical component of daily operations, real-time data warehouses that can provide end users with rapid updates from transactional systems are increasingly sprouting up at companies.
For example, online retailer Overstock.com Inc. has begun connecting users to a real-time data warehouse it completed last month. The project's goal is to help employees gain insight into the effectiveness of the company's online and e-mail advertising campaigns.
Overstock is using transactional data management tools from GoldenGate Software Inc. to pull information directly from its business systems into the data warehouse, said Jack Garcella, the Salt Lake City-based retailer's vice president of data warehousing, analytics and reporting.
The data warehouse, which is based on NCR Corp.'s Teradata software, will replace a process that used traditional extract, transform and load tools to build reports directly from Overstock's back-end systems. As the retailer grew, the reports stressed the systems and gave employees day-old data, Garcella said. Now the data warehouse receives Web site clickstream data in real time, financial and product-sales data every 15 minutes and other information hourly.
"When we launch campaigns now, we can look within five minutes and see if they are producing lift or revenue that would not normally have happened," Garcella said. "You can't wait until the next day or three hours later to get that data." He declined to specify how much Overstock is spending on the warehousing project, other than to say the cost is in the millions of dollars.
Harrah's Entertainment Inc. is testing a real-time data warehouse that combines operational and historical customer data, said Tim Stanley, the Las Vegas-based gaming company's CIO.
The new setup is based on an architecture that Harrah's developed in mid-2002. The company is using adapters from Tibco Software Inc. to feed information from transactional systems into its Teradata warehouse to help workers interact with customers at Harrah's properties, on the phone or on the Harrah's Web site.


Tim Stanley, CIO of Harrah's Entertainment Inc. Image Credit: Martin Le Pire/KlixPix

"It uses Teradata's transactional database and also has direct access to all the historical data," Stanley said. "You don't have to have two databases talk to each other."
Changing Needs
Eric Rogge, an analyst at Ventana Research Inc. in San Mateo, Calif., said that because business intelligence tools are being used more often for operational decision-making, many companies are finding that they need to refresh their data warehouses more frequently than on a nightly basis.
"It's not about loading a data warehouse so a small department of business

Recommend Digg Twitter ShareThis

Email Print Send Feedback Reprints

Additional Resources

Xerox

Win a color printer!

By using solid ink technology only from Xerox, you could save up to 65% by printing color for the cost of black and white. Enter for a chance to WIN a PhaserTM 8860 network color printer!

Microsoft

Upgrade to Internet Explorer 8 today.

Save time and mitigate security risk. Deploy it now.

Sybase

NEXT-GENERATION MOBILITY PLATFORMS

In this white paper, IDC analyzes the role of next-generation mobile enterprise platforms as organizations seek a more strategic deployment of mobile solutions.

Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.

White Papers & Webcasts

MarketVibe: Communications and Collaboration Needs at Business Organizations
In April 2009, IT and business leaders were invited to participate in a survey on business communications and collaboration solutions. The goal of...

How to Reduce Eclipse BIRT Development Effort for Data Visualizations
Web applications can come with a long list of visualization requirements for structured data. By delivering your output through the BIRT Interactive Viewer,...

The Value of Network and Application Visibility by Aberdeen
This survey-based paper analyzes best practices for improving application visibility and analysis. This paper can help serve as a guideline for organizations looking...

Legacy IT Modernization - Practical Reality
(Source: BluePhoenix) Corporate budgets continue to tighten. Organizations are looking at ways to reduce operating costs and eliminate unnecessary expenses while at the...

The CIO's New Guide to Design of Global IT Infrastructure
Is it possible to eliminate the impact of distance? This paper explores the 5 key principles successful CIOs are using to redesign IT...

Interactive Guide: Getting Started with Data Governance
In this online interactive guide, Andrew White, Research VP with lead analyst firm Gartner, answers these questions to help get you on the...

2007 Gartner Magic Quadrant Report
Riverbed positioned in Leaders Quadrant of Gartner Magic Quadrant for WAN Optimization Controllers. Analyzing strengths vs. cautions, Gartner helps organizations looking to acquire...

Why Now is the Right Time for the Linux Desktop
(Source: Novell) Faced with tighter budgets, enterprises are rethinking their desktop strategies to deliver the same - if not better - services and...

Five Steps to Successful IT Consolidation
Has your Enterprise made the strategic decision to consolidate remote site IT infrastructure into central data centers? Then you have probably discovered that...

Agile Enterprise Content Management (ECM) for Rapid ROI
(Source: IBM) Content rich business processes are a core feature of daily operations at just about any organization today. Very often these essential...

All White Papers | All Webcasts