# US 2021/0240692 A1 · Unified database transition tool > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2021/0240692 A1 - Document ID: US20210240692A1 - Status: Published application - Kind: A1 - Application number: 16/777,050 - Filed: 2020-01-30 - Published: 2021-08-05 - Earliest claimed: 2020-01-30 - Assignees: Dell Products L.P. - Applicants: Dell Products L.P. - Inventors: Emilio De Oliveira; Daniel Gomes - Web page: https://patentgrep.com/patent/US20210240692A1 ## CPC - G06F 16/2365: {Ensuring data consistency and integrity} - G06F 16/214: {Database migration support} - G06N 20/00: Machine learning - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS ## Abstract Disclosed are a system and method for transitioning a database from one computer environment to another according to a standard workflow. An individual issues a command relating to transition to the system, and a transition management processor selects an associated sequence of technical transition processes according to a dynamic, best practices workflow. Each such process is performed by a corresponding module in the system, which is first configured by the processor according to which environment the command pertains. Some of the modules may be built-in, while some of the modules may be provided by third parties, including the database vendor. After each module performs its respective process, it generates a report, and when all modules have completed the processor transmits to the individual a response based on the produced reports, e.g. as a webpage. ## Claims ### Claim 1 A method of transitioning a database from a pre-production environment to a production environment, the method comprising: in response to receiving commands from each of a plurality of users, by a transition management processor comprising hardware, the transition management processor: retrieving, from a data storage repository according to a best practices workflow, a sequence of processes that implement each received command; for each process in the retrieved sequence, configuring a database analysis module according to whether the command pertains to the pre-production environment or the production environment, then executing the process using the database analysis module to produce a report; and transmitting, to the commanding user, a response based on the produced reports. ### Claim 2 (depends on 1) The method according to claim 1, further comprising the transition management processor storing the produced reports in the data storage repository. ### Claim 3 (depends on 1) The method according to claim 1, wherein the plurality of users includes a first database administrator (DBA), and a first sequence of the processes comprises automatically: predicting common transition errors, auditing compliance of data in the database in accordance with the production environment, and validating a maintenance plan. ### Claim 4 (depends on 3) The method according to claim 3, wherein the common transition errors include data connection errors, or insufficient disk space errors, or invalid database indexes, or database users having improper data access permissions, or data lookup performance errors, or unused data errors, or improper database software patching errors, or any combination thereof. ### Claim 5 (depends on 3) The method according to claim 3, wherein a second sequence of the processes comprises repeatedly requesting manual review by a second DBA of the reports of the predicting, auditing and validating processes, until the second DBA either approves or rejects each such process. ### Claim 6 (depends on 5) The method according to claim 5, wherein repeatedly requesting comprises transmitting one or more emails to the second DBA, to a manager of the second DBA, or both. ### Claim 7 (depends on 5) The method according to claim 5, wherein a third sequence of the processes comprises, after the second DBA approves the predicting, auditing, and validating processes, transmitting a stabilization period beginning email to the first DBA. ### Claim 8 (depends on 7) The method according to claim 7, wherein a fourth sequence of the database analysis processes comprises, waiting a fixed duration after transmitting the stabilization period beginning email, then transmitting a stabilization period ending email to the first DBA and to the second DBA. ### Claim 9 (depends on 3) The method according to claim 3, wherein predicting the common transition errors is performed by a machine learning module. ### Claim 10 (depends on 9) The method according to claim 9, wherein the machine learning module operates by determining information about the database and an operating system in the pre-production environment using which the database is executing. ### Claim 11 (depends on 10) The method according to claim 10, wherein the machine learning module further operates by performing an automated analysis of the operating system to compute operating system parameters. ### Claim 12 (depends on 11) The method according to claim 11, wherein the machine learning module further operates by performing an automated analysis of the database to compute database parameters. ### Claim 13 (depends on 12) The method according to claim 12, wherein the machine learning module further operates by classifying the operating system parameters and the database parameters according to a model for predicting the common transition errors. ### Claim 14 (depends on 13) The method according to claim 13, wherein the machine learning module further operates by training the model according to the classification. ### Claim 15 (depends on 13) The method according to claim 13, wherein the machine learning module further operates by generating reports, based on the classification, of a transition failure prediction, of potential problems caused by the common issues, and of the pre-production environment. ### Claim 16 (depends on 15) The method according to claim 15, wherein the machine learning module further operates by transmitting the generated reports to the first DBA. ### Claim 17 A system for transitioning a database from a pre-production environment into a production environment, the system comprising: a plurality of modules, each for performing a respective process; a data storage repository for storing associations between each of a plurality of commands and a corresponding plurality of configurable sequences of the processes that implement the command; and a transition management processor comprising hardware for, in response to receiving a command from a user: retrieving, from the data storage repository according to a best practices workflow, the sequence of processes that implement the received command; for each process in the retrieved sequence, configuring the respective module in the plurality of modules according to whether the command pertains to the pre-production environment or the production environment, then executing the process using the respective module to produce a report; and transmitting, to the user, a response based on the produced reports. ### Claim 18 (depends on 17) The system according to claim 17, wherein the data storage repository comprises a database. ### Claim 19 (depends on 17) The system according to claim 17, wherein the plurality of modules includes a module that predicts common transition failures according to a machine learning model.