Efficiently modeling database scenarios for later use on live data

US11449952B2 · kind B2 · utility

Assignee

• Oracle International Corporation · US

Inventors

• Chi Ken Yeung · San Ramon, US
• Ravi Shankar · Jamkhed, IN
• Sondhi · Fremont, US
• Amira A. Morcos · San Ramon, US
• Eva Kifri · Antioch, US
• Dave Altendorf · San Ramon, US
• Qing Du · Pleasanton, US
• Hsiaowen Mou · Brentwood, US
• David James Bell · Folsom, US

Key dates

• Filing date: Oct 1, 2012
• Grant date: Sep 20, 2022
• Expiry date: Jul 23, 2033

Classification

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

Abstract

A method of modeling a scenario for use with live data in a production database may include selecting the scenario. The live data can be stored in the production database on a first computing resource, and production scenarios can be stored and executed on the live data using the first computing resource. The method may also include identifying a subset of the live data that are affected by the scenario, copying the subset to a second computing resource to create modeling data, running the scenario on the modeling data using the second computing resource, causing a display device to provide an output comprising a result of the scenario on the modeling data, receiving an input indicating that the scenario is approved, and storing the scenario with the plurality of production scenarios for use on the first computing resource.