Oracle International Corporation

Abhijit Dhakephalkar

David Joseph Haimes

Rondy C Ng

Robert Cooke Zwiebach

Zeesha Currimbhoy

Arunesh C Banerjee

A method of accelerating transactions for a relational database using a pre-populated multidimensional data cube includes pre-populating the multidimensional data cube based on values from the relational database system; executing one or more transactions using values in the multidimensional data cube instead of using the values from the relational database system; generating one or more entries that update the relational database system using results generated from executing the one or more transactions; posting the one or more entries to the relational database system; and repopulating the multidimensional data cube based on values from the relational database system that changed as a result of posting the one or more entries to the relational database system.

Data transaction acceleration using multiple data structure types

A method of accelerating execution of a transactions includes storing financial ledgers in a relational database, prepopulating a multidimensional data cube using the relational database, executing the transactions using the data cube by querying the data cube for aggregated balances to generate result values, generating accounting journal entries that update each account in the ledgers affected by the transactions using the result values from the data cube, posting the accounting journal entries to the financial ledgers in the relational database, repopulating the data cube with the changes resulting from the posted journal entries, and updating the aggregated balances of the data cube.

A method of using rules to execute periodic allocations of funds in a hierarchal accounting structure may include receiving an allocation rule, comprising a source account, a rule for determining a first amount, a parent account, and an allocation basis; accessing a multidimensional data cube comprising a hierarchal arrangement and aggregated balances for each level of the hierarchal arrangement; generating an allocation scenario by allocating the first amount to the aggregated balances for the one or more child accounts according to the allocation rule; generating one or more accounting journal entries corresponding to the allocation scenario; posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating, using the relational database, the multidimensional data cube to reflect the allocation scenario.

Allocation manager

A method of using a formula to execute periodic transfers in a hierarchal accounting structure includes receiving a transfer formula that may comprise a source account, a target account, an offset account, an account characteristic, and a formula for determining a first amount of the source account based on the account characteristic. The method may also include accessing a multidimensional data cube with a hierarchal arrangement and aggregated balances for each level. The method may additionally include generating a transfer scenario by transferring the first amount to the aggregated balance for the target account according to the transfer formula, and generating one or more accounting journal entries corresponding to the transfer scenario. The method may further include posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating the multidimensional data cube to reflect the transfer scenario.

Growing community of inventors

Hyderabad Telangana, India

Abhijit Dhakephalkar