发明名称 SYSTEM AND METHOD FOR REAL-TIME CLOUD DATA SYNCHRONIZATION USING A DATABASE BINARY LOG
摘要 A system synchronizes change-data in a multi-tenant system with one or more external service provider systems. The system comprises a system interface configured to receive transaction events; a write-optimized transactional database for recording the transaction events; a replicated read-optimized transactional database; a transaction log of change-data generated from the read-optimized transactional database; a first change-data processor configured to identify the change-data in the transaction log that is relevant to at least one external service provider system, and to generate an aggregate relevant change-data log; a second change-data processor configured to identify aggregate relevant change-data that is relevant to a particular external service provider system, and to generate a service provider relevant change-data log; a service provider connector configure to await a real-time trigger condition, and to, in response to the trigger condition, perform a synchronization session to synchronize the service provider relevant change-data with the particular external service provider system.
申请公布号 US2016308963(A1) 申请公布日期 2016.10.20
申请号 US201615132168 申请日期 2016.04.18
申请人 Zuora, Inc. 发明人 Kung Tinglan
分类号 H04L29/08;G06F17/30 主分类号 H04L29/08
代理机构 代理人
主权项 1. A method of synchronizing change-data in a multi-tenant system with one or more external service provider systems, the method comprising: receiving transaction events in a write-optimized transactional database of a multi-tenant system; replicating the transaction events in a read-optimized transactional database; generating a transaction log of change-data from the read-optimized transactional database; extracting, by a first change-data processor, the change-data from the transaction log; identifying, by the first change-data processor, the change-data in the transaction log that is relevant to at least one of one or more external service provider systems; generating an aggregate relevant change-data log; extracting, by a second change-data processor, the aggregate relevant change-data from the aggregate relevant change-data log, the second change-data processor being associated with a particular external service provider system of the one or more external service provider systems; identifying, by a second change-data processor, the change-data in the aggregate relevant change-data log that is relevant to the particular external service provider system; generating a service provider relevant change-data log; awaiting a trigger condition of one or more trigger conditions, at least one of the one or more trigger conditions including a real-time trigger condition; and in response to the trigger condition, performing a synchronization session to synchronize the service provider relevant change-data with the particular external service provider system.
地址 Foster City CA US