Innovation event 20131030
Download as PPTX, PDF
0 likes469 views
Presenting manners and a methodology to enable the development of standard ways for maintaining data warehouse solutions
Innovation event 20131030
- 2. Maintaining data warehouses using hot technologies Rien Matthijsse
- 4. Introductie Maintaining ( data warehouses using hot technologies ) ( Maintaining data warehouses ) using hot technologies
- 5. Hot technologies Maintaining ( data warehouses using hot technologies )
- 8. Hot technologies The holy Grail Houston, weve got it !! Source: Next generation DWH modeling, BI podium, 2013-06-06
- 10. Hot technologies
- 11. Hot technologies
- 12. Hot technologies Het moet wel beheerd (kunnen) worden.
- 13. DWH management
- 14. DWH management
- 29. DWH management In hi谷rarchie plaatsen Level 4 proces Level 3 proces proces proces Level 2 proces proces proces Level 1 proces proces proces Proces afhankelijkheden proces
- 30. DWH management Als Datavault Sats proces Links proces proces proces proces proces Hubs proces proces Refs proces proces proces proces Proces afhankelijkheden
- 32. DWH management SI.BRON.RDY ? BRON SI.BRON.DONE ? SV.BRON.DONE ? BV.BRON.DONE ? Refs Refs Lvl 1 Hubs Hubs Hubs Lvl 2 Links Links Links Lvl 3 Sats Sats Sats STAGEIN SI.BRON.DONE Refs SV BV SV.BRON.DONE BV.BRON.DONE Pres PRES.BRON.DONE
- 33. DWH management Spoorboekje SV.BRONA.DONE & SV.BRONB.DONE SI.BRONA.DONE SI.BRONA.RDY Bron A Bron B Bron C Bron N STAGEIN SV BV PRES
- 36. DWH management Syntax Sematics Logic Uitdaging: veranderingen door de tijd
- 37. DWH management Focus: Data verwerkbaar in DWH
- 38. DWH management Prepare Valideer Ok Yes proces Exit No VAL.SV.BNK.USR Resultaat Validatie Engine VAL.SV.BNK.USR: Tabel = Users Centrale repository 1) 2) 3) 4) Veld a must_be: m, v Veld b may_not_be null Veld c must_be 1-n reference to #rows must_be within 10% of prev #rows 5)
- 42. DWH management En: Process characteristics Restartable Standard logging Messaging Escalation Suspension of execution wait for milestone
- 45. Hot technology ( Maintaining data warehouses ) using hot technologies
- 50. iWHAT
- 51. iWHAT
- 52. iWHAT
- 53. iWHAT
- 54. iWHAT
- 55. iWHAT
- 57. Dank voor u belangstelling Rien Matthijsse