OceanBase Database supports normal and partitioned tables.
In OceanBase Database, partitioning refers to decomposing a table or an index into multiple smaller parts based on specific rules to simplify management. Each partition is a separate object with a unique name and optional storage characteristics.
A partitioned table consists of one or more partitions that are separately managed and can operate independently of each other. Tables can be classified into partitioned and non-partitioned tables. A partitioned table is different from a non-partitioned table even if the partitioned table consists of only one partition. You cannot add partitions to a non-partitioned table.
OceanBase Database stores data of each partition in its SSTable. Each SSTable contains part of the data in the table.
OceanBase Database provides multiple partitioning strategies to meet different business requirements. Partitions are transparent to applications. Therefore, you can apply partitions to most applications without extensive modifications.