Sap Ag

Stefan Hildenbrand

Franz Faerber

Carsten Binnig

Juchang Lee

Norman May

Donald Kossmann

A system and method of performing snapshot isolation in distributed databases. Each node stores local snapshot information that enforces snapshot isolation for that node. The method includes partially processing a distributed transaction by a first node, receiving a global commit identifier from a coordinator, and continuing to process the distributed transaction, by the first node and a second node, in accordance with the global commit identifier.

System and method of performing snapshot isolation in distributed databases

Methods and systems are described that involve usage of dictionaries for compressing a large set of variable-length string values with fixed-length integer keys in column stores. The dictionary supports updates (e.g., inserts of new string values) without changing codes for existing values. Furthermore, a shared-leaves approach is described for indexing such a dictionary that compresses the dictionary itself while offering access paths for encoding and decoding.

Growing community of inventors

Altdorf, Switzerland

Stefan Hildenbrand