公开(公告)号：US20170147618A1

公开(公告)日：2017-05-25

申请号：US14949635

申请日：2015-11-23

Applicant: SAP SE

Inventor： STEFFEN GEISSINGER ,  Ivan Schreter

IPC: G06F17/30

CPC classification number: G06F17/30315

Abstract: A first block in a page chain can be assigned to a first dictionary for a first column of a database. The page chain can include a plurality of dictionary blocks allocated to a plurality of dictionaries of a plurality of columns including the first column such that the plurality of dictionary blocks is interleaved in the page chain. A new unique value to be added to the first column can be appended to an end of the first dictionary. The plurality of dictionaries can be loaded from the page chain into memory of one or more computers performing operations of a database management system. The loading can include scanning the page chain a single time and assigning the plurality of dictionary blocks to the respective dictionaries of the plurality of dictionaries.

公开(公告)号：US20170147225A1

公开(公告)日：2017-05-25

申请号：US14951046

申请日：2015-11-24

Applicant: SAP SE

Inventor： STEFFEN GEISSINGER ,  Ivan Schreter ,  Mihnea Andrei

IPC: G06F3/06 ,  G06F12/08

CPC classification number: G06F3/0608 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0652 ,  G06F3/0656 ,  G06F3/0673 ,  G06F12/0891 ,  G06F13/00 ,  G06F16/00 ,  G06F16/221

Abstract: First page data from one or more pages stored on a persistent storage can be loaded into a page buffer in a main system memory of one or more computing systems, and second page data that includes first dictionary values of a first dictionary for a first database column can be loaded and pinned into the page buffer in the main system memory. First contents of a first dictionary block containing first re-direction references to the first dictionary can be copied from the loaded first page data into a first in-memory array, and the first page data can be deallocated from the page buffer. The first re-direction references can direct to the first dictionary values of the first dictionary in the pinned second page data.