公开(公告)号：US11061927B2

公开(公告)日：2021-07-13

申请号：US16373691

申请日：2019-04-03

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Priya Sharma ,  Mahendra Chavan

IPC: G06F17/00 ,  G06F16/27 ,  G06F16/2453 ,  G06F16/25

Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.

公开(公告)号：US20200320094A1

公开(公告)日：2020-10-08

申请号：US16373691

申请日：2019-04-03

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Priya Sharma ,  Mahendra Chavan

IPC: G06F16/27 ,  G06F16/25 ,  G06F16/2453

Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.

公开(公告)号：US20200301901A1

公开(公告)日：2020-09-24

申请号：US16356240

申请日：2019-03-18

Applicant: SAP SE

Inventor： Zhilong Hao ,  Priya Sharma ,  Yinghua Ouyang

IPC: G06F16/22 ,  G06F12/0804 ,  G06F16/2455

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing index and storage management for multi-tiered databases. An embodiment operates by receiving a request to create an index on a multi-tiered database including both an in-memory store and a disk store. A multi-store table associated with the index is determined, wherein the multi-store table includes both a first set of data stored on the memory store and a second set of data stored on the disk store. Either the first set of data or the second set of data on which to create the index is selected based on the request. The index for the selected set of data of the multi-store table is generated. The index is stored on either the disk store or the memory store as corresponding to the selected set of data for which the index was generated.

公开(公告)号：US11494359B2

公开(公告)日：2022-11-08

申请号：US16356240

申请日：2019-03-18

Applicant: SAP SE

Inventor： Zhilong Hao ,  Priya Sharma ,  Yinghua Ouyang

IPC: G06F17/00 ,  G06F7/00 ,  G06F16/22 ,  G06F16/2455 ,  G06F12/0804

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing index and storage management for multi-tiered databases. An embodiment operates by receiving a request to create an index on a multi-tiered database including both an in-memory store and a disk store. A multi-store table associated with the index is determined, wherein the multi-store table includes both a first set of data stored on the memory store and a second set of data stored on the disk store. Either the first set of data or the second set of data on which to create the index is selected based on the request. The index for the selected set of data of the multi-store table is generated. The index is stored on either the disk store or the memory store as corresponding to the selected set of data for which the index was generated.

公开(公告)号：US11182405B2

公开(公告)日：2021-11-23

申请号：US16373725

申请日：2019-04-03

Applicant: SAP SE

Inventor： Priya Sharma ,  Mahendra Chavan ,  Kunj Kothari

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/28 ,  G06F16/22

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.