Concurrent request handling for database transactions

摘要

A request handler may receive transaction requests for transactions to be executed using data of a database, and may classify a first transaction request of the transaction requests as a simple transaction request, and a second transaction request of the transaction requests as a complex transaction request. A key-value store engine may execute a first transaction satisfying the first transaction request, using a key-value store of pre-calculated results determined prior to receipt of the first transaction request, and based on the data, and may update a key-value delta reflecting a change, if any, of the key-value store caused by the first transaction. A relational store engine may cause the at least one processor to execute a second transaction satisfying the second transaction request, using a relational store including a subset of the data, and may update a relational delta reflecting a change, if any, of the relational store caused by the second transaction. A synchronizer may execute a synchronization of the key-value store and the relational store, based on the key-value delta and the relational delta.

主权项

1. A system inducting instructions recorded on a computer-readable medium, and executable by at least one processor, the system comprising:
a request handler configured to cause the at least one processor to receive transaction requests for transactions to be executed using data of a database, and further configured to cause the at least one processor to classify a first transaction request of the transaction requests as a simple transaction request, and classify a second transaction request of the transaction requests as a complex transaction request; a key-value store engine configured to cause the at least one processor to execute a first transaction satisfying the first transaction request, using a key-value store of pre-calculated results determined prior to receipt of the first transaction request, and based on the data, and further configured to update a key-value delta reflecting a change, if any, of the key-value store caused by the first transaction, wherein the key-value store engine includes a first invalidity notifier configured to update the relational delta based on the updating of the key-value delta; a relational store engine configured to cause the at least one processor to execute a second transaction satisfying the second transaction request, using a relational store including a subset of the data, and further configured to update a relational delta reflecting a change, if any, of the relational store caused by the second transaction, wherein the relational store engine includes a second invalidity notifier configured to update the key-value delta based on the updating of the relational delta; and a synchronizer configured to cause the at least one processor to execute a two-way synchronization between the key-value store and the relational store, based on the key-value delta and the relational delta.