Supporting piecewise update of JSON document efficiently

    公开(公告)号:US11341317B2

    公开(公告)日:2022-05-24

    申请号:US16863268

    申请日:2020-04-30

    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.

    Framework and method for consistent cross-tier data validation

    公开(公告)号:US12147398B2

    公开(公告)日:2024-11-19

    申请号:US18115629

    申请日:2023-02-28

    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.

    UBIQUITOUS SEARCH ON DATA STORED IN THE RDBMS

    公开(公告)号:US20240378199A1

    公开(公告)日:2024-11-14

    申请号:US18367722

    申请日:2023-09-13

    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.

    Dynamically Updating Data Guide For Hierarchical Data Objects
    18.
    发明申请
    Dynamically Updating Data Guide For Hierarchical Data Objects 有权
    动态更新分层数据对象的数据指南

    公开(公告)号:US20160321375A1

    公开(公告)日:2016-11-03

    申请号:US14699685

    申请日:2015-04-29

    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对象符号)的数据对象的文档。 当分层数据对象被添加到集合时,可以创建和/或更新数据指南。

Patent Agency Ranking