Scalable roll-up summary field calculation using graphs

    公开(公告)号:US11442989B2

    公开(公告)日:2022-09-13

    申请号:US16741248

    申请日:2020-01-13

    Abstract: Systems and methods for updating values of roll-up summary fields (RSFs) associated with a data model are described. A server computing system receives data associated with roll-up summary fields (RSF) of objects of a data model. The data is in in a serialized format. The computer system deserializes the data to determine values of the RSFs at nodes of a graph associated with the data model. The computer system updates a value of a RSF at a first node of the graph. The computer system updates a value of one or more RSFs at one or more remaining nodes of the graph based on said updating the value of the RSF at the first node. The computer system serializes the values of the RSFs at all of the nodes of the graph to generate serialized data subsequent to said updating the value of the one or more RSFs at the one or more remaining nodes of the graph.

    Change order application programming interfaces

    公开(公告)号:US11354726B2

    公开(公告)日:2022-06-07

    申请号:US16723629

    申请日:2019-12-20

    Abstract: Disclosed embodiments are related to Application Programming Interface (API) technologies, and in particular, to Order APIs that are used to make modifications and cancelations to existing order objects. The Order APIs can be used to retrieve the current state of an order object, retrieve the summarized state of an order object as of a specified date, and retrieve a potential state of an order object along with specified changes. The Order APIs are also used to process order changes including changes to the quantity of an existing order object and applying line item changes to an existing order object. Other embodiments may be described and/or claimed.

    Bulk duplication detection supporting data encryption

    公开(公告)号:US11354285B2

    公开(公告)日:2022-06-07

    申请号:US16848878

    申请日:2020-04-15

    Abstract: Provided herein are system, methods and computer program products for identifying duplicate records stored in a database system, comprising: generating a plurality of encrypted match indexes for each of a plurality of records stored in the database system, each of the plurality of encrypted match indexes encrypts a value of each encryption enabled field of a respective one of the plurality of records defined by at least one match rule, creating a cluster of records comprising at least one set containing at least two records of the plurality of records, the at least two records having respective encrypted match indexes corresponding to the at least one match rule, causing identification of duplicate records in the at least one set according to detection of records of the at least one set having respective match indexes matching the at least one match rule, and outputting an indication of the identified duplicate records.

    SCALABLE ROLL-UP SUMMARY FIELD CALCULATION USING GRAPHS

    公开(公告)号:US20210216591A1

    公开(公告)日:2021-07-15

    申请号:US16741248

    申请日:2020-01-13

    Abstract: Systems and methods for updating values of roll-up summary fields (RSFs) associated with a data model are described. A server computing system receives data associated with roll-up summary fields (RSF) of objects of a data model. The data is in in a serialized format. The computer system deserializes the data to determine values of the RSFs at nodes of a graph associated with the data model. The computer system updates a value of a RSF at a first node of the graph. The computer system updates a value of one or more RSFs at one or more remaining nodes of the graph based on said updating the value of the RSF at the first node. The computer system serializes the values of the RSFs at all of the nodes of the graph to generate serialized data subsequent to said updating the value of the one or more RSFs at the one or more remaining nodes of the graph.

    CHANGE ORDER APPLICATION PROGRAMMING INTERFACES

    公开(公告)号:US20210192601A1

    公开(公告)日:2021-06-24

    申请号:US16723629

    申请日:2019-12-20

    Abstract: Disclosed embodiments are related to Application Programming Interface (API) technologies, and in particular, to Order APIs that are used to make modifications and cancelations to existing order objects. The Order APIs can be used to retrieve the current state of an order object, retrieve the summarized state of an order object as of a specified date, and retrieve a potential state of an order object along with specified changes. The Order APIs are also used to process order changes including changes to the quantity of an existing order object and applying line item changes to an existing order object. Other embodiments may be described and/or claimed.

    Matching objects using keys based on match rules

    公开(公告)号:US09740743B2

    公开(公告)日:2017-08-22

    申请号:US14518145

    申请日:2014-10-20

    CPC classification number: G06F17/30489

    Abstract: Matching objects using keys based on match rules is described. A system generates a match rule key based on a match rule, wherein the match rule specifies whether two objects match. The system creates candidate keys by applying the match rule key to data objects. The system creates a probe key by applying the match rule key to a probe object. The system determines whether the probe key matches a candidate key. The system determines whether the probe object matches a candidate object based on applying the match rule to the probe object and the candidate object if the probe key matches the candidate key corresponding to the candidate object. The system identifies the probe object and the candidate object as matching based on the match rule if the probe object matches the candidate object.

    LARGE SCALE DATA INGESTION
    17.
    发明申请

    公开(公告)号:US20210232585A1

    公开(公告)日:2021-07-29

    申请号:US16773881

    申请日:2020-01-27

    Abstract: Disclosed are some implementations of systems, apparatus, methods and computer program products for performing data ingestion. A request received from a client device is processed, where the request has a payload including a plurality of data items pertaining to a data object. An identifier associated with the data object is generated. Information including the data items is obtained from the request. The information including the data items is stored in association with the identifier in a first data store, where the first data store is not a relational database. The data items and identifier are obtained from the first data store and stored in a second data store, where the second data store is a relational database. A query including the identifier is processed to obtain the identifier from the query. It is determined whether the identifier obtained from the query is in the first data store. One or more of the data items associated with the identifier are retrieved from the first data store according to a result of determining whether the identifier obtained from the query is in the first data store.

    Optimized subset processing for de-duplication

    公开(公告)号:US10901996B2

    公开(公告)日:2021-01-26

    申请号:US15052556

    申请日:2016-02-24

    Abstract: Some embodiments of the present invention include a method for identifying duplicate records from a group of records in a database system. The method includes generating a cluster of records from a group of records based on one or more keys; splitting the cluster of records into multiple subsets of records with each subset of records having fewer number of records than the cluster of records, wherein the splitting the cluster of records into multiple subsets of records is based on a number of records in the cluster of records exceeding a threshold; causing duplicate sets of records in each of the subsets of records to be identified, wherein a duplicate set of records includes one or more records, and wherein when a duplicate set of records includes two or more records, the two or more records are duplicates of one another; merging all of the duplicate sets of records identified from the multiple subsets of records forming a first group of duplicate sets of records; and forming a representative set of records based on selecting a representative record from each of the duplicate sets in the first group of duplicate sets of records.

    Using row value constructor (RVC) based queries to group records of a database for multi-thread execution

    公开(公告)号:US10671604B2

    公开(公告)日:2020-06-02

    申请号:US15884322

    申请日:2018-01-30

    Abstract: Methods for splitting a plurality of records into subsets for parallel processing by separate threads are disclosed. In one embodiment, a plurality of records are added to a database. The adding includes tracking, for each unique value found in the plurality of records within a selected one of the sequence of fields, a statistic based on the values found in the plurality of records within a next one of the sequence of fields. Then a plurality of queries are generated, each includes a row value constructor (RVC) with a logical operation, a specific one of the unique values found within the selected one of the sequence of fields, and, for that specific value, the tracked statistic. Then a plurality of threads are caused to execute that each submit one of the queries and operate on a subset of the plurality of records responsive to execution of that query.

Patent Agency Ranking