A Replication Scheme for Multiple Fragmentations with Overlapping Fragments. (6th August 2016)

• Record Type: Journal Article
• Authors: Wiese, Lena; Waage, Tim; Bollwein, Ferdinand
• Is Part Of: Computer journal. Volume 60:Number 3(2017)
• Page Start: 308
• Page End: 328
• Publication Date: 2016-08-06
• Subjects: bin packing problem with conflicts (BPPC) -- data replication problem (DRP) -- distributed database -- fragmentation -- integer linear programming (ILP); Computers -- Periodicals; 005.1
• DOI: 10.1093/comjnl/bxw041
• Languages: English
• ISSNs: 0010-4620

Abstract

Abstract: In this article, we introduce a replication procedure in a distributed database system that supports several fragmentations of the same data table. One application that requires multiple fragmentations is flexible (similarity-based) query answering. The major feature of our replication procedure is that replication and recovery respect the overlaps of fragments stemming from different fragmentations. In this paper we extend the data replication problem by not only considering hard constraints to ensure a fixed replication factor but also adding soft constraints that express desired data locality of fragments. We furthermore analyze the case that there are more fragmentations (leading to the situation that some replication conditions are optional); and we study the influences of data updates (insertions and deletions) on the data distribution.