Call For Papers
Contact Us

  A Modified Vertical Fragmentation Strategy for Distributed Database  
  Authors : Gamal H. Eladl
  Cite as:


In the last decade; distributed database (DDB) has been developed for solving the problem of huge amount of uploaded data over different network sites. Fragmentation is one of the most important strategies/solutions in order to distribute the organization's database according to its three type (vertical, horizontal, mixed/hybrid). Furthermore, it reduces the amount of irrelevant data, disk access, and a single source bottleneck. In this paper, a modified vertical fragmentation strategy that is divided any single relation's attributes into two or more partitions but by using the advantages of fuzzy logic concept. The modified strategy allows the distributed database designer to specify the weight (membership function) of all attributes' importance before partitioning it in order to get accurate projection. The application of this strategy will be led to accurate fragmentation strategy.


Published In : IJCSN Journal Volume 6, Issue 4

Date of Publication : August 2017

Pages : 505-508

Figures :02

Tables : 04


Gamal H. Eladl : Information Systems Department, Mansoura University, Faculty of Computers and Information Sciences, El-Mansoura, 35516 D.K, Egypt.


DDB, Vertical Fragmentation, Projection, Fuzzy logic, Weight, Membership Function

Distributed database is an important research area because it needs more effort to utilize the available resources with the correct placement of data/fragment and the program/application across a computer network sites. The fragmentation represents the unit of distribution. The success of any fragmentation strategy depends on the accurate selection/choice of appropriate partitions on the suitable site according to the organization's need. We explore the vertical fragmentation technique using the concept of fuzzy logic. As mention above, all the time fuzzy is better than crisp logic. It deals with numerous ranges of data (numeric or linguistics). A guideline steps are introduced to convert any system into a fuzzy-based system. DDB's designer is responsible for determining and calculating the importance of any attribute (weight) by using the application's query log to assign the accurate value of its membership function. This modified vertical fragmentation strategy can be applied to any optimized technique to find the best fragmentation allocation.


[1] S.K. Verma," Fragmentation techniques for distribution database: A Review", IJICSE, Vol. 3, Issue 2; April 2016. [2] A. Patel , et. al " A review on Fragmentation Techniques in Distributed Database", IJMTER, Vol. 01, Issue 03, September 2014. [3] R. Basseda, "Fragment Allocation in Distributed Database Systems", online available at https://pdfs.semanticscholar.org/00dd/a697ceef89bea2 d4c9fddf738aa54b48bd06.pdf last accessed on May 2017 [4] A.B. Deshmukh, et. al. "Horizontal Fragmentation Technique in Distributed Database", IJSRP, Vol.2, Issue 5, May 2015 [5] Suksawat, Bandit. "Diameter Error Prediction Using Fuzzy Logic for Cast Nylon 6 Turning Operation", IERI Procedia, 2014. [6] Huang, Shouren, Yuji Yamakawa, Taku Senoo, and Masatoshi Ishikawa. "A Pre-compensation Fuzzy Logic Algorithm Designed for the Dynamic Compensation Robotic System", International Journal of Advanced Robotic Systems, 2015.