公开(公告)号：US11138204B2

公开(公告)日：2021-10-05

申请号：US16530680

申请日：2019-08-02

Applicant: salesforce.com, inc.

Inventor： Percy Dara Mehta ,  Yogesh Prabhudas Patel ,  Shaahin Mehdinezhad Rushan ,  Mattia Padovani ,  Aaron Yulong Zhang ,  Shan-Cheng Ho ,  Clinton Tran ,  Birva Pankaj Joshi ,  Mugdha Choudhari ,  Johannes Kienzle

IPC: G06F16/30 ,  G06F16/2455 ,  G06F16/28

Abstract: Techniques are disclosed for generating metrics for a stream of interaction data. In some embodiments, a computing system receives a stream of interaction data that is based on user interactions with one or more computing systems, where the stream of interaction data includes information for multiple interaction characteristics including an interaction category. In response to receiving additional interaction information in the stream of interaction data, the computing system may generate cumulative metric values for one or more interaction categories. Generating cumulative metric values may include: sharding the additional interaction information based on multiple characteristics including interaction category, storing the sharded information in a non-relational database, determining respective metric values for shards modified by the storing, storing the respective metric values and shard information for each of the modified shards in a relational database, querying the relational database using one or more interaction categories corresponding to the modified shards, and determining the cumulative metric values based on the results of the querying.

公开(公告)号：US20210034627A1

公开(公告)日：2021-02-04

申请号：US16530680

申请日：2019-08-02

Applicant: salesforce.com, inc.

Inventor： Percy Dara Mehta ,  Yogesh Prabhudas Patel ,  Shaahin Mehdinezhad Rushan ,  Mattia Padovani ,  Aaron Yulong Zhang ,  Shan-Cheng Ho ,  Clinton Tran ,  Birva Pankaj Joshi ,  Mugdha Choudhari ,  Johannes Kienzle

IPC: G06F16/2455 ,  G06F16/28

Abstract: Techniques are disclosed for generating metrics for a stream of interaction data. In some embodiments, a computing system receives a stream of interaction data that is based on user interactions with one or more computing systems, where the stream of interaction data includes information for multiple interaction characteristics including an interaction category. In response to receiving additional interaction information in the stream of interaction data, the computing system may generate cumulative metric values for one or more interaction categories. Generating cumulative metric values may include: sharding the additional interaction information based on multiple characteristics including interaction category, storing the sharded information in a non-relational database, determining respective metric values for shards modified by the storing, storing the respective metric values and shard information for each of the modified shards in a relational database, querying the relational database using one or more interaction categories corresponding to the modified shards, and determining the cumulative metric values based on the results of the querying.