February 10, 2011
Operational Data Warehousing in 25 Tweets
Topic: Operational Data Warehousing
To help educate people about what operational data warehousing (OpDW) is and why they should care, I recently issued a series of 25 tweets via Twitter over a two-week period. Every tweet is a short sound bite drawn from TDWI's recent report on OpDW, which I researched and wrote. Most of the tweets focused on a statistic cited in the report; I like to call these "stat bites." The other tweets are definitions stated in the report.
As a change of pace for TDWI Experts in BI, I'd like to share these tweets with you. I think you'll find them interesting because they are a compact -- yet amazingly comprehensive -- study of OpDW, albeit in Twitter style.
I was tempted to edit the tweets, to spell out arcane acronyms and abbreviations, but I left these alone because I think that almost everyone in TDWI's audience can figure them out. Even so, I cut out hash tags, tiny URLs, and repetitive phrases. I issued the tweets in groups, on related topics. I've added some headings here to show that organization. Otherwise, these are raw tweets.
What is Operational Data Warehousing?
1. Operational Data Warehousing integrates apps for biz operations & biz intelligence, often in real time.
2. Operational Data Warehousing enables time-sensitive biz practices like OpBI, JIT inventory, real time.
3. 51% of survey respondents know what Operational Data Warehousing (OpDW) is but don't have name for it.
4. 43% of survey respondents know what Operational Data Warehousing (OpDW) is but call it by another name.
5. Some respondents call OpDW an ODS (19%), OpBI (15%), Real-Time DW (12%), or Active DW (6%).
Who's using OpDW today?
6. 66% of organizations surveyed practice a form of OpDW today, but only 17% run in real time.
7. Only 3% of surveyed folks said "don't know" if their org does OpDW. This shows high awareness of OpDW.
8. 56% of organizations surveyed are committed to Operational Data Warehousing (OpDW), deployed or in dev.
9. 29% of orgs surveyed are considering OpDW. Only 15% have no plans for it. Hence OpDW usage will grow.
What are the common barriers and benefits for OpDW?
10. Top 3 Barriers to OpDW: cost (44%), lack of sponsorship (31%), and a DW that can't do real time (28%).
11. 46% of survey respondents selected "business decisions and strategies" as top benefit of OpDW.
12. 39% chose "business performance and execution" as the second place benefit of OpDW.
13. In third place among benefits of OpDW, 35% surveyed chose "data freshness or timeliness."
14. 44% of survey respondents chose "cost" as top barrier to Operational Data Warehousing (OpDW).
15. 31% chose "lack of business sponsorship" as the second place barrier to OpDW.
16. In 3rd place among barriers to OpDW, 28% surveyed chose "current DW can't handle data in real time."
What are the common best practices and use cases for OpDW?
17. Real Time Operational Data Warehousing (OpDW) cycle has 4 steps: Recognize event, Capture info about it, Analyze, React.
18. Op apps integrated via OpDW: financials (38%), CRM (36%), call center (31%), ERP (26%), HR (21%), etc.
19. Analytic apps integrated OpDW: OpRptg (55%), OpBI (43%), active DW (37%), customer analysis (33%), etc.
20. Today 86% of data values in a data warehouse are updated daily or less frequently (week, month, year).
21. Only 14% of data values are updated every few hours or sooner. Real-time data is rare, but critical.
22. EDW queries execute in seconds (34%), minutes (38%), hours (12%), etc. Potential for RT query is there.
23. Most EDWs are designed & optimized for latent reports & OLAP, not real-time operational data warehousing (RT OpDW).
24. 58% of EDWs support only rpts & OLAP. 35% support those plus analytics, real time, & other workloads.
25. Where to process RT OpDW workload? 24% in EDW. 22% outside EDW. 23% both. 31% don't know.
For a more detailed discussion of OpDW -- in a traditional publication!
Philip Russom is senior manager of TDWI Research. Philip can be reached at firstname.lastname@example.org .
Copyright 2011. TDWI. All rights reserved.