Michael Haisten of Daman Consulting met with a peer-to-peer group at The Data Warehousing Institute World Conference - Spring 2002 and discussed the difference between real-time data warehousing and real-time analytics. He stated that the two are "exclusive, but complementary." The advantages of real-time data warehousing include continuous availability, elimination of the cost of the extraction process and a linear way to scale. Real-time analytics provide immediate availability – on the fly – and act as an accumulator for the operational environment.

There are at least three things to consider when planning a real-time data warehouse (RTDW) according to Haisten: "One – make sure you have a real reason for implementing a RTDW. Just because people want up-to-the-minute results doesn’t mean they need them to perform their jobs. Secondly, do not implement timidly – if you can’t afford a whole system, it might not be worth the investment at all. Thirdly, whatever is problematic in batch will be worse in real time because you can’t stop and back it out." He advises that you take the logic and fix the data. Alerts need to be immediate and you need to determine the dependencies before you start the project.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access