In his blog, Do You Know the Differences between a Data Warehouse and a Live Datamart, Kai Waehner illustrated that the former stores historical business data for reporting, analysis, and data discovery whereas the latter leverages live operational data in real time. These two domains and/or IT tools are therefore not mutually exclusive. In fact, one can augment the other and vice versa, if implemented properly, and drive your overall BI initiatives to the next level.
Here is how that can be done—many of our customers that are on their path to a Fast Data company use analytics tools for both historical and real-time data in addition to their data warehouse and tackle operational problems, including fraud detection, predictive equipment maintenance, track and trace, cross-sell/up-sell in retail, and more. So let’s look at a specific example implemented for predictive equipment maintenance in oil production.
Using TIBCO Spotfire, this Fast Data company finds patterns in historical data in their data warehouse and predicts pressure and electrical current thresholds that will likely lead to oil well equipment failure. Downtime being the last thing the company wants to experience, this predictive model plays a critical role. It is injected in streaming analytics, a key capability TIBCO Live Datamart provides, and implemented against new live events to quickly and seamlessly detect these thresholds being crossed. When such risk is identified in real time, the operations staff gets notified and takes immediate action to prevent pump failures from occurring.
You see how companies in a capital-intensive industry can reduce cost associated with downtime significantly by combining a data warehouse with BI analytics tools and a live data mart; the ROI of adopting this approach can be phenomenal. And, as mentioned earlier, the use cases are extensive.
We invite you to watch Kai’s 20-minute webinar to see TIBCO Spotfire and TIBCO Live Datamart in action and understand how they extract more value from data in your traditional data warehouse. We hope it will inspire you to take your operations to the next level.