Overstock.com Moves Reports To Data Warehouse - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
8/3/2005
10:04 AM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

Overstock.com Moves Reports To Data Warehouse

Faced with rapid growth, Overstock.com is building a data warehouse for operational reporting to reduce the strain on its transactional systems.

Overstock.com Inc., the "close-out" retailer of brand-name merchandise, is migrating from an Oracle 9i database to Oracle 10g and shifting its reporting from operational systems to a data warehouse.

The latter is necessary because Overstock's business has been growing by 100% a year and its operational systems were staggering under their combined customer transaction and reporting loads, says Shawn Schwegman, senior VP of technology. With 14 million to 18 million hits a month, Overstock's Web site handles an information and transaction load equivalent to Sears' or J.C. Penney's Web sites, he says.

The demands on its transactional systems were becoming so heavy that Overstock found itself "turning off one reporting function after another" to keep customer response times satisfactory. But Schwegman acknowledges that was a dead-end path. "Basically, you're dead in the water if you can't report on operations," he says.

What's more, each time Schwegman turned off a reporting function, "I had the most irate users you've ever seen," he says.

With no overnight window in which to shut down operations and move data, the 24-by-7 online merchandiser had to decide how best to make its migration to Oracle 10g and implement a new reporting system without affecting operations.

That means Overstock needed a high-volume data-management tool to migrate data into Oracle 10g and then load selected data into the new NCR Corp. Teradata data warehouse, Schwegman says. Overstock evaluated data-migration toolsets from GoldenGate Software, Quest Software, and DataMirror. All three offer solid, real-time data migration, Schwegman says, but it selected GoldenGate's transactional data-management tools for their ability to read Oracle database log files and extract the needed data from those files rather than going into the database itself.

"Most ETL [extract, transform, and load] tools add 10% to 15% performance overhead to the production environment. Because GoldenGate can read the Oracle log files, its overhead is less than 4%," Schwegman says.

Overstock uses 10 Oracle database clusters, with the largest consisting of four eight-way servers. That cluster alone represents a $1 million technology investment, including the cost of the application software running on it. Reducing performance overhead by 10% saves Overstock $100,000, Schwegman says. Likewise, his total relational database investment is over $5 million. To save 10% of that promises even more significant savings.

Overstock purchased the GoldenGate data-management tools two months ago. In the first phase of its project, it has been migrating from Oracle 9i to 10g, with GoldenGate handling the data transfers without any database down time.

The online retailer also has been building a Teradata data warehouse with Business Objects SA reporting software replacing the 30,000 lines of custom reporting code previously used by Overstock managers and analysts. The company started to assemble the data warehouse in April, a project that normally takes up to six months or more, but Schwegman expects to finish the work in less time. The system now has 25 early users, "executives and a set of data hounds, power users," Schwegman says. In another month, the total will be 250 users, Schwegman says.

When the data warehouse is finished, GoldenGate will continue moving data from the operational Oracle systems into the data warehouse "in near real time to provide reporting and analysis for our environment," Schwegman says.

Needing real-time analysis for customer-relationship management was one reason Overstock created its own in-house reporting system after it was founded in 1999. Now, as a maturing online retailer--Schwegman says Overstock is the No. 6 or 7 retail Web site in terms of the number of its unique visitors--Overstock must move away from homegrown systems to systems that march in step with its growth rather than impede it.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

News
Pandemic Responses Make Room for More Data Opportunities
Jessica Davis, Senior Editor, Enterprise Apps,  5/4/2021
Slideshows
10 Things Your Artificial Intelligence Initiative Needs to Succeed
Lisa Morgan, Freelance Writer,  4/20/2021
News
Transformation, Disruption, and Gender Diversity in Tech
Joao-Pierre S. Ruth, Senior Writer,  5/6/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Slideshows
Flash Poll