System and method for batch database modification

A system to alter a database structure in a distributed computing system, the system comprising:

• one or more hardware processors associated with a cloud service;
• and
• a non-transitory memory, the non-transitory memory storing instructions that, when executed by the one or more hardware processors, causes the one or more hardware processors to perform actions comprising:
• receiving a first document object comprising a first alteration to a first structural element of the database structure;
• receiving a second document object comprising a second alteration to the first structural element of the database structure;
• identifying a plurality of alterations to the first structural element, wherein the plurality of alterations to the first structural element comprises the first alteration and the second alteration;
• resolving the plurality of alterations to the first structural element to generate a combined alteration by combining one or both of redundant or conflicting alterations of the plurality of alterations based on a precedence metric that indicates that the first document object has a higher precedence than the second document object;
• and
• generating a database statement to alter the first structural element based on the combined alteration, wherein the database statement is used to update the database structure.

A method to alter a database structure in a distributed computing system, the method comprising:

• receiving a first eXtensible Markup Language (XML) file comprising a first alteration to a first structural element of the database structure;
• receiving a second XML file comprising a second alteration to the first structural element of the database structure;
• identifying a plurality of alterations to the first structural element, wherein the plurality of alterations to the first structural element comprises the first alteration and the second alteration;
• resolving the plurality of alterations to the first structural element to generate a combined alteration by combining one or both of redundant or conflicting alterations of the plurality of alterations based on a precedence metric that indicates that the first XML file has a higher precedence than the second XML file;
• and
• generating a database statement to alter the first structural element based on the combined alteration, wherein the database statement is used to update the database structure.

A non-transitory computer-readable medium comprising computer readable code, that when executed by one or more processors, causes the one or more processors to perform operations comprising:

• receiving a first document object comprising a first alteration to a first structural element of a database structure;
• receiving a second document object comprising a second alteration to the first structural element of the database structure;
• identifying a plurality of alterations to the first structural element, wherein the plurality of alterations to the first structural element comprises the first alteration and the second alteration;
• resolving the plurality of alterations to the first structural element to generate a combined alteration by combining one or both of redundant or conflicting alterations of the plurality of alterations based on a precedence metric that indicates that the first document object has a higher precedence than the second document object;
• and
• generating a database statement to alter the first structural element based on the combined alteration;
• and
• update the database structure based on the database statement.