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