-
公开(公告)号: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.
-
12.
公开(公告)号: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.
-
公开(公告)号:US09864816B2
公开(公告)日:2018-01-09
申请号:US14699685
申请日:2015-04-29
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Beda Christoph Hammerschmidt , Ying Lu , Rahul Manohar Kadwe , Douglas McMahon
IPC: G06F17/30
CPC classification number: G06F17/30911 , G06F17/30917 , G06F17/3092
Abstract: A data guide is dynamically generated. The data guide describes the structures of hierarchical data objects added to a collection of hierarchical data objects. Examples of hierarchical data objects are documents that conform to XML (Extensible Mark-up Language) or data objects that conform to JSON (JavaScript Object Notation). The data guide may be created and/or updated as hierarchical data objects are added to the collection.
-
公开(公告)号:US12287777B2
公开(公告)日:2025-04-29
申请号:US17966730
申请日: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/00 , G06F16/23 , G06F16/2455
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.
-
公开(公告)号:US12271378B2
公开(公告)日:2025-04-08
申请号:US18367722
申请日:2023-09-13
Applicant: Oracle International Corporation
Inventor: Saurabh Naresh Netravalkar , Aleksandra Czarlinska , Zhen Hua Liu , Beda Christoph Hammerschmidt
IPC: G06F16/20 , G06F16/2453
Abstract: Techniques are provided for creating a “ubiquitous search index” which allows for full-text as well as value range-based search across all columns from multiple database tables, multiple user-defined unmaterialized views, and external sources. In one implementation, the data is indexed in a peculiarly constructed schema-based JSON format without duplicating data. The techniques maintain eventual consistency with the normalized source of truth database tables, and do not have a significant impact on the performance of transactional Data Manipulation Language (DML) operations.
-
公开(公告)号:US12147398B2
公开(公告)日:2024-11-19
申请号:US18115629
申请日:2023-02-28
Applicant: Oracle International Corporation
Inventor: Tirthankar Lahiri , Srikrishnan Suresh , Beda Christoph Hammerschmidt , Adrian Daniel Popescu , Jesse Kamp , Zhen Hua Liu
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.
-
公开(公告)号:US20240378199A1
公开(公告)日:2024-11-14
申请号:US18367722
申请日:2023-09-13
Applicant: Oracle International Corporation
Inventor: Saurabh Naresh Netravalkar , Aleksandra Czarlinska , Zhen Hua Liu , Beda Christoph Hammerschmidt
IPC: G06F16/2453
Abstract: Techniques are provided for creating a “ubiquitous search index” which allows for full-text as well as value range-based search across all columns from multiple database tables, multiple user-defined unmaterialized views, and external sources. In one implementation, the data is indexed in a peculiarly constructed schema-based JSON format without duplicating data. The techniques maintain eventual consistency with the normalized source of truth database tables, and do not have a significant impact on the performance of transactional Data Manipulation Language (DML) operations.
-
18.
公开(公告)号:US20160321375A1
公开(公告)日:2016-11-03
申请号:US14699685
申请日:2015-04-29
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Beda Christoph Hammerschmidt , Ying Lu , Rahul Manohar Kadwe , Douglas McMahon
IPC: G06F17/30
CPC classification number: G06F17/30911 , G06F17/30917 , G06F17/3092
Abstract: A data guide is dynamically generated. The data guide describes the structures of hierarchical data objects added to a collection of hierarchical data objects. Examples of hierarchical data objects are documents that conform to XML (Extensible Mark-up Language) or data objects that conform to JSON (JavaScript Object Notation). The data guide may be created and/or updated as hierarchical data objects are added to the collection.
Abstract translation: 动态生成数据指南。 数据指南描述了添加到分层数据对象集合中的分层数据对象的结构。 分层数据对象的示例是符合XML(可扩展标记语言)或符合JSON(JavaScript对象符号)的数据对象的文档。 当分层数据对象被添加到集合时,可以创建和/或更新数据指南。
-
-
-
-
-
-
-