Data transaction acceleration using multiple data structure types

A non-transitory, computer-readable storage medium comprising a set of instructions which, when executed by one or more processors, causes the one or more processors to perform operations including:

• storing one or more financial ledgers in a relational database system;
• prepopulating a multidimensional data cube using data from the one or more financial ledgers in the relational database system, wherein the multidimensional data cube comprises aggregated balances used by a batch of transactions;
• receiving the batch of transactions;
• executing the batch of transactions using data in the multidimensional data cube, wherein:
• the multidimensional data cube is queried for the aggregated balances;
• and
• the batch of transactions are executed using the queried aggregated balances of the multidimensional data cube to generate result values for each account affected by the batch of transactions;
• generating one or more accounting journal entries that update each account in the one or more ledgers affected by the batch of transactions using the result values from the multidimensional data cube;
• posting the one or more accounting journal entries to the one or more financial ledgers in the relational database system;
• repopulating the multidimensional data cube with changes resulting from the one or more accounting journal entries being posted to the one or more financial ledgers in the relational database system;
• and
• updating the aggregated balances of the multidimensional data cube.

A system comprising:

• one or more processors;
• and
• a non-transitory memory comprising a set of instructions which, when executed by the one or more processors, cause the one or more processors to perform operations including:
• storing one or more financial ledgers in a relational database system;
• prepopulating a multidimensional data cube using data from the one or more financial ledgers in the relational database system, wherein the multidimensional data cube comprises aggregated balances used by a batch of transactions;
• receiving the batch of transactions;
• executing the batch of transactions using data in the multidimensional data cube, wherein:
• the multidimensional data cube is queried for the aggregated balances;
• and
• the batch of transactions are executed using the queried aggregated balances of the multidimensional data cube to generate result values for each account affected by the batch of transactions;
• generating one or more accounting journal entries that update each account in the one or more ledgers affected by the batch of transactions using the result values from the multidimensional data cube;
• posting the one or more accounting journal entries to the one or more financial ledgers in the relational database system;
• repopulating the multidimensional data cube with changes resulting from the one or more accounting journal entries being posted to the one or more financial ledgers in the relational database system;
• and
• updating the aggregated balances of the multidimensional data cube.