# US 2025/0156433 A1 · Refactoring workbench with migration support > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2025/0156433 A1 - Document ID: US20250156433A1 - Status: Published application - Kind: A1 - Application number: 18/508,705 - Filed: 2023-11-14 - Published: 2025-05-15 - Earliest claimed: 2023-11-14 - Assignees: Sap SE - Applicants: Sap SE - Inventors: Peter Eberlein; Volker Driesen - Web page: https://patentgrep.com/patent/US20250156433A1 ## CPC - G06F 16/2474: {Sequence data queries, e.g. querying versioned data} - G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)} - G06F 16/2282: {Tablespace storage structures; Management thereof} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## 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. ## Claims ### Claim 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; 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; 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; 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 migration test results. ### Claim 2 (depends on 1) 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. ### Claim 3 (depends on 1) 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. ### Claim 4 (depends on 1) 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. ### Claim 5 (depends on 1) 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. ### Claim 6 (depends on 5) 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. ### Claim 7 (depends on 1) 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. ### Claim 8 (depends on 7) 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. ### Claim 9 (depends on 1) The computer-implemented method of claim 1, wherein the migration assessment is executed using scenarios defined based on a structure of the old software product version. ### Claim 10 (depends on 9) The computer-implemented method of claim 9, 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. ### Claim 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; 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; executing a migration test of the one or more database tables using the migration assessment to generate migration test results; 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 migration test results. ### Claim 12 (depends on 11) The computer-implemented system of claim 11, wherein the operations further comprise: displaying structured query language (SQL) views of the old software product version. ### Claim 13 (depends on 11) 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. ### Claim 14 (depends on 11) 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. ### Claim 15 (depends on 11) 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. ### Claim 16 (depends on 15) 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. ### Claim 17 (depends on 11) 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. ### Claim 18 (depends on 17) 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. ### Claim 19 (depends on 11) The computer-implemented system of claim 11, wherein the migration assessment is executed using scenarios defined based on a structure of the old software product version. ### Claim 20 A non-transitory, computer-readable media encoded with a computer program, the computer program comprising instructions that when executed by one or more computers cause the one or more computers to perform 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; 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; executing a migration test of the one or more database tables using the migration assessment to generate migration test results; 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 migration test results.