OceanBase Database uses macroblocks to store data. Each table may contain multiple macroblocks. Each macroblock is 2 MB in size. A macroblock contains one or more microblocks, and each microblock stores one or more rows.
Table organization
OceanBase Database uses clustered index tables to organize data. In other words, data is stored in a table in the order of the primary key of the table. When you insert a row into a table, the row is inserted in the order of the primary key of the table.
The same column order applies to all rows in a table. OceanBase Database stores data in a table in the column order that is generated when the table is initially created. New columns are added to the table as the last data columns.
Row storage
Rows are stored in microblocks. In most cases, all columns of a row are stored together. If a table contains large object (LOB) columns, the size of these columns may exceed that of a macroblock. In this case, the extra data spills over to other macroblocks.
Null value storage
OceanBase Database stores null values and uses one byte as a marker to indicate whether the value in a column is null.