-
公开(公告)号：US11249962B2
公开(公告)日：2022-02-15
申请号：US16411869
申请日：2019-05-14
申请人： SAP SE
发明人： Panfeng Zhou , Xu-Dong Qian , Yanhong Wang , Shyam Sunder Reddy Avula , Amarnadh Sai Eluri , Chirag Samtani
IPC分类号： G06F16/21 , G06F16/185 , G06F11/34 , G06F16/242
摘要： Disclosed herein are systems, methods, and devices for providing load unit recommendations. An example method includes monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Subsequently, the method includes generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values. The load unit indicates whether to load the whole database object, or only a portion thereof, into a main memory of the DBMS while accessing the database object.
-
公开(公告)号：US11023447B2
公开(公告)日：2021-06-01
申请号：US16276556
申请日：2019-02-14
申请人： SAP SE
IPC分类号： G06F16/00 , G06F16/23 , G06F9/50 , G06F16/18 , G06F16/901 , G06F3/06 , G06F16/908
摘要： A method may include performing a transaction on a row in a table stored in a database. In response to performing the transaction, a first timestamp block associated with a range of rows including the row may be retrieved. In response to determining that the first timestamp block is a sparse timestamp block that has reached maximum capacity, a second timestamp block may be allocated for storing the timestamp associated with the transaction. The sparse timestamp block may be allocated with sufficient storage space for storing some but not all of the timestamps associated with the range of rows. By contrast, the second timestamp block may be a dense timestamp block allocated with sufficient storage space for storing all of the timestamps associated with the range of rows. The timestamp associated with the transaction may be stored in the second timestamp block.
-
公开(公告)号：US20190354620A1
公开(公告)日：2019-11-21
申请号：US15980974
申请日：2018-05-16
申请人： SAP SE
摘要： Disclosed herein are system, method, and computer program product embodiments for managing timestamp information in memory systems. In an embodiment, an infrastructure may utilize a controller to manage sparse timestamp blocks. These sparse timestamp blocks may manage timestamp information in a persistent memory structure. Controller 110 may utilize a transient timestamp accessor to map the timestamp information for faster hash lookups. Controller 110 may also utilize a garbage collection map as a bitmap to further save processing steps. Controller 110 may utilize the sparse timestamp blocks, transient timestamp accessor, and garbage collection map to efficiently store timestamp data and to quickly retrieve the stored timestamp data.
-
公开(公告)号：US11775488B2
公开(公告)日：2023-10-03
申请号：US17699747
申请日：2022-03-21
申请人： SAP SE
发明人： Panfeng Zhou , Vivek Kandiyanallur , Colin Florendo , Robert Schulze , Zheng-Wei She , Yanhong Wang , Amarnadh Sai Eluri
CPC分类号： G06F16/213 , G06F16/221 , G06F16/2255 , G06N5/04
摘要： System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.
-
公开(公告)号：US11347711B2
公开(公告)日：2022-05-31
申请号：US16893567
申请日：2020-06-05
申请人： SAP SE
摘要： Disclosed herein are system, method, and computer program product embodiments for managing timestamp information in memory systems. In an embodiment, an infrastructure may utilize a controller to manage sparse timestamp blocks. These sparse timestamp blocks may manage timestamp information in a persistent memory structure. Controller 110 may utilize a transient timestamp accessor to map the timestamp information for faster hash lookups. Controller 110 may also utilize a garbage collection map as a bitmap to further save processing steps. Controller 110 may utilize the sparse timestamp blocks, transient timestamp accessor, and garbage collection map to efficiently store timestamp data and to quickly retrieve the stored timestamp data.
-
公开(公告)号：US11308047B2
公开(公告)日：2022-04-19
申请号：US16816511
申请日：2020-03-12
申请人： SAP SE
发明人： Panfeng Zhou , Vivek Kandiyanallur , Colin Florendo , Robert Schulze , Zheng-Wei She , Yanhong Wang , Amarnadh Sai Eluri
摘要： System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.
-
公开(公告)号：US11232090B2
公开(公告)日：2022-01-25
申请号：US16374472
申请日：2019-04-03
申请人： SAP SE
摘要： In one aspect, there is provided a method. The method may include accessing a multi-version concurrency control block providing row state for a block of rows in a table of a database, the multi-version concurrency control block including a header portion and a data portion, the header portion including a type indicator indicating whether all of the rows of the block are visible to a plurality of threads at a database management system or invisible to the plurality of threads at the database management system. Related systems, methods, and articles of manufacture are also disclosed.
-
公开(公告)号：US20210286777A1
公开(公告)日：2021-09-16
申请号：US16816511
申请日：2020-03-12
申请人： SAP SE
发明人： PANFENG ZHOU , Vivek Kandiyanallur , Colin Florendo , Robert Schulze , Zheng-wei She , Yanhong Wang , Amarnadh Sai Eluri
摘要： System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.
-
公开(公告)号：US11030182B2
公开(公告)日：2021-06-08
申请号：US16276560
申请日：2019-02-14
申请人： SAP SE
IPC分类号： G06F16/00 , G06F16/23 , G06F16/18 , G06F9/50 , G06F16/901 , G06F3/06 , G06F16/908
摘要： A method may include iterating through at least a portion of a table stored in a database by identifying a timestamp block associated with a range of rows forming the portion of the table. In response to determining that the timestamp block is a sparse timestamp block storing timestamps associated with only some of the rows in the first range of rows, generating a bitmap. Each of the binary values in the bitmap may correspond one of the rows in the range of rows. Moreover, each of the binary values in the bitmap may indicate whether the timestamp block includes a timestamp associated with a corresponding row from the range of rows. Iterating through the range of rows may include accessing, based on the bitmap, the timestamp block to read or write timestamps of transaction affecting the rows in the range of rows.
-
公开(公告)号：US20200301906A1
公开(公告)日：2020-09-24
申请号：US16893567
申请日：2020-06-05
申请人： SAP SE
摘要： Disclosed herein are system, method, and computer program product embodiments for managing timestamp information in memory systems. In an embodiment, an infrastructure may utilize a controller to manage sparse timestamp blocks. These sparse timestamp blocks may manage timestamp information in a persistent memory structure. Controller 110 may utilize a transient timestamp accessor to map the timestamp information for faster hash lookups. Controller 110 may also utilize a garbage collection map as a bitmap to further save processing steps. Controller 110 may utilize the sparse timestamp blocks, transient timestamp accessor, and garbage collection map to efficiently store timestamp data and to quickly retrieve the stored timestamp data.
-
-
-
-
-
-
-
-
-
搜索结果
11 条记录 (耗时 0.016 秒)
