An Integer Linear-Programming Approach To Data Allocation With The Minimum Total Communication Cost In Distributed Database-Systems

Xm Lin,M Orlowska
DOI: https://doi.org/10.1016/0020-0255(94)00070-R
IF: 8.1
1995-01-01
Information Sciences
Abstract:This paper investigates the problem of allocating relational database fragments to a network to minimize the overall communication cost for processing a given set of transactions. This problem is known as NP-hard. In this paper, we transfer the optimal data allocation problem to an integer linear program subject to various constraints, such as network load capacity and storage capacity of each individual computer. Using the presented transformation, we suggest the application of integer linear programming algorithms (fast in practice) to approach the optimal data allocation problem.
What problem does this paper attempt to address?