17528589. LOADING DATA IN A TARGET DATABASE SYSTEM USING DIFFERENT SYNCHRONIZATION PROGRAMS simplified abstract (International Business Machines Corporation)

From WikiPatents
Jump to navigation Jump to search

LOADING DATA IN A TARGET DATABASE SYSTEM USING DIFFERENT SYNCHRONIZATION PROGRAMS

Organization Name

International Business Machines Corporation

Inventor(s)

Knut Stolze of Hummelshain (DE)

Luis Eduardo Oliveira Lizardo of Boeblingen (DE)

Reinhold Geiselhart of Rottenburg-Ergenzingen (DE)

Felix Beier of Haigerloch (DE)

LOADING DATA IN A TARGET DATABASE SYSTEM USING DIFFERENT SYNCHRONIZATION PROGRAMS - A simplified explanation of the abstract

This abstract first appeared for US patent application 17528589 titled 'LOADING DATA IN A TARGET DATABASE SYSTEM USING DIFFERENT SYNCHRONIZATION PROGRAMS

Simplified Explanation

The abstract describes a computer implemented method for managing data replication in a target database system. Here are the key points:

  • The method involves identifying a query view of the target database system, which allows access to a specific source table stored in a target table.
  • A load program is executed to load a partition of the source table into a load target partition of the target table.
  • The query view is then changed to select records from the target table.
  • An update program is executed to assign records from a replication target partition to the load target partition.
  • The method determines the mode of operation for a replication program based on whether the update program has finished executing.
  • The replication program is executed according to the selected mode of operation.
  • Finally, the query view is changed again to select records from the replication target partition.

Potential applications of this technology:

  • Data replication in large-scale database systems.
  • Database management systems that require efficient and automated replication processes.
  • Real-time data synchronization between multiple databases.

Problems solved by this technology:

  • Simplifies the process of data replication by automating the loading and updating of target tables.
  • Provides a flexible and efficient method for managing data replication in a target database system.
  • Reduces the complexity and potential errors associated with manual data replication processes.

Benefits of this technology:

  • Improved data consistency and accuracy across multiple databases.
  • Increased efficiency and speed in data replication processes.
  • Simplified management of data replication tasks.
  • Reduced risk of data loss or inconsistencies during replication.


Original Abstract Submitted

A computer implemented method includes identifying a query view of a target database system enabling access to a first source table stored in a first target table, executing a load program for a current version of a first source partition of the first source table, wherein executing the load program includes loading the first source partition in a second load target partition of the first target table, changing the query view to select records of the first target table, executing an update program for assigning records of the first replication target partition to the first load target partition, selecting a mode of operation for a replication program based on determining whether the execution of the update program is finished, executing the replication program in accordance with the selected mode of operation, and changing the query view to further select the records of the first replication target partition.

Retrieved from "http://wikipatents.org/index.php?title=17528589._LOADING_DATA_IN_A_TARGET_DATABASE_SYSTEM_USING_DIFFERENT_SYNCHRONIZATION_PROGRAMS_simplified_abstract_(International_Business_Machines_Corporation)&oldid=23529"