公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US20170116273A1

公开(公告)日：2017-04-27

申请号：US15078713

申请日：2016-03-23

Applicant: Oracle International Corporation

Inventor： ZHEN HUA LIU ,  BEDA HAMMERSCHMIDT ,  DOUGLAS MCMAHON ,  YING LU

IPC: G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30911 ,  G06F17/30917

Abstract: Techniques are provided for de-normalizing semi-structured hierarchical data into a virtual table. At least a portion of semi-structured data document collection is denormalized for improving the execution of queries that involves a traversal of the semi-structured data hierarchy of the semi-structured data document collection, in an embodiment. Based on the extracted schema of the semi-structured data, a de-normalized arrangement is generated, in which the hierarchical relationship of the semi-structured data is converted into a set of columns. The denormalized arrangement is materialized by applying the de-normalized arrangement onto the semi-structured data. The materialized arrangement, the virtual table, may be stored on a persistent storage or kept in volatile memory. The virtual table may be stored in one format on the persistent storage and in another format in the volatile memory. A received query that involves a traversal of the semi-structured data hierarchy is converted to a relational query that can be executed on the virtual table, in an embodiment. The execution of the relational query on the virtual table improves the performance in generating the resulting data set.

公开(公告)号：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.

公开(公告)号：US20220292067A1

公开(公告)日：2022-09-15

申请号：US17198159

申请日：2021-03-10

Applicant: Oracle International Corporation

Inventor： HUI ZHANG ,  ZHEN HUA LIU ,  YING LU ,  BEDA CHRISTOPH HAMMERSCHMIDT ,  DOUGLAS JAMES MCMAHON ,  DENIS B. MUKHIN

IPC: G06F16/22

Abstract: Herein is acceleration for JavaScript object notation (JSON) documents in a relational database based on multilevel, multifield, multivalued indexing and querying. In an embodiment, into a table in a relational database, a computer stores many hierarchical data objects that respectively contain multiple levels that respectively contain one or more fields. An index is generated for indexed values in fields in at least two of the multiple levels. Based on the index, a database statement that references the table in the relational database and at least one of the indexed fields is executed. Indices herein provide matching to more fields in more levels of hierarchical data objects thereby decreasing or eliminating further filtering by brute force after index access. Matching ordinal positions within an array field needs no further filtration after index access. A single index provides increased spatial locality of index entries for acceleration. Index maintenance is minimized for acceleration.