3

I'm trying to learn something about distributed databases and I stumbled upon the concepts of fragmentation and partitioning. It seems to me as if both do the same thing and produce similar results (deviding a relation horizontally/vertically/both).

So what's the difference between fragmentation and partitioning?

Nick Chammas
  • 14,810
  • 17
  • 76
  • 124
nozzleman
  • 130
  • 1
  • 6

2 Answers2

1

The terminology depends on the RDBMS. In SQL server: Partitioning is a DB feature that can be used to improve performance and/or manageability of your DB.

Fragmentation happens when your rows in the data pages are non-contiguous due to insert/delete operations. Your DB performance will decrease if you have high fragmentation of your data.

StanleyJohns
  • 5,982
  • 2
  • 25
  • 44
-2

look here. Remember partitioning and fragmentation on your local hard disk.

http://de.wikipedia.org/wiki/Skalierbarkeit#Skalierung_hinsichtlich_Datenbankeintr.C3.A4ge_-_Denormalisierung