-
公开(公告)号:US20190324648A1
公开(公告)日:2019-10-24
申请号:US16503122
申请日:2019-07-03
Applicant: SAP SE
Inventor: Yong Sik Kwon , Jaeyun Noh , Juchang Lee , Ji Hoon Jang , Sang Kyun Cha
Abstract: Technologies are described for restarting an application while maintaining data in memory (e.g., using shared memory). For example, shared memory can be associated with an application. The shared memory can also be associated with a holder process to maintain the shared memory from the time the application stops to the time the application starts again. When the application starts, the shared memory can be associated with the started application. In addition, restart of in-memory databases can be provided using shared memory. For example, in-memory data can be maintained when a database process or database management system stops and starts (e.g., during a restart).
-
公开(公告)号:US10360146B2
公开(公告)日:2019-07-23
申请号:US15231566
申请日:2016-08-08
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Jaeyun Noh , Sung Heun Wi
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.
-
公开(公告)号:US20170357576A1
公开(公告)日:2017-12-14
申请号:US15231566
申请日:2016-08-08
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Jaeyun Noh , Sung Heun Wi
IPC: G06F12/02
CPC classification number: G06F12/0253 , G06F3/0619 , G06F3/0641 , G06F3/065 , G06F3/067 , G06F12/0261 , G06F12/0269 , G06F16/2322 , G06F16/2329 , 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.
-
4.
公开(公告)号:US20180293276A1
公开(公告)日:2018-10-11
申请号:US15483690
申请日:2017-04-10
Applicant: SAP SE
Inventor: Jin Uk Bae , Stefan Baeuerle , Christian Bensberg , Steffen Geissinger , Ki Hong Kim , Taehyung Lee , Jaeyun Noh , Di Wu , Long Zhang
IPC: G06F17/30
Abstract: A method can include: generating a query execution plan for a query including a plurality of operations that operate on data from a relational database and data from a non-structured query language (NoSQL) database, the generating comprising optimizing the query by: identifying a first operation that operate on data from the relational database and an intermediate result output by a second operation, the second operation outputting the intermediate result by operating on the data from the NoSQL database; and determining a fixed datatype for the intermediate result, an indication of the fixed datatype being included in the query execution plan; and executing, based on the query execution plan, the query, the executing of the query comprising converting the intermediate result to the fixed datatype, the converting enabling the first operation to operate on the intermediate result output by the second operation along with the data from the relational database.
-
公开(公告)号:US10740311B2
公开(公告)日:2020-08-11
申请号:US14853569
申请日:2015-09-14
Applicant: SAP SE
Inventor: Jaeyun Noh , Hyeong Seog Kim
IPC: G06F16/00 , G06F16/22 , G06F16/23 , G06F16/2455
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.
-
公开(公告)号:US10459889B2
公开(公告)日:2019-10-29
申请号:US15615504
申请日:2017-06-06
Applicant: SAP SE
Inventor: Jaeyun Noh , Taesik Yoon , Eun Kyung Chi
IPC: G06F16/00 , G06F16/176 , G06F16/242 , G06F16/2453 , G06F16/2455 , G06F16/2452
Abstract: Technologies are provided for using a multi-user execution plan cache to process database queries. A database query processor can be configured to store execution plans in a multi-user execution plan cache. The query processor can determine whether an execution plan is shareable by multiple database users. If the execution plan is shareable, it can be stored in the cache in association with a sharing user identifier. When a database query is received, the query processor can determine that the query can be performed using the cached execution plan. If the cached execution plan is shareable, the database query can determine whether the cached execution plan is valid for a database user associated with the received database query. If the cached execution plan is valid for the database user, the query processor uses the cached execution plan to perform the query for the associated database user.
-
公开(公告)号:US20180349404A1
公开(公告)日:2018-12-06
申请号:US15615504
申请日:2017-06-06
Applicant: SAP SE
Inventor: Jaeyun Noh , Taesik Yoon , Eun Kyung Chi
IPC: G06F17/30
CPC classification number: G06F16/176 , G06F16/244 , G06F16/24524 , G06F16/24534 , G06F16/24539 , G06F16/24557
Abstract: Technologies are provided for using a multi-user execution plan cache to process database queries. A database query processor can be configured to store execution plans in a multi-user execution plan cache. The query processor can determine whether an execution plan is shareable by multiple database users. If the execution plan is shareable, it can be stored in the cache in association with a sharing user identifier. When a database query is received, the query processor can determine that the query can be performed using the cached execution plan. If the cached execution plan is shareable, the database query can determine whether the cached execution plan is valid for a database user associated with the received database query. If the cached execution plan is valid for the database user, the query processor uses the cached execution plan to perform the query for the associated database user.
-
公开(公告)号: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
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.
-
公开(公告)号:US20170357577A1
公开(公告)日:2017-12-14
申请号:US15231553
申请日:2016-08-08
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Jaeyun Noh , Wolfgang Stephan , Hyungyu Shin , Seongyun Ko
CPC classification number: G06F12/0253 , G06F3/0619 , G06F3/0641 , G06F3/065 , G06F3/067 , G06F12/0261 , G06F12/0269 , G06F16/2322 , G06F16/2329 , 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.
-
公开(公告)号: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
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.
-
-
-
-
-
-
-
-
-