TECHNIQUE FOR IMPLEMENTING CHANGE DATA CAPTURE IN DATABASE MANAGEMENT SYSTEM

摘要

A computer program stored in a computer readable storage medium including instructions encoded according to one embodiment of the present disclosure is disclosed. The computer program, when executed by one or more processors of a source database server, causes the one or more processors to perform steps for Change Data Capture (CDC). The steps include: identifying a plurality of Structured Query Language (SQL) operations generated for one or more objects associated with the transaction by analyzing a log record containing information about the transaction being processed at the source database server; Determining whether a previous SQL operation history for an object corresponding to an individual SQL operation exists in a CDC file based on the order in which the identified multiple SQL operations have occurred; Determining information to be written to the CDC file based on the existence of a previous SQL operation history in the CDC file; Recording the determined information in the CDC file; And determining to transmit the CDC file to the target database server.