Enterprise Apps - Baseline
Home arrow Enterprise Apps arrow How to Get Real-Time Analytics from a Data Warehouse



Smarter Virtualization – Key Building Block for Dynamic Infrastructure
Turn Data into Results with Better Business Intelligence
Plan, Launch and Manage Your Data Centers More Efficiently









Renew Your Subscription

  Enterprise Apps


How to Get Real-Time Analytics from a Data Warehouse
By Kevin Fogarty

  Table of Contents:
  1. How to Get Real-Time Analytics from a Data Warehouse
  2. Responding to Local Conditions Rapidly


Rate This Article:
Add This Article To:
How to Get Real-Time Analytics from a Data Warehouse
( Page 1 of 2 )

Out-of-band, near-real-time data warehousing allows companies that could never afford real-time data before find good reasons to pay for it.

It’s a cliché in business to say that time is money, but the people who repeat it usually don’t quantify how much of one it costs to buy the other.

That’s probably a good thing, too, because the equation is changing. Time is getting cheaper.

Not radically cheaper: Saving time for other parts of the business still costs IT hard dollars for compute power, lines of code and bandwidth.

Resource Library:

But the kind of technology that can crunch and deliver data quickly enough that its results are considered “real-time” has become so much less esoteric that it is now available to more than just brokerages, air-traffic controllers and emergency response agencies—organizations that would lose either their clients or their shirts if their information were more than a few seconds old.

Many of the companies moving into real-time systems are those for whom it’s a priority to measure time in seconds and to preserve as many as possible. Others are more surprising. Grocery products, for example, come with notoriously narrow profit margins, short shelf lives and complex buying patterns that have made after-the-fact data mining more successful than real-time sales tracking.

But near-real-time data allows grocery chain Haggen, Inc. to respond to low-inventory warnings as the inventory dwindles, rather than long after both inventory and prospective customers are gone.

“The software in our stores used to serve up summary files and log data at 3 a.m. We’d pull it across from all our stores by about 6 a.m. and begin the process of loading it into our data warehouse. By about 9 a.m., the business would begin to get some idea of what had gone on the previous day,” according to Harrison Lewis, CIO of the 33-store chain, which is based in Bellingham, Wash.

“Now we have a trickle-feed of data coming in all the time from the stores. Within fractions of a second after the transaction we can pull the data out, convert it to XML, send it to the controller and on to the server,” Lewis says. “We get visibility throughout the day; at 9 a.m. I can say how I was doing 15 minutes ago.”

That’s important for a store that focuses on high-quality, local products and—more importantly—products being mixed or baked or cooked in the store and sold for high margins in the company’s specialty departments.

Since we’re “dealing with products we’re manufacturing in the store, or with items that are doing incredibly well, having the ability to respond faster gives me the ability to take advantage of a good situation or minimize the impact of a bad one,” Lewis says.



 
 
>>> More Enterprise Apps Articles          >>> More By Kevin Fogarty
 


Sponsored Links
  • up.time Easily Monitors Virtual/Physical/Cloud. Free Trial.
  • Register for WES 2010 by February 19 and save $400.
  • Learn more about EnterpriseDB @ the Postgres Center
  • FREE Sophos Encryption Tool: Encrypt, compress and share files easily.
  • CDW Healthcare offers the IT solutions you need.
  • One number. One voicemail. Sprint Mobile Integration.
  • 12 Ways to Reduce Costs with SQL Server 2008.

     
  •  
    FEATURED SPONSORED MESSAGE

    FEATURED SPONSORED MESSAGE
       

     

    LATEST STORIES


     

     


    rss graphic
           Baseline Newsletters