Users speed feeds to data warehouses

Google's Universal Search for Business Driving BI Value with Data Integration: Overcoming the Thorniest Challenges Gain a faster, cheaper way to manage workload BI Trends: The Next Generation of Performance Management Massively Parallel Processing Database for Business Intelligence Surviving and Thriving in Tough Times The Business Value of Tape Storage Computerworld Technology Briefing: An open-source path to optimal virtualization Learn-Fast Guide: Get Up to Speed on Green IT Sign up to receive Business Intelligence Resource Alerts

August 8, 2005 (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 analysts can forecast two years out -- it's for daily decisions," he said.
For the past 18 months, Avnet Electronics

Print this Story

Send Us Feedback

E-mail this Story

Digg this Story

Slashdot this Story

"The social network search engine goes offline...." Read more... "Salary surveys musings often cause the mind to stray. IT jobs seem in a growth cycle, despite all the new..." Read more... Read more Business Intelligence posts or See all Blogs

iPhone 3G owner sues Apple, AT&T over dropped calls, app crashes Mozilla: Firefox is faster than Chrome Upcoming Microsoft patch lineup could be 'massive,' says researcher More top stories...

Microsoft explains Seinfeld-Windows TV ad: just a 'teaser' Continuing coverage: Google's Chrome browser Social Security numbers exposed on Iowa land-records Web site

Microsoft warns of IE8 lock-in with XP SP3 Users of Windows XP SP3 who try out IE8 Beta 2 won't be able to uninstall either one under certain circumstances. Opinion: Why Google has lost its mojo -- and why you should care Google has gone from innovative upstart to fat-and-happy industry leader in what seems like record time. Preston Gralla explains. Review: Internet Explorer 8 Beta 2 offers some nifty new features Microsoft's latest beta of IE8 includes better tab management, new services such as Web Slices and Accelerators, and the new 'porn mode.' IT Schools to Watch 2008 These leading-edge graduate schools are moving at the pace of the IT workplace, delivering coursework that's relevant to today's IT professionals. Windows Vista A to Z Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS. More Continuing Coverage After 9/11: Homeland Security Apple's iPhone Ask a Premier 100 IT Leader Bill Gates steps down BlackBerry Legal Battle Data Security Breaches Electronic Voting Firefox H-1B Visas HP's Boardroom Scandal Handheld Devices Hurricane Katrina Aftermath Microsoft Legal Issues Microsoft's Vista Open Source RFID Technology SCO's Linux Fight Sarbanes-Oxley Act Spam Voice Over IP Wi-Fi Windows Meta File Vulnerability Windows XP Service Pack 3 IT Careers 2010 Four years from now, the IT field will be a vastly different place. Will you be ready? More Special Reports Premier 100 IT Leaders 2007 Best in Class 2006 Computerworld Horizon Awards 2006 Premier 100 IT Leaders 2006 Salary Survey 2007 Best Places to Work in IT 2007 IT Forecast 2007 Premier 100 IT Leaders 40 Years of Computerworld ASPs, Take Two Best Places to Work in IT 2003 Best Places to Work in IT 2004 Best Places to Work in IT 2005 Best Places to Work in IT 2006 Business Intelligence Home Runs Business Intelligence: Smarter BI Business Intelligence: The Future of BI CRM Goes Vertical CRM: Sober CRM Career Planning Guide 2005 Careers: IT Profession 2010 Computerworld Horizon Awards 2005 Data Management: Mining for Gems Data Management: Taming Data Chaos Development: Hard-Workin' Web Sites Development: New Tools New Choices Development: The New World of Application Development Development: The Web Services Tsunami Development: Web Services Hurdles Disaster Recovery: Preparing for the Worst E-commerce Grows Up E-mail/Groupware: Big Decisions Faces of Mobile IT Forecast 2006 Global Mobile Hardware: Multiple Cores, Multiple Challenges Hardware: On-Demand Un-Hyped Hardware: The Shape of Things to Come Horizon Awards: 10 Cool Cutting Edge Technologies IT Management: Guide to Managing Vendors IT Management: Navigating Global IT IT Management: Recovery Ahead IT Management: The Future of IT IT Management: The Resourceful Project Manager Innovative Technology Awards 2004 Management: Reinventing IT Microsoft in Transition Mobile/Wireless Leaders and Laggards Mobile/Wireless: The Untethered Worker Mobile/Wireless: Tiny Gadgets, Huge Costs Network Management: Taking Control Networking: Turbulence Ahead! Networking: VoIP Goes Mainstream Operating Systems: In the Slow Lane Operating Systems: Linux Goes Global Operating Systems: Should You Nix Unix? Outsourcing: Offshore Buyer's Guide Outsourcing: Outsourcing Dangers Premier 100 IT Leaders 2004 Best in Class Premier 100 IT Leaders 2005 Best in Class ROI: Do the Math! Salary Survey 2003 Salary Survey 2004 Salary Survey 2005 Security Action Plan Security: Compliance Headaches Security: Proactive Security Security: Risk and Reward Security: Tips From Security Pros Souped-up Security Storage: Battling Complexity Storage: Cheap & Secure Data Stores Storage: Stretching Your Storage Dollars Storage: The Lean Storage Machine Storage: The New Rules of Storage Storage: The Ultimate Backup Guide Supply Chain: Missing Links Supply Chain: RFID Reality Check The Business of Security Web 2.0 Security Wireless: Wireless At Work All Zones Application Performance Zone Business Continuity Zone The File Data Management Zone Security Management Zone ITIL Best Practices Zone The SAS Zone Business Intelligence and Analytics Zone Windows Protection Zone Identity & Security Management Zone See your link here

Speeding the time to intelligence Get this Computerworld report free for a limited time, compliments of SAS. Time To Intelligence -- a concept defining how long it takes to get accurate and timely information into the hands of workers who need it most. Do it slower than your competitors and your company is toast. Do it faster, you scorch them. Business Intelligence is the key to optimizing Time To Intelligence, and success there is a combination of people, policies, and technology. Download this executive briefing  From Laggard to Leader: Transforming the Data Center From Laggard to Leader: Transforming the Data Center Register for this complimentary live webcast today! Go to the webcast  Rapid application development, rapid results Download this special report now! (Source: Intersystems) All too many businesses suffer from IT infrastructures that are a hodge-podge of disconnected databases and applications. What's needed is the ability rapidly develop connected applications under a unified service-oriented architecture. InterSystems Ensemble integration environment and Cache database are effective tools in answering this need, delivering a rapid ROI. Download this white paper  White Papers Read up on the latest ideas and technologies from companies that sell hardware, software and services. Death to PST: Hidden Cost of Email Mismanagement Extend, Replace, or Convert; which is the best way forward for COBOL Applications? The Trend from Unix to Linux in SAP Data Centers View more whitepapers

• iPhone 3G owner sues Apple, AT&T over dropped calls, app crashes
• Microsoft explains Seinfeld-Windows TV ad: just a 'teaser'
• Mozilla: Firefox is faster than Chrome
• More top stories 

SAS Business and Analytics Zone No matter where your organization is on the path toward evolving your IT infrastructure, SAS can adapt to your situation to meet your long-term enterprise intelligence needs. We can help you drive intelligence evolution to the next level, while leveraging and extending the value of your existing IT investments. Learn more in the Business and Analytics Zone See All Zones

Intercept Spam & Viruses With MessageLabs MessageLabs is offering a complimentary 30 day trial of its managed Anti-virus and Anti-spam security solutions. MessageLabs guarantees complete protection against all know and unknown email threats. By providing 24 hour support, your business can increase productivity and decrease risk. Register for a complimentary trial and receive a free datasheet. Download this white paper now!

XenServer FREE trial Citrix XenServer is the simplest and most effective way to virtualize and provision servers. XenServer combines comprehensive server virtualization capabilities with unparalleled scalability, performance, economics, and ease-of-use. Based on the open source Xen hypervisor, XenServer delivers fast performance, easy management, and advanced features such as live migration. Request free trial now

Since You Asked A weekly storage column from storage analyst, Steve Duplessie of the Enterprise Strategy Group Click here to read the latest column by Steve Duplessie