Salesforce, inc. (20240220484). TRANSMITTING CHANGE DATA CAPTURE EVENTS DURING DATABASE REPLICATION simplified abstract
Contents
TRANSMITTING CHANGE DATA CAPTURE EVENTS DURING DATABASE REPLICATION
Organization Name
Inventor(s)
Narsimha Reddy Challa of Hyderabad (IN)
Swaroop Jayanthi of Hyderabad (IN)
Komalapriya of Rajapalayam (IN)
Raju Kalidindi of Hyderabad (IN)
TRANSMITTING CHANGE DATA CAPTURE EVENTS DURING DATABASE REPLICATION - A simplified explanation of the abstract
This abstract first appeared for US patent application 20240220484 titled 'TRANSMITTING CHANGE DATA CAPTURE EVENTS DURING DATABASE REPLICATION
The abstract describes an online system that replicates a database from one system to another. The system initially copies data in bulk and then captures changes to keep the target database up to date. Batching is used to group change events, and a multi-constrained analysis determines when a batch is ready for transmission. Multiple buffers are utilized to decouple event sending and receiving. The system can handle multiple tenants, adjusting resources based on a tenant score. Events are split into partial events to enable independent execution and reduce synchronization overhead during replication.
- Initial bulk copy followed by change data capture
- Batching of change events for transmission
- Multi-constrained analysis for batch readiness
- Use of multiple buffers for event transmission
- Resource adjustment based on tenant score
- Splitting events into partial events for independent execution
Potential Applications: - Data replication in multi-tenant systems - Real-time database synchronization - Efficient event transmission in online systems
Problems Solved: - Reduced synchronization overhead during replication - Efficient resource allocation for multiple tenants - Independent execution of tasks for partial events
Benefits: - Real-time data replication - Improved resource management - Reduced dependency between events
Commercial Applications: Title: Real-time Data Replication System for Multi-Tenant Databases This technology can be used in cloud-based systems, online marketplaces, and enterprise applications to ensure real-time data synchronization and efficient resource utilization.
Prior Art: Further research can be conducted on data replication techniques in multi-tenant systems and event transmission optimization in online databases.
Frequently Updated Research: Stay updated on advancements in database replication technologies, multi-tenant system management, and event processing in online systems.
Questions about the technology: 1. How does the system handle resource allocation for multiple tenants? The system adjusts resources based on a tenant score to optimize event transfer. 2. What is the significance of splitting events into partial events during replication? Splitting events enables independent execution of tasks and reduces synchronization overhead.
Original Abstract Submitted
an online system performs replication of database from one system to another. a source database is replicated to a target database by performing an initial bulk copy followed by repeated change data capture. the system performs batching to group events generated by the change data capture events. the system performs a multi-constrained analysis to determine when a batch is ready for sending. the system uses multiple buffers for transmitting events to decouple the receiving and sending of events. the online system may be a multi-tenant system the source and target databases stores data of tenants. the system determines a tenant score to adjust the resources allocated during event transfer. the system splits an event into partial events, to avoid dependency between the partial events so that tasks can be executed independent of each other. therefore, the system performs replication with reduced synchronization overhead.
