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, nor...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Universitas Gadjah Mada
2016-08-01
|
| Series: | Jurnal Nasional Teknik Elektro dan Teknologi Informasi |
| Subjects: | |
| Online Access: | http://ejnteti.jteti.ugm.ac.id/index.php/JNTETI/article/view/253 |
| _version_ | 1828878555529871360 |
|---|---|
| author | Hendra Suprayogi Harry Soekotjo Dachlan Muhammad Aswin |
| author_facet | Hendra Suprayogi Harry Soekotjo Dachlan Muhammad Aswin |
| author_sort | Hendra Suprayogi |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-12-13T09:09:15Z |
| format | Article |
| id | doaj.art-77a7e15188294a73bc661aa73a624ef8 |
| institution | Directory Open Access Journal |
| issn | 2301-4156 2460-5719 |
| language | English |
| last_indexed | 2024-12-13T09:09:15Z |
| publishDate | 2016-08-01 |
| publisher | Universitas Gadjah Mada |
| record_format | Article |
| series | Jurnal Nasional Teknik Elektro dan Teknologi Informasi |
| spelling | doaj.art-77a7e15188294a73bc661aa73a624ef82022-12-21T23:53:00ZengUniversitas Gadjah MadaJurnal Nasional Teknik Elektro dan Teknologi Informasi2301-41562460-57192016-08-015316817610.22146/jnteti.v5i3.253Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System)Hendra Suprayogi0Harry Soekotjo Dachlan1Muhammad Aswin2Universitas Brawijaya Universitas Brawijaya Universitas Brawijaya 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.http://ejnteti.jteti.ugm.ac.id/index.php/JNTETI/article/view/253basis datachange data capturetimestampnormalisasientitas runtutanrdbms |
| spellingShingle | Hendra Suprayogi Harry Soekotjo Dachlan Muhammad Aswin Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System) Jurnal Nasional Teknik Elektro dan Teknologi Informasi basis data change data capture timestamp normalisasi entitas runtutan rdbms |
| title | Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System) |
| title_full | Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System) |
| title_fullStr | Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System) |
| title_full_unstemmed | Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System) |
| title_short | Modifikasi Metode Timestamped Change Data Capture pada RDBMS (Relational Database Management System) |
| title_sort | modifikasi metode timestamped change data capture pada rdbms relational database management system |
| topic | basis data change data capture timestamp normalisasi entitas runtutan rdbms |
| url | http://ejnteti.jteti.ugm.ac.id/index.php/JNTETI/article/view/253 |
| work_keys_str_mv | AT hendrasuprayogi modifikasimetodetimestampedchangedatacapturepadardbmsrelationaldatabasemanagementsystem AT harrysoekotjodachlan modifikasimetodetimestampedchangedatacapturepadardbmsrelationaldatabasemanagementsystem AT muhammadaswin modifikasimetodetimestampedchangedatacapturepadardbmsrelationaldatabasemanagementsystem |