Data transaction acceleration using multiple data structure types

US10242409B2 · kind B2 · utility

Assignee

• Oracle International Corporation · US

Inventors

• Abhijit Dhakephalkar · Hyderabad, IN
• David Haimes · Belmont, US
• Arunesh C. Banerjee · Fremont, US
• Zeesha Currimbhoy · Mountain View, US
• Robert C. Zwiebach · San Mateo, US
• Rondy Ng · Redwood Shores, US

Key dates

• Filing date: Apr 11, 2014
• Grant date: Mar 26, 2019
• Expiry date: Apr 17, 2036

Classification

• Technology area (CPC G): Physics
• CPC primary: G06Q40/02
• WIPO field: IT methods for management
• WIPO sector: Electrical engineering

Abstract

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.