公开(公告)号：US10713277B2

公开(公告)日：2020-07-14

申请号：US15794424

申请日：2017-10-26

Applicant: SAP SE

Inventor： Ulrich Auer ,  Ralf-Juergen Hauck ,  Heiko Konrad ,  Kerstin Hoeft ,  Florian Thomas ,  Volker Driesen

IPC: G06F16/00 ,  G06F16/27 ,  G06F16/23 ,  G06F15/16 ,  G06F16/22 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/21 ,  G06F16/25 ,  G06F16/951 ,  G06F16/248 ,  G06F11/14 ,  G06F21/62 ,  G06F8/65

Abstract: The present disclosure teaches solutions for patching content in database systems. In one example, a deployment package for an upgrade of a database system to a new system is received, and the content is deployed to a shared container. Shared objects are identified that are completely stored in the shared container, and partially-shared objects are identified where those objects have a shared portion in the shared container and a tenant portion in one or more tenant containers. First shared content is determined for the shared objects, while second shared content is determined for partially-shared objects. The first and second shared content is then deployed to the shared container. Local content is determined for the partially-shared objects and is deployed to each tenant container. Local content is then identified for local objects and is also deployed to each respective tenant container. Accordingly, both shared and tenant content is deployed.

公开(公告)号：US09881035B2

公开(公告)日：2018-01-30

申请号：US14568959

申请日：2014-12-12

Applicant: SAP SE

Inventor： Andrey Engelko ,  Klaus Daschakowsky ,  Joerg Schoen ,  Florian Thomas ,  Christiane Valentin

IPC: G06F17/30

CPC classification number: G06F17/303 ,  G06F17/30595

Abstract: A system and method for database migration is provided. In an example embodiment, the database migration technique may include a first connection to a relational database, a second connection to an in-memory database, and a migration framework to analyze the data structures of the relational database so as to identify first and second subsets of data structures. The first subset of data structures is migrated to the in-memory database during an uptime period of the relational database, and the second subset of data structures is migrated to the in-memory database during a downtime period of the relational database.

公开(公告)号：US20190130010A1

公开(公告)日：2019-05-02

申请号：US15794424

申请日：2017-10-26

Applicant: SAP SE

Inventor： Ulrich Auer ,  Ralf-Juergen Hauck ,  Heiko Konrad ,  Kerstin Hoeft ,  Florian Thomas ,  Volker Driesen

IPC: G06F17/30 ,  G06F21/62 ,  G06F11/14

CPC classification number: G06F16/27 ,  G06F8/65 ,  G06F11/1464 ,  G06F15/16 ,  G06F16/211 ,  G06F16/2264 ,  G06F16/2272 ,  G06F16/2282 ,  G06F16/2365 ,  G06F16/2452 ,  G06F16/24553 ,  G06F16/248 ,  G06F16/258 ,  G06F16/951 ,  G06F21/6218 ,  G06F2201/80

Abstract: The present disclosure involves systems, software, and computer implemented methods for patching content in database systems. One example method includes receiving a deployment package for an upgrade of a database system to a new version. Content is deployed to a shared container. Shared objects are identified that are completely stored in the shared container. First shared content is determined for shared objects. Partially-shared objects are identified that have a shared portion in the shared container and a tenant portion in one or more tenant containers. Second shared content is determined for partially-shared objects. The first shared and second shared content are deployed to the shared container. Local content is determined for the partially-shared objects and deployed to each tenant container. Local objects that have no data in the shared container are identified. Local content is identified for the local objects and deployed to each respective tenant container.

公开(公告)号：US20180210880A1

公开(公告)日：2018-07-26

申请号：US15416125

申请日：2017-01-26

Applicant: SAP SE

Inventor： Florian Thomas ,  Christiane Valentin ,  Joerg Schoen ,  Stefan Krebs

IPC: G06F17/30

Abstract: Methods, systems, and computer-readable storage media for data migration in an upgrade procedure executed on a software system include actions of initiating the upgrade procedure, determining a first set of tables of a source database that include data to be converted before being first written to a target database, converting data of the first set of tables to provide first converted data, and writing the converted data to one or more tables in the target database.

公开(公告)号：US10754833B2

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

申请号：US15416125

申请日：2017-01-26

Applicant: SAP SE

Inventor： Florian Thomas ,  Christiane Valentin ,  Joerg Schoen ,  Stefan Krebs

IPC: G06F16/21 ,  G06F16/25

Abstract: Methods, systems, and computer-readable storage media for data migration in an upgrade procedure executed on a software system include actions of initiating the upgrade procedure, determining a first set of tables of a source database that include data to be converted before being first written to a target database, converting data of the first set of tables to provide first converted data, and writing the converted data to one or more tables in the target database.

公开(公告)号：US20170139960A1

公开(公告)日：2017-05-18

申请号：US14945192

申请日：2015-11-18

Applicant: SAP SE

Inventor： Andreas Lober ,  Florian Thomas ,  Christiane Valentin ,  Wieland Hoprich

IPC: G06F17/30

CPC classification number: G06F16/2228 ,  G06F16/21 ,  G06F16/214 ,  G06F16/2282

Abstract: A database definition language (DDL) description of a database table can be copied to create a temporary copy of the database table as part of a table upgrade to change a structure of the database table to an upgraded structure. The temporary copy of the database table can be renamed, and the DDL description in the temporary copy of the database table can be changed to an intermediate state while a runtime object and a database object of the database table remain in original states. The changed DDL description can be activated in the temporary copy of the database table such that the runtime object and the database object are updated to the intermediate state, and the temporary copy of the database table can be renamed to an original name of the database table, thereby activating the temporary copy as the database table with the upgraded structure.

公开(公告)号：US20160170977A1

公开(公告)日：2016-06-16

申请号：US14568959

申请日：2014-12-12

Applicant: SAP SE

Inventor： Andrey Engelko ,  Klaus Daschakowsky ,  Joerg Schoen ,  Florian Thomas ,  Christiane Valentin

IPC: G06F17/30

CPC classification number: G06F17/303 ,  G06F17/30595

Abstract: A system and method for database migration is provided. In an example embodiment, the database migration technique may include a first connection to a relational database, a second connection to an in-memory database, and a migration framework to analyze the data structures of the relational database so as to identify first and second subsets of data structures. The first subset of data structures is migrated to the in-memory database during an uptime period of the relational database, and the second subset of data structures is migrated to the in-memory database during a downtime period of the relational database.

Abstract translation: 提供了一种用于数据库迁移的系统和方法。 在示例实施例中，数据库迁移技术可以包括到关系数据库的第一连接，到内存数据库的第二连接，以及用于分析关系数据库的数据结构以便识别第一和第二子集的迁移框架 的数据结构。 数据结构的第一个子集在关系数据库的正常运行期间迁移到内存数据库，并且数据结构的第二个子集在关系数据库的停机期间迁移到内存数据库。