database partitioning


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial.

database partitioning

Splitting large databases into separate entities for faster retrieval.

Horizontal Partitioning and Sharding
Horizontal partitioning separates rows by key fields; for example, all Arizona records are maintained in one index and New Mexico records in another, etc., or account numbers from 00001 to 49999 in one, and 50000 to 99999 in another.

If each horizontal partition is stored on a separate server, the partition is called a "shard," and the process is "sharding." Databases that provide automatic sharding determine how to divide the database into chunks based on ranges of values as in the above examples or by computing hash values of the keys. The latter creates a more uniform distribution of the data.

Vertical Partitioning
Also known as "row splitting," vertical partitioning separates columns. For example, widely used columns are stored in one database, while columns that are accessed infrequently are stored in another.

Master/Slave Partitioning
This simple method is used when viewing updates in real time is not critical. The master server is used for all updating of the database (writing), and one or more slave servers are used as copies for reading. Periodically, the updates on the master are copied to the slaves. See shared nothing.
References in periodicals archive ?
Cheng, C-H; Lee, W-K; Wong, K-F, "A Genetic Algorithm-Based Clustering Approach for Database Partitioning," IEEE Transactions on Systems, Man, and Cybernetics, 32(3), 2002, 215-230.
It offers reliable management of data, the ability to handle large transaction loads, database partitioning, DVR integration, and LAN/WAN compatibility.
In addition, DB2 Viper will be the first data server to support all three common methods of database partitioning at the same time, that is range partitioning, multi-dimensional clustering and hashing, the company claims.
New features, such as database partitioning, help operators separate their systems so that partners or customers can access their respective databases securely," says Manji Matharu, SOTAS CTO and senior vice president of engineering.

Full browser ?