Saturday, April 23, 2016

Database partitioning memo

Database Partitioning
 1. Range partitioning
      example C0 {0001 ... 9999}
 2. List  partitioning
 3. Hash partitioning (membership)
 4. Composite partitioning
    combinations of {1..3}


 5. Horizontal partitioning
    split by rows
 6. Vertical partitioning
    split by columns             



Bibliography
https://en.wikipedia.org/wiki/Partition_%28database%29 
http://dev.mysql.com/doc/refman/5.5/en/partitioning.html

No comments:

Post a Comment