Ask the Expert

How to transition to real-time business intelligence and data warehousing

What's the best (and smoothest!) way to switch to real-time business intelligence (BI)? Do you have any best practices/advice?

    Requires Free Membership to View

There are several ways to make the transition to real-time business intelligence (BI).

One approach to switch to real-time business intelligence is to make the data warehouse real-time, loading it in concert with operational structures and minimizing operational business intelligence. 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 intra-day 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 has increasingly helped allow operational queries, but extracts remain a challenge.

Sometimes, however, the simplicity and value-add of a real-time data warehouse can prove to be so enormous that a company can choose to actually replace its operational system with one that is more "real-time data warehouse friendly." That's the second approach. Generally, these are systems that can tolerate extracts while also performing real-time operations. The irony is that many of these modern enterprise resource planning (ERP) systems provide much more analytics than previous ones and also control many of the functions that previously were the domain of the data warehouse. Consequently, some companies have found themselves in the enviable position -- but still at an intersection -- of having analytical abilities both in operations as well as in a real-time enabled data warehouse.

Putting that aside for the moment, most shops need to choose generally where analytics and business intelligence will prevail, and give the appropriate attention to operational BI as a result. I do not believe a shop can ignore operational business intelligence any longer. However, the emphasis of where the majority of BI occurs is in question -- in the data warehouse or in the operational arena.

More about real-time business intelligence

•  Experts predict growing real-time business intelligence trend in 2008

•  Real-time business intelligence case study: Gartner lauds police for crime-fighting BI

More about operational business intelligence

•  Operational data store vs. operational business intelligence

•  Operational business intelligence making its way in the enterprise .

More about active data warehousing

•  Active data warehousing explained and examined

•  Business intelligence and data warehousing top trends: A two-part series by Dr. Mark Whitehorn

This was first published in March 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: