Particle swarm optimisation for data warehouse logical design

International Journal of Bio-Inspired Computation

Volumn 4, Issue 4, 2012, Pages 249-257

  Derrar, Hacène ^a   Ahmed Nacer, Mohamed ^a   Boussaid, Omar ^b  

^a UNIVERSITY OF SCIENCES AND TECHNOLOGY HOUARI BOUMEDIENE   (Algeria)

^b UNIVERSITÉ LUMIÈRE LYON 2   (France)

Author keywords

Bio inspired computation; Data warehouse; Fragmentation; OLAP queries; Particle swarm optimisation; Performance; PSO

Indexed keywords

BIOMIMETICS; DATA WAREHOUSES; DESIGN; INFORMATION MANAGEMENT; QUERY PROCESSING;

BIO INSPIRED COMPUTATION; FRAGMENTATION; OLAP QUERIES; PARTICLE SWARM OPTIMISATION; PERFORMANCE;

PARTICLE SWARM OPTIMIZATION (PSO);

EID: 84864233426     PISSN: 17580366     EISSN: 17580374     Source Type: Journal    
DOI: 10.1504/IJBIC.2012.048072     Document Type: Article

References (26)

1. Agrafiotis, D.K. and Cedeno, W. (2002) 'Feature selection for structure-activity correlation using binary particle swarms', Journal of Medicinal Chemistry, Vol. 45, No. 5, pp. 1098-1107. (Pubitemid 34173920)
2. Bellatreche, L. and Boukhalfa, K. (2005) 'An evolutionary approach to schema partitioning selection in a data warehouse environment', Proceeding of the International Conference on Data Warehousing and Knowledge Discovery (DAWAK'05).
3. Bernardino, J., Furtado, P. and Madeira, P.H. (2002) 'Approximate query answering using data warehouse striping', Journal of Intelligent Information Systems - Integrating Artificial Intelligence and Database Technologies, Vol. 19, No. 2, pp. 145-167, Elsevier Science Publication. (Pubitemid 34950898)
4. Blankinship, R., Hevner, A.R. and Yao, S.B. (1991) 'An interactive method for distributed database design', in Lohman, G.M., Sernadas, A. and Camps, R. (Eds.): Proceedings of the 17th International Conference on Very Large Data Bases, Morgan Kaufmann, pp. 389-400.
5. Ceri, S., Negri, M. and Pelagatti, G. (1982) 'Horizontal data partitioning in data base design', Proceeding of the ACM SIGMOD, International Conference on Management of Data, SIGPLAN Notices, pp. 128-136.
6. Cheng, C-H., Lee, W-K. and Wong, K-F. (2002) 'A genetic algorithm-based clustering approach for database partitioning', IEEE Transactions on Systems, Man, and Cybernetics, Vol. 32, No. 3, pp. 215-230.
7. Clerc, M. (2004) 'Discrete particle swarm optimization', in Onwubolu, G.C. and Babu, B.V. (Eds.): New Optimization Techniques in Engineering, pp. 219-204, Springer-Verlag.
8. Golfarelli, M., Maio, D. and Rizzi, S. (1999) Vertical Fragmentation of Views in Relational Data Warehouses, Université de Bologne, Italy.
9. Gorla, N. (2001) 'An object-oriented database design for improved performance', Data & Knowledge Engineering, Vol. 37, No. 2, pp. 117-138. (Pubitemid 32287851)
10. Gourgand, M. and Tchomté, S.M. (2007) Une extention de l'optimisation par essaims particu-laires, Séminaire francophone sur l'OEP, France.
11. He, Z., Wei, C., Yang, L., Gao, X., Yao, S., Eberhart, R.C. and Shi, Y. (1998) 'Extracting rules from fuzzy neural network by particle swarm optimization', Proceedings of IEEE Congress on Evolutionary Computation (CEC), Anchorage, Alaska, USA, pp. 74-77.
12. Karlapalem, K., Navathe, S.B. and Ammar, M. (1996) 'Optimal redesign policies to support dynamic processing of applications on a distributed database system', Information Systems, Vol. 21, No. 4, pp. 353-367. (Pubitemid 126404325)
13. Kennedy, J. and Eberhart, R.C. (1995) 'Particle swarm optimization', in IEEE Service Center (Ed.): Proceedings of the 1995 IEEE International Conference on Neural Networks, pp. 1942-1948.
14. Kimball, R. (1996) The Data Warehouse Toolkit, Ed Wiley, New York.
15. Maniezzo, V., Carbonaro, A., Golfarelli, M. and Rizzi, S. (2001) 'ANTS for data warehouse logical design', Proceeding 4th Metaheuristics International Conference, Porto.
16. Navathe, S., Ceri, S., Wierhold, G. and Dou, J. (1984) 'Vertical partitioning algorithms for database design', ACM Transactions on Database Systems, Vol. 9, No. 4, pp. 680-710. (Pubitemid 15456037)
17. Noaman, A.Y. and Barker, K. (1999) 'A horizontal fragmentation algorithm for the fact relation in a distributed data warehouse', in The 8th International Conference on Information and Knowledge Management (CIKM'99), pp. 154-161. (Pubitemid 32262536)
18. Omran, M., Salman, A. and Engelbrecht, A.P. (2002) 'Image classification using particle swarm optimization', in Proceedings of the 4th Asia-Pacific Conference on Simulated Evolution and Learning (SEAL), pp. 370-374.
19. Ozsu, M.T. and Valduriez, P. (1999) Principles of Distributed Database Systems, 2nd ed., Prentice Hall, Upper. Saddle River, NJ, USA.
20. Sacco, G. (1986) 'Fragmentation: a technique for efficient query processing', ACM Transaction on Database Systems, Vol. 11, No. 2, pp. 113-133. (Pubitemid 16586163)
21. Song, S.K. and Gorla, N. (2000) 'A genetic algorithm for vertical fragmentation and access path selection', The Computer Journal, Vol. 45, No. 1, pp. 81-93. (Pubitemid 32132851)
22. Sousa, T., Neves, A. and Silva, A. (2003) 'Swarm optimisation as a new tool for data mining', in Proceedings of NIDICS, Nice, France.
23. Ujjin, S. and Bentley, P.J. (2003) 'Particle swarm optimization recommender system', in Proceedings of the IEEE Swarm Intelligence Symposium 2003, pp. 124-131, Indianapolis, Indiana, USA.
24. Xiao, X., Dow, E., Eberhart, R., BenMiled, Z. and Oppel, R.J. (2003) 'Gene clustering using self-organizing maps and particle swarm optimization', in Second IEEE International Workshop on High Performance Computational Biology (HICOMB).
25. Xinjian, L. and Lowenthal, F. (2004) 'Arranging fact table records in a data warehouse to improve query performance', Computers & Operations Research, Vol. 31, No. 13, pp. 2165-2182. (Pubitemid 38791068)
26. Zhang, Y. and Orlowska, M.E. (1994) 'On fragmentation approaches for distributed database design', Information Science, Vol. 1, No. 3, pp. 117-132.