Why Denormalization

Author Topic: Why Denormalization  (Read 5087 times)

Offline Sap SolutionTopic starter

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 3
  • Posts: 144
  • Karma: 0
Why Denormalization
« on: 01-11-2017, 09:49:10 »
Why demoralization techniques are used when we develop a decision support system ?


Offline richardmsmith

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 3
  • Posts: 221
  • Karma: 0
  • Gender: Male
    • Trucking App Solution
Re: Why Denormalization
« Reply #1 on: 07-19-2018, 03:54:51 »
Denormalization is a strategy used on a previously-normalized database to increase performance.
When and Why to Use Denormalization
Maintaining history
Improving query performance
Speeding up reporting
Computing commonly-needed values up front

Offline saravanan28

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 2
  • Posts: 183
  • Karma: 0
Re: Why Denormalization
« Reply #2 on: 04-12-2021, 05:45:24 »
Denormalization is a strategy used on a previously-normalized database to increase performance. The idea behind it is to add redundant data where we think it will help us the most. We can use extra attributes in an existing table, add new tables, or even create instances of existing tables.

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
947 Views
Last post 04-12-2021, 05:41:22
by saravanan28