{"id":30342,"date":"2023-11-14T15:34:16","date_gmt":"2023-11-14T14:34:16","guid":{"rendered":"https:\/\/rat-haus.com\/intelligent-data-management\/"},"modified":"2024-10-09T22:28:35","modified_gmt":"2024-10-09T20:28:35","slug":"intelligent-data-management","status":"publish","type":"page","link":"https:\/\/rat-haus.com\/en\/intelligent-data-management\/","title":{"rendered":"Intelligent data management"},"content":{"rendered":"<div class=\"gb-container gb-container-203b088c\">\n<div class=\"gb-container gb-container-bb2ee0c1\">\n<div class=\"gb-container gb-container-dc7e467d rh-col-2thirds\">\n\n<h2 id='here-you-can-find-out-about'  id=\"boomdevs_1\" class=\"gb-headline gb-headline-b8db8ba5 gb-headline-text\">Here you can find out about &#8230;<\/h2>\n\n<\/div>\n\n<div class=\"gb-container gb-container-c78ebb30 rh-col-1third\">\n<div class=\"gb-container gb-container-725f61bb rh-col-1third\">\n\n<h1 id='intelligent-data-management'  id=\"boomdevs_2\" class=\"gb-headline gb-headline-111a1878 gb-headline-text\">Intelligent data management<\/h1>\n\n\n        \n            \n            <div class=\"fit_content\">\n                <div class=\"bd_toc_container\" data-fixedWidth=\"\">\n                    <div class=\"bd_toc_wrapper\" data-wrapperPadding=\"48px\">\n                        <div class=\"bd_toc_wrapper_item\">\n                            <div class=\"bd_toc_header active\" data-headerPadding=\"2px\">\n                                <div class=\"bd_toc_header_title\">\n                                    Inhalt                                <\/div>\n                                <div class=\"bd_toc_switcher_hide_show_icon\">\n                                    <span class=\"bd_toc_arrow\"><\/span>                                <\/div>\n                            <\/div>\n                            <div class=\"bd_toc_content list-type-number\">\n                                <div class=\"bd_toc_content_list \">\n                                    <div class='bd_toc_content_list_item'><ul>\n  <li class=\"first\">\n    <span><\/span>\n    <ul class=\"menu_level_1\">\n      <li class=\"first last\">\n        <a href=\"#here-you-can-find-out-about\">Here you can find out about &#8230;<\/a>\n      <\/li>\n    <\/ul>\n  <\/li>\n  <li class=\"last\">\n    <a href=\"#intelligent-data-management\">Intelligent data management<\/a>\n    <ul class=\"menu_level_1\">\n      <li class=\"first\">\n        <a href=\"#a-good-data-warehouse-structure-is-timeless-sustainable-and-highly-adaptable\">A good data warehouse structure is timeless, sustainable and highly adaptable<\/a>\n      <\/li>\n      <li>\n        <a href=\"#problem-child-or-challenge-of-data-governance-quite-simply-quite-logically\">Problem child or &quot;challenge&quot; of data governance &#8211; quite simply, quite logically<\/a>\n      <\/li>\n      <li>\n        <a href=\"#as-few-brakes-as-possible-dsgvo-gdpr-secure-implementation-in-the-data-warehouse\">As few brakes as possible: DSGVO \/ GDPR secure implementation in the data warehouse<\/a>\n      <\/li>\n      <li class=\"last\">\n        <a href=\"#how-do-we-easily-find-the-correct-and-complete-data\">How do we easily find the correct and complete data?<\/a>\n      <\/li>\n    <\/ul>\n  <\/li>\n<\/ul>\n<\/div>                                <\/div>\n                            <\/div>\n                        <\/div>\n                    <\/div>\n                    <div class=\"layout_toggle_button\">\n                        <span class=\"bd_toc_arrow\"><\/span>\n                    <\/div>\n                <\/div>\n            <\/div>\n\n    \n<\/div>\n<\/div>\n\n<div class=\"gb-container gb-container-de23b4e7 rh-col-2thirds\">\n\n<ul class=\"wp-block-list mw-list-home\">\n<li>Data warehouse structure &#8211; <strong>timeless<\/strong>, <strong>sustainable<\/strong>, highly <strong>adaptable<\/strong><\/li>\n\n\n\n<li>Data governance &#8211; very <strong>simple<\/strong>, very <strong>logical<\/strong><\/li>\n\n\n\n<li>DSGVO \/ GDPR <strong>secure<\/strong> implementation in the data warehouse<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">also:<\/p>\n\n\n\n<ul class=\"wp-block-list mw-list-home\">\n<li>How do we easily find the correct and complete data?<\/li>\n\n\n\n<li>How can we become faster with our data?<\/li>\n\n\n\n<li class=\"mw-list-home\">Why is everyone talking about &#8220;metadata&#8221;?<\/li>\n<\/ul>\n\n<\/div>\n\n<div class=\"gb-container gb-container-585b0f45 rh-col-1third\">\n\n<a class=\"gb-button gb-button-273e75fb\" href=\"https:\/\/rat-haus.com\/intelligentes-datenmanagement-angebote\/\"><span class=\"gb-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" role=\"img\" height=\"1em\" width=\"1em\" viewbox=\"0 0 576 512\"><path fill=\"currentColor\" d=\"M576 240c0-23.63-12.95-44.04-32-55.12V32.01C544 23.26 537.02 0 512 0c-7.12 0-14.19 2.38-19.98 7.02l-85.03 68.03C364.28 109.19 310.66 128 256 128H64c-35.35 0-64 28.65-64 64v96c0 35.35 28.65 64 64 64h33.7c-1.39 10.48-2.18 21.14-2.18 32 0 39.77 9.26 77.35 25.56 110.94 5.19 10.69 16.52 17.06 28.4 17.06h74.28c26.05 0 41.69-29.84 25.9-50.56-16.4-21.52-26.15-48.36-26.15-77.44 0-11.11 1.62-21.79 4.41-32H256c54.66 0 108.28 18.81 150.98 52.95l85.03 68.03a32.023 32.023 0 0 0 19.98 7.02c24.92 0 32-22.78 32-32V295.13C563.05 284.04 576 263.63 576 240zm-96 141.42l-33.05-26.44C392.95 311.78 325.12 288 256 288v-96c69.12 0 136.95-23.78 190.95-66.98L480 98.58v282.84z\"><\/path><\/svg><\/span><span class=\"gb-button-text\">Offers<\/span><\/a>\n\n<\/div>\n<\/div>\n\n<div class=\"gb-container gb-container-ba7b7139 rh-col-1third\"><\/div>\n\n<div class=\"gb-container gb-container-f165a2f7 rh-col-2thirds\">\n\n<h2 id='a-good-data-warehouse-structure-is-timeless-sustainable-and-highly-adaptable'  id=\"boomdevs_3\" class=\"gb-headline gb-headline-5bd37a40 gb-headline-text\">A good data warehouse structure is <strong>timeless<\/strong>, <strong>sustainable<\/strong> and highly <strong>adaptable<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Technology changes, systems change, business models change. A good data warehouse adapts flexibly to these changes and continues to fulfill two important characteristics: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Historization &#8211; within the changing environment, the DWH ensures that the historicized deliveries fit together seamlessly<\/li>\n\n\n\n<li>Integration &#8211; the company is (hopefully) not structured according to operational systems and data sources but is based on a business model with business objects, transactions, hierarchies and relationships that are brought together from the various sources.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Intelligent data management fulfills these characteristics regardless of the source systems and data platforms used.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Note: Data Vault 2.0 as a methodology for intelligent data management provides concepts that can be used in virtualized or materialized form, which are open for structured (RDBMS tables), semi-structured (XML, JSON, Avro, &#8230;) or unstructured (texts, photos, videos, &#8230;) data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A common misconception is that data needs to be converted and stored multiple times. The Data Vault 2.0 methodology is open in this respect, which makes it timeless. <\/p>\n\n<\/div>\n\n<div class=\"gb-container gb-container-fe00bf9e rh-col-2thirds\">\n\n<h2 id='problem-child-or-challenge-of-data-governance-quite-simply-quite-logically'  id=\"boomdevs_4\" class=\"gb-headline gb-headline-81709bab gb-headline-text\">Problem child or &#8220;challenge&#8221; of data governance &#8211; quite <strong>simply<\/strong>, quite <strong>logically<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the past, data governance was often a problem child because governance structures (responsibility for a data object such as &#8220;customer&#8221;, &#8220;product&#8221;, &#8220;order&#8221;, &#8220;production&#8221;) differed greatly from data structures in the source system and in the data warehouse. Data Vault 2.0 organizes the data in the data warehouse in exactly the same way as data governance (tools). Data Vault 2.0 is easy to automate and there are now many good tools for this. For every budget, level of automation and depth of automation. Automation implicitly automates the lineage from the source to the report, the connection from the data vault to the (conceptual) governance model is almost 1:1. If you focus on these principles, efficient governance is easily possible.     <\/p>\n\n<\/div>\n\n<div class=\"gb-container gb-container-675a7d26 rh-col-1third\"><\/div>\n\n<div class=\"gb-container gb-container-2bffcf62 rh-col-1third\">\n\n<figure class=\"gb-block-image gb-block-image-b8132a83\"><img loading=\"lazy\" decoding=\"async\" width=\"810\" height=\"540\" class=\"gb-image gb-image-b8132a83\" src=\"https:\/\/rat-haus.com\/wp-content\/uploads\/\/GDPR.svg\" alt=\"\" title=\"GDPR\"><\/figure>\n\n<\/div>\n\n<div class=\"gb-container gb-container-454b69da rh-col-2thirds\">\n\n<h2 id='as-few-brakes-as-possible-dsgvo-gdpr-secure-implementation-in-the-data-warehouse'  id=\"boomdevs_5\" class=\"gb-headline gb-headline-10b5c632 gb-headline-text\">As few brakes as possible: DSGVO \/ GDPR <strong>secure<\/strong> implementation in the data warehouse<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">DSGVO \/ GDPR is a topic that is still weighing heavily on the minds of many companies. If it seems to have been tackled and dealt with well on the operational side, there are completely new challenges in the data warehouse. The long-running historization, combined with schema evolution and perhaps a lot of data that does not come from operational source systems, all want and need to be taken into account. This applies to the data warehouse as well as the lake or the PSA (Persistent Staging Area).   <\/p>\n\n<\/div>\n\n<div class=\"gb-container gb-container-42c7ad9e rh-content-container rh-col-2thirds\">\n\n<h2 id='how-do-we-easily-find-the-correct-and-complete-data'  id=\"boomdevs_6\" class=\"gb-headline gb-headline-eeb43ebe gb-headline-text\">How do we easily find the correct and complete data?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You have many sources of data in your company. Nowadays, you also have a lot of structured, digital data. Your applications are often based on databases, whether in your data center (&#8220;on-prem&#8221;) or in the cloud.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These applications help you in your day-to-day business and support your processes, such as finance, ordering and order processing, time recording, document management and much more. The disadvantage of these applications: They deal with the here and now, historical changes to data are typically not saved. Only with this &#8220;historization&#8221; can you answer some important questions, such as  <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>What was the customer&#8217;s previous address?<\/li>\n\n\n\n<li>How many and which changes are first recorded in quotations before an order is placed?<\/li>\n\n\n\n<li>etc.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">For this type of historization, the data is extracted from the application databases and placed in a data pool. Until a few years ago, this was the data warehouse, then the data lake was added. <\/p>\n\n<\/div>\n\n<div class=\"gb-container gb-container-53320781 rh-content-container rh-col-1third\">\n\n<figure class=\"gb-block-image gb-block-image-3885e904\"><img loading=\"lazy\" decoding=\"async\" width=\"353\" height=\"502\" class=\"gb-image gb-image-3885e904 rh-img-vn-home rh-col-1third\" src=\"https:\/\/rat-haus.com\/wp-content\/uploads\/DV2_opener.png\" alt=\"Data management  \" title=\"Architecture overview data management\" srcset=\"https:\/\/rat-haus.com\/wp-content\/uploads\/DV2_opener.png 353w, https:\/\/rat-haus.com\/wp-content\/uploads\/DV2_opener-211x300.png 211w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/figure>\n\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Here you can find out about &#8230; Intelligent data management also: A good data warehouse structure is timeless, sustainable and highly adaptable Technology changes, systems change, business models change. A good data warehouse adapts flexibly to these changes and continues to fulfill two important characteristics: Intelligent data management fulfills these characteristics regardless of the source &#8230; <a title=\"Intelligent data management\" class=\"read-more\" href=\"https:\/\/rat-haus.com\/en\/intelligent-data-management\/\" aria-label=\"Read more about Intelligent data management\">Weiterlesen &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"pmpro_default_level":"","footnotes":""},"class_list":["post-30342","page","type-page","status-publish","pmpro-has-access"],"acf":[],"_links":{"self":[{"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/pages\/30342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/comments?post=30342"}],"version-history":[{"count":1,"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/pages\/30342\/revisions"}],"predecessor-version":[{"id":30343,"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/pages\/30342\/revisions\/30343"}],"wp:attachment":[{"href":"https:\/\/rat-haus.com\/en\/wp-json\/wp\/v2\/media?parent=30342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}