-
公开(公告)号:US20220413481A1
公开(公告)日:2022-12-29
申请号: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
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.
-
公开(公告)号:US11468098B2
公开(公告)日:2022-10-11
申请号:US16917468
申请日:2020-06-30
Applicant: Oracle International Corporation
Inventor: Eric S. Chan , Dieter Gawlick , Adel Ghoneimy , Zhen Hua Liu
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.
-
公开(公告)号:US11423001B2
公开(公告)日:2022-08-23
申请号: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 , G06F11/34 , G06F16/242
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.
-
64.
公开(公告)号:US11409741B2
公开(公告)日:2022-08-09
申请号:US15993438
申请日:2018-05-30
Applicant: Oracle International Corporation
Inventor: Beda Christoph Hammerschmidt , Zhen Hua Liu , Vikas Arora , Prakashkumar Thiagarajan , Douglas James McMahon
IPC: G06F16/00 , G06F16/2453 , G06F16/22 , G06F16/80 , G06F16/25
Abstract: Functionalities of new data types are enabled for data stored using native data types (“recognized data types”) supported by DBMSs. Values having a latent data type may be stored using a recognized data type of a DBMS. That is, a value stored in a database table may be recognized by a DBMS as having a recognized data type (e.g., character string) but the value may also include information that indicates the value conforms to a particular latent data type. DBMSs compile database statements. The database statement can contain multiple expressions that may specify a latent data type or that may have a recognized data type but that also imply latent data types. By determining that various expressions have latent data types, operations that rely on the expressions as having a latent data type may be validated in a query and executed accordingly.
-
公开(公告)号:US11341317B2
公开(公告)日:2022-05-24
申请号:US16863268
申请日:2020-04-30
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.
-
公开(公告)号:US11182429B2
公开(公告)日:2021-11-23
申请号:US16852094
申请日: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
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.
-
公开(公告)号:US11182428B2
公开(公告)日:2021-11-23
申请号: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
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.
-
68.
公开(公告)号:US11157478B2
公开(公告)日:2021-10-26
申请号:US16690817
申请日:2019-11-21
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Vikas Arora , Ying Lu , Sriram Krishnamurthy , Hui Joe Chang , Beda Christoph Hammerschmidt , Joshua Jeffrey Spiegel
IPC: G06F7/00 , G06F16/22 , G06F16/2455 , G06F16/28
Abstract: The present invention relates to autonomous tuning of a data grid of documents in a database. Herein are techniques for storage cells to autonomously maintain local indices and other optimization metadata and algorithms to accelerate selective access into a distributed collection of documents. In an embodiment, each storage cell persists a respective subset of documents. Each storage cell stores, in memory, respective index(s) that map each item to location(s), in one or more documents of the respective subset of documents, where the item occurs. One or more computers execute, based on at least a subset of the indices of the storage cells, a data access request from a database management system. In an embodiment, a cloud of JSON document services provides an easy-to-use, fully autonomous JSON document database that horizontally and elastically scales to deliver fast execution of document transactions and queries without needing tuning by a database administrator.
-
公开(公告)号:US20200242157A1
公开(公告)日:2020-07-30
申请号:US16852085
申请日: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
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.
-
70.
公开(公告)号:US20190197145A1
公开(公告)日:2019-06-27
申请号:US15850027
申请日:2017-12-21
Applicant: Oracle International Corporation
Inventor: Kenny C. Gross , Dieter Gawlick , Zhen Hua Liu , Mengying Li
IPC: G06F17/30
CPC classification number: G06F16/2365 , G06F16/2477
Abstract: The disclosed embodiments relate to a system that certifies provenance of time-series data in a time-series database. During operation, the system retrieves time-series data from the time-series database, wherein the time-series data comprises a sequence of observations comprising sensor readings for each signal in a set of signals. The system also retrieves multivariate state estimation technique (MSET) estimates, which were computed for the time-series data, from the time-series database. Next, the system performs a reverse MSET computation to produce reconstituted time-series data from the MSET estimates. The system then compares the reconstituted time-series data with the time-series data. If the reconstituted time-series data matches the original time-series data, the system certifies provenance for the time-series data.
-
-
-
-
-
-
-
-
-