Daniel Linstedt’s Data Vault 2.0<\/b> places particular emphasis on the flexibility of the data model. Comparable to Inmon’s approach, it differs in that it is divided into a raw vault and a business vault. This flexibility is achieved by dividing the data into three table types:<\/p>\n<\/div>- <\/i><\/span>
Hubs<\/div><\/li>
- <\/i><\/span>
Links<\/div><\/li>
- <\/i><\/span>
Satellites<\/div><\/li><\/ul>
Changes are easier to implement as existing tables do not need to be adapted. Instead, new hubs, satellites and links are added using largely standardized and automated processes.<\/p>\n<\/div><\/div><\/div><\/div><\/div>
All 3 approaches in direct comparison<\/h2><\/div>The different architectural approaches each offer their own advantages and can be used differently depending on the specific requirements and objectives of the company.<\/p>\n<\/div>
![](\"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/DWH_Design_Tabelle.png\" "\\"DWH")
<\/span><\/div><\/div><\/div>Our expertise for your success<\/h2><\/div>With years of experience in all areas of data warehousing, DATA MART Consulting offers you professional and competent advice. Our aim is to guarantee you fast and cost-effective access to relevant data and information. Put your trust in our expertise and let us work together to optimize and consolidate your data strategies.
\nTogether we will turn your data into your company’s most valuable asset.<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":8689,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"100-width.php","meta":{"footnotes":""},"class_list":["post-8988","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\n
Data Warehouse & Data Lakehouse Design - Find out now!<\/title>\n<meta name=\"description\" content=\"Data Warehouse & Data Lakehouse Design. Faster and more cost-effective access to relevant data and new information.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Warehouse & Data Lakehouse Design - Find out now!\" \/>\n<meta property=\"og:description\" content=\"Data Warehouse & Data Lakehouse Design. Faster and more cost-effective access to relevant data and new information.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/\" \/>\n<meta property=\"og:site_name\" content=\"DATA MART Consulting GmbH\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-13T19:16:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/dwh_design_1500x650_final_klein.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"650\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/\",\"url\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/\",\"name\":\"Data Warehouse & Data Lakehouse Design - Find out now!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.datamart.de\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/dwh_design_1500x650_final_klein.jpg\",\"datePublished\":\"2024-08-01T14:50:30+00:00\",\"dateModified\":\"2025-03-13T19:16:18+00:00\",\"description\":\"Data Warehouse & Data Lakehouse Design. Faster and more cost-effective access to relevant data and new information.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.datamart.de\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/dwh_design_1500x650_final_klein.jpg\",\"contentUrl\":\"https:\\\/\\\/www.datamart.de\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/dwh_design_1500x650_final_klein.jpg\",\"width\":1500,\"height\":650,\"caption\":\"Data Warehouse Designs\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/data-warehouse-data-lakehouse-design\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Warehouse & Data Lakehouse Design\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/\",\"name\":\"DATA MART Consulting GmbH\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Warehouse & Data Lakehouse Design - Find out now!","description":"Data Warehouse & Data Lakehouse Design. Faster and more cost-effective access to relevant data and new information.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/","og_locale":"en_US","og_type":"article","og_title":"Data Warehouse & Data Lakehouse Design - Find out now!","og_description":"Data Warehouse & Data Lakehouse Design. Faster and more cost-effective access to relevant data and new information.","og_url":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/","og_site_name":"DATA MART Consulting GmbH","article_modified_time":"2025-03-13T19:16:18+00:00","og_image":[{"width":1500,"height":650,"url":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/dwh_design_1500x650_final_klein.jpg","type":"image\/jpeg"}],"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/","url":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/","name":"Data Warehouse & Data Lakehouse Design - Find out now!","isPartOf":{"@id":"https:\/\/www.datamart.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/#primaryimage"},"image":{"@id":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/dwh_design_1500x650_final_klein.jpg","datePublished":"2024-08-01T14:50:30+00:00","dateModified":"2025-03-13T19:16:18+00:00","description":"Data Warehouse & Data Lakehouse Design. Faster and more cost-effective access to relevant data and new information.","breadcrumb":{"@id":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/#primaryimage","url":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/dwh_design_1500x650_final_klein.jpg","contentUrl":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/dwh_design_1500x650_final_klein.jpg","width":1500,"height":650,"caption":"Data Warehouse Designs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.datamart.de\/en\/data-warehouse-data-lakehouse-design\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.datamart.de\/en\/"},{"@type":"ListItem","position":2,"name":"Data Warehouse & Data Lakehouse Design"}]},{"@type":"WebSite","@id":"https:\/\/www.datamart.de\/en\/#website","url":"https:\/\/www.datamart.de\/en\/","name":"DATA MART Consulting GmbH","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datamart.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages\/8988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/comments?post=8988"}],"version-history":[{"count":4,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages\/8988\/revisions"}],"predecessor-version":[{"id":9849,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages\/8988\/revisions\/9849"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/media\/8689"}],"wp:attachment":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/media?parent=8988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Data](\"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/dwh_design_1500x650_final_klein.jpg\" "\\"Data")
<\/span><\/div><\/div><\/div><\/div><\/div><\/div><\/div>![](\"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/DWH_Design_1_Kimball.png\" "\\"DWH")
<\/span><\/div><\/div><\/div>![](\"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/DWH_Design_2_Inmon.png\" "\\"DWH")
<\/span><\/div><\/div><\/div><\/div><\/div>![](\"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/08\/DWH_Design_3_Data_Vault_2.0-1.png\" "\\"DWH")
<\/span><\/div><\/div><\/div><\/div>