Reading both pages and segments via applying a columnar-formatted structuring-based read process

Abstract

A database system is operable to generating a plurality of pages from a plurality of rows, where each page of the plurality of pages is generated to include a corresponding set of rows of the plurality of rows in accordance with a columnar-formatted structuring based on generating a plurality of columns from the corresponding set of rows. A query is executed based on reading a first set of column values for a first plurality of rows based on applying a columnar-formatted structuring-based read process and reading a second set of column values for a second plurality of rows based on applying the columnar-formatted structuring-based read process. At least one page conversion process is performed to generate an additional plurality of segments based on reading all column values for the plurality of rows based on applying the columnar-formatted structuring-based read process.