1. A method for storing and retrieving data in a storage node of a data store comprising the step of storing at least one segment of a relational table in data storage means of the storage node, the data storage means comprising at least a processor core and its associated main memory, characterized in that the method comprises the following steps: storing in each associated main memory of a processor core a single segment; running from the processor core one scan thread dedicated to the scanning of the said segment; continuously and fully scanning said segment; receiving and processing batches of query and update operations; indexing query and update operations of a batch at beginning of each data scan; joining query and update operations of a batch to retrieved data records of said segment that match with predicates of the indexed query and update operations; progressively fulfilling query and update operations of a batch whenever data of the joined data records are retrieved by the scan thread while scanning said segment.