Data transaction acceleration using multiple data structure types

US10650473B2 · 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: Jan 23, 2019
• Grant date: May 12, 2020
• Expiry date: Jan 23, 2039

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 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.