公开(公告)号：US20250094398A1

公开(公告)日：2025-03-20

申请号：US18885531

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Aleksandra Czarlinska ,  Saurabh Naresh Netravalkar ,  Denis B. Mukhin ,  Harichandan Roy ,  Zhen Hua Liu ,  Sebastian de la Hoz Luna ,  Beda Christoph Hammerschmidt ,  George R. Krupka ,  Bo Xia ,  David Chih-Wei Jiang

IPC: G06F16/22 ,  G06F16/93

Abstract: Techniques for a unified relational database framework for hybrid vector search are provided. In one technique, multiple documents are accessed and a vector table and a text table are generated. For each accessed document, data within the document is converted to plaintext, multiple chunks are generated based on the plaintext, an embedding model generates a vector for each of the chunks, the vectors are stored in the vector table along with a document identifier that identifies the accessed document, tokens are generated based on the plaintext, the tokens are stored in the text table along with the document identifier. Such processing may be performed in a database system in response to a single database statement to create a hybrid index. In response to receiving a hybrid query, a vector query and a text query are generated and executed and the respective results may be combined.

公开(公告)号：US11567932B2

公开(公告)日：2023-01-31

申请号：US17080698

申请日：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/242 ,  G06F16/2455 ,  G06F16/2452 ,  G06F16/25 ,  G06F16/22

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.

公开(公告)号：US20230008658A1

公开(公告)日：2023-01-12

申请号：US17368840

申请日：2021-07-07

Applicant: Oracle International Corporation

Inventor： Richard P. Sonderegger ,  Kenneth P. Baclawski ,  Guang C. Wang ,  Anna Chystiakova ,  Dieter Gawlick ,  Zhen Hua Liu ,  Kenny C. Gross

IPC: G05B23/02 ,  G06N20/00 ,  G05B13/02 ,  G05B15/02

Abstract: The disclosed embodiments relate to a system that automatically adapts a prognostic-surveillance system to account for aging phenomena in a monitored system. During operation, the prognostic-surveillance system is operated in a surveillance mode, wherein a trained inferential model is used to analyze time-series signals from the monitored system to detect incipient anomalies. During the surveillance mode, the system periodically calculates a reward/cost metric associated with updating the trained inferential model. When the reward/cost metric exceeds a threshold, the system swaps the trained inferential model with an updated inferential model, which is trained to account for aging phenomena in the monitored system.

公开(公告)号：US11500868B2

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

申请号：US17162527

申请日：2021-01-29

Applicant: Oracle International Corporation

Inventor： Andrea Segalini ,  Jean-Pierre Lozi ,  Laurent Daynes ,  Marco Arnaboldi ,  Vlad Ioan Haprian ,  Hugo Kapp ,  Shasank Kisan Chavan ,  Zhen Hua Liu ,  Danica Porobic

IPC: G06F16/245 ,  G06F16/22 ,  G06F16/2453 ,  G06F16/2452 ,  G06F16/2455

Abstract: Vertex/edge table rows are mapped to unique integer identifiers, to enable construction of in-memory representation of a graph from existing, unmodified RDBMS tables. The unique integer identifiers are based on an encoding of primary key values of the table rows. The unique integer identifiers are used as graph indexes of the in-memory representation.

公开(公告)号：US20220245147A1

公开(公告)日：2022-08-04

申请号：US17162527

申请日：2021-01-29

Applicant: Oracle International Corporation

Inventor： Andrea Segalini ,  Jean-Pierre Lozi ,  Laurent Daynes ,  Marco Arnaboldi ,  Vlad Ioan Haprian ,  Hugo Kapp ,  Shasank Kisan Chavan ,  Zhen Hua Liu ,  Danica Porobic

IPC: G06F16/2453 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/22

Abstract: Techniques are provided for mapping vertex/edge table rows to unique integer identifiers, to enable construction of in-memory representation of a graph from existing, unmodified RDBMS tables. The unique integer identifiers are based on an encoding of primary key values of the table rows. The unique integer identifiers are used as graph indexes of the in-memory representation.

公开(公告)号：US20220129465A1

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

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

公开(公告)号：US20220129461A1

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

申请号：US17080700

申请日：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/2453 ,  G06F16/901 ,  G06F16/2455

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.

公开(公告)号：US20210109967A1

公开(公告)日：2021-04-15

申请号：US17129085

申请日：2020-12-21

Applicant: oracle international corporation

Inventor： Zhen Hua Liu ,  Ying Lu ,  Hui Joe Chang

IPC: G06F16/835

Abstract: Techniques are described to improve query evaluation in computer systems. In an embodiment, a system receives a full text query for evaluation against a collection of hierarchically marked data object sets. The query specifies token(s) and context(s) which indicate hierarchical location(s) to match within a queried hierarchical data structure. To evaluate the query, the system determines a) data object set(s) that contain the query specified token(s) using token list(s), and/or b) data object set(s) that contain the query specified context(s) using label list(s).

公开(公告)号：US10740358B2

公开(公告)日：2020-08-11

申请号：US14665171

申请日：2015-03-23

Applicant: Oracle International Corporation

Inventor： Eric S. Chan ,  Dieter Gawlick ,  Adel Ghoneimy ,  Zhen Hua Liu

IPC: G06F16/28 ,  G06F16/27 ,  G06F16/9535 ,  G06F11/30 ,  G06F11/34 ,  G06F16/21

Abstract: Embodiments of the invention provide systems and methods for managing and processing large amounts of complex and high-velocity data by capturing and extracting high-value data from low value data using big data and related technologies. Illustrative database systems described herein may collect and process data while extracting or generating high-value data. The high-value data may be handled by databases providing functions such as multi-temporality, provenance, flashback, and registered queries. In some examples, computing models and system may be implemented to combine knowledge and process management aspects with the near real-time data processing frameworks in a data-driven situation aware computing system.

公开(公告)号：US20200242156A1

公开(公告)日：2020-07-30

申请号：US16852075

申请日：2020-04-17

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Beda C. Hammerschmidt ,  Sriram Krishnamurthy ,  Ying Lu ,  Douglas J. McMahon ,  Srividya Tata ,  Vikas Arora

IPC: G06F16/84 ,  G06F16/27 ,  G06F16/2458 ,  G06F16/83 ,  G06F16/81 ,  G06F16/30

Abstract: Techniques are described herein for leveraging and extending relational data sharding infrastructure to provide comprehensive support for sharding semi-structured and unstructured data, in addition to the relational data, in a single sharded database system. Specifically, techniques are described in which a catalog server pre-gathers all data it needs to answer fetches from a dynamically created temporary lob. In addition, techniques are provided in which a catalog server encodes shard identifiers in lob locators sent to the client. Techniques are provided for pushing down various operators to shard servers.