-
公开(公告)号:US20190286725A1
公开(公告)日:2019-09-19
申请号:US15925427
申请日:2018-03-19
Applicant: Oracle International Corporation
Inventor: Dieter Gawlick , Kenny C. Gross , Zhen Hua Liu , Adel Ghoneimy
Abstract: The disclosed embodiments relate to a system that preprocesses sensor data to facilitate prognostic-surveillance operations. During operation, the system obtains training data from sensors in a monitored system during operation of the monitored system, wherein the training data comprises time-series data sampled from signals produced by the sensors. The system also obtains functional requirements for the prognostic-surveillance operations. Next, the system performs the prognostic-surveillance operations on the training data and determines whether the prognostic-surveillance operations meet the functional requirements when tested on non-training data. If the prognostic-surveillance operations do not meet the functional requirements, the system iteratively applies one or more preprocessing operations to the training data in order of increasing computational cost until the functional requirements are met.
-
公开(公告)号:US10409795B2
公开(公告)日:2019-09-10
申请号:US13831137
申请日:2013-03-14
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Vineet Marwah , Amit Ganesh , Teck Hua Lee , Hui Joe Chang , Zhen Hua Liu
IPC: G06F16/22
Abstract: In an approach, the database server generates a request for data representing rows of a table, the request identifying one or more data blocks stored on a storage system. The database server then generates metadata describing one or more filtering conditions to be applied to the rows and sends the metadata along with the request to the storage system. The storage system, when applying filtering conditions to a column containing a LOB, determines whether the LOB is stored in-line or out-of-line. If the column contains an out-of-line LOB, the storage system skips the filtering conditions on the column. If the column contains an in-line LOB, the storage system applies the filtering conditions to the column. Upon obtaining the filtered data from the storage system, the database server retrieves the data blocks for out-of-line LOBs and applies the skipped filtering conditions to create a final result set.
-
53.
公开(公告)号:US20190236162A1
公开(公告)日:2019-08-01
申请号:US15885600
申请日:2018-01-31
Applicant: Oracle International Corporation
Inventor: Kenny C. Gross , Mengying Li , Dieter Gawlick , Zhen Hua Liu
IPC: G06F17/30
CPC classification number: G06F16/1744 , G06F16/2237 , G06F16/2453 , G06F16/24561
Abstract: The disclosed embodiments relate to a system that caches time-series data in a time-series database system. During operation, the system receives the time-series data, wherein the time-series data comprises a series of observations obtained from sensor readings for each signal in a set of signals. Next, the system performs a multivariate memory vectorization (MMV) operation on the time-series data, which selects a subset of observations in the time-series data that represents an underlying structure of the time-series data for individual and multivariate signals that comprise the time-series data. The system then performs a geometric compression aging (GAC) operation on the selected subset of time-series data. While subsequently processing a query involving the time-series data, the system: caches the selected subset of the time-series data in an in-memory database cache in the time-series database system; and accesses the selected subset of the time-series data from the in-memory database cache.
-
公开(公告)号:US20190102476A1
公开(公告)日:2019-04-04
申请号:US15848737
申请日:2017-12-20
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Beda C. Hammerschmidt , Sriram Krishnamurthy , Ying Lu , Douglas J. McMahon , Srividya Tata , Vikas Arora
IPC: G06F17/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.
-
公开(公告)号:US12298946B2
公开(公告)日:2025-05-13
申请号: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/20 , G06F16/21 , G06F16/2453 , G06F16/84
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.
-
公开(公告)号:US20250139096A1
公开(公告)日:2025-05-01
申请号:US18385617
申请日:2023-10-31
Applicant: Oracle International Corporation
Inventor: Laurent Daynes , Martin Brugnara , Jean-Pierre Lozi , Calin Iorgulescu , Marco Arnaboldi , Hugo Kapp , Vlad Ioan Haprian , Zhen Hua Liu , Sungpack Hong
IPC: G06F16/2455 , G06F16/22 , G06F16/23
Abstract: Techniques are described for applying topological graph changes and traversing the modified graph. In an implementation, a set of compile processes schedules the graph changes caused by a DML (Data Manipulation Language) statement. Based on the requested graph operation in a received query for graph, a set of graph operation processes generate extensions to the graph that capture the changes to the graph by the DML. The received graph operation(s) are then performed by traversing both the existing graph and the generated extensions.
-
公开(公告)号:US12007759B2
公开(公告)日:2024-06-11
申请号:US17361189
申请日:2021-06-28
Applicant: Oracle International Corporation
Inventor: Dieter Gawlick , Matthew Torin Gerdes , Kirk Bradley , Anna Chystiakova , Zhen Hua Liu , Guang Chao Wang , Kenny C. Gross
IPC: G05B23/02 , G06F11/34 , G06F16/215 , G06F18/214 , G06N20/00
CPC classification number: G05B23/0283 , G06F11/3409 , G06F16/215 , G06F18/2148 , G06N20/00
Abstract: Techniques for geometric aging data reduction for machine learning applications are disclosed. In some embodiments, an artificial-intelligence powered system receives a first time-series dataset that tracks at least one metric value over time. The system then generates a second time-series dataset that includes a reduced version of a first portion of the time-series dataset and a non-reduced version of a second portion of the time-series dataset. The second portion of the time-series dataset may include metric values that are more recent than the first portion of the time-series dataset. The system further trains a machine learning model using the second time-series dataset that includes the reduced version of the first portion of the time-series dataset and the non-reduced version of the second portion of the time-series dataset. The trained model may be applied to reduced and/or non-reduced data to detect multivariate anomalies and/or provide other analytic insights.
-
58.
公开(公告)号:US11948051B2
公开(公告)日:2024-04-02
申请号:US16826478
申请日:2020-03-23
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Edward R. Wetherbee , Kenneth P. Baclawski , Guang C. Wang , Kenny C. Gross , Anna Chystiakova , Dieter Gawlick , Zhen Hua Liu , Richard Paul Sonderegger
IPC: G06F16/00 , G05B23/02 , G06F17/16 , G06F17/18 , G06F30/27 , G06N20/00 , G06F111/10 , G06N3/08 , G06N20/10
CPC classification number: G06N20/00 , G05B23/024 , G06F17/16 , G06F17/18 , G06F30/27 , G06F2111/10 , G06N3/08 , G06N20/10
Abstract: In one embodiment, a method for auditing the results of a machine learning model includes: retrieving a set of state estimates for original time series data values from a database under audit; reversing the state estimation computation for each of the state estimates to produce reconstituted time series data values for each of the state estimates; retrieving the original time series data values from the database under audit; comparing the original time series data values pairwise with the reconstituted time series data values to determine whether the original time series and reconstituted time series match; and generating a signal that the database under audit (i) has not been modified where the original time series and reconstituted time series match, and (ii) has been modified where the original time series and reconstituted time series do not match.
-
公开(公告)号:US11899644B2
公开(公告)日:2024-02-13
申请号:US17860187
申请日: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.
-
公开(公告)号:US11550785B2
公开(公告)日:2023-01-10
申请号:US16389304
申请日:2019-04-19
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Beda Christoph Hammerschmidt , Zhen Hua Liu , Vikas Arora , Chandrasekharan Iyer , Beethoven Cheng , Ying Hu , Douglas James McMahon
IPC: G06F16/242 , G06F16/25 , G06F16/84
Abstract: Described is a system, method, and computer program product to perform bi-directional mapping of hierarchical data (e.g. JSON, XML) to database object types (e.g., user defined database object types).
-
-
-
-
-
-
-
-
-