Abstract

Among the techniques that the distributed database designer considers for performance improvement are fragmentation, replication and allocation techniques. Fragmentation is the process of dividing a relation into two or more relations called fragments. Usually two fragmentation techniques are considered, these are: vertical and horizontal fragmentation. A third rarely considered one is hybrid or mixed fragmentation. In this paper, vertical fragmentation along with a two-phases allocation method in the context of relational DDBSs is proposed to partition a relation vertically and allocate the resulting fragments/attributes across different sites. The proposed algorithm will greatly minimize communication cost and query response time in DDBSs. Empirical results have supported this hypothesis and shown that this method will present an efficient solution to vertical fragmentation and allocation problem in distributed environments.

Full Text

Published Version

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.