Patent ID: 11886407
Assignee: SINGLESTORE, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 7:
8. A database system comprising a database having data stored in a columnstore, a processor and memory comprising processor readable instructions which when executed on the processor cause the processor to:
identify a row in a segment of the columnstore, the row having a first entry in a first column of the segment containing data matching a value of a parameter of a query and the row having other entries in different one or more columns of the segment, respectively;
for each entry of the row in a column of the different one or more columns that corresponds to the query:
determining an offset within the respective column based on a location of the row in the segment; and
retrieving, from the respective column and based on the respective offset, data of the entry;

move, for each said entry, the retrieved data to a rowstore;
manipulate the retrieved data of at least one entry of the identified row in the rowstore based upon an update request;
activate an access lock on an identifier of the row whilst the retrieved data of the at least one entry is manipulated in the rowstore, whereby rows other than the row for which the access lock has been activated are available for access such that other concurrent queries are allowed to access the segment of the columnstore from which the row was moved;
release the access lock after the manipulating is completed; and
in response to the manipulation, update a status of the row to indicate that updates to the retrieved data of the row are located in the rowstore.