{"id":560,"date":"2015-10-12T11:30:00","date_gmt":"2015-10-12T16:30:00","guid":{"rendered":"https:\/\/blog.felineflock.com\/?p=560"},"modified":"2024-01-01T11:32:31","modified_gmt":"2024-01-01T17:32:31","slug":"data-modeling-insight-from-the-bible","status":"publish","type":"post","link":"https:\/\/blog.felineflock.com\/index.php\/2015\/10\/12\/data-modeling-insight-from-the-bible\/","title":{"rendered":"Data modeling insight from the Bible"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/blog.felineflock.com\/wp-content\/uploads\/2024\/01\/dataModelBible-1024x578.jpeg\" alt=\"\" class=\"wp-image-562\" style=\"width:790px;height:auto\" srcset=\"https:\/\/blog.felineflock.com\/wp-content\/uploads\/2024\/01\/dataModelBible-1024x578.jpeg 1024w, https:\/\/blog.felineflock.com\/wp-content\/uploads\/2024\/01\/dataModelBible-300x169.jpeg 300w, https:\/\/blog.felineflock.com\/wp-content\/uploads\/2024\/01\/dataModelBible-768x433.jpeg 768w, https:\/\/blog.felineflock.com\/wp-content\/uploads\/2024\/01\/dataModelBible.jpeg 1276w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>&#8220;In the beginning, God created the heaven and the earth.&#8221;<\/p>\n<\/blockquote>\n\n\n\n<p>The very first sentence in the Bible lays out all dimensions of information:<br>&#8211; the time: in the beginning<br>&#8211; the person: God<br>&#8211; the action: created<br>&#8211; the location: the heaven (the first reference to a place)<br>&#8211; and the matter&nbsp;produced by the action: the earth<\/p>\n\n\n\n<p>Those correspond to the following questions:  When &#8211; who &#8211; what was done &#8211; where &#8211; what was the target,\u00a0object\u00a0or\u00a0result.<\/p>\n\n\n\n<p>Those are questions we ask when we want to find out what the database should store:  data about who did what, where, when and the object\/target\/product of the action.<\/p>\n\n\n\n<p>When you think more concretely about &#8211; say, a sales application or CRM &#8211; you get the same categories\/dimensions:<br>&#8211; the time: date fields<br>&#8211; the person: a contact<br>&#8211; the action: a sales opportunity, order or a quote<br>&#8211; the location: an account (usually a company or a local branch with specific billing\/shipping addresses)<br>&#8211; the matter: products\/services sold<\/p>\n\n\n\n<p>Each data goes into their own table, except for time, which usually becomes a table when you want to summarize events per period (week, month, quarter, year) in a data warehouse.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;In the beginning, God created the heaven and the earth.&#8221; The very first sentence in the Bible lays out all dimensions of information:&#8211; the time: in the beginning&#8211; the person: God&#8211; the action: created&#8211; the location: the heaven (the first reference to a place)&#8211; and the matter&nbsp;produced by the action: the earth Those correspond to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-560","post","type-post","status-publish","format-standard","hentry","category-blog"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/posts\/560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/comments?post=560"}],"version-history":[{"count":4,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/posts\/560\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/posts\/560\/revisions\/565"}],"wp:attachment":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/media?parent=560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/categories?post=560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/tags?post=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}