Data Warehouse vs. Live Datamart - Comparison and Differences

Data Warehouses have existed for many years in almost every company. While they are still as good and relevant for the same use cases as they were 20 years ago, they cannot solve new, existing challenges and those sure to come in a ever-changing digital world. The upcoming sections will clarify when to still use a Data Warehouse and when to use a modern Live Datamart instead.

Transcript

1. Difference between a Data Warehouse and a Live Datamart Kai Wähner kwaehner@tibco.com @KaiWaehner www.kai-waehner.de LinkedIn / Xing à Please connect!
2. Key Messages –  A Data Warehouse is used for analysis and reporting of historical data! –  A Live Datamart is used to manage operations in real time! –  A Live Datamart combines automated streaming analytics and proactive human interaction
3. © Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice
4. © Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice
5. Data Warehouse http://www.exforsys.com/tutorials/msas/data-warehouse-database-and-oltp-database.html … used for storing historical data.
6. Business Intelligence = Reporting + Statistics + Data Discovery
7. Live Demo Reporting and Analytics with TIBCO Spotfire
8. © Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice
9. Live Datamart Live Datamart Continuous Query Processor Alerts   BusinessEvents   FTL   EMS   Ac4veSpaces   BusinessWorks   Social  Media  Data   Market  Data   Sensor  Data   Historical   Data   Ac4veSpaces  Datagrid Enterprise   data   Market Data IoT Mobile Social Live UI Command & Control ACTION   Con4nuous  Query   … used for operations in real time.
10. Live Demo Operations in Real Time with TIBCO Live Datamart
11. © Copyright 2000-2015 TIBCO Software Inc. Agenda What is a Data Warehouse? What is a Live Datamart? Spoilt for Choice
12. © Copyright 2000-2015 TIBCO Software Inc. Spoilt for Choice Data Warehouse Live Datamart Historical Data 1) Reporting 2) Data Discovery to find Patterns 3) Optional: Analyze using Statistics Real Time Data (and historical data integrated) 4) Operations 5) Optional: Apply Statistics
13. Key Messages •  A Data Warehouse is used for analysis and reporting of historical data! •  A Live Datamart is used to manage operations in real time! •  A Live Datamart combines automated streaming analytics and proactive human interaction
14. Please contact me! Kai Wähner kwaehner@tibco.com @KaiWaehner www.kai-waehner.de LinkedIn / Xing à Please connect! Questions?