In-memory database for multi-tenancy

    公开(公告)号:US10997146B2

    公开(公告)日:2021-05-04

    申请号:US16107917

    申请日:2018-08-21

    Applicant: SAP SE

    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.

    Hybrid database table stored as both row and column store

    公开(公告)号:US10664497B2

    公开(公告)日:2020-05-26

    申请号:US15380720

    申请日:2016-12-15

    Applicant: SAP SE

    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.

    In-memory database for multi-tenancy

    公开(公告)号:US10102237B2

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

    申请号:US15256323

    申请日:2016-09-02

    Applicant: SAP SE

    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.

    In-Memory Database For Multi-Tenancy
    14.
    发明申请
    In-Memory Database For Multi-Tenancy 审中-公开
    多租户内存数据库

    公开(公告)号:US20160371315A1

    公开(公告)日:2016-12-22

    申请号:US15256323

    申请日:2016-09-02

    Applicant: SAP SE

    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: 托管多承租人软件架构租户的内存数据库服务器可以接收对具有对租户的独立访问权限的组织独有的自定义数据字段的定义。 定制数据字段可以扩展由存储在多承租人软件体系结构的系统租户处的中央元数据定义的标准表。 包含定义的租户私有元数据可以存储在只能由租户访问的存储器中。 可以形成包括自定义数据字段的租户相关表,例如通过从系统租户检索定义标准表的中心元数据,并使用定义添加自定义数据字段。 可以通过组织中的数据库客户端呈现租户相关表。 公开了相关系统,制品和计算机实现的方法。

    Tenant-level database recovery
    15.
    发明授权

    公开(公告)号:US12242359B2

    公开(公告)日:2025-03-04

    申请号:US18185872

    申请日:2023-03-17

    Applicant: SAP SE

    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.

    IN-MEMORY DATABASE FOR MULTI-TENANCY

    公开(公告)号:US20230112355A1

    公开(公告)日:2023-04-13

    申请号:US18064924

    申请日:2022-12-12

    Applicant: SAP SE

    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.

    EFFICIENT AND NON-DISRUPTIVE ONLINE DEFRAGMENTATION WITH RECORD LOCKING

    公开(公告)号:US20210294786A1

    公开(公告)日:2021-09-23

    申请号:US16824933

    申请日:2020-03-20

    Applicant: SAP SE

    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.

    OPTIMAL SORT KEY COMPRESSION AND INDEX REBUILDING

    公开(公告)号:US20190034467A1

    公开(公告)日:2019-01-31

    申请号:US15658671

    申请日:2017-07-25

    Applicant: SAP SE

    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.

    Memory allocation and deallocation mechanism to reduce fragmentation and enhance defragmentation performance

    公开(公告)号:US11461363B2

    公开(公告)日:2022-10-04

    申请号:US16835549

    申请日:2020-03-31

    Applicant: SAP SE

    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.

Patent Agency Ranking