公开(公告)号：US20240126729A1

公开(公告)日：2024-04-18

申请号：US17966736

申请日：2022-10-14

Applicant: Oracle International Corporation

Inventor： ZHEN HUA LIU ,  JUAN R. LOAIZA ,  SUNDEEP ABRAHAM ,  SHUBHA BOSE ,  HUI JOE CHANG ,  SHASHANK GUGNANI ,  BEDA CHRISTOPH HAMMERSCHMIDT ,  TIRTHANKAR LAHIRI ,  YING LU ,  DOUGLAS JAMES MCMAHON ,  AUROSISH MISHRA ,  AJIT MYLAVARAPU ,  SUKHADA PENDSE ,  ANANTH RAGHAVAN

IPC: G06F16/21 ,  G06F16/2453 ,  G06F16/84

CPC classification number: G06F16/212 ,  G06F16/24534 ,  G06F16/86

Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.

公开(公告)号：US20240126746A1

公开(公告)日：2024-04-18

申请号：US18380098

申请日：2023-10-13

Applicant: Oracle International Corporation

Inventor： SHUBHA BOSE ,  DAVID PACHECO ,  AUROSISH MISHRA

IPC: G06F16/23 ,  G06F16/22

CPC classification number: G06F16/2379 ,  G06F16/2219

Abstract: LOB cache swapping is reduced by multi-LOB writing. Under multi-LOB writing, information that tracks changes made by a database transaction to multiple LOBs is retained in a LOB staging buffer after one or more LOB switches. Thus, at commit time, changes to multiple LOBs in a column may be staged in the LOB staging cache, thereby enabling the changes to be made in contiguous data blocks for all the multiple LOBs. Storing LOBs in the same column in this way improves clustering, thereby improving database performance. In addition, LOBs inserted or updated in the same database transaction are often related and accessed together within database transactions and/or query accesses. Clustering the LOB content of such related LOBs allows the LOBs to be accessed more efficiently.

公开(公告)号：US20240126728A1

公开(公告)日：2024-04-18

申请号：US17966724

申请日：2022-10-14

Applicant: Oracle International Corporation

Inventor： ZHEN HUA LIU ,  JUAN R. LOAIZA ,  SUNDEEP ABRAHAM ,  SHUBHA BOSE ,  HUI JOE CHANG ,  SHASHANK GUGNANI ,  BEDA CHRISTOPH HAMMERSCHMIDT ,  TIRTHANKAR LAHIRI ,  YING LU ,  DOUGLAS JAMES MCMAHON ,  AUROSISH MISHRA ,  AJIT MYLAVARAPU ,  SUKHADA PENDSE ,  ANANTH RAGHAVAN

IPC: G06F16/21 ,  G06F16/2453 ,  G06F16/84

CPC classification number: G06F16/212 ,  G06F16/24534 ,  G06F16/86

Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.

公开(公告)号：US20240126743A1

公开(公告)日：2024-04-18

申请号：US17966730

申请日：2022-10-14

Applicant: Oracle International Corporation

Inventor： ZHEN HUA LIU ,  JUAN R. LOAIZA ,  SUNDEEP ABRAHAM ,  SHUBHA BOSE ,  HUI JOE CHANG ,  SHASHANK GUGNANI ,  BEDA CHRISTOPH HAMMERSCHMIDT ,  TIRTHANKAR LAHIRI ,  YING LU ,  DOUGLAS JAMES MCMAHON ,  AUROSISH MISHRA ,  AJIT MYLAVARAPU ,  SUKHADA PENDSE ,  ANANTH RAGHAVAN

IPC: G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/2379 ,  G06F16/24568

Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.