Method of performing transactional and analytical data processing using a data structure

A computer-implemented method of updating data, the method comprising:

• identifying a row in a segment of a 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;
• moving, for each said entry, the retrieved data the identified row to a rowstore;
• manipulating the retrieved data of at least one entry of the identified row in the rowstore based upon an update request;
• activating 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 based on a determination of respective offsets within different one or more columns of the segment such that other concurrent queries are allowed to access data within entries of other rows in the segment of the columnstore from which the row was moved;
• releasing the access lock after the manipulating is completed;
• and
• in response to the manipulating, updating a status of the row to indicate that updates to the retrieved data of at least one entry of the row are located in the rowstore.