Details

Autor(en) / Beteiligte

• Adil, S. H.
• Ebrahim, M.
• Ali, S. S. A.
• Raza, K.

Titel

Performance Analysis of Duplicate Record Detection Techniques

Ist Teil von

• Engineering, technology & applied science research, 2019-10, Vol.9 (5), p.4755-4758

Ort / Verlag

D. G. Pylarinos

Erscheinungsjahr

2019

Quelle

Free E-Journal (出版社公開部分のみ）

Beschreibungen/Notizen

• In this paper, a comprehensive performance analysis of duplicate data detection techniques for relational databases has been performed. The research focuses on traditional SQL based and modern bloom filter techniques to find and eliminate records which already exist in the database while performing bulk insertion operation (i.e. bulk insertion involved in the loading phase of the Extract, Transform, and Load (ETL) process and data synchronization in multisite database synchronization). The comprehensive performance analysis was performed on several data sizes using SQL, bloom filter, and parallel bloom filter. The results show that the parallel bloom filter is highly suitable for duplicate detection in the database.