18090461. CREATING CONSISTENT COPIES OF A DATABASE simplified abstract (Salesforce, Inc.)

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 18090461 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 in multiple target database systems. It achieves this by sending change data streams from the source to the targets, pausing updates at a specific timestamp, and using partitioned change data streams for consistency.

  • The system generates consistent copies of data from a source database in multiple target database systems.
  • It sends change data streams from the source to the target databases for updates.
  • Timestamps of the latest transactions processed by consumer processes are received to determine a pause timestamp.
  • Updates to the target databases are paused at the pause timestamp to ensure consistency.
  • Multiple partitioned change data streams are used to generate consistent copies in the target databases.

Key Features and Innovation:

  • Generation of consistent copies of data in multiple target databases.
  • Use of change data streams for data updates.
  • Pausing updates at a specific timestamp for consistency.
  • Utilization of partitioned change data streams for generating consistent copies.

Potential Applications:

  • Data replication in distributed systems.
  • Database synchronization in real-time.
  • Disaster recovery solutions for databases.

Problems Solved:

  • Ensuring consistency of data across multiple databases.
  • Efficient data replication and synchronization.
  • Simplifying disaster recovery processes.

Benefits:

  • Improved data reliability and consistency.
  • Real-time database updates.
  • Streamlined disaster recovery procedures.

Commercial Applications:

The technology can be applied in industries such as finance, healthcare, e-commerce, and telecommunications for ensuring data consistency, real-time updates, and disaster recovery solutions.

Questions about the Technology: 1. How does the system handle conflicts in data updates between the source and target databases? 2. What are the scalability limitations of using partitioned change data streams for generating consistent copies in target databases?


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.

Retrieved from "http://wikipatents.org/index.php?title=18090461._CREATING_CONSISTENT_COPIES_OF_A_DATABASE_simplified_abstract_(Salesforce,_Inc.)&oldid=89192"