{"id":722,"date":"2018-06-07T03:57:46","date_gmt":"2018-06-07T00:57:46","guid":{"rendered":"http:\/\/kusuaks7\/?p=327"},"modified":"2026-05-22T09:22:45","modified_gmt":"2026-05-22T09:22:45","slug":"data-modeling","status":"publish","type":"post","link":"https:\/\/www.experfy.com\/blog\/bigdata-cloud\/data-modeling\/","title":{"rendered":"Data Modeling"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tReady to learn Data Science? Browse\u00a0Data Science Training and Certification<\/a> courses developed by industry thought leaders and Experfy in Harvard Innovation Lab.<\/em><\/strong>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

What is Data Modeling?<\/strong><\/h3>\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tData Modeling refers to the practice of documenting software and business system design. A Data Model is used to document, define, organize, and show how the data structures within a given database, architecture, application, or platform are connected, stored, accessed, and processed within the given system and between other systems. ~ Wikipedia\n
\u201cAn analysis and design method used to:<\/div>\n
    \n \t
  • Define and analyze data requirements.<\/li>\n \t
  • Define logical and physical structures that support these requirements.\u201d<\/li>\n<\/ul>\n
    And, \u201ca data model is a set of data specifications and related diagrams that reflect data requirements and designs.\u201d\u00a0– DAMA (Data Management Association)<\/div>\n
    <\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t

    Why Data Modeling is required?<\/strong><\/h3>\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\tThere are following benefits of using data modeling to store your business data:\n
      \n \t
    • To Manage Data as a Resource: without a good data model, you can find yourself in the possession of a great deal of data, and with no efficient way \u2013 or no way at all \u2013 to make use of it<\/li>\n \t
    • To Integrate Existing Information Systems: by modeling the data in variety of systems, you can see relationships and redundancies, resolve discrepancies, and integrate disparate systems so they can work together<\/li>\n \t
    • To Design Databases and Repositories: by modeling your data, you can also drive better decisions about data warehousing and repositories<\/li>\n \t
    • Understanding the Business: process of data modeling requires you and your teams to understand detail how the business works in order to define the data that drives it<\/li>\n \t
    • Business Intelligence: using proper modeling and reporting, you can spot business trends, spending patterns, and make predictions that will help your business navigate challenges and opportunities<\/li>\n \t
    • Knowledge Transfer: data modeling is a form of documentation, both for business stakeholders and technical experts<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t

      How to do Data Modeling?<\/strong><\/h3>\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\tLets understand how to model your business data. There are three primary types of data models: conceptual, logical and physical.\n
        \n \t
      • A conceptual data model is a model of the things in the business and the relationships among them.<\/li>\n \t
      • A logical data model is a fully attributed data model that is fully normalized.<\/li>\n \t
      • A physical data model represents the actual structure of a database\u2014 mainly tables and columns.<\/li>\n<\/ul>\nFrom logical data modeling perspective, there are majorly three types of model:\n
          \n \t
        • ER model: entity relationship modeling is done for operational data stores.<\/li>\n \t
        • Star\/Snowflake model: star\/snowflake schema is built for data warehosing puspose.<\/li>\n \t
        • ETL\/ELT model: extract, transform & load model is built to transfer data from one model to another model<\/li>\n<\/ul>\nOthers are:<\/strong>\n
            \n \t
          • Object-relational model: this model is relational but with objects, classes & inheritance properties<\/li>\n \t
          • Generic model: this is generalization of conventional data models<\/li>\n \t
          • Semantic model: this model is the abstraction of real world entities and their relationship<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
            \n\t\t\t\t\t\t
            \n\t\t\t\t\t
            \n\t\t\t
            \n\t\t\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t

            Case Study: Rathi Pizza Inc<\/strong><\/h3><\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
            \n\t\t\t\t\t\t
            \n\t\t\t\t\t
            \n\t\t\t
            \n\t\t\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t\t\t\t\tLets say we need to build data models for our pizza business, what kind of data models do we need to build? First, an operational data model, which will keep track of operational activities of our business, it will be based on ER modeling. A typical operation is a customer visits one of our store and places an order of a pizza and get it. After this, lets say management wants to know how good our business is running, which of our stores are performing good, which requires improvements? Which products are having good sales and which aren’t? Which age-group of customer is preferring what kind of pizza? To answer these questions we need a data warehouse on top of which we can build an analytics platform. The data model that we would use to build this data warehouse would be of star or snowflake model. Now, how would operational data would be transferred to our data warehouse? And both models are different so how our data will transform from ER to star\/snowflake model? ETL or ELT model will take care of this problem.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

            Data Modeling refers to the practice of documenting software and business system design. A Data model is used to document, define, organize, and show how the data structures within a given database, architecture, application, or platform are connected, stored, accessed, and processed within the given system and between other systems.  Data modeling is required to manage data as a resource, integrate existing Information systems, design databases and repositories, and understanding the business. Using proper modeling and reporting, you can spot business trends, spending patterns, and make predictions that will help your business navigate challenges and opportunities.<\/p>\n","protected":false},"author":280,"featured_media":3859,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[187],"tags":[94],"ppma_author":[1811],"class_list":["post-722","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bigdata-cloud","tag-data-science"],"authors":[{"term_id":1811,"user_id":280,"is_guest":0,"slug":"ankit-rathi","display_name":"Ankit Rathi","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","author_category":"","user_url":"","last_name":"Rathi","first_name":"Ankit","job_title":"","description":"Ankit Rathi is Lead Architect at SITA, the leading & innovative IT organization in ATI, delivering end-to-end analytics platforms using Data Science, Big Data & Cloud. He is a Data Science Architect with extensive experience is designing & developing data-intensive technology solutions including data architecture, data science, big data & cloud."}],"_links":{"self":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/users\/280"}],"replies":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/comments?post=722"}],"version-history":[{"count":0,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/722\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media\/3859"}],"wp:attachment":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media?parent=722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/categories?post=722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/tags?post=722"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}