公开(公告)号：US20240126816A1

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

申请号：US18375122

申请日：2023-09-29

Applicant: Oracle International Corporation

Inventor： Jorge Luis Issa Garcia ,  Teck Hua Lee ,  Sheldon Andre Kevin Lewis ,  Bangalore Prashanth ,  Hui Joe Chang ,  Zhen Hua Liu ,  Aurosish Mishra ,  Shasank K. Chavan

IPC: G06F16/903

CPC classification number: G06F16/90335

Abstract: Herein is database query acceleration from dynamic discovery of whether contents of a persistent column can be stored in an accelerated representation in storage-side memory. In an embodiment, based on data type discovery, a storage server detects that column values in a persistent column have a particular data type. Based on storage-side metadata including a frequency of access of the persistent column as an offload input column for offload computation requests on a certain range of memory addresses, the storage server autonomously decides to generate and store, in storage-side memory in the storage server, an accelerated representation of the persistent column that is based on the particular data type. The storage server receives a request to perform an offload computation for the offload input column. Based on the accelerated representation of the persistent column, execution of the offload computation is accelerated.

公开(公告)号：US20240119031A1

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

申请号：US18115629

申请日：2023-02-28

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Srikrishnan Suresh ,  Beda Christoph Hammerschmidt ,  Adrian Daniel Popescu ,  Jesse Kamp ,  Zhen Hua Liu

IPC: G06F16/21 ,  G06F16/23 ,  G06F16/25

CPC classification number: G06F16/212 ,  G06F16/2365 ,  G06F16/258

Abstract: A computer analyzes a relational schema of a database to generate a data entry schema and encodes the data entry schema as JSON. The data entry schema is sent to a database client so that the client can validate entered data before the entered data is sent for storage. From the client, entered data is received that conforms to the data entry schema because the client used the data entry schema to validate the entered data before sending the data. Into the database, the entered data is stored that conforms to the data entry schema. The data entry schema and the relational schema have corresponding constraints on a datum to be stored, such as a range limit for a database column or an express set of distinct valid values. A constraint may specify a format mask or regular expression that values in the column should conform to, or a correlation between values of multiple columns.

公开(公告)号：US11762834B2

公开(公告)日：2023-09-19

申请号：US17860192

申请日：2022-07-08

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F11/34 ,  G06F16/242

CPC classification number: G06F16/2282 ,  G06F11/3409 ,  G06F16/221 ,  G06F16/244 ,  G06F16/248 ,  G06F16/24552 ,  G06F16/24556

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.

公开(公告)号：US20230267120A1

公开(公告)日：2023-08-24

申请号：US17585146

申请日：2022-01-26

Applicant: Oracle International Corporation

Inventor： Hugo Kapp ,  Laurent Daynes ,  Vlad Ioan Haprian ,  Jean-Pierre Lozi ,  Zhen Hua Liu ,  Marco Arnaboldi ,  Sabina Petride ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/2453

CPC classification number: G06F16/24539

Abstract: Techniques described herein allow a user of an RDBMS to specify a graph algorithm function (GAF) that takes a graph object as input and returns a logical graph object as output. GAFs are used within graph queries to compute temporary and output properties (“GAF-computed properties”), which are live for the duration of the query cursor execution. GAF-computed output properties are accessible in the enclosing graph pattern matching query as though they were part of the input graph object of the GAF. Temporary cursor-duration tables are generated for the query cursor during compilation of a graph query that includes a GAF, and are used to store the GAF-computed properties. Each temporary table corresponds to one of the primary tables of the input graph, and includes, as a foreign key, primary key information from the corresponding primary table. Thus, the input graph of a GAF may be a “heterogeneous” graph.

公开(公告)号：US20230153680A1

公开(公告)日：2023-05-18

申请号：US17455536

申请日：2021-11-18

Applicant: Oracle International Corporation

Inventor： James Charles Rohrkemper ,  Kenneth Paul Baclawski ,  Dieter Gawlick ,  Kenny C. Gross ,  Guang Chao Wang ,  Anna Chystiakova ,  Richard Paul Sonderegger ,  Zhen Hua Liu

IPC: G06N20/00

CPC classification number: G06N20/00

Abstract: Techniques for using machine learning model validated sensor data to generate recommendations for remediating issues in a monitored system are disclosed. A machine learning model is trained to identify correlations among sensors for a monitored system. Upon receiving current sensor data, the machine learning model identifies a subset of the current sensor data that cannot be validated. The system generates estimated values for the sensor data that cannot be validated based on the learned correlations among the sensor values. The system generates the recommendations for remediating the issues in the monitored system based on validated sensor values and the estimated sensor values.

公开(公告)号：US11640380B2

公开(公告)日：2023-05-02

申请号：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.

公开(公告)号：US11507579B2

公开(公告)日：2022-11-22

申请号：US17080719

申请日：2020-10-26

Applicant: Oracle International Corporation

Inventor： Vlad Haprian ,  Laurent Daynes ,  Zhen Hua Liu ,  Lei Sheng ,  Hugo Kapp ,  Marco Arnaboldi ,  Jean-Pierre Lozi ,  Andrew Witkowski ,  Hassan Chafi ,  Sungpack Hong

IPC: G06F16/2455 ,  G06F16/2453

Abstract: Techniques support graph pattern matching queries inside a relational database management system (RDBMS) that supports SQL execution. The techniques compile a graph pattern matching query into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

公开(公告)号：US20220229971A1

公开(公告)日：2022-07-21

申请号：US17715384

申请日：2022-04-07

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Beda Christoph Hammerschmidt ,  Douglas James McMahon ,  Joshua Jeffrey Spiegel

IPC: G06F40/146 ,  G06F16/22 ,  G06F16/23

Abstract: Herein are fine grained updates to pieces of JavaScript object notation (JSON) documents by database statements that can update, delete, and insert parts of JSON documents. In an embodiment, a computer receives a request that specifies a modification of a JSON document that is stored in a compressed format in persistent storage. The modification adds additional content to the JSON document, and/or replaces an old value in the JSON document with a new value that is not a same size as the old value. The modification is recorded in a change log. The change log is eventually applied to the compressed format of the JSON document in the persistent storage without entirely rewriting the compressed format of the JSON document in the persistent storage.

公开(公告)号：US11372859B2

公开(公告)日：2022-06-28

申请号：US16570356

申请日：2019-09-13

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Geeta Arora ,  Sriram Krishnamurthy ,  Sneha Chandrababu ,  Sunitha Subramanyam

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

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.

公开(公告)号：US20210081389A1

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

申请号：US16904417

申请日：2020-06-17

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F16/242 ,  G06F11/34

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.