IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Localization of Data Sets in Distributed Database Systems Using Slope-Based Vertical Fragmentation

Localization of Data Sets in Distributed Database Systems Using Slope-Based Vertical Fragmentation
View Sample PDF
Author(s): Ashish Ranjan Mishra (Rajkiya Engineering College, Sonbhadra, India)and Neelendra Badal (Kamla Nehru Institute of Technology, India)
Copyright: 2020
Pages: 25
Source title: Handling Priority Inversion in Time-Constrained Distributed Databases
Source Author(s)/Editor(s): Udai Shanker (Madan Mohan Malaviya University of Technology, India)and Sarvesh Pandey (Madan Mohan Malaviya University of Technology, India)
DOI: 10.4018/978-1-7998-2491-6.ch003

Purchase

View Localization of Data Sets in Distributed Database Systems Using Slope-Based Vertical Fragmentation on the publisher's website for pricing and purchasing information.

Abstract

This chapter explains an algorithm that can perform vertical partitioning of database tables dynamically on distributed database systems. After vertical partitioning, a new algorithm is developed to allocate that fragments to the proper sites. To accomplish this, three major tasks are performed in this chapter. The first task is to develop a partitioning algorithm, which can partition the relation in such a way that it would perform better than most of the existing algorithms. The second task is to allocate the fragments to the appropriate sites where allocating the fragments will incur low communication cost with respect to other sites. The third task is to monitor the change in frequency of queries at different sites as well as same site. If the change in frequency of queries at different sites as well as the same site exceeds the threshold, the re-partitioning and re-allocation are performed.

Related Content

Tapan Kumar Behera. © 2023. 20 pages.
B. Narendra Kumar Rao. © 2023. 17 pages.
Blendi Rrustemi, Deti Baholli, Herolind Balaj. © 2023. 18 pages.
Alma Beluli. © 2023. 11 pages.
Jona Ndrecaj, Shkurte Berisha, Erita Çunaku. © 2023. 15 pages.
Yllka Totaj. © 2023. 12 pages.
Hla Myo Tun, Devasis Pradhan. © 2023. 31 pages.
Body Bottom