US 11,907,251 B2
Method and system for implementing distributed lobs
Lakshminarayanan Chidambaran, Chennai (IN); Srividya Tata, Bangalore (IN); Geeta Arora, Union City, CA (US); Rajendra S. Pingte, Foster City, CA (US); Sneha Chandrababu, San Mateo, CA (US); and Ramkrishan Kanodia, Bangalore (IN)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed on Aug. 30, 2017, as Appl. No. 15/690,894.
Claims priority of provisional application 62/381,389, filed on Aug. 30, 2016.
Prior Publication US 2018/0060362 A1, Mar. 1, 2018
Int. Cl. G06F 16/27 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/27 (2019.01) [G06F 16/2219 (2019.01); G06F 16/2282 (2019.01)] 51 Claims
OG exemplary drawing
 
1. A method for performing operations on large objects (LOBs) in a distributed database that includes at least a client and one or more database servers, the method comprising:
receiving a query from the client at a database server of the one or more database servers, wherein the distributed database is distributed as at least a first portion of the distributed database and at least a second portion of the distributed database, the query specifying access to a column of at least a second portion of the distributed database, and the column comprises a LOB;
in response to receipt of the query, creating, at the database server, a remote LOB locator at least by combining a local LOB locator, a database link count, and one or more database links, the one or more database links corresponding to one or more remote database servers of the one or more database servers, the local LOB locator points to a location at which the LOB is stored in the at least the second portion of the distributed database and the database link count specifies a number of the one or more database links in the remote LOB locator;
sending the remote LOB locator to the client;
after sending the remote LOB locator to the client, receiving the remote LOB locator in a request from the client to perform an operation that accesses data in the LOB;
forwarding the request to the at least the second portion of the distributed database based at least in part on the remote LOB locator; and
performing the operation that accesses the data in the LOB stored in the at least the second portion of the distributed database.