公开(公告)号：US20240169072A1

公开(公告)日：2024-05-23

申请号：US17988975

申请日：2022-11-17

Applicant: SAP SE

Inventor： Beomsoo KIM ,  Yong Sik KWON ,  Ji Hoon JANG ,  Hyeong Seog KIM

IPC: G06F21/60 ,  G06F21/62

CPC classification number: G06F21/602 ,  G06F21/6218

Abstract: Systems and methods include determination of a first encryption key associated with a data page of a row store database table stored in a volatile memory, based on a header of the data page, encryption of a body of the data page using the first encryption key, and storage of an encrypted data page comprising the header and the encrypted body in a persistent storage system.

公开(公告)号：US20170075936A1

公开(公告)日：2017-03-16

申请号：US14853569

申请日：2015-09-14

Applicant: SAP SE

Inventor： Jaeyun NOH ,  Hyeong Seog KIM

IPC: G06F17/30

Abstract: A system, computer-implemented method, and computer-program product embodiments for rebuilding database indexes is disclosed. A pre-loader thread rebuilds a plurality of indexes in the background once a database is initialized. Simultaneously, a query processor receives queries from a user/client of a database. If an index that is required by the query processor has not yet been rebuilt by the pre-loader, a request to rebuild the index is sent to an asynchronous index loader. The asynchronous index loader places the request in a queue, processes the queue based on available system resources, and then rebuilds the requested indexes. Once the necessary indexes have been rebuilt, a wake-up signal is sent to the query processor which then proceeds to execute the query from a user/client.

Abstract translation: 公开了一种用于重建数据库索引的系统，计算机实现的方法和计算机程序产品实施例。 数据库初始化后，预加载程序线程会在后台重建多个索引。 同时，查询处理器从数据库的用户/客户端接收查询。 如果预处理器尚未重建查询处理器所需的索引，则将重建索引的请求发送到异步索引加载器。 异步索引加载器将请求放入队列中，根据可用的系统资源处理队列，然后重建请求的索引。 一旦重建了必要的索引，就将唤醒信号发送给查询处理器，然后查询处理器继续执行来自用户/客户端的查询。

公开(公告)号：US20180150363A1

公开(公告)日：2018-05-31

申请号：US15362714

申请日：2016-11-28

Applicant: SAP SE

Inventor： Hyeong Seog KIM ,  Yong Sik KWON ,  Seyeong BAE ,  Ji Hoon JANG ,  Won Wook HONG

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1469 ,  G06F16/2308 ,  G06F16/2365 ,  G06F2201/84

Abstract: Restoring a database image of a secondary database system comprises initializing the database image from a recovery image that includes metadata logs and non-metadata logs, of which at least one metadata log includes an undo log of non-committed data that is applied to the initialized database image. A first pagelist and first indexes are then rebuilt based on first data segments of the database image and the corresponding metadata objects. The database image is then updated by replaying the metadata redo log generated from the undo log, the metadata logs, and the non-metadata logs. Then, a second pagelist and second indexes for the database system are rebuilt based on second data segments of the database image and the corresponding non-metadata objects, while each of the first data segments is statically separated from the second data segments in physical memory space. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20240195617A1

公开(公告)日：2024-06-13

申请号：US18065048

申请日：2022-12-13

Applicant: SAP SE

Inventor： Beomsoo KIM ,  Yong Sik KWON ,  Ji Hoon JANG ,  Hyeong Seog KIM

IPC: H04L9/08 ,  G06F21/60 ,  G06F21/62

CPC classification number: H04L9/0891 ,  G06F21/602 ,  G06F21/6218

Abstract: Systems and methods include storage of a plurality of encrypted data pages of a row store database table in a persistent storage system, determination of a first encryption key associated with one of the plurality of encrypted data pages based on a header of the one of the plurality of encrypted data pages, determination of whether the first encryption key has been revoked, and, if it is determined that the first encryption key has been revoked, adding of a portion of volatile memory allocated to the one of the plurality of data pages to a free list.