

{"id":29034,"date":"2020-09-29T07:00:06","date_gmt":"2020-09-29T05:00:06","guid":{"rendered":"https:\/\/blog.scalefree.com\/?p=13442"},"modified":"2026-04-16T11:54:26","modified_gmt":"2026-04-16T09:54:26","slug":"write-backs-in-der-enterprise-data-warehouse-architektur","status":"publish","type":"post","link":"https:\/\/www.scalefree.com\/de\/blog\/architecture\/write-backs-in-the-enterprise-data-warehouse-architecture\/","title":{"rendered":"Write-Backs in der Enterprise Data Warehouse-Architektur"},"content":{"rendered":"<div id=\"fws_69f31c4fbf9a3\"  data-column-margin=\"default\" data-midnight=\"dark\"  class=\"wpb_row vc_row-fluid vc_row\"  style=\"padding-top: 0px; padding-bottom: 0px; \"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\" ><div class=\"row-bg viewport-desktop\"  style=\"\"><\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\">\n\t<div  class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone\"  data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\" >\n\t\t<div class=\"vc_column-inner\" >\n\t\t\t<div class=\"wpb_wrapper\">\n\t\t\t\t\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2>Die Data Vault 2.0-Schichten<\/h2>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"font-weight: 400;\">Dieser Blogartikel behandelt Write-Backs in <a href=\"https:\/\/www.scalefree.com\/consultingterprise-data-warehouse\/\">Enterprise Data Warehouses<\/a> und wie diese von der <a href=\"https:\/\/www.scalefree.com\/consulting\/data-vault-2-0\/#architecture\">Data Vault 2.0 Architektur<\/a> erm\u00f6glicht werden. Viele kennen bereits die dreischichtige Architektur von Data Warehouses, die in <a href=\"https:\/\/www.scalefree.com\/de\/beratung\/data-vault-2-0\/\">Data Vault 2.0<\/a>Anwendung findet. Der Staging-Bereich stellt die erste Schicht dar, der die Rohdaten aus den Quellsystemen enth\u00e4lt. Die Enterprise Data Warehouse-Schicht, die in diesem Fall nach <a href=\"https:\/\/www.scalefree.com\/consulting\/data-vault-2-0\/#modeling\">Data Vault 2.0<\/a> modelliert ist, und die dritte Schicht mit den <a href=\"https:\/\/www.scalefree.com\/scalefree-newsletter\/about-information-marts-in-data-vault-2-0\/\">Information Marts<\/a>, die Informationen in verschiedenen Strukturen (Stern-Schemata, Snowflake-Schemata etc.) bereitstellen.<\/span><\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div><div class=\"img-with-aniamtion-wrap center\" data-max-width=\"100%\" data-max-width-mobile=\"default\" data-shadow=\"none\" data-animation=\"none\" >\n      <div class=\"inner\">\n        <div class=\"hover-wrap\"> \n          <div class=\"hover-wrap-inner\">\n            <img loading=\"lazy\" decoding=\"async\" class=\"img-with-animation skip-lazy nectar-lazy\" data-delay=\"0\" height=\"920\" width=\"1408\" data-animation=\"none\" data-nectar-img-src=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture.png\" src=\"data:image\/svg+xml;charset=utf-8,svgxmlns&#039;httpwww.w3.org2000svg&#039;viewBox&#039;001408920&#039;\" alt=\"Data Vault 2.0-Architektur und Write-Backs\" data-nectar-img-srcset=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture.png 1408w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-300x196.png 300w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-1024x669.png 1024w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-768x502.png 768w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-320x209.png 320w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-640x418.png 640w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-360x235.png 360w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-720x470.png 720w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-1080x706.png 1080w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-800x523.png 800w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-1280x836.png 1280w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-1.-Data-Vault-2.0-Architecture-600x392.png 600w\" sizes=\"auto, (max-width: 1408px) 100vw, 1408px\" \/>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p style=\"text-align: center;\"><em><span style=\"font-weight: 400;\">Abbildung 1. Data Vault 2.0 Architektur<\/span><\/em><\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"font-weight: 400;\">Diese Architektur bietet M\u00f6glichkeiten und Vorteile f\u00fcr Daten-Write-Back. Zwei der M\u00f6glichkeiten sind das R\u00fcckschreiben von Daten in das Enterprise Data Warehouse oder in die <a href=\"https:\/\/www.scalefree.com\/scalefree-newsletter\/satellite-modeling-for-any-structural-changes-in-the-source-system\/\">Quellensysteme<\/a>. Dieser Artikel behandelt den Write-Back in das Enterprise Data Warehouse, w\u00e4hrend ein bald erscheinender Artikel das R\u00fcckschreiben in die Quellsysteme behandeln wird.<\/span><\/p>\n<p><!--more--><div class=\"content-list-wrapper\"><p class=\"content-heading\">In diesem Artikel:<\/p><ul class=\"content-list\"><li><a href=\"#write-backs-in-the-enterprise-data-warehouse-edw\">Write backs in the Enterprise Data Warehouse (EDW)<\/a><li><a href=\"#conclusion\">Fazit<\/a><\/ul><\/div>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2><span style=\"font-weight: 400;\">Write backs in the Enterprise Data Warehouse (EDW)<\/span><\/h2>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"font-weight: 400;\">Die IT-gesteuerte Architektur in Abbildung 1 kann um einen benutzergesteuerten Bereich erweitert werden. Der Write-Back in das Enterprise Data Warehouse bedeutet nicht, dass die Benutzer das Recht haben, die bestehenden IT-gesteuerten Daten darin zu \u00e4ndern. Vielmehr wird ihnen die M\u00f6glichkeit gegeben, Daten aus dem Enterprise Data Warehouse in einen Nutzerbereich zu laden und mit ihnen zu arbeiten, den sie nutzen k\u00f6nnen, f\u00fcr den sie aber auch verantwortlich sind. Insbesondere Power-User oder Data Scientists, die nicht die vollen Data Vault 2.0-Prinzipien kennen m\u00fcssen, k\u00f6nnen schnell eigene L\u00f6sungen erstellen, ohne die Daten im Enterprise Data Warehouse zu ver\u00e4ndern. In diesem Fall k\u00f6nnen Power-User, die ihre eigenen, benutzerdefinierten L\u00f6sungen erstellen, Daten und Informationen in das Enterprise Data Warehouse zur\u00fcckschreiben, indem sie den f\u00fcr diesen Zweck vorgesehenen Nutzerbereich nutzen.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Dieser gesamte Ansatz wird als <\/span><a href=\"https:\/\/www.scalefree.com\/scalefree-newsletter\/how-to-combine-managed-self-service-bi-with-data-vault-2-0\/\"><span style=\"font-weight: 400;\">verwaltetes Self-Service-BI bezeichnet<\/span><\/a><span style=\"font-weight: 400;\">.<\/span> <span style=\"font-weight: 400;\">Es bietet eine verwaltete Umgebung, in der Daten auf kontrollierte und sichere Weise bereitgestellt werden. Power-User und Data Scientists k\u00f6nnen nur die Daten abfragen, die sie aus Sicht der Datensicherheit sehen d\u00fcrfen.<\/span><span style=\"font-weight: 400;\"> Nat\u00fcrlich sind die Nutzerbereiche begrenzt, um Speicher- und CPU-Verbrauchsprobleme zu vermeiden. Dar\u00fcber hinaus ist das EDW \"gemanagt\" - das bedeutet, dass neben der Sicherheit auch andere organisatorische oder regulatorische Richtlinien eingehalten werden: zum Beispiel, dass personenbezogene  Daten gesetzeskonform verarbeitet werden. <\/span><span style=\"font-weight: 400;\">Auf diese Weise k\u00f6nnen benutzerdefinierte L\u00f6sungen f\u00fcr die individuelle Informationsbereitstellung erstellt und wiederverwendet werden. Es kann auch Zeit bei der Einf\u00fchrung neuer Gesch\u00e4ftsregeln sparen, da die L\u00f6sung bereits verf\u00fcgbar und \"in Produktion\" ist.<\/span><\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"img-with-aniamtion-wrap center\" data-max-width=\"100%\" data-max-width-mobile=\"default\" data-shadow=\"none\" data-animation=\"none\" >\n      <div class=\"inner\">\n        <div class=\"hover-wrap\"> \n          <div class=\"hover-wrap-inner\">\n            <img loading=\"lazy\" decoding=\"async\" class=\"img-with-animation skip-lazy nectar-lazy\" data-delay=\"0\" height=\"920\" width=\"1408\" data-animation=\"none\" data-nectar-img-src=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI.png\" src=\"data:image\/svg+xml;charset=utf-8,svgxmlns&#039;httpwww.w3.org2000svg&#039;viewBox&#039;001408920&#039;\" alt=\"Verwaltetes Self-Service-BI und Write-Backs\" data-nectar-img-srcset=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI.png 1408w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-300x196.png 300w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-1024x669.png 1024w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-768x502.png 768w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-320x209.png 320w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-640x418.png 640w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-360x235.png 360w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-720x470.png 720w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-1080x706.png 1080w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-800x523.png 800w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-1280x836.png 1280w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/09\/Figure-2.-Managed-Self-Service-BI-600x392.png 600w\" sizes=\"auto, (max-width: 1408px) 100vw, 1408px\" \/>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p style=\"text-align: center;\"><em><span style=\"font-weight: 400;\">Abbildung 2. Verwaltetes Self-Service-BI<\/span><\/em><\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"font-weight: 400;\">Durch die Nutzung von verwaltetem Self-Service-BI-erhalten sowohl Power-User als auch <a href=\"https:\/\/www.scalefree.com\/de\/beratung\/data-science\/\">Data Scientists<\/a> die M\u00f6glichkeit, die IT-gesteuerten Ressourcen durch ihre eigenen Daten und Berechnungen zu erweitern. <\/span><span style=\"font-weight: 400;\">Die Write-Backs sind zeitlich nicht begrenzt: sie existieren stattdessen bis zur Industrialisierung der L\u00f6sung \u2013 wodurch sie in die IT-gesteuerten Bereiche des EDW \u00fcbertragen werden.<\/span><\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2>Fazit<\/h2>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p>Verwaltetes Self-Service BI erm\u00f6glicht es den Benutzern, ihre eigenen L\u00f6sungen zu erstellen und das Unternehmen zu datengest\u00fctzten Entscheidungen zu f\u00fchren. Der Prozess wird durch datenbasierte Fakten unterst\u00fctzt und spart Zeit und Geld. Die Verwendung von Write-Back in Data Vault 2.0 ist ein Schl\u00fcsselfaktor, der es Ihnen und Ihrer Organisation erm\u00f6glicht, proaktiv und effizienter zu handeln.<\/p>\n\t<\/div>\n<\/div>\n\n\n\n\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>This architecture provides possibilities and benefits for data write backs. Two possibilities are writing back data into the enterprise data warehouse and into the source systems. This issue covers the&#8230;<\/p>","protected":false},"author":2,"featured_media":29592,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100],"tags":[588,355,890,327,887,893,894,425,896,328,892,337,891,356,895,888,889],"class_list":{"0":"post-29034","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-architecture","8":"tag-business-rules","9":"tag-data-scientists","10":"tag-data-security","11":"tag-data-vault-2-0","12":"tag-data-warehouses","13":"tag-data-driven-decisions","14":"tag-efficiency","15":"tag-enterprise-data-warehouse","16":"tag-facts-based","17":"tag-information-marts","18":"tag-it-driven-architecture","19":"tag-managed-self-service-bi","20":"tag-personal-data","21":"tag-power-users","22":"tag-time-saving","23":"tag-user-driven-area","24":"tag-write-back"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts\/29034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/comments?post=29034"}],"version-history":[{"count":0,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts\/29034\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/media\/29592"}],"wp:attachment":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/media?parent=29034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/categories?post=29034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/tags?post=29034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}