MY188208A - System and method for managing change data in database - Google Patents

System and method for managing change data in database

Info

Publication number
MY188208A
MY188208A MYPI2014701770A MYPI2014701770A MY188208A MY 188208 A MY188208 A MY 188208A MY PI2014701770 A MYPI2014701770 A MY PI2014701770A MY PI2014701770 A MYPI2014701770 A MY PI2014701770A MY 188208 A MY188208 A MY 188208A
Authority
MY
Malaysia
Prior art keywords
data
unit
change data
database
source
Prior art date
Application number
MYPI2014701770A
Inventor
Tong Khin Thong
Maidin Azizah
Wah Yan Koong
M Perumal Nagendran
Original Assignee
Mimos Berhad
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Mimos Berhad filed Critical Mimos Berhad
Priority to MYPI2014701770A priority Critical patent/MY188208A/en
Priority to PCT/MY2015/050062 priority patent/WO2015199533A1/en
Publication of MY188208A publication Critical patent/MY188208A/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2358—Change logging, detection, and notification

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

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.
MYPI2014701770A 2014-06-26 2014-06-26 System and method for managing change data in database MY188208A (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
MYPI2014701770A MY188208A (en) 2014-06-26 2014-06-26 System and method for managing change data in database
PCT/MY2015/050062 WO2015199533A1 (en) 2014-06-26 2015-06-25 System and method for managing change data in database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
MYPI2014701770A MY188208A (en) 2014-06-26 2014-06-26 System and method for managing change data in database

Publications (1)

Publication Number Publication Date
MY188208A true MY188208A (en) 2021-11-24

Family

ID=54330830

Family Applications (1)

Application Number Title Priority Date Filing Date
MYPI2014701770A MY188208A (en) 2014-06-26 2014-06-26 System and method for managing change data in database

Country Status (2)

Country Link
MY (1) MY188208A (en)
WO (1) WO2015199533A1 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101573663B1 (en) * 2015-07-21 2015-12-01 한다시스템 주식회사 Method and system for data integration
US11315198B2 (en) * 2016-07-29 2022-04-26 The Bureau Of National Affairs, Inc. Data analysis engine
CN107798120B (en) * 2017-11-10 2022-01-21 中国银行股份有限公司 Data conversion method and device

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6999977B1 (en) 2002-05-09 2006-02-14 Oracle International Corp Method and apparatus for change data capture in a database system

Also Published As

Publication number Publication date
WO2015199533A1 (en) 2015-12-30

Similar Documents

Publication Publication Date Title
GB201618161D0 (en) Improved method, system and software for searching, identifying, retrieving and presenting electronic documents
WO2015191746A8 (en) Systems and methods for a database of software artifacts
WO2014049334A3 (en) A document management system and method
SG10201901732UA (en) Sensitive information processing method, device, server and security determination system
ES2576464A2 (en) Solvent-free processing, system and methods
MY191557A (en) Management server and management method employing same
WO2013166140A3 (en) Playlist generation
SG10201907044XA (en) Methods and apparatuses for pushing a message
GB2542053A (en) Automatically generating a semantic mapping for a relational database
GB201300933D0 (en) Geological log data processing methods and apparatuses
BR112016001108A2 (en) IDENTIFICATION AND EXTRACTION OF Fault BLOCKS IN ONE OR MORE BODIES THAT REPRESENT A GEOLOGICAL STRUCTURE
IN2013CH01043A (en)
IN2014CH02163A (en)
GB201209399D0 (en) A method for identifying pairs of derivative and original images
GB2513815A (en) System, method, and interfaces for work product management
MX2017008687A (en) Metadata management for content delivery.
WO2012122212A3 (en) Processing medical records
GB2546442A (en) Electronic processing system for electronic document and electronic file
PH12014501692A1 (en) Control method, system and device
GB2529344A (en) Method and apparatus for identifying local features
TW201614507A (en) Methods and devices for finding settings to be used in relation to a sensor unit connected to a processing unit
MY188208A (en) System and method for managing change data in database
TW201612841A (en) Online learning system, skill evaluation method thereof, and storage media storing the method
GB2527230A (en) Processing seismic attributes using mathematical morphology
SG11201810856RA (en) Method, device, and terminal device for extracting data