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

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.

[1]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .

[2]  Ge Yu,et al.  Study on Log-Based Change Data Capture and Handling Mechanism in Real-Time Data Warehouse , 2008, 2008 International Conference on Computer Science and Software Engineering.

[3]  David J. Evans,et al.  True Real-Time Change Data Capture with Web Service Database Encapsulation , 2010, 2010 6th World Congress on Services.

[4]  F.N. Springsteel Entity-relationship logical design of database systems: relational normal forms and extended regular ERDs , 1988, [1988] Proceedings of the Twenty-First Annual Hawaii International Conference on System Sciences. Volume II: Software track.

[5]  Amit Ganatra,et al.  Speeding ETL Processing in Data Warehouses Using High-Performance Joins for Changed Data Capture (CDC) , 2010, 2010 International Conference on Advances in Recent Technologies in Communication and Computing.

[6]  M.M. Awais,et al.  Eliminating process of normalization in relational database design , 2003, 7th International Multi Topic Conference, 2003. INMIC 2003..

[7]  Sikha Bagui,et al.  Database design using entity-relationship diagrams , 2003 .