A computer program for providing efficient change data capture in a database system

A database server to implement Change Data Capture (CDC) comprising:

• a processor comprising one or more of core;
• a memory storing executable program codes by the processor;
• and
• a network unit transmitting and receiving data from a source database server and a target database server;
• wherein the processor extracts a change data from at least one redo log of an online redo log and an archive redo log, analyzes at least one information of a resource utilization rate information and a remain log information of a source database server, and determines to process the change data in one mode of a first mode saving the change data as a CDC file and a second mode recording the change data in a memory, based on at least one of the remain log information and the resource utilization rate information.

A method to implement Change Data Capture (CDC) comprising:

• extracting a change data from at least one redo log of an online redo log and an archive redo log;
• analyzing at least one information of a resource utilization rate information and a remain log information of a source database server;
• and
• determining to process the change data in one mode of a first mode saving the change data as a CDC file and a second mode recording the change data in a memory, based on at least one of the remain log information and the resource utilization rate information.