True real-time change data capture with web service database encapsulation

Mitchell J. Eccles, David J. Evans, Anthony J. Beaumont

Research output: Chapter in Book/Published conference outputConference publication

Abstract

This research is investigating the claim that Change Data Capture (CDC) technologies capture data changes in real-time. Based on theory, our hypothesis states that real-time CDC is not achievable with traditional approaches (log scanning, triggers and timestamps). Traditional approaches to CDC require a resource to be polled, which prevents true real-time CDC. We propose an approach to CDC that encapsulates the data source with a set of web services. These web services will propagate the changes to the targets and eliminate the need for polling. Additionally we propose a framework for CDC technologies that allow changes to flow from source to target. This paper discusses current CDC technologies and presents the theory about why they are unable to deliver changes in real-time. Following, we discuss our web service approach to CDC and accompanying framework, explaining how they can produce real-time CDC. The paper concludes with a discussion on the research required to investigate the real-time capabilities of CDC technologies.

Original languageEnglish
Title of host publicationProceedings : 2010 6th World Congress on Services, Services-1
Place of PublicationPiscataway, NJ (US)
PublisherIEEE
Pages128-131
Number of pages4
ISBN (Print)978-0-7695-4129-7
DOIs
Publication statusPublished - 2010
Event2010 6th World Congress on Services - Miami, FL, United States
Duration: 5 Jul 201010 Jul 2010

Congress

Congress2010 6th World Congress on Services
Abbreviated titleServices-1
Country/TerritoryUnited States
CityMiami, FL
Period5/07/1010/07/10

Keywords

  • change data capture
  • log scanning
  • real-time
  • timestamps
  • triggers
  • web services

Fingerprint

Dive into the research topics of 'True real-time change data capture with web service database encapsulation'. Together they form a unique fingerprint.

Cite this