A database system includes a data input sub-system including a first computing device cluster including a first plurality of computing devices including pluralities of loader computing nodes. A set of loader computing nodes of the pluralities of loader computing nodes is operable to receive a dataset. The dataset includes rows of columnar data and when a page amount of rows of columnar data is received, the set of loader computing nodes is operable to convert the page amount of rows of columnar data into a column-oriented page segment; and provide the column-oriented page segment to a set of store and compute computing nodes of pluralities of store and compute computing nodes of a store and compute sub-system, for storage therein. The column-oriented page segment is accessible via a column-based block input/output (IO) read process for query processing and long-term storage (LTS) segment generation.