US 11,989,169 B2
Autonomous refactoring system for database
Jyoti Ranjan, Hyderabad (IN)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by Salesforce, Inc., San Francisco, CA (US)
Filed on May 9, 2022, as Appl. No. 17/662,485.
Prior Publication US 2023/0359605 A1, Nov. 9, 2023
Int. Cl. G06F 16/22 (2019.01); G06F 16/31 (2019.01)
CPC G06F 16/2272 (2019.01) [G06F 16/328 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for performing a refactoring process on a database system, comprising:
receiving, by a computer system from a requesting computer system, a request to access first data from the database system, wherein the request conforms to a relational database application programming interface (API), wherein the database system includes a relational database storing structured data and unstructured data that is being refactored according to the refactoring process such that the unstructured data is stored in a non-relational database;
determining, by the computer system, that a first database element within the relational database that includes the first data has not yet been refactored;
retrieving, by the computer system, the requested first data from the first database element;
providing, by the computer system, the requested first data to the requesting computer system;
performing, by the computer system, a refactoring operation for the first database element, wherein the refactoring operation includes:
storing a portion of data in the first database element identified as unstructured data in the non-relational database; and
including, in the relational database, a reference to a location of the portion of data in the non-relational database; and
storing, by the computer system, refactoring information indicating that the first database element has been refactored.