US 12,423,356 B2
Systems and methods of programmatic control of scaling read requests to a database system
Venkatesan Chandrasekaran, San Francisco, CA (US); Valliappan Annamalai Natarajan, San Francisco, CA (US); and Sidarth Srinivas Conjeevaram, New Haven, CT (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by Salesforce, Inc., San Francisco, CA (US)
Filed on Dec. 16, 2021, as Appl. No. 17/552,424.
Prior Publication US 2023/0195799 A1, Jun. 22, 2023
Int. Cl. G06F 16/903 (2019.01)
CPC G06F 16/90335 (2019.01) 14 Claims
OG exemplary drawing
 
1. A method comprising:
modifying, at a server that is communicatively coupled to a database system that includes a primary node and one or more standby nodes, a class of an application program that includes one or more nested classes to route a request that is a read-only request to the database system to the one or more standby nodes of the database system for an operation performed by the one or more of the nested classes, wherein the modifying the class of the application program to route the request to the database system to the one or more standby nodes for the operation performed by the one or more of the nested classes when the application program receives an input to execute the modified class that includes the one or more nested classes;
executing, at the server, based on the input, the operation of the modified class of the application program that includes the one or more nested classes;
transmitting, at the server executing the application program, the read-only request to the database system for data to complete the executing of the operation of the modified class;
routing, at the database system, the read-only request to one standby node of the one or more standby nodes to handle the read-only request for the data; and
transmitting, at the standby node, the retrieved data to the server to complete the execution of the operation of the modified class for the application program.