US 12,436,936 B1
File directory structure and naming convention for storing columnar tables
Austin Lee, Burbank, CA (US); and Vikram Jiandani, Los Angeles, CA (US)
Assigned to Rapid7, Inc., Boston, MA (US)
Filed by Rapid7, Inc., Boston, MA (US)
Filed on Aug. 6, 2024, as Appl. No. 18/795,246.
Application 18/795,246 is a continuation of application No. 17/668,444, filed on Feb. 10, 2022, granted, now 12,079,194.
Int. Cl. G06F 16/23 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2329 (2019.01) [G06F 16/221 (2019.01); G06F 16/2282 (2019.01)] 20 Claims
OG exemplary drawing
 
1. One or more computing systems that implements a columnar database system, configured to:
store a table in a file store, wherein
table data of the table is stored in a plurality column files in a table directory that has a directory name that indicates a table name of the table,
each of the column files are associated with a corresponding column of the table,
each of the column files has a file name that indicates (a) a column name of the corresponding column, (b) a data type of the corresponding column, and (c) a sequence number of the column file that indicates an ordering of column files, and
each of the column files stores metadata about the column file including (a) a last update time of the column file and (b) a number of rows stored in the column file;
receive a client request to update the table, and in response:
determine, based on a specified column name indicated in the client request, one or more column files in the table directory to be updated;
update a column file according to the client request, including to mark an existing chunk of the column file as obsolete and append a new chunk to the column file; and
update the metadata in the column file including the last update time of the column file.