Refactoring workbench with migration support

Patent metadata

Field	Value
Publication number	US-12499116-B2
Application number	US-202318508705-A
Country	US
Kind code	B2
Filing date	Nov 14, 2023
Priority date	Nov 14, 2023
Publication date	Dec 16, 2025
Grant date	Dec 16, 2025

Abstract

The disclosure generally describes methods, software, and systems for re-architecting an existing software product provided as a service. A user input specifying current databases used for an old software product version is received. The user input includes a definition of a target persistency layout including databases assigned for storing a new software product version, the old software product version including one or more database tables and the new software product version including an adjustment to the one or more database tables to generate one or more target database tables. Sizes of the one or more database tables are read from a catalog of a database. A migration assessment of the new software product version is generated based on the sizes of the one or more database tables. A migration test of the one or more database tables is executed using the migration assessment to generate migration test results. An updated adjustment to the one or more database tables is provided based on the migration test results.

First claim

What is claimed is:

1 . A computer-implemented method comprising: receiving, by one or more processors, a user input specifying current databases used for an old software product version, the user input comprising a definition of a target persistency layout comprising databases assigned for storing a new software product version undergoing a development process, the old software product version comprising an application code defining interactions with data stored in one or more database tables and the new software product version comprising an adjustment to the application code associated with a migration of the data to one or more target database tables, the development process comprising an assignment of the data generated by the new software product version, being developed, to the one or more target database tables;
reading, by the one or more processors, sizes of the one or more database tables from a catalog of a database; generating, by the one or more processors, a migration assessment of the new software product version based on the sizes of the one or more database tables, wherein the migration assessment is executed using scenarios defined based on a structure of the old software product version, wherein the scenarios define transformations to the one or more database tables based on one or more determined limitations of the one or more database tables; executing, by the one or more processors, a migration test of the one or more database tables using the migration assessment to generate migration test results, wherein the migration test results define an impact of re-design options of the new software product version during the development process; and providing, by the one or more processors, an updated adjustment to the one or more database tables and a rearchitecture of the new software product version, during the development process, based on the impact of the re-design options of the new software product version defined by the migration test results.

2 . The computer-implemented method of claim 1 , further comprising:
displaying, by the one or more processors, structured query language (SQL) views of the old software product version.

3 . The computer-implemented method of claim 1 , further comprising:
determining, by the one or more processors, extensions to the one or more database tables by comparing database key fields and field types of the one or more database tables and of the one or more target database tables.

4 . The computer-implemented method of claim 1 , wherein the adjustment to the one or more database tables comprises at least one of a modification of a table structure or a database type.

5 . The computer-implemented method of claim 1 , wherein the adjustment to the one or more database tables comprises applying an operation to the one or more database tables.

6 . The computer-implemented method of claim 5 , wherein the operation comprises at least one of a merge or a split of the one or more database tables.

7 . The computer-implemented method of claim 1 , wherein the migration test results comprise migration parameters comprising migration durations of migration phases and a migration volume for the one or more database tables to be moved to a target database.

8 . The computer-implemented method of claim 7 , wherein the migration test comprises an identification of source database instances and target database instances of a same type.

9 . The computer-implemented method of claim 1 , wherein the migration assessment comprises generating one or more virtual database tables comprising data flow operators that define table field data structures.

10 . The computer-implemented method of claim 9 , wherein the migration assessment comprises querying content of a remote database using the one or more virtual database tables.

11 . A computer-implemented system comprising:
memory storing application programming interface (API) information; and a server performing operations comprising:
receiving a user input specifying current databases used for an old software product version, the user input comprising a definition of a target persistency layout comprising databases assigned for storing a new software product version undergoing a development process, the old software product version comprising an application code defining interactions with data stored in one or more database tables and the new software product version comprising an adjustment to the application code associated with a migration of the data to one or more target database tables, the development process comprising an assignment of the data generated by the new software product version, being developed, to the one or more target database tables;
reading sizes of the one or more database tables from a catalog of a database;
generating a migration assessment of the new software product version based on the sizes of the one or more database tables, wherein the migration assessment is executed using scenarios defined based on a structure of the old software product version, wherein the scenarios define transformations to the one or more database tables based on one or more determined limitations of the one or more database tables;
executing a migration test of the one or more database tables using the migration assessment to generate migration test results, wherein the migration test results define an impact of re-design options of the new software product version during the development process; and
providing an updated adjustment to the one or more database tables and a rearchitecture of the new software product version, during the development process, based on the impact of the re-design options of the new software product version defined by the migration test results.

12 . The computer-implemented system of claim 11 , wherein the operations further comprise:
displaying structured query language (SQL) views of the old software product version.

13 . The computer-implemented system of claim 11 , wherein the operations further comprise:
determining extensions to the one or more database tables by comparing database key fields and field types of the one or more database tables and of the one or more target database tables.

14 . The computer-implemented system of claim 11 , wherein the adjustment to the one or more database tables comprises at least one of a modification of a table structure or a database type.

15 . The computer-implemented system of claim 11 , wherein the adjustment to the one or more database tables comprises applying an operation to the one or more database tables.

16 . The computer-implemented system of claim 15 , wherein the operation comprises at least one of a merge or a split of the one or more database tables.

17 . The computer-implemented system of claim 11 , wherein the migration test comprise migration parameters comprising migration durations of migration phases and a migration volume weight for the one or more database tables to be moved to a target database.

18 . The computer-implemented system of claim 17 , wherein the migration test comprises an identification of source database instances and target database instances of a same type.

19 . The computer-implemented system of claim 11 , wherein the migration assessment comprises generating one or more virtual database tables comprising data flow operators that define table field data structures.

20 . A non-transitory, computer-readable media encoded with a computer program, the computer program comprising ins

Assignees

• Sap Se

Inventors

• Eberlein Peter
• Driesen Volker

Classifications

• G06F16/217 Primary

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/2474 Primary

  Sequence data queries, e.g. querying versioned data · CPC title