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 ?
Applying Genetic Algorithms in Database Partitioning," Proceedings of the 2003 ACM Symposium on Applied Computing (SAC) 2003, pp 544-549.
Running on Ingres Database, the Ingres Icebreaker BI Appliance takes advantage of the advanced BI features that Ingres provides such as database partitioning, parallel query execution, and advanced query optimization techniques.
Database partitioning allows users to administer employee-level access in field offices around the world.
To safeguard sensitive data, Convio RMS employs sophisticated database partitioning, encryption, firewalls and other security measures.

Full browser ?