Algorithms for vertical partitioning in database physical design
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. Our 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 our algorithm avoid the limitations of existing approaches, but also it performs better than existing algorithms in our comparative study.
If you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
As the access to this document is restricted, you may want to look for a different version under "Related research" (further below) or search for a different version of it.
Volume (Year): 22 (1994)
Issue (Month): 3 (May)
|Contact details of provider:|| Web page: http://www.elsevier.com/wps/find/journaldescription.cws_home/375/description#description|
|Order Information:|| Postal: http://www.elsevier.com/wps/find/supportfaq.cws_home/regional|
When requesting a correction, please mention this item's handle: RePEc:eee:jomega:v:22:y:1994:i:3:p:291-303. See general information about how to correct material in RePEc.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Zhang, Lei)
If references are entirely missing, you can add them using this form.