{"id":634,"date":"2021-05-04T17:51:44","date_gmt":"2021-05-04T21:51:44","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/?p=634"},"modified":"2021-05-04T17:51:44","modified_gmt":"2021-05-04T21:51:44","slug":"week-6-types-of-data-models-prince-patel","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/2021\/05\/04\/week-6-types-of-data-models-prince-patel\/","title":{"rendered":"Week 6 Types of data models- Prince Patel"},"content":{"rendered":"

Types of data models:<\/p>\n

Conceptual data models.\u00a0<\/strong>They are also referred to as domain models and offer a big-picture view of what the system will contain, how it will be organized, and which business rules are involved. Conceptual models are usually created as part of the process of gathering initial project requirements. Typically, they include entity classes (defining the types of things that are important for the business to represent in the data model), their characteristics and constraints, the relationships between them and relevant security and data integrity requirements. Any notation is typically simple.<\/p>\n

Logical data models<\/strong>. They are less abstract and provide greater detail about the concepts and relationships in the domain under consideration. One of several formal data modeling notation systems is followed. These indicate data attributes, such as data types and their corresponding lengths, and show the relationships among entities. Logical data models don\u2019t specify any technical system requirements. This stage is frequently omitted in agile or\u00a0DevOps\u00a0practices. Logical data models can be useful in highly procedural implementation environments, or for projects that are data-oriented by nature, such as\u00a0data warehouse\u00a0design or reporting system development.<\/div>\n
\u00a0<\/div>\n
Physical data models.\u00a0<\/strong>They\u00a0<\/strong>provide a schema for how the data will be physically stored within a database. As such, they\u2019re the least abstract of all. They offer a finalized design that can be implemented as a\u00a0relational database, including associative tables that illustrate the relationships among entities as well as the primary keys and foreign keys that will be used to maintain those relationships. Physical data models can include database management system (DBMS)-specific properties, including performance tuning.<\/p>\n
\u00a0<\/div>\n<\/div>\n
\u00a0<\/div>\n
Ref- https:\/\/www.ibm.com\/cloud\/learn\/data-modeling<\/div>\n
\u00a0<\/div>\n","protected":false},"excerpt":{"rendered":"

Types of data models: Conceptual data models.\u00a0They are also referred to as domain models and offer a big-picture view of what the system will contain, how it will be organized, and which business rules are involved. Conceptual models are usually created as part of the process of gathering initial project requirements. Typically, they include entity […]<\/p>\n","protected":false},"author":12990,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[663943],"tags":[],"class_list":{"0":"post-634","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-instructor","7":"entry"},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts\/634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/users\/12990"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/comments?post=634"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts\/634\/revisions"}],"predecessor-version":[{"id":635,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/posts\/634\/revisions\/635"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/media?parent=634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/categories?post=634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5203sec001spring2021\/wp-json\/wp\/v2\/tags?post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}