-
公开(公告)号：US11204911B2
公开(公告)日：2021-12-21
申请号：US16824933
申请日：2020-03-20
申请人： SAP SE
发明人： Ji Hoon Jang , Seungho Yoo , Yong Sik Kwon , Hyeong Seog Kim
摘要： Methods, systems, and computer-readable storage media for online defragmentation of memory in database systems by applying an IX-lock to each table having data stored in a marked page in a set of marked pages, generating a record map including key-value pairs, each being associated with a record location in a marked page, a value of each key-value pair initially set to a first value, iteratively executing the online defragmentation to delete data from marked pages and add the data to non-sparse pages, at least one iteration including applying a try-lock to a record in a marked page, and at iterations of the online defragmentation, updating the record map to change the value of at least one key-value pair from the first value to the second value, the second value representing that data of a marked page has been deleted from the marked page and added to a non-sparse page.
-
公开(公告)号：US11074141B2
公开(公告)日：2021-07-27
申请号：US16711853
申请日：2019-12-12
申请人： SAP SE
发明人： Yong Sik Kwon , Changseob Lee , Seyeong Bae , Beomsoo Kim , Youngho Yoo
摘要： A system includes initiation of recovery from a crash of a database instance and, during the recovery, identification of a subset of pages of a memory image of the database instance which are not reusable and replacement of the identified subset of pages with corresponding pages of the savepoint image.
-
公开(公告)号：US20210182157A1
公开(公告)日：2021-06-17
申请号：US16711853
申请日：2019-12-12
申请人： SAP SE
发明人： Yong Sik Kwon , Changseob Lee , Seyeong Bae , Beomsoo Kim , Youngho Yoo
摘要： A system includes initiation of recovery from a crash of a database instance and, during the recovery, identification of a subset of pages of a memory image of the database instance which are not reusable and replacement of the identified subset of pages with corresponding pages of the savepoint image.
-
公开(公告)号：US20190324648A1
公开(公告)日：2019-10-24
申请号：US16503122
申请日：2019-07-03
申请人： SAP SE
发明人： Yong Sik Kwon , Jaeyun Noh , Juchang Lee , Ji Hoon Jang , Sang Kyun Cha
摘要： 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).
-
公开(公告)号：US10346383B2
公开(公告)日：2019-07-09
申请号：US15260181
申请日：2016-09-08
申请人： SAP SE
发明人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F16/27 , G06F16/2453 , G06F16/2455 , G06F16/9535 , G06F16/23 , G06F16/22
摘要： A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.
-
公开(公告)号：US20180150360A1
公开(公告)日：2018-05-31
申请号：US15361946
申请日：2016-11-28
申请人： SAP SE
发明人： Yong Sik Kwon , Hyeong Seog Kim , Kyu Hwan Kim , Seyeong Bae , Joo Yeon Lee , Beomsoo Kim , Juchang Lee , Marcel Birn
CPC分类号： G06F11/1451 , G06F17/30309 , G06F17/30371 , G06F2201/84
摘要： A computer implemented method is provided. The method comprises initializing a first database image of a first database system based on a recovery image comprising committed transactions, visible uncommitted transactions, and undo logs associated with the visible uncommitted transactions, undoing the visible uncommitted transactions using the undo logs, generating redo logs from the undo logs, replaying the redo logs to create invisible uncommitted transactions, and after replaying the redo logs, replaying transaction logs received from a second database system. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US11847109B2
公开(公告)日：2023-12-19
申请号：US18064924
申请日：2022-12-12
申请人： SAP SE
IPC分类号： G06F16/22 , G06F16/27 , G06F16/21 , G06F16/248 , G06F16/951
CPC分类号： G06F16/2282 , G06F16/211 , G06F16/221 , G06F16/248 , G06F16/27 , G06F16/951
摘要： An in-memory database server hosting a tenant of a multi-tenant software architecture can receive a definition of a custom data field that is unique to an organization having isolated access to the tenant. The custom data field can extend a standard table defined by central metadata stored at a system tenant of the multi-tenant software architecture. Tenant private metadata that includes the definition can be stored in memory accessible only to the tenant. A tenant-dependent table that includes the custom data field can be formed, for example by retrieving central metadata defining the standard table from the system tenant and adding the custom data field using the definition. The tenant-dependent table can be presented for access via a database client at the organization. Related systems, articles of manufacture, and computer-implemented methods are disclosed.
-
公开(公告)号：US20230195705A1
公开(公告)日：2023-06-22
申请号：US17555979
申请日：2021-12-20
申请人： SAP SE
发明人： Yong Sik Kwon , Kunsoo Park , Joong Chae Na , Seonho Lee , Bongki Moon , Yehyun Nam
IPC分类号： G06F16/22 , G06F16/245
CPC分类号： G06F16/2246 , G06F16/2272 , G06F16/245
摘要： In some embodiments, a method determines a query distinction bit (D-bit) slice for a query key using values at D-bit positions that are associated with a node in the data structure. D-bit positions are determined based on branches in the data structure. The method selects a D-bit slice for a key in the set of keys for the node based on the D-bit slice of the query key and compares a key value for the key to a query key value for the query key to determine a first D-bit position value. A D-bit position that has a second D-bit position value that is smaller in value than the first D-bit position value is selected. The D-bit position is used to determine a result for the query key.
-
公开(公告)号：US20220100715A1
公开(公告)日：2022-03-31
申请号：US17210393
申请日：2021-03-23
申请人： SAP SE
发明人： Juchang Lee , Ivan Veselinov Andreev , Eunsang Kim , Jaehwa Kim , Yong Sik Kwon , Joo Yeon Lee , Jian Luo , Myunggon Park , Edward-Robert Tyercha , Zheng-Wei Wang , Paul Willems
摘要： A physio-logical migration of a database from a source system to a target system may include exporting a catalog of the database in a data interchange format that preserves the hierarchical dependencies present amongst the entities included in the catalog. The physio-logical migration of the database may further include exporting the contents of a table in the database in a binary format compatible at the target system. The binary format may be a data buffer having a metadata portion, a fixed-size portion, and a page chain portion. Where the target system is a cloud-based system, the physio-logical migration of the database may include exporting the catalog and the contents of the table to a cloud-based object store before importing the catalog and the contents of the table to the target system. Related systems and articles of manufacture, including computer program products, are also provided.
-
公开(公告)号：US10997146B2
公开(公告)日：2021-05-04
申请号：US16107917
申请日：2018-08-21
申请人： SAP SE
IPC分类号： G06F16/22 , G06F16/27 , G06F16/21 , G06F16/248 , G06F16/951
摘要： An in-memory database server hosting a tenant of a multi-tenant software architecture can receive a definition of a custom data field that is unique to an organization having isolated access to the tenant. The custom data field can extend a standard table defined by central metadata stored at a system tenant of the multi-tenant software architecture. Tenant private metadata that includes the definition can be stored in memory accessible only to the tenant. A tenant-dependent table that includes the custom data field can be formed, for example by retrieving central metadata defining the standard table from the system tenant and adding the custom data field using the definition. The tenant-dependent table can be presented for access via a database client at the organization. Related systems, articles of manufacture, and computer-implemented methods are disclosed.
-
-
-
-
-
-
-
-
-
搜索结果
32 条记录 (耗时 0.015 秒)
