Tuesday, April 12, 2011

What is denormalization and when would you go for it?





As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Explain the different parts that constitute ASP.NET application.

Content, program logic and configuration file constitute an ASP.NET application. Content files Content files include static text, images ...

  • Define your own namespace
    Namespace MyNamespace      Public Class  Class2      End Class End  Namespace Namespace MyNamespace      Public Class  Class1      ...
  • Use Namespace
    Namespace MyApp.Info      Module Main          Sub  Main ()              Dim  objHW  As  New MyApp.Info.Utilities              objHW.Dis...
  • Add two integers together
    Module Tester     Sub  Main ()        Dim  firstNumber, secondNumber  As  String        Dim  number1, number2, sumOfNumbers  As  Intege...