公开(公告)号：US20210081421A1

公开(公告)日：2021-03-18

申请号：US16570356

申请日：2019-09-13

Applicant: Oracle International Corporation

Inventor： Zhen Hua LIU ,  Geeta ARORA ,  Sriram KRISHNAMURTHY ,  Sneha CHANDRABABU ,  Sunitha SUBRAMANYAM

IPC: G06F16/2455 ,  G06F16/28 ,  G06F16/22

Abstract: Described are improved systems, computer program products, and methods for an improved approach to access small to medium size objects (MOBs) stored in LOB data type columns of a RDBMS. The approach includes receiving a SQL statement comprising a retrieval of a large object (LOB). The approach also includes determining whether to return a value of the LOB or a reference to a storage location storing the value of the LOB based on: a data dictionary property of the LOB to return the value of the LOB, a function included in the SQL statement to return the value of the LOB, or a flag derived from a SQL operator tree propagation to return the value of the LOB.