公开(公告)号：US20220318211A1

公开(公告)日：2022-10-06

申请号：US17216974

申请日：2021-03-30

Applicant: SAP SE

Inventor： Hong-zhu Ji ,  Tianlun Chen ,  Ying Li ,  Ning Li ,  Hu Yin ,  Zhan-feng Ma ,  Jian-ping Hui

IPC: G06F16/21 ,  G06F16/22 ,  G06F7/08

Abstract: Disclosed herein are system, method, and computer program product embodiments for database management coordinators operated by a source server and a target server, respectively. The database management coordinator can be in a state selected from an initial state, a ready state, a transmission state, or a pause state. The database management coordinator operated by the source server can extract data in a first format stored in a first storage device and convert the data in the first format into a second format to be transmitted to the target serer. The database management coordinator operated by the target server can convert the data in the second format into a third format to be stored in a third storage device associated with the target server.

公开(公告)号：US20190266267A1

公开(公告)日：2019-08-29

申请号：US15907884

申请日：2018-02-28

Applicant: SAP SE

Inventor： Zhan-feng Ma ,  Tianlun Chen ,  Zhi-ping Xiong ,  Hu Yin

IPC: G06F17/30

Abstract: Various examples are directed to systems and methods for managing hash indexing in a database management system. A database management system may receive first index usage data for a first index describing a database. The database management system may determine a first hash index effectiveness for the first index based at least in part on the first index usage data. The database management system may compare the first hash index effectiveness to a threshold hash index effectiveness. The database management system may modify a hash index status of the first index based at least in part on the comparing.

公开(公告)号：US11768814B2

公开(公告)日：2023-09-26

申请号：US17216974

申请日：2021-03-30

Applicant: SAP SE

Inventor： Hong-zhu Ji ,  Tianlun Chen ,  Ying Li ,  Ning Li ,  Hu Yin ,  Zhan-feng Ma ,  Jian-ping Hui

IPC: G06F16/21 ,  G06F7/08 ,  G06F16/22

CPC classification number: G06F16/214 ,  G06F7/08 ,  G06F16/2282

Abstract: Disclosed herein are system, method, and computer program product embodiments for database management coordinators operated by a source server and a target server, respectively. The database management coordinator can be in a state selected from an initial state, a ready state, a transmission state, or a pause state. The database management coordinator operated by the source server can extract data in a first format stored in a first storage device and convert the data in the first format into a second format to be transmitted to the target serer. The database management coordinator operated by the target server can convert the data in the second format into a third format to be stored in a third storage device associated with the target server.

公开(公告)号：US10803043B2

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

申请号：US15907884

申请日：2018-02-28

Applicant: SAP SE

Inventor： Zhan-feng Ma ,  Tianlun Chen ,  Zhi-ping Xiong ,  Hu Yin

IPC: G06F16/22 ,  G06F16/23 ,  G06F16/21

Abstract: Various examples are directed to systems and methods for managing hash indexing in a database management system. A database management system may receive first index usage data for a first index describing a database. The database management system may determine a first hash index effectiveness for the first index based at least in part on the first index usage data. The database management system may compare the first hash index effectiveness to a threshold hash index effectiveness. The database management system may modify a hash index status of the first index based at least in part on the comparing.

公开(公告)号：US11119997B2

公开(公告)日：2021-09-14

申请号：US15908727

申请日：2018-02-28

Applicant: SAP SE

Inventor： Aditya Gurajada ,  Zhan-feng Ma ,  Zhi-ping Xiong

IPC: G06F17/30 ,  G06F16/22 ,  G06F11/14 ,  G06F16/27 ,  G06F16/23 ,  G06F3/06 ,  G06F12/02

Abstract: A system for an in-memory row storage architecture can be provided. In some implementations, the system performs operations comprising adding a data row to an in-memory row store at a row location based on a database operation, indexing the row location in an index table comprising a plurality of nodes for a plurality of rows in the in-memory row store, the plurality of nodes organized across a plurality of buckets, and accessing the data row at the row location in the in-memory row store based on the index table to perform another database operation on the data row Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20180349374A1

公开(公告)日：2018-12-06

申请号：US15908727

申请日：2018-02-28

Applicant: SAP SE

Inventor： Aditya Gurajada ,  Zhan-feng Ma ,  Zhi-ping Xiong

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F17/30377 ,  G06F3/061 ,  G06F3/065 ,  G06F3/0673 ,  G06F11/1471 ,  G06F17/30336 ,  G06F17/30339 ,  G06F17/30575 ,  G06F2201/80 ,  G06F2201/82

Abstract: A system for an in-memory row storage architecture can be provided. In some implementations, the system performs operations comprising adding a data row to an in-memory row store at a row location based on a database operation, indexing the row location in an index table comprising a plurality of nodes for a plurality of rows in the in-memory row store, the plurality of nodes organized across a plurality of buckets, and accessing the data row at the row location in the in-memory row store based on the index table to perform another database operation on the data row Related systems, methods, and articles of manufacture are also described.