Posted on

Steps to create Data Model (via learndatamodeling.com)

Big Data, big data, data modeling, data, data science, data scientist, data management, analysis, data analyzing, technology, tech

Source: learndatamodeling.com

Review of Article

These is general guidance for creating standard data models.  I’m not going to include all the steps as it’s over 24 separate steps, but depending on what your business requires you might not need to have all the steps anyways.  The link to the article is above if you’d like to see the entire list of what you can include.

Steps for Building Logical Data Models

  1. Gather up the business requirements
  2. Analyze business requirements
  3. Select target database – the data modeling tool will build the scripts to create reports
  4. Assign data type to attributes created to find data
  5. When analysis complete create columns to sort data
  6. Build subject areas to add the data
  7. Validate data model
  8. Create reports

Steps for Building Physical Data Models

  1. Get the logical data model and build a physical one from it
  2. Add properties to sort data
  3. Create SQL scripts
  4. Compare the database from the data model
  5. Create change log to document changes that have occurred

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.