公开(公告)号：MY188208A

公开(公告)日：2021-11-24

申请号：MYPI2014701770

申请日：2014-06-26

Applicant: MIMOS BERHAD

Inventor： THONG TONG KHIN ,  AZIZAH MAIDIN ,  KOONG WAH YAN ,  NAGENDRAN M PERUMAL

Abstract: The present invention relates to an improved system for managing change data including the data newly added, removed and modified in database and to the method thereof. The system comprises an extract, transform and load (ETL) unit (100) that is configured for extracting data from a data source and loading the data into a staging table; and a unit for identifying the change data in the staging table, coupled to the ETL unit (100). The system can be characterized by a rule- based key generator (101), a record linkage unit (102), a delta data comparison unit (103) and a change data extraction unit (104) for quick and easy detection or capture of the change data in continuous manner without involving modification of the source?s system and source database.