Okuzeka
Software Engineering vocabulary · Databases and Persistence

Partitioning

Meaning in software engineering, with examples

/pɑːrˈtɪʃənɪŋ/nounAdvanced term

In software engineering, partitioning means: Dividing one large table into smaller pieces, called partitions, by a rule such as date range or region, while it still looks like one table to queries.

In Turkish: bölümleme, partitioning

How it is used

Common types are range, list and hash partitioning. Benefits include partition pruning (queries skip irrelevant partitions) and easy removal of old data by dropping a whole partition instead of deleting millions of rows.

Example sentences

  1. Monthly partitioning lets us drop last year's logs in a second.

  2. Partitioning only helps if your queries filter on the partition key.

Common collocations

  • range partitioning
  • partition key
  • partition pruning
  • drop a partition
  • shardingSplitting one large dataset across several database servers, each holding a different part of the rows, so the system can grow beyond one machine.
  • indexThe position number of an item in an array or list. In most languages counting starts at zero, so the first item has index 0.
  • query tuningThe work of making slow queries faster by studying their execution plans and then adding indexes, rewriting SQL or changing database settings.
  • tableA structure in a relational database that stores data about one kind of thing in rows and columns, for example all customers or all orders.

This word in other fields

The same English word can have a different meaning in another field:

More terms: Databases and Persistence

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: