{"id":691,"date":"2020-03-26T07:36:00","date_gmt":"2020-03-26T07:36:00","guid":{"rendered":"https:\/\/testing02.sagetech.com.hk\/?page_id=691"},"modified":"2025-07-22T07:35:35","modified_gmt":"2025-07-22T07:35:35","slug":"data-modeling","status":"publish","type":"page","link":"https:\/\/testing02.sagetech.com.hk\/?page_id=691","title":{"rendered":"Data Modeling"},"content":{"rendered":"\n<div class=\"wp-block-media-text alignwide is-vertically-aligned-top\" style=\"grid-template-columns:42% auto\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"390\" height=\"400\" src=\"https:\/\/testing02.sagetech.com.hk\/wp-content\/uploads\/2020\/03\/4_data-modeling_2.jpg\" alt=\"\" class=\"wp-image-753 size-full\" srcset=\"https:\/\/testing02.sagetech.com.hk\/wp-content\/uploads\/2020\/03\/4_data-modeling_2.jpg 390w, https:\/\/testing02.sagetech.com.hk\/wp-content\/uploads\/2020\/03\/4_data-modeling_2-293x300.jpg 293w, https:\/\/testing02.sagetech.com.hk\/wp-content\/uploads\/2020\/03\/4_data-modeling_2-244x250.jpg 244w\" sizes=\"auto, (max-width: 390px) 100vw, 390px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<h2 class=\"wp-block-heading has-light-green-cyan-color has-text-color\">DATA MODELING<\/h2>\n\n\n\n<p>Data Modeling is the process of creating a data model for storing data in a database. Data model is used to visual representation of data regulatory compliances and to enforce business rules \/ regulatory compliances \/ government policies on the data. It can also ensure the quality of the data with consistence in naming conventions, default values, semantics and security.<br><br><\/p>\n\n\n\n<p><strong>Purposes for Different Data Modeling<\/strong><\/p>\n\n\n\n<p>It is vital to define the purpose of the data model to start data modeling. There are two types of data models: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Relational Data Modeling<\/strong><br>&#8211; Design for building transactional and operational systems<br>&#8211; Designed to get data into database that maintains integrity and stores every piece of non-key data only once <br><br><\/li>\n\n\n\n<li><strong>Dimensional Data Modeling<\/strong><br>&#8211; Design for building reporting and analytical systems<br>&#8211; Designed to get data into data warehouse and into the hands of business users <br>&#8211; Easy to query across many different tables<br><br><\/li>\n<\/ol>\n\n\n\n<p>Data modeling is the process of creating a data model. It occurs at the following levels:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Physical Model <\/strong><br>&#8211; Scheme \/ framework for how data stored in a database<br><br><\/li>\n\n\n\n<li> <strong>Conceptual Model <\/strong><br>&#8211; High-level \/ user view of data<br><br><\/li>\n\n\n\n<li><strong>Logical Data Model <\/strong><br>&#8211; Middle level: between the physical and conceptual levels <br>&#8211; Separate the logical representation of data and its physical storage<\/li>\n<\/ul>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-691","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages\/691","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=691"}],"version-history":[{"count":6,"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages\/691\/revisions"}],"predecessor-version":[{"id":1226,"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages\/691\/revisions\/1226"}],"wp:attachment":[{"href":"https:\/\/testing02.sagetech.com.hk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}