Pre-migration detection and resolution of issues in migrating databases systems

    公开(公告)号:US11550765B1

    公开(公告)日:2023-01-10

    申请号:US17487026

    申请日:2021-09-28

    Applicant: SAP SE

    Abstract: Implementations include providing, by a computer-executed migration advisor executing within a run-time of a source database system, a query data set including queries processed by the source database system during production use of the source database system, providing, by the migration advisor, an object data set including data representative of database objects stored within a database of the source database system, generating, by the migration advisor, a list of query-level features and a list of object-level features, each feature in the list of query-level features and each feature in the list of object-level features including a feature that is deprecated in a target database system, resolving one or more issues represented by features of one or more of the list of query-level features and the list of object-level features, and executing migration of the database of the source database system to the database of the target database system.

    Dynamic topology switch for data replication

    公开(公告)号:US11258852B2

    公开(公告)日:2022-02-22

    申请号:US16885505

    申请日:2020-05-28

    Applicant: SAP SE

    Abstract: The present disclosure involves systems, software, and computer implemented methods for performing dynamic topology switch in a failover operation. In one example, a failover of a first node is determined. The first node includes a first data server and a first replication server. At least one user application connects to the first data server prior to the failover of the first node. In response to the determined failover, the at least one user application is connected to a second data server of a second node. The second node includes the second data server and a second replication server. Prior to the failover of the first node, a data replication topology of the second node is a remote topology. During the failover, if the first replication server on the first node is down, the data replication topology of the second node is switched from the remote topology to a local topology.

    DATABASE MIGRATION
    3.
    发明申请

    公开(公告)号: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.

    DYNAMIC TOPOLOGY SWITCH FOR DATA REPLICATION

    公开(公告)号:US20200296160A1

    公开(公告)日:2020-09-17

    申请号:US16885505

    申请日:2020-05-28

    Applicant: SAP SE

    Abstract: The present disclosure involves systems, software, and computer implemented methods for performing dynamic topology switch in a failover operation. In one example, a failover of a first node is determined. The first node includes a first data server and a first replication server. At least one user application connects to the first data server prior to the failover of the first node. In response to the determined failover, the at least one user application is connected to a second data server of a second node. The second node includes the second data server and a second replication server. Prior to the failover of the first node, a data replication topology of the second node is a remote topology. During the failover, if the first replication server on the first node is down, the data replication topology of the second node is switched from the remote topology to a local topology.

    Dynamic topology switch for data replication

    公开(公告)号:US10771551B2

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

    申请号:US15471294

    申请日:2017-03-28

    Applicant: SAP SE

    Abstract: The present disclosure involves systems, software, and computer implemented methods for performing dynamic topology switch in a failover operation. In one example, a failover of a first node is determined. The first node includes a first data server and a first replication server. At least one user application connects to the first data server prior to the failover of the first node. In response to the determined failover, the at least one user application is connected to a second data server of a second node. The second node includes the second data server and a second replication server. Prior to the failover of the first node, a data replication topology of the second node is a remote topology. During the failover, if the first replication server on the first node is down, the data replication topology of the second node is switched from the remote topology to a local topology.

    DYNAMIC TOPOLOGY SWITCH FOR DATA REPLICATION

    公开(公告)号:US20180288146A1

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

    申请号:US15471294

    申请日:2017-03-28

    Applicant: SAP SE

    Abstract: The present disclosure involves systems, software, and computer implemented methods for performing dynamic topology switch in a failover operation. In one example, a failover of a first node is determined. The first node includes a first data server and a first replication server. At least one user application connects to the first data server prior to the failover of the first node. In response to the determined failover, the at least one user application is connected to a second data server of a second node. The second node includes the second data server and a second replication server. Prior to the failover of the first node, a data replication topology of the second node is a remote topology. During the failover, if the first replication server on the first node is down, the data replication topology of the second node is switched from the remote topology to a local topology.

Patent Agency Ranking