Why Denormalization

Author Topic: Why Denormalization  (Read 5837 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: 220
  • 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)
  • Sr. Member
  • ****
  • Thank You 2
  • Posts: 428
  • 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.

Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 200
  • Karma: 0
    • F1removals.co.uk
Re: Why Denormalization
« Reply #3 on: 07-30-2022, 08:48:14 »
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.

Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 200
  • Karma: 0
    • F1removals.co.uk
Re: Why Denormalization
« Reply #4 on: 08-08-2022, 12:17:55 »
Denormalization is a strategy used on a previously-normalized database to increase performance.


Offline f1dark

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 0
  • Posts: 135
  • Karma: 0
  • Gender: Female
  • F1 Removals is the top removals company in the UK,
    • F1removals.co.uk
Re: Why Denormalization
« Reply #5 on: 08-12-2022, 09:50:18 »
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 dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 200
  • Karma: 0
    • F1removals.co.uk
Re: Why Denormalization
« Reply #6 on: 08-12-2022, 09:55:51 »
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.

 

Related Topics

  Subject / Started by Replies Last post
3 Replies
2141 Views
Last post 09-22-2022, 10:31:19
by dark404