Canvas CloudAI
Canvas Cloud AI

Partitioning

advanced
data
Enhanced Content

Definition

Dividing a database table or dataset into smaller, more manageable pieces based on specific criteria like date ranges or geographic regions. Like organizing a large library by splitting books into different rooms based on subject.

Real-World Example

An e-commerce platform partitions its orders table by month, so queries for recent orders only scan the current month's partition instead of billions of historical records.

Cloud Provider Equivalencies

Partitioning is a database/data-lake feature rather than a standalone service. Each cloud offers it through managed databases/warehouses (native table partitioning) and query engines over object storage (partitioned files and partitioned table metadata).

AWS
Amazon Redshift (table partitioning via sort keys/distribution + spectrum partitioned data), Amazon Athena (partitioned tables), Amazon RDS for PostgreSQL (native table partitioning)
AZ
Azure Synapse Analytics (table partitioning), Azure SQL Database (partitioned tables), Azure Data Lake + serverless SQL (partitioned data layouts)
GCP
BigQuery (partitioned tables), Cloud SQL for PostgreSQL (native table partitioning)
OCI
Oracle Autonomous Data Warehouse (table partitioning), Oracle Database on OCI (native table partitioning)

Explore More Cloud Computing Terms