Algorithms for vertical partitioning in database physical design

Algorithms for vertical partitioning in database physical design

0.00 Avg rating0 Votes
Article ID: iaor19951115
Country: United Kingdom
Volume: 22
Issue: 3
Start Page Number: 291
End Page Number: 303
Publication Date: May 1994
Journal: OMEGA
Authors:
Keywords: computers: data-structure, Computers: data structure
Abstract:

An overriding objective in database physical design is to minimize the number of accesses made in the secondary storage when processing transactions. Vertical partitioning is a major step in database physical design to ensure fewer disk accesses. This paper defines the vertical partitioning problem and discusses the limitations of existing clustering algorithms for the problem. A new clustering algorithm is proposed. The algorithm uses the branch and bound approach. It may use an optimal or heuristic branching scheme and therefore it may generate optimal or approximate solutions. Not only does the algorithm avoid the limitations of existing approaches, but also it performs better than existing algorithms in the present comparative study.

Reviews

Required fields are marked *. Your email address will not be published.