The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 13, 2018
Filed:
Nov. 25, 2014
Anil Kumar Goel, Ontario, CA;
Ivan Schreter, Malsch, DE;
Juchang Lee, Seoul, KR;
Mihnea Andrei, Issy les Moulineaux, FR;
Steffen Geissinger, Wiesloch, DE;
Thomas Legler, Walldorf, DE;
Anil Kumar Goel, Ontario, CA;
Ivan Schreter, Malsch, DE;
Juchang Lee, Seoul, KR;
Mihnea Andrei, Issy les Moulineaux, FR;
Steffen Geissinger, Wiesloch, DE;
Thomas Legler, Walldorf, DE;
SAP SE, Walldorf, DE;
Abstract
As part of a database system comprising a combination of on-disk storage and in-memory storage, a plurality of records that comprise a table are stored in a plurality of fragments that include at least a delta fragment and a main fragment retained in the on-disk storage. Each fragment has visibility data structures to enable multi-version concurrency control. Each fragment can be compressed using dictionary compression and n-bits compression. The fragments are loaded into main system memory in the in-memory storage from the on-disk storage if they are accessed for read operations or write operations and are not already in memory. A plurality of lockless read and write operations are concurrently performed, while providing snapshot isolation, on the at least one of the plurality of fragments while the at least one of the plurality of fragments is in the main system memory.