知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

23 records (took 0.023 seconds)

    Runtime data persistency for in-memory database systems
    1.
    发明授权
    Runtime data persistency for in-memory database systems 有权

    公开(公告)号：US10853343B2

    公开(公告)日：2020-12-01

    申请号：US15596603

    申请日：2017-05-16

    Applicant: SAP SE

    Inventor： Michael Muehle ,  Chaitanya Gottipati ,  Nirvik Basak ,  Mihnea Andrei

    IPC: G06F16/22 ,  G06F16/245

    Abstract: Systems, apparatus, techniques, articles, and methods include a unified table container for storing data and metadata in pages organized in one or more page chains. A determination is made as to whether the query includes a data definition statement. In response to determining that the query includes a data definition statement, in-memory runtime data is persisted to a persistent volume that is configured to be accessed by the database system. The in-memory runtime data includes one or more first data fields and one or more second data fields that are different from the one or more first data fields. Furthermore, the unified table container includes a persistent runtime data descriptor that is associated with the one or more first data fields and persists the first one or more first data fields when persisting the in-memory runtime data.

    Delayed snapshot isolation for read service at a database
    3.
    发明授权
    Delayed snapshot isolation for read service at a database 有权

    公开(公告)号：US10452636B2

    公开(公告)日：2019-10-22

    申请号：US15361760

    申请日：2016-11-28

    Applicant: SAP SE

    Inventor： Kyu Hwan Kim ,  Juchang Lee ,  Beomsoo Kim ,  Chang Gyoo Park ,  Reiner Singer ,  Christoph Rottering ,  Werner Thesing ,  Michael Muehle

    IPC: G06F16/00 ,  G06F16/23 ,  G06F16/245 ,  G06F16/27

    Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.

    In-place load unit conversion
    5.
    发明授权
    In-place load unit conversion 有权

    公开(公告)号：US11372845B2

    公开(公告)日：2022-06-28

    申请号：US16893703

    申请日：2020-06-05

    Applicant: SAP SE

    Inventor： Deepak Shrivastava ,  Chaitanya Gottipati ,  Colin Florendo ,  Rolando Blanco ,  Michael Muehle ,  Awisha Makwana

    IPC: G06F16/23 ,  G06F16/22 ,  G06F16/2455 ,  G06F12/02 ,  G06F3/06 ,  G06F12/0882 ,  G06F12/0875 ,  G06F9/48

    Abstract: Disclosed herein are system, method, and computer program product embodiments for converting column loadable data in a database into a page loadable format. When a column oriented in-memory database needs to perform an operation on a table, the affected columns must be loaded fully into memory. In some cases, a database may partition tables, allowing for column fragments corresponding to those partitions to be loaded into memory. These column fragments may exceed available memory, such that it is beneficial to convert the column fragment into a page loadable format. Approaches are discussed herein for performing the conversion without the need to update global metadata during the process, allowing for multiple parallel column fragments to be updated, allowing data manipulation language (DML) operations to continue on the column during the conversion process, and reducing the impact of blocked parallel savepoint operations during the conversion process by chunking the conversion process.

    Delayed snapshot isolation for read service at a database
    6.
    发明授权
    Delayed snapshot isolation for read service at a database 有权

    公开(公告)号：US11200221B2

    公开(公告)日：2021-12-14

    申请号：US16576498

    申请日：2019-09-19

    Applicant: SAP SE

    Inventor： Kyu Hwan Kim ,  Juchang Lee ,  Beomsoo Kim ,  Chang Gyoo Park ,  Reiner Singer ,  Christoph Roterring ,  Werner Thesing ,  Michael Muehle

    IPC: G06F16/00 ,  G06F16/23 ,  G06F16/245 ,  G06F16/27

    Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.

    Synchronization mechanism for serialized data log replay in database systems
    7.
    发明授权
    Synchronization mechanism for serialized data log replay in database systems 有权

    公开(公告)号：US10762107B2

    公开(公告)日：2020-09-01

    申请号：US15409234

    申请日：2017-01-18

    Applicant: SAP SE

    Inventor： Colin Florendo ,  Chaitanya Gottipati ,  Michael Muehle ,  Nirvik Basak ,  Mihnea Andrei ,  Thomas Peh

    IPC: G06F16/27

    Abstract: A computer implemented method for updating a secondary database includes receiving transaction log information from a primary database system at a secondary database system. The transaction log information comprises a first marker identifying a beginning of an operation comprising a plurality of sub-operations and a second marker identifying an end of the operation. The transaction log information is sequentially parsed, a first marker is identified, and a lock state is created after replaying the first marker to ensure proper serialization of the plurality of sub-operations. The lock state is terminated after replaying the second marker. Related apparatus, systems, techniques and articles are also described.

    Altering data type of a column in a database
    8.
    发明授权
    Altering data type of a column in a database 有权

    公开(公告)号：US10747737B2

    公开(公告)日：2020-08-18

    申请号：US14552902

    申请日：2014-11-25

    Applicant: SAP SE

    Inventor： Colin Florendo ,  Ivan Schreter ,  Panfeng Zhou ,  David Wein ,  Steffen Geissinger ,  Michael Muehle

    IPC: G06F17/22 ,  G06F16/22

    Abstract: Disclosed herein are system, method, and computer program product embodiments for altering the data type of a column in a database. An embodiment operates by converting an original dictionary associated with a column into a new dictionary. The new dictionary stores the values of the original dictionary using a different data type. An index vector containing the keys of the original dictionary is then updated to contain the associated keys of the new dictionary. Because the size of the original dictionary is often substantially smaller than the number of rows in the associated column, this dictionary conversion decreases the computation cost to the database system of altering the data type of the column and reduces or even minimizes database downtime for users.

    Delayed Snapshot Isolation for Read Service at a Database
    9.
    发明申请
    Delayed Snapshot Isolation for Read Service at a Database 审中-公开

    公开(公告)号：US20200012633A1

    公开(公告)日：2020-01-09

    申请号：US16576498

    申请日：2019-09-19

    Applicant: SAP SE

    Inventor： Kyu Hwan Kim ,  Juchang Lee ,  Beomsoo Kim ,  Chang Gyoo Park ,  Reiner Singer ,  Christoph Roterring ,  Werner Thesing ,  Michael Muehle

    IPC: G06F16/23 ,  G06F16/245

    Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.

Patent Agency Ranking