Executing transactions on distributed databases

A distributed database system comprising:

• a query server;
• a distributed database including a plurality of data servers;
• and
• a non-transitory computer readable storage medium for storing instructions that when executed by a computer processor cause the computer processor to perform steps for exacting a transaction in the distributed database, the steps comprising:
• receiving, by the distributed database system, a transaction including a statement, the statement including instructions for modification of a record stored at a data server of the plurality of data servers;
• executing, at the query server of the distributed database system, the transaction, the execution of the transaction comprising:
• obtaining a record copy of the record corresponding to the statement at the query server;
• performing the modification corresponding to the statement on the record copy at the query server;
• and
• storing the modified record copy at the query server;
• and
• responsive to completing execution of the transaction at the query server, updating the record at the data server based on the modified record copy, the updating preventing conflicts with modifications of the record corresponding to other transactions executed by the distributed database system.

A non-transitory computer readable storage medium for storing instructions that when executed by a computer processor cause the computer processor to perform steps for exacting a transaction in a distributed database, the steps comprising:

• receiving, by a distributed database system comprising a query server and a plurality of data servers, a transaction including a statement, the statement including instructions for modification of a record stored at a data server of the plurality of data servers;
• executing, at the query server of the distributed database system, the transaction, the execution of the transaction comprising:
• obtaining a record copy of the record corresponding to the statement at the query server;
• performing the modification corresponding to the statement on the record copy at the query server;
• and
• storing the modified record copy at the query server;
• and
• responsive to completing execution of the transaction at the query server, updating the record at the data server based on the modified record copy, the updating preventing conflicts with modifications of the record corresponding to other transactions executed by the distributed database system.