FAST RESTART OF APPLICATIONS USING SHARED MEMORY

    公开(公告)号:US20190324648A1

    公开(公告)日:2019-10-24

    申请号:US16503122

    申请日:2019-07-03

    Applicant: SAP SE

    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).

    Group garbage collection for multi-version concurrency control in database systems

    公开(公告)号:US10360146B2

    公开(公告)日:2019-07-23

    申请号:US15231566

    申请日:2016-08-08

    Applicant: SAP SE

    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.

    HARMONIZED STRUCTURED QUERY LANGUAGE AND NON-STRUCTURED QUERY LANGUAGE QUERY PROCESSING

    公开(公告)号:US20180293276A1

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

    申请号:US15483690

    申请日:2017-04-10

    Applicant: SAP SE

    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.

    Asynchronous index loading for database computing system startup latency managment

    公开(公告)号:US10740311B2

    公开(公告)日:2020-08-11

    申请号:US14853569

    申请日:2015-09-14

    Applicant: SAP SE

    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.

    Multi-user database execution plan caching

    公开(公告)号:US10459889B2

    公开(公告)日:2019-10-29

    申请号:US15615504

    申请日:2017-06-06

    Applicant: SAP SE

    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.

    MULTI-USER DATABASE EXECUTION PLAN CACHING
    7.
    发明申请

    公开(公告)号:US20180349404A1

    公开(公告)日:2018-12-06

    申请号:US15615504

    申请日:2017-06-06

    Applicant: SAP SE

    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.

Patent Agency Ranking