公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US10509775B2

公开(公告)日：2019-12-17

申请号：US15941364

申请日：2018-03-30

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Dennis Floyd Fuglsang ,  Joshua Jeffrey Spiegel

IPC: G06F16/21 ,  G06F16/2452

Abstract: Techniques for dynamically generating database views and class objects for allowing access to domain data stored in a repository are provided. A computer-implemented method, a system, and/or a machine-readable medium storing instructions executable by one or more processors may include generating a database view and a class object using metadata included in a domain model, and retrieving domain data from a repository using the database view and the class object. For example, a method may include obtaining a domain model from a repository, the domain model including metadata corresponding to a set of domain data stored in the repository, generating a database view of a subset of the set of domain data using the metadata, generating a class object for the subset using the metadata, generating mapping information, and retrieving the subset of domain data from the repository using the database view, the class object, and the mapping information.

公开(公告)号：US20200210398A1

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

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

公开(公告)号：US20180225310A1

公开(公告)日：2018-08-09

申请号：US15941364

申请日：2018-03-30

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Dennis Floyd Fuglsang ,  Joshua Jeffrey Spiegel

IPC: G06F17/30

CPC classification number: G06F16/211 ,  G06F16/2452

Abstract: Techniques for dynamically generating database views and class objects for allowing access to domain data stored in a repository are provided. A computer-implemented method, a system, and/or a machine-readable medium storing instructions executable by one or more processors may include generating a database view and a class object using metadata included in a domain model, and retrieving domain data from a repository using the database view and the class object. For example, a method may include obtaining a domain model from a repository, the domain model including metadata corresponding to a set of domain data stored in the repository, generating a database view of a subset of the set of domain data using the metadata, generating a class object for the subset using the metadata, generating mapping information, and retrieving the subset of domain data from the repository using the database view, the class object, and the mapping information.

公开(公告)号：US09934258B2

公开(公告)日：2018-04-03

申请号：US14230627

申请日：2014-03-31

Applicant: Oracle International Corporation

Inventor： Dennis Floyd Fuglsang ,  Joshua Jeffrey Spiegel

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30292

Abstract: Techniques for dynamically generating database views and class objects for allowing access to domain data stored in a repository are provided. A computer-implemented method, a system, and/or a machine-readable medium storing instructions executable by one or more processors may include generating a database view and a class object using metadata included in a domain model, and retrieving domain data from a repository using the database view and the class object. For example, a method may include obtaining a domain model from a repository, the domain model including metadata corresponding to a set of domain data stored in the repository, generating a database view of a subset of the set of domain data using the metadata, generating a class object for the subset using the metadata, generating mapping information, and retrieving the subset of domain data from the repository using the database view, the class object, and the mapping information.

公开(公告)号：US20150278314A1

公开(公告)日：2015-10-01

申请号：US14230627

申请日：2014-03-31

Applicant: Oracle International Corporation

Inventor： Dennis Floyd Fuglsang ,  Joshua Jeffrey Spiegel

IPC: G06F17/30 ,  H04L29/12

CPC classification number: G06F17/30292

Abstract: Techniques for dynamically generating database views and class objects for allowing access to domain data stored in a repository are provided. A computer-implemented method, a system, and/or a machine-readable medium storing instructions executable by one or more processors may include generating a database view and a class object using metadata included in a domain model, and retrieving domain data from a repository using the database view and the class object. For example, a method may include obtaining a domain model from a repository, the domain model including metadata corresponding to a set of domain data stored in the repository, generating a database view of a subset of the set of domain data using the metadata, generating a class object for the subset using the metadata, generating mapping information, and retrieving the subset of domain data from the repository using the database view, the class object, and the mapping information.

Abstract translation: 提供了用于动态生成数据库视图和类对象以允许访问存储在存储库中的域数据的技术。 存储可由一个或多个处理器执行的指令的计算机实现的方法，系统和/或机器可读介质可以包括使用域模型中包含的元数据生成数据库视图和类对象，以及从仓库检索域数据 使用数据库视图和类对象。 例如，一种方法可以包括从存储库获得域模型，域模型包括与存储在存储库中的一组域数据相对应的元数据，使用元数据生成该域集合的子集的数据库视图，生成 使用元数据的子集的类对象，生成映射信息，以及使用数据库视图，类对象和映射信息从存储库中检索域数据的子集。