FIELD

The subject matter disclosed herein generally relates to the technical field of databases and more specifically, databases with dimensional balances updating. The updating enables the transmission of funds, electricity, water, etc. according to a set of dimensional rules.

BACKGROUND

The present subject matter seeks to address technical problems existing in conventional databases. For example, state, national and international regulations govern financial transfers and a payment processor must navigate these regulations by constantly updating a database. However, current databases generally shut down overnight to allow for updating, leading to significant downtown to the database and potential loss of updated information arising while shut down. Further, constraint enforcement is not possible in databases that only do post-hoc reconciliation.

BRIEF SUMMARY

The present disclosure relates generally to a database with dimensional balances updating. Embodiments enable real-time capabilities in databases. That is, embodiments enable a database to answer questions accurately and deny certain impermissible actions (real-time constraint enforcement) based on a completely up-to-date picture of the dimensions. Embodiments further solve the technical problem of database downtime by updating the database in real-time as a transaction occurs instead of blocking access to the database to perform updating and reconciliation overnight.

In some examples, a method for updating a database with dimensional balancing comprises receiving a transaction request to transfer a portion of a first balance from the first balance to a second balance; determining a subset of the first balance less than or equal to the portion in the first balance compliant with dimensional rules based on one or more attributes of the subset and an identifier of an account holding the second balance (the account can be the same account or different account holding the first balance); moving the determined subset from the first balance to the second balance; and updating attributes of the moved subset in the second balance.

A database system having dimensional balance updating can perform the above method. In addition, a non-transitory machine-readable medium comprising instructions which, when read by a machine, can cause the machine to perform operations for updating dimensional balances in a database according to the method.

