Column generation-based algorithm for fragment allocation: minimizing query splitting in distributed databases.
Saved in:
| Title: | Column generation-based algorithm for fragment allocation: minimizing query splitting in distributed databases. |
|---|---|
| Authors: | Amiri, Ali1 (AUTHOR) amiri@okstate.edu |
| Source: | Information Technology & Management. Dec2025, Vol. 26 Issue 4, p559-572. 14p. |
| Subjects: | Distributed databases, Column generation (Algorithms), Data distribution, Computer performance, Algorithms, Economic efficiency, Turnaround time |
| Abstract: | This paper focuses on the fragment allocation problem in distributed databases and proposes an approach that minimizes query splitting. Query splitting occurs when a query has to access multiple servers to retrieve the fragments it needs, resulting in reduced system performance. The objective of minimizing query splitting is important because it captures many factors that affect the performance of the database, such as reducing response time and cost. The paper presents a column generation-based algorithm to solve the fragment allocation problem, which requires less fine-tuning of its parameters and outperforms the IP approach implemented by CPLEX in terms of the number of queries split and execution time. The approach and algorithm offer practical solutions to optimize the design of a distributed database system. The paper's contribution is significant as it fills the gap in the literature by offering a novel approach that minimizes query splitting, which can serve as a proxy for achieving a combination of other objectives such as minimizing costs, reducing response time, and balancing server workloads. [ABSTRACT FROM AUTHOR] |
| Copyright of Information Technology & Management is the property of Springer Nature and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Engineering Source |
|
Full text is not displayed to guests.
Login for full access.
|
|
Be the first to leave a comment!
