A bi-tour ant colony optimisation framework for vertical partitions

Clustering refers to a process of grouping together similar objects while separating out the dissimilar objects. In this work, we consider block clustering in vertical partitioning. Block clustering is a specific clustering method, which clusters the sets of objects and their associated attributes (descriptors) together, simultaneously, in a solution matrix. For this specific problem we propose using a bi-tour ant colony optimisation. To show the quality of the new proposed approach, we conduct an extensive computational study and show that our method is performed better than some traditional clustering methods, such as genetic algorithms and average linkage clustering.

[1]  D. Duffy,et al.  A permutation-based algorithm for block clustering , 1991 .

[2]  Maria E. Orlowska,et al.  On fragmentation approaches for distributed database design , 1994 .

[3]  Shamkant B. Navathe,et al.  Vertical partitioning for database design: a graphical algorithm , 1989, SIGMOD '89.

[4]  Vivek R. Narasayya,et al.  Integrating vertical and horizontal partitioning into automated physical database design , 2004, SIGMOD '04.

[5]  Paul J. Schweitzer,et al.  Problem Decomposition and Data Reorganization by a Clustering Technique , 1972, Oper. Res..

[6]  Philip S. Yu,et al.  A vertical partitioning algorithm for relational databases , 1987, 1987 IEEE Third International Conference on Data Engineering.

[7]  Chun Hung Cheng A branch and bound clustering algorithm , 1995, IEEE Trans. Syst. Man Cybern..

[8]  Luca Maria Gambardella,et al.  Ant colony system: a cooperative learning approach to the traveling salesman problem , 1997, IEEE Trans. Evol. Comput..

[9]  Philip S. Yu,et al.  An Effective Approach to Vertical Partitioning for Physical Design of Relational Databases , 1990, IEEE Trans. Software Eng..

[10]  John A. Hartigan,et al.  Clustering Algorithms , 1975 .

[11]  Michael Hammer,et al.  A heuristic approach to attribute partitioning , 1979, SIGMOD '79.

[12]  Kwan-Ho Woo,et al.  Bi-Tour Ant Colony Optimization for Diagonal Clustering , 2005, WSTST.

[13]  Jeng-Shyang Pan,et al.  Constrained Ant Colony Optimization for Data Clustering , 2004, PRICAI.

[14]  Myoung Ho Kim,et al.  An adaptable vertical partitioning method in distributed systems , 2004 .

[15]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[16]  Yin-Fu Huang,et al.  Vertical Partitioning in Database Design , 1995, Inf. Sci..

[17]  Donald K. Burleson,et al.  Physical Database Design Using Oracle , 2004 .

[18]  Shamkant B. Navathe,et al.  Vertical partitioning algorithms for database design , 1984, TODS.

[19]  Dennis G. Severance,et al.  Mathematical Techniques for Efficient Record Segmentation in Large Shared Databases , 1976, JACM.