locked
Normalization vs De-Normalization RRS feed

  • Question

  • Hello,
    Is this statement correct?

    "De-normalising the table is another way to describe breaking out a single table into multiple tables to create a model ?"

    Thank you

    Thursday, August 13, 2020 6:56 AM

Answers

  • Hi arkiboys,

    By normalizing a database, you arrange the data into tables and columns. You ensure that each table contains only related data. If data is not directly related, you create a new table for that data. 

    Denormalization is the process where data from multiple tables are combined into a single table, so that data retrieval will be faster.

    Please refer more details from below link and check whether it is helpful to you. Thanks.

    Normalization Vs Denormalization In SQL: 9 Major Differences (With Advantages & Disadvantages)

    Best regards

    Melissa


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    • Marked as answer by arkiboys Thursday, August 13, 2020 9:38 AM
    Thursday, August 13, 2020 8:22 AM

All replies

  • In short: No.

    It's not entirely wrong, cause you can denormalize a table by doing this.

    But this description is much more what you do when you normalize a table. Thus apply the normal forms other then 1NF.

    Thursday, August 13, 2020 7:53 AM
  • Hi arkiboys,

    By normalizing a database, you arrange the data into tables and columns. You ensure that each table contains only related data. If data is not directly related, you create a new table for that data. 

    Denormalization is the process where data from multiple tables are combined into a single table, so that data retrieval will be faster.

    Please refer more details from below link and check whether it is helpful to you. Thanks.

    Normalization Vs Denormalization In SQL: 9 Major Differences (With Advantages & Disadvantages)

    Best regards

    Melissa


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    • Marked as answer by arkiboys Thursday, August 13, 2020 9:38 AM
    Thursday, August 13, 2020 8:22 AM
  • Denormalization is the process where data from multiple tables are combined into a single table, so that data retrieval will be faster.

    Strictly speaking: Not really.

    It is an example for denormalization and in the real-life the most common form of it.

    But in its core it's taking a normalized model and changing it without requirements. Thus taking a single, normalized table and storing it in a different form or using more tables, e.g. an EAV model or falsely moving repeating group lookalikes to separate tables.

    Thursday, August 13, 2020 8:51 AM
  • Thank you
    Thursday, August 13, 2020 9:38 AM