Database Processing After a Lock Condition
    1.
    发明申请

    公开(公告)号:US20170083538A1

    公开(公告)日:2017-03-23

    申请号:US14861438

    申请日:2015-09-22

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.

    Proxy views for extended monitoring of database systems

    公开(公告)号:US11042568B2

    公开(公告)日:2021-06-22

    申请号:US16457170

    申请日:2019-06-28

    Applicant: SAP SE

    Abstract: A computer implemented method for monitoring databases includes providing views for monitoring information associated with a first datacenter and proxy views for monitoring information associated with a second datacenter. The first datacenter receives a query for monitoring information and parses the query to identify filter information that identifies which of the first or second datacenter the requested services are running on. If the filter information indicates the service is running on the first datacenter, the first datacenter queries the views to request the monitoring information from the server on the first datacenter running the requested service. If the filter information indicates the service is running on the second datacenter, the first datacenter queries the proxy views to request the monitoring information from the server on the second datacenter running the requested service, and receives the monitoring information. Related apparatus, systems, techniques and articles are also described.

    Data transfer in a computer-implemented database

    公开(公告)号:US12008012B2

    公开(公告)日:2024-06-11

    申请号:US18054515

    申请日:2022-11-10

    Applicant: SAP SE

    CPC classification number: G06F16/254 G06F16/214 G06F16/221 G06F16/2282

    Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.

    Data transfer in a computer-implemented database

    公开(公告)号:US11526527B2

    公开(公告)日:2022-12-13

    申请号:US16375101

    申请日:2019-04-04

    Applicant: SAP SE

    Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.

    DATABASE MIGRATION
    9.
    发明申请

    公开(公告)号:US20220100715A1

    公开(公告)日:2022-03-31

    申请号:US17210393

    申请日:2021-03-23

    Applicant: SAP SE

    Abstract: 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.

    Synchronized updates across multiple database partitions

    公开(公告)号:US10534797B2

    公开(公告)日:2020-01-14

    申请号:US15365693

    申请日:2016-11-30

    Applicant: SAP SE

    Abstract: A first store and a second store can be configured to store a first partition of a table of a database and a second partition of the table of the database, respectively. A database management system can be configured to at least update at least a first portion of the first partition where the update includes an update to a first primary key column in the first partition and verify that the first primary key column is unique across the first partition and the second partition. A first row having a first primary key value of the first primary key column from the first partition can be deleted, when the first primary key value in the first partition conflicts with a second primary key value of a second primary key column in the second partition.

Patent Agency Ranking