Salesforce, inc. (20240220478). CREATING CONSISTENT COPIES OF A DATABASE simplified abstract

From WikiPatents
Jump to navigation Jump to search

CREATING CONSISTENT COPIES OF A DATABASE

Organization Name

salesforce, inc.

Inventor(s)

Sai Rama Raju Alluru of Hyderabad (IN)

Swaroop Jayanthi of Hyderabad (IN)

CREATING CONSISTENT COPIES OF A DATABASE - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240220478 titled 'CREATING CONSISTENT COPIES OF A DATABASE

Simplified Explanation

The patent application describes a system that creates consistent copies of data from a source database to multiple target database systems by sending change data streams and using timestamps to ensure data updates are paused at the right moment.

  • The system generates consistent copies of data from a source database to multiple target database systems.
  • It sends change data streams from the source database to the target systems for data updates.
  • Timestamps are used to track the latest transactions processed by consumer processes updating the target systems.
  • A pause timestamp is determined to pause updates once a specific transaction is processed.
  • Multiple partitioned change data streams are used to create consistent copies in the target systems.

Key Features and Innovation

  • Generation of consistent copies of data across multiple target database systems.
  • Use of change data streams and timestamps to ensure data updates are paused at the right moment.
  • Utilization of partitioned change data streams for creating consistent copies in target systems.

Potential Applications

This technology can be applied in:

  • Data replication across multiple databases.
  • Disaster recovery solutions.
  • Real-time data synchronization.

Problems Solved

  • Ensures consistency of data across multiple database systems.
  • Facilitates efficient data replication and synchronization.
  • Helps in maintaining data integrity during updates.

Benefits

  • Improved data consistency and integrity.
  • Enhanced disaster recovery capabilities.
  • Efficient data synchronization across multiple systems.

Commercial Applications

The technology can be used in various industries for:

  • Database management solutions.
  • Real-time data replication services.
  • Disaster recovery and backup systems.

Prior Art

Readers can explore prior art related to data replication, data synchronization, and database management technologies to understand the evolution of similar concepts.

Frequently Updated Research

Stay updated on research related to data replication, database synchronization, and disaster recovery solutions to enhance the understanding and application of this technology.

Questions about the Technology

What are the key benefits of using change data streams in data replication?

Change data streams help in tracking and transmitting only the modified data, reducing bandwidth usage and improving efficiency in data replication processes.

How does the use of timestamps ensure data consistency in multiple database systems?

Timestamps help in tracking the order of transactions and ensuring that updates are paused at the right moment to maintain data consistency across different database systems.


Original Abstract Submitted

a system generates consistent copies of data stored in a source database in a plurality of target database systems. the system sends a change data stream from the source database system to the target database systems for performing data updates. the system receives timestamps of a latest transactions processed by consumer processes updating the target database system. the system determines a pause timestamp that occurs after the received transactions. the updates to the target database systems are paused once a transaction corresponding to the pause timestamp is processed. the pause timestamp is used to generate a consistent copy of a source database system in a target database system using multiple partitioned change data streams, each partitioned change data stream processing transactions associated with a partition of the source database system.