公开(公告)号：US20170147638A1

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

申请号：US14961309

申请日：2015-12-07

Applicant: SAP SE

Inventor： Changgyoo Park ,  Yongjae Chuh ,  Juchang Lee ,  Norman May ,  Thomas Seufert ,  Hannes Jakschitsch

IPC: G06F17/30

CPC classification number: G06F16/24539 ,  G06F16/2282 ,  G06F16/2308 ,  G06F16/2379 ,  G06F16/24552

Abstract: Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update data associated with a table stored at the source database. The embodiment continues by modifying a value of a modification-in-progress data structure corresponding to the table to indicate that a modification is in progress for the table, and that cached data associated with the table is invalid while the modification is in progress for the table and performing the table update based, at least, on information received in the update request. The embodiment further continues by updating a value of a commit identification counter, and subsequently a table time stamp associated with the table, to indicate that all cached data associated with the table having a time stamp older than the updated time stamp are invalid. The embodiment further continues by modifying the value of the modification-in-progress counter to indicate the completion of table modification.

公开(公告)号：US10353895B2

公开(公告)日：2019-07-16

申请号：US14961309

申请日：2015-12-07

Applicant: SAP SE

Inventor： Changgyoo Park ,  Yongjae Chuh ,  Juchang Lee ,  Norman May ,  Thomas Seufert ,  Hannes Jakschitsch

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

Abstract: Disclosed herein are systems, methods, and computer program products for providing transaction-consistent snapshots of data stored in or associated with a database. An embodiment operates by receiving, at a source database, an update request to update data associated with a table stored at the source database, and modifying a value of a modification-in-progress data structure corresponding to the table to indicate that a modification is in progress for the table. The embodiment includes updating a value of a commit identification counter and a table time stamp associated with the table to indicate that cached data having a time stamp older than the updated time stamp are invalid. The embodiment further includes modifying the value of the modification-in-progress counter to indicate completion of table modification.

公开(公告)号：US10102120B2

公开(公告)日：2018-10-16

申请号：US15401988

申请日：2017-01-09

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Jaeyun Noh ,  Yongjae Chuh ,  Hyungyu Shin ,  Seongyun Ko

IPC: G06F12/00 ,  G06F12/02 ,  G06F3/06

Abstract: Technologies for performing garbage collection in database systems, such as multi-version concurrency control (MVCC) database systems, are described. For example, different garbage collection techniques can be used separately or in various combinations, including interval garbage collection, group garbage collection, table garbage collection, and combinations. For example, a particular type of combination, called hybrid garbage collection, uses technique from interval garbage collection and group garbage collection, or from interval, group, and table garbage collection.

公开(公告)号：US20170357575A1

公开(公告)日：2017-12-14

申请号：US15401988

申请日：2017-01-09

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Jaeyun Noh ,  Yongjae Chuh ,  Hyungyu Shin ,  Seongyun Ko

IPC: G06F12/02 ,  G06F3/06

CPC classification number: G06F12/0269 ,  G06F3/0619 ,  G06F3/0641 ,  G06F3/065 ,  G06F3/067 ,  G06F12/0253 ,  G06F12/0261 ,  G06F17/30353 ,  G06F17/30356 ,  G06F2212/1044 ,  G06F2212/702

Abstract: Technologies for performing garbage collection in database systems, such as multi-version concurrency control (MVCC) database systems, are described. For example, different garbage collection techniques can be used separately or in various combinations, including interval garbage collection, group garbage collection, table garbage collection, and combinations. For example, a particular type of combination, called hybrid garbage collection, uses technique from interval garbage collection and group garbage collection, or from interval, group, and table garbage collection.

公开(公告)号：US20170147628A1

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

申请号：US14985766

申请日：2015-12-31

Applicant: SAP SE

Inventor： Changgyoo Park ,  Yongjae Chuh ,  Juchang Lee ,  Norman May ,  Thomas Seufert ,  Hannes Jakschitsch

IPC: G06F17/30

Abstract: Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update a table at the source database and transmitting a message to a cache node to invalidate a copy of a table time stamp associated with the table, where the copy of the table time stamp is stored at the cache node. The embodiment continues by updating the table at the source database based on the update request.