Difference-Specific Database Updates for Lower Data I/O

The patent segments the database update process into two distinct phases: (1) writing new data to a separate change data feed (CDF) table while leaving the original table unchanged, and (2) subsequently applying only the changed data to the target table. This segmentation eliminates the need to rewrite entire data sets, reducing I/O operations and processing resource usage while maintaining data consistency through the intermediary CDF mechanism.

The patent performs preliminary action by capturing and storing data changes in a Change Data Feed (CDF) table before applying them to the target database table. This preliminary capture of changes allows the system to update only the necessary data portions in subsequent operations, avoiding redundant rewriting of unchanged data and thereby reducing processing resource consumption while ensuring data consistency.

The update process is segmented into change capture phase and change application phase. The CDF table stores changes separately, allowing the target table to be updated only with changed data in the second phase. This segmentation ensures updated data is achieved while significantly reducing update time by avoiding rewriting of unchanged data portions.

Instead of performing excessive action by rewriting the entire data set, the patent applies partial action by updating only the specific rows or columns that have changed, as identified and stored in the CDF table. This partial update approach ensures data is updated correctly while minimizing the time required for the update operation.