US 12,461,899 B2
Automatic sequencing of database objects
Jahangeer Pasha Mohammed, Milton (CA); and Polu Ram Charan Teja, Hyderabad (IN)
Assigned to Dell Products L.P., Round Rock, TX (US)
Filed by Dell Products L.P., Round Rock, TX (US)
Filed on Apr. 21, 2022, as Appl. No. 17/725,968.
Prior Publication US 2023/0342341 A1, Oct. 26, 2023
Int. Cl. G06F 16/21 (2019.01); G06F 9/48 (2006.01)
CPC G06F 16/212 (2019.01) [G06F 9/4881 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
obtaining two or more database scripts to be executed on at least one database, wherein each database script is associated with one or more database objects and comprises at least one value indicative of an order in which the database script is to be executed, and wherein the at least one value for at least two of the database scripts comprises a same value that creates a conflict in an execution order of the two or more database scripts;
determining that at least one of the database scripts is associated with two or more database object types and, in response, dividing the at least one database script into multiple parts, wherein each of the parts corresponds to one of the two or more database object types;
for each of the two or more database scripts: parsing the database script to identify object information corresponding to the one or more database objects associated with the database script, and determining one or more dependencies of the one or more database objects based at least in part on the object information, wherein at least one of the one or more database objects for at least one of the two or more database scripts comprises a new database object that does not exist in the at least one database, and wherein the determining comprises: (i) obtaining information corresponding to dependent objects and dependency levels associated with the new database object based on one or more reference keys associated with the new database object and (ii) recursively identifying one or more dependencies for the new database object based at least in part on the obtained information;
automatically adjusting the order in which the two or more database scripts are to be executed to resolve the conflict in the execution order, wherein the adjusting is based at least in part on the object dependencies of the one or more database objects determined for each of the two or more database scripts; and
initiating an execution of the two or more database scripts in accordance with the adjusted order;
wherein the method is performed by at least one processing device comprising a processor coupled to a memory.