-
公开(公告)号:US10997146B2
公开(公告)日:2021-05-04
申请号:US16107917
申请日:2018-08-21
Applicant: SAP SE
Inventor: Yong Sik Kwon , Yongsik Yoon , Joo Yeon Lee , Oliver M. Steinau , Markus Hartmann
IPC: G06F16/22 , G06F16/27 , G06F16/21 , G06F16/248 , G06F16/951
Abstract: 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.
-
公开(公告)号:US10664497B2
公开(公告)日:2020-05-26
申请号:US15380720
申请日:2016-12-15
Applicant: SAP SE
Inventor: Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC: G06F16/22 , G06F16/28 , G06F16/27 , G06F16/9535 , G06F40/177 , G06F16/23
Abstract: 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.
-
公开(公告)号:US10102237B2
公开(公告)日:2018-10-16
申请号:US15256323
申请日:2016-09-02
Applicant: SAP SE
Inventor: Yong Sik Kwon , Yongsik Yoon , Joo Yeon Lee , Oliver M. Steinau , Markus Hartmann
IPC: G06F17/30
Abstract: 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.
-
公开(公告)号:US20160371315A1
公开(公告)日:2016-12-22
申请号:US15256323
申请日:2016-09-02
Applicant: SAP SE
Inventor: Yong Sik Kwon , Yongsik Yoon , Joo Yeon Lee , Oliver M. Steinau , Markus Hartmann
IPC: G06F17/30
CPC classification number: G06F17/30339 , G06F17/30292 , G06F17/30315 , G06F17/30554 , G06F17/30575 , G06F17/30864
Abstract: 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.
Abstract translation: 托管多承租人软件架构租户的内存数据库服务器可以接收对具有对租户的独立访问权限的组织独有的自定义数据字段的定义。 定制数据字段可以扩展由存储在多承租人软件体系结构的系统租户处的中央元数据定义的标准表。 包含定义的租户私有元数据可以存储在只能由租户访问的存储器中。 可以形成包括自定义数据字段的租户相关表,例如通过从系统租户检索定义标准表的中心元数据,并使用定义添加自定义数据字段。 可以通过组织中的数据库客户端呈现租户相关表。 公开了相关系统,制品和计算机实现的方法。
-
公开(公告)号:US12242359B2
公开(公告)日:2025-03-04
申请号:US18185872
申请日:2023-03-17
Applicant: SAP SE
Inventor: Uwe Hahn , Eunsang Kim , Mihnea Andrei , Werner Thesing , Patrick Voelker , Ruediger Karl , Yong Sik Kwon , Jaeyoung Choi , Jian Luo , Hyunjun Kim , Andre Schefe , Urs Klingsporn , Norman May
Abstract: Systems and methods include reception of an instruction to recover a first database tenant of a first database instance to a first point in time, the first database tenant associated with first database artifacts of the first database instance, and the first database instance including two or more database tenants and, in response to the instruction, creation of a second database instance, selection of backup data of the first database instance based on the first point in time, execution of a recovery of the backup data on the second database instance, export of second database artifacts of the first database tenant from the second database instance to a storage, truncation of the first database artifacts from the first database instance, import of the second database artifacts from the storage to the first database instance, and deletion of the second database instance.
-
公开(公告)号:US20230112355A1
公开(公告)日:2023-04-13
申请号:US18064924
申请日:2022-12-12
Applicant: SAP SE
Inventor: Yong Sik Kwon , Yongsik Yoon , Joo Yeon Lee , Oliver M. Steinau , Markus Hartmann
IPC: G06F16/22 , G06F16/27 , G06F16/21 , G06F16/248 , G06F16/951
Abstract: 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.
-
公开(公告)号:US20210294786A1
公开(公告)日:2021-09-23
申请号:US16824933
申请日:2020-03-20
Applicant: SAP SE
Inventor: Ji Hoon Jang , Seungho Yoo , Yong Sik Kwon , Hyeong Seog Kim
Abstract: 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.
-
公开(公告)号:US20190034467A1
公开(公告)日:2019-01-31
申请号:US15658671
申请日:2017-07-25
Applicant: SAP SE
Inventor: Yong Sik Kwon , Kunsoo Park , Cheol Yoo
IPC: G06F17/30
CPC classification number: G06F16/2272 , G06F16/2228 , G06F16/23
Abstract: A system and method, including determining, by a processor, distinction bit positions for index keys of a database index; determining, by the processor, concatenation of the bits of the index keys; and generating a record of the concatenation. Other systems and methods include collecting, by a processor, index keys of a database index in parallel, wherein data pages of a target table are evenly distributed to a plurality of processor cores; scanning, by each of the cores the data pages to extract compressed keys and corresponding record identifiers; sorting, by a plurality of the processor cores, pairs of the compressed key and corresponding record identifier in accordance with a parallel sorting algorithm; generating an index tree in a bottom-up fashion; and storing a record of the generated index tree.
-
公开(公告)号:US20160378813A1
公开(公告)日:2016-12-29
申请号:US15260181
申请日:2016-09-08
Applicant: SAP SE
Inventor: Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC: G06F17/30
CPC classification number: G06F16/23 , G06F16/22 , G06F16/2282 , G06F16/2453 , G06F16/24544 , G06F16/2455 , G06F16/278 , G06F16/9535
Abstract: 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.
-
20.
公开(公告)号:US11461363B2
公开(公告)日:2022-10-04
申请号:US16835549
申请日:2020-03-31
Applicant: SAP SE
Inventor: Seungho Yoo , Ji Hoon Jang , Seyeong Bae , Yong Sik Kwon , Hyeong Seog Kim
Abstract: Methods, systems, and computer-readable storage media for receiving a first storage request indicating a first type of data and a first size, identifying a first sub-space based on the first type, the first sub-space including a dense group of dense segments and a sparse group of sparse segments, and determining that the dense group of the first sub-space is absent a dense segment to store data of the first storage request based on the first size, and in response: determining whether the sparse group of the first sub-space includes a sparse segment to store the data of the first storage request based on the first size, and storing the data of the first storage request to the sparse group of the first sub-space in response to determining that the sparse group of the first sub-space includes a sparse segment to store the data of the first storage request.
-
-
-
-
-
-
-
-
-