{"id":375,"date":"2020-04-29T03:11:45","date_gmt":"2020-04-29T03:11:45","guid":{"rendered":"https:\/\/sagetech.com.hk\/?page_id=375"},"modified":"2025-07-23T10:41:30","modified_gmt":"2025-07-23T10:41:30","slug":"data-modeling-2","status":"publish","type":"page","link":"https:\/\/sagetech.com.hk\/?page_id=375","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 decoding=\"async\" src=\"https:\/\/testing02.sagetech.com.hk\/wp-content\/uploads\/2020\/03\/4_data-modeling_2.jpg\" alt=\"\" class=\"wp-image-753\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<h2 class=\"has-light-green-cyan-color has-text-color wp-block-heading\">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\"><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><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><\/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\"><li><strong>Physical Model <\/strong><br>&#8211; Scheme \/ framework for how data stored in a database<br><br><\/li><li> <strong>Conceptual Model <\/strong><br>&#8211; High-level \/ user view of data<br><br><\/li><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><\/ul>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>DATA MODELING 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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-375","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages\/375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=375"}],"version-history":[{"count":2,"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages\/375\/revisions"}],"predecessor-version":[{"id":494,"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=\/wp\/v2\/pages\/375\/revisions\/494"}],"wp:attachment":[{"href":"https:\/\/sagetech.com.hk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}