This month’s column is excerpted from the white paper “Modernizing and Advancing Information Management across the Enterprise” by William McKnight.

The data warehouse faces a conundrum, and companies need to make a decision about it. One approach is to make the data warehouse real time, loading it in concert with operational structures and minimizing operational business intelligence (BI). This is simple in concept. However, making data warehouses real time can be an extremely complex challenge. Operational systems need to cooperate with this vision by not being so fragile that they break with intraday extracts. The data warehouse environment needs to be efficient to the point where the requested extracts are kept to a minimum. This is not always the case, so real time remains a challenge. Service-oriented architecture (SOA) has increasingly helped allow operational queries, but extracts remain a challenge.

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