公开(公告)号：US20230101004A1

公开(公告)日：2023-03-30

申请号：US17491105

申请日：2021-09-30

Applicant: salesforce.com, inc.

Inventor： Yogesh Prabhudas Patel ,  Syed Mohammad Raza Hussain ,  Rajkumar Pellakuru ,  Johannes Kienzle ,  Violet Gong

IPC: G06F16/23 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/25 ,  G06F16/27

Abstract: An indication to migrate requested data objects stored in a source database environment to a destination database environment is received. Some of data objects have many-to-one relationships with other data objects in the source database environment. At least one snapshot file generated by the source database environment is transferred to a destination database environment in bulk transfer mode. Subsequent incoming data received during bulk transfer mode, after the indication is stored in a temporary table. Upon completion of migration of the requested data objects the system transitions from bulk transfer mode to streaming mode. The subsequent incoming data from the temporary table is transferred to the destination database environment in response to the transition to streaming mode. Additional data received after the temporary table is empty is transferred from the source database environment to the destination database environment without use of the temporary table.

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