US2021125007A1PendingUtilityA1

System for automated database replication and testing

39
Assignee: SALESFORCE COM INCPriority: Oct 25, 2019Filed: Oct 25, 2019Published: Apr 29, 2021
Est. expiryOct 25, 2039(~13.2 yrs left)· nominal 20-yr term from priority
Inventors:Swaroop JayanthiRamalinga Raju KalidindiRamaprasad Venkata SanapalaSatyanarayana Silaparasetti
G06F 16/211G06F 18/24323G06F 18/217G06F 16/27G06F 11/3006G06K 9/6262G06K 9/6282
39
PatentIndex Score
0
Cited by
0
References
0
Claims

Abstract

System and methods are described for automated replication of a database. The method includes generating a replication decision tree (RDT) for a database replication, deploying a database installation according to the RDT, and identifying a replication topology for the database replication according to the RDT. The method further includes loading schemas for one or more source databases and one or more target databases according to the replication topology and the RDT, validating a replication policy, and cloning the one or more source databases to the one or more target databases according to the replication policy.

Claims

exact text as granted — not AI-modified
What is claimed is: 
     
         1 . An apparatus, comprising:
 a processing device; and   a memory device coupled to the processing device, the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:   generate a replication decision tree (RDT) for a database replication;   deploy a database installation according to the RDT;   identify a replication topology for the database replication according to the RDT;   load schemas for one or more source databases and one or more target databases according to the replication topology and the RDT;   validate a replication policy; and   clone the one or more source databases to the one or more target databases according to the replication policy.   
     
     
         2 . The apparatus of  claim 1 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 perform change data capture (CDC) operations on the one or more source databases and the one or more target databases.   
     
     
         3 . The apparatus of  claim 2 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 perform data comparison of the one or more source databases to the one or more target databases to validate the cloning.   
     
     
         4 . The apparatus of  claim 3 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 generate a report of the replication policy-based cloning of the one or more source databases to the one or more target databases.   
     
     
         5 . The apparatus of  claim 1 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 generate the RDT from test cases and test scenarios.   
     
     
         6 . The apparatus of  claim 1 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 identify the replication topology for the database replication as one to one, one to many, or many to one.   
     
     
         7 . The apparatus of  claim 1 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 validate the replication policy by validating syntax and semantics of the replication policy.   
     
     
         8 . The apparatus of  claim 1 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 identify a type and a location of the database installation prior to deployment.   
     
     
         9 . The apparatus of  claim 8 , wherein the type of database installation is one of “system in a box” and “system in a cluster” in a cloud computing environment. 
     
     
         10 . The apparatus of  claim 1 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 provision the one or more source databases and the one or more target databases.   
     
     
         11 . The apparatus of  claim 1 , the memory device having instructions stored thereon that, in response to execution by the processing device, cause the processing device to:
 validation a connection between the one or more source databases and the one or more target databases prior to cloning.   
     
     
         12 . A computer-implemented method comprising:
 generating a replication decision tree (RDT) for a database replication;   deploying a database installation according to the RDT;   identifying a replication topology for the database replication according to the RDT;   loading schemas for one or more source databases and one or more target databases according to the replication topology and the RDT;   validating a replication policy; and   cloning the one or more source databases to the one or more target databases according to the replication policy.   
     
     
         13 . The computer-implemented method of  claim 12 , comprising:
 performing change data capture (CDC) operations on the one or more source databases and the one or more target databases.   
     
     
         14 . The computer-implemented method of  claim 13 , comprising:
 performing data comparison of the one or more source databases to the one or more target databases to validate the cloning.   
     
     
         15 . The computer-implemented method of  claim 14 , comprising:
 generating a report of the replication policy-based cloning of the one or more source databases to the one or more target databases.   
     
     
         16 . The computer-implemented method of  claim 12 , comprising:
 generating the RDT from test cases and test scenarios.   
     
     
         17 . The computer-implemented method of  claim 12 , comprising:
 identifying the replication topology for the database replication as one to one, one to many, or many to one.   
     
     
         18 . The computer-implemented method of  claim 12 , comprising:
 validating the replication policy by validating syntax and semantics of the replication policy.   
     
     
         19 . The computer-implemented method of  claim 12 , comprising:
 identifying a type and a location of the database installation prior to deployment.   
     
     
         20 . The computer-implemented method of  claim 19 , wherein the type of database installation is one of “system in a box” and “system in a cluster” in a cloud computing environment. 
     
     
         21 . The computer-implemented method of  claim 12 , comprising:
 provisioning the one or more source databases and the one or more target databases.   
     
     
         22 . The computer-implemented method of  claim 12 , the memory device comprising:
 validating a connection between the one or more source databases and the one or more target databases prior to cloning.   
     
     
         23 . A tangible, non-transitory computer-readable storage medium having instructions stored thereon which, when executed by a processing device, cause the processing device to:
 generate a replication decision tree (RDT) for a database replication;   deploy a database installation according to the RDT;   identify a replication topology for the database replication according to the RDT;   load schemas for one or more source databases and one or more target databases according to the replication topology and the RDT;   validate a replication policy; and   clone the one or more source databases to the one or more target databases according to the replication policy.   
     
     
         24 . The tangible, non-transitory computer-readable storage medium of  claim 23 , having instructions stored thereon which, when executed by the processing device, cause the processing device to:
 perform change data capture (CDC) operations on the one or more source databases and the one or more target databases.   
     
     
         25 . The tangible, non-transitory computer-readable storage medium of  claim 24 , having instructions stored thereon which, when executed by the processing device, cause the processing device to:
 perform data comparison of the one or more source databases to the one or more target databases to validate the cloning.   
     
     
         26 . The tangible, non-transitory computer-readable storage medium of  claim 23 , having instructions stored thereon which, when executed by the processing device, cause the processing device to:
 generate a report of the replication policy-based cloning of the one or more source databases to the one or more target databases.   
     
     
         27 . The tangible, non-transitory computer-readable storage medium of  claim 23 , having instructions stored thereon which, when executed by the processing device, cause the processing device to:
 generate the RDT from test cases and test scenarios.   
     
     
         28 . The tangible, non-transitory computer-readable storage medium of  claim 23 , having instructions stored thereon which, when executed by the processing device, cause the processing device to:
 identify the replication topology for the database replication as one to one, one to many, or many to one.   
     
     
         29 . The tangible, non-transitory computer-readable storage medium of  claim 23 , having instructions stored thereon which, when executed by the processing device, cause the processing device to:
 validate the replication policy by validating syntax and semantics of the replication policy.

Join the waitlist — get patent alerts

Track US2021125007A1 — get alerts on status changes and closely related new filings.

We store only your email — no account needed. See our privacy policy.