Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System)

  • Hendra Suprayogi Universitas Brawijaya
  • Harry Soekotjo Dachlan Universitas Brawijaya
  • Muhammad Aswin Universitas Brawijaya
Keywords: Basis Data, Change Data Capture, Timestamp, Normalisasi, Entitas Runtutan, RDBMS

Abstract

A normalization process must be applied in the data structure in database designing process in RDBMS, in order to eliminate data anomaly and redundancy. This procedure increases access performance as well as reduces unnecessary storage space. It transforms a single entity into multiple entities, normalization process is often so-called decomposition. A problem occurs, however, after a normalized database is being implemented. When a new data recorded there is nothing wrong with its retrieval, while the retrieval process goes into the last data updated in the case of updating activity. Moreover, when a deletion occurred, the data can never be retrieved. Timestamped CDC method offers a way of tracking data change. Basically, timestamped CDC uses historical record to include timestamp everytime change occurs. Tracking updated record is simply done by the previous research of timestamped CDC, while keeping track on deleted data is impossible since the data vanished within the deletion process. This paper modifies the timestamped CDC method so that data deletion tracking can be achieved as well as data updating. Furthermore, this research also makes several testing procedures to find out performance of the modified timestamped CDC structures.

References

Bagui, Sikha, Earp, Richard, Database Design Using Entity-Relationship Diagrams, CRC Press., 2011.

JinGang Shi, YuBin Bao, FangLing Leng, & Ge Yu, “Study on Log-Based Change Data Capture and Handling Mechanism in Real-Time Data Warehouse”, International Conference on Computer Science and Software Engineering, 479-481, 2008.

Eccles, Mitchell J., Evans, David J., & Beaumont, Anthony J., “True Real-Time Change Data Capture WithWeb Service Database Encapsulation”, IEEE 6th World Congress on Services: 128-131, 2010.

Tank , Darshan M., Ganatra, Amit, Kosta, Y. P., & Bhensdadia, C K., “Speeding ETL Processing in Data Warehouses Using High-Performance Joins For Changed Data Capture (CDC)”, International Conference on Advances in Recent Technologies in Communication and Computing, 365-368, 2010.

Hussain, Tauqeer, Shamail, Shafay, & Awais, Mian M., “Eliminating Process of Normalization in Relational Database Design”, Proceedings IEEE INMIC, 408-413, 2003.

Abiteboul, Serge, Hull, Richard B., & Vianu, Victor, Foundations of Databases, Addison-Wesley, 1995.

Springsteel, Frederick N., “Entity-Relationship Logical Design of Database Systems”, IEEE: 581-582, 1988.

Microsoft Developer Network, 2014, Track Data Changes (SQL Server). [Online] https://msdn.microsoft.com/en-us/library/bb933994.aspx, tanggal akses: 2 Juli 2014.

How to Cite
Hendra Suprayogi, Harry Soekotjo Dachlan, & Muhammad Aswin. (1). Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System). Jurnal Nasional Teknik Elektro Dan Teknologi Informasi, 5(3), 168-176. Retrieved from https://journal.ugm.ac.id/v3/JNTETI/article/view/2930
Section
Articles