Systems and methods for optimized cloud database query execution

A method for fetching data from a cloud-based database for optimized cloud-based database query execution, comprising:

• receiving, by a table reader computer program executed by a local electronic device, a data query request from a user for data that is stored in cloud storage, the data query request comprising a row filtering expression and the cloud storage comprises table data having a plurality of datapages;
• retrieving, by the table reader computer program, a footer for table data associated with the data stored in cloud storage;
• identifying, by the table reader computer program, one of the plurality of datapages comprising data responsive to the row filtering expression based on the footer;
• retrieving, by the table reader computer program, the identified datapage from cloud storage;
• assembling, by the table reader computer program, matching rows from the datapage;
• and
• returning, by the table reader computer program, the assembled matching rows to the local electronic device.

A non-transitory computer readable storage medium, including instructions stored thereon, which when read and executed by one or more computer processors, cause the one or more computer processors to perform steps comprising:

• receiving table data comprising a plurality of rows and a plurality of columns, a schema for the table data, and a primary-key for the table data;
• creating a footer for the table data, the footer comprising the schema and the primary-key;
• sorting the rows of the table data using the primary-key;
• dividing columns of the sorted rows of the table data into a plurality of datapages based on a datapage size;
• identifying sparse indices for each datapage, wherein the sparse indices comprise a minimum value, a maximum value, a starting row index, an ending row index for each datapage;
• writing each datapage to cloud storage;
• inserting the sparse indices into the footer for the table data;
• and
• writing the footer to cloud storage.