article

Materialised view selection using BCO

Authors:

T.V. Vijay Kumar,

Biri ArunAuthors Info & Claims

International Journal of Business Information Systems, Volume 22, Issue 3

Pages 280 - 301

Published: 01 January 2016 Publication History

Abstract

Economists in the post-industrial era had long realised that data, information and knowledge are the key capital of any organisation. Presently, almost every enterprise maintains their data in a data warehouse. This helps the analyst in accessing critical business information in real time using online analytical processing OLAP tools. Materialised views have been the popular mode used to achieve very fast OLAP operations. Selecting appropriate sets of optimal views, from amongst all possible views, is an NP-complete problem. In this paper, the bee colony optimisation BCO meta-heuristic, which is inspired by the foraging behaviour of bees in nature, has been adapted to address the view selection problem. In this regard, a BCO-based view selection algorithm BCOVSA, that selects the Top-K views from a multidimensional lattice, has been proposed. The experimental results show that BCOVSA, in comparison to the most fundamental greedy view selection algorithm HRUA, is able to select comparatively better quality of views.

References

[1]

Alzaqebah, M. and Abdullah, S. (2015) 'Hybrid bee colony optimization for examination timetabling problems', Computers & Operations Research, Vol. 54, pp. 142-154.

Digital Library

[2]

Amador-Angulo, L. and Castillo, O. (2014) 'Optimization of the type-1 and type-2 fuzzy controller design for the water tank using the bee colony optimization', in Wiener, N. (Ed.): In the 21st Century (21 CW), 2014 IEEE Conference, pp. 1-8.

[3]

Aouiche, K., Jouve, P.E. and Darmont, J. (2006) 'Clustering-based materialized view selection in data warehouses', Proceeding of 10th East-European Conference on Advances in Databases and Information Systems (ADBIS06), Thessaloniki, Greece, LNCS, Vol. 4152, pp. 81-95.

Digital Library

[4]

Beni, G. and Wang, J. (1993) 'Swarm intelligence in cellular robotic systems', Robots and Biological Systems: Towards a New Bionics?, NATO ASI Series, Vol. 102, pp. 703-712, Springer.

[5]

Boisot, M. and Canals, A. (2004) 'Data, information and knowledge: have we got it right?', Journal of Evolutionary Economics, Vol. 14, No. 1, pp. 43-67.

[6]

Bonabeau, E., Dorigo, M. and Theraulaz, G. (1999) Swarm Intelligence: From Natural to Artificial Systems, Oxford University Press, New York, USA.

[7]

Chaiyatham, T. and Ngamroo, I. (2012) 'Bee colony optimization of battery capacity and placement for mitigation of voltage rise by PV in radial distribution network', IPEC, 2012 Conference on Power & Energy, pp. 13-18.

[8]

Chaiyatham, T., Ngamroo, I., Pothiya, S. and Vachirasricirikul, S. (2009) 'Design of optimal fuzzy logic-PID controller using bee colony optimization for frequency control in an isolated wind-diesel system', Transmission & Distribution Conference & Exposition: Asia and Pacific, pp. 1-4.

[9]

Chirkova, R. and Yang, J. (2012) 'Materialized views', Foundations and Trends in Databases, Vol. 4, No. 4, pp. 295-405.

[10]

Chirkova, R., Halevy, A.Y. and Suciu, D. (2001) 'A formal perspective on the view selection problem', Proceedings of VLDB, pp. 59-68.

[11]

Davidovic, T., Ramljak, D., ¿elmic, M. and Teodorovic, D. (2011) 'Bee colony optimization for the p-center problem', Computers & Operations Research, Vol. 38, No. 10, pp. 1367-1376.

Digital Library

[12]

Davidovic, T., ¿elmic, M., Teodorovic, D. and Ramljak, D. (2012) 'Bee colony optimization for scheduling independent tasks to identical processors', Journal of Heuristics, Vol. 18, No. 4, pp. 549-569.

Digital Library

[13]

Derakhshan, R., Dehne, F.K., Korn, O. and Stantic, B. (2006) 'Simulated annealing for materialized view selection in data warehousing environment', Proceedings of the 24th IASTED International Conference on Database and Applications, ACTA Press Anaheim, CA, USA, pp. 89-94.

Digital Library

[14]

Derakhshan, R., Stantic, B., Korn, O. and Dehne, F. (2008) 'Parallel simulated annealing for materialized view selection in data warehousing environments', Lecture Notes in Computer Science, Vol. 5022, pp. 121-132.

Digital Library

[15]

Dorigo, M. (Ed.) (2006) 'Ant colony optimization and swarm intelligence', Proceedings 5th International Workshop, ANTS 2006, Brussels, Belgium, Vol. 4150.

[16]

Dyer, F.C. (2002) 'The biology of the dance language', Annual Review Entomology, Vol. 47, pp. 917-949.

[17]

Encinas-Serna, M.S. and Montano-Hoya, J.A. (2007) 'Algorithm for selection of materialized views: based on a costs model', Proc. of ICCT, pp. 18-24.

[18]

Frisch, K.V. (1967) The Dance Language and Orientation of Bees, Belknap Press (Harvard University Press), Cambridge, MA, USA.

[19]

Girsang, A.S., Tsai, C.W. and Yang, C.S. (2012) 'A fast bee colony optimization for traveling salesman problem', Innovations in Bio-Inspired Computing and Applications (IBICA), 2012 Third International Conference, pp. 7-12.

Digital Library

[20]

Gupta, H. (1997) 'Selection of views to materialize in a data warehouse', Database Theory - ICDT'97, pp. 98-112.

[21]

Gupta, H. and Mumick, I.S. (2005) 'Selection of views to materialize in a data warehouse', IEEE Transactions on Knowledge & Data Engineering, Vol. 17, No. 1, pp. 24-43.

Digital Library

[22]

Gupta, H., Harinarayan, V., Rajaraman, V. and Ullman, J. (1997) 'Index selection for OLAP', Proceedings of the 13th International Conference on Data Engineering, ICDE 97, Birmingham, UK, pp. 208-219.

[23]

Haider, M. and Vijay Kumar, T.V. (2011) 'Materialised views selection using size and query frequency', International Journal of Value Chain Management (IJVCM), Vol. 5, No. 2, pp. 95-105, Inderscience Publishers.

[24]

Halevy, A.Y. (2001) 'Answering queries using views: a survey', VLDB Journal, Vol. 10, No. 4, pp. 270-294.

Digital Library

[25]

Harinarayan, V., Rajaraman, A. and Ullman, J.D. (1996) 'Implementing data cubes efficiently', ACM SIGMOD Record, Vol. 25, No. 2, pp. 205-216.

Digital Library

[26]

Horng, J.T., Chang, Y.J., Liu, B.J. and Kao, C.Y. (1999) 'Materialized view selection using genetic algorithms in a data warehouse system', Evolutionary Computation, 1999: CEC 99: Proceedings of the 1999 Congress on, Vol. 3.

[27]

Huang, Y.M. and Lin, J.C. (2011) 'A new bee colony optimization algorithm with idle-time-based filtering scheme for open shop-scheduling problems', Expert Systems with Applications, Vol. 38, No. 5, pp. 5438-5447.

Digital Library

[28]

Inmon, W.H. (2003) Building the Data Warehouse, 3rd ed., Wiley Dreamtech India Pvt. Ltd., India.

[29]

Karaboga, D. (2005) An Idea Based on Honey Bee Swarm for Numerical Optimization, Technical Report-tr06, Vol. 200, Erciyes University, Engineering Faculty, Computer Engineering Department.

[30]

Kennedy, J., Kennedy, J.F. and Eberhart, R.C. (2001) Swarm Intelligence, Morgan Kaufmann Publishers, San Francisco, California, USA.

[31]

Lawrence, M. (2006) 'Multiobjective genetic algorithms for materialized view selection in OLAP data warehouses', Proceedings of the 8th Annual Conference on Genetic and Evolutionary Computation, pp. 699-706.

[32]

Lee, M. and Hammer, J. (2001) 'Speeding up materialized view selection in data warehouses using a randomized algorithm', International Journal of Cooperative Information Systems, Vol. 10, No. 3, pp. 327-353.

[33]

Low, M.Y.H., Chandramohan, M. and Choo, C.S. (2009) 'Application of multi-objective bee colony optimization algorithm to automated red teaming', Winter Simulation Conference, pp. 1798-1808.

Digital Library

[34]

Markovic, G.Z., Teodorovic, D.B. and Acimovic-Raspopovic, V.S. (2007) 'Routing and wavelength assignment in all-optical networks based on the bee colony optimization', AI Communications, Vol. 20, No. 4, pp. 273-285.

Digital Library

[35]

Nadeau, T.P. and Teorey, T.J. (2002) 'Achieving scalability in OLAP materialized view selection', Proc. of the 5th ACM International Workshop on Data Warehousing and OLAP, pp. 28-34.

Digital Library

[36]

Nikolic, M. and Teodorovic, D. (2013a) 'Empirical study of the bee colony optimization (BCO) algorithm', Expert Systems with Applications, Vol. 40, No. 11, pp. 4609-4620.

[37]

Nikolic, M. and Teodorovic, D. (2013b) 'Transit network design by bee colony optimization', Expert Systems with Applications, Vol. 40, No. 15, pp. 5945-5955.

Digital Library

[38]

Ni¿etic, I., Fertalj, K. and Mila¿inovic, B. (2007) 'An overview of decision support system concepts', 18th International Conference on Information and Intelligent Systems, September, pp. 251-256.

[39]

Psomas, N., Mitravinda, P. and Kolachalam (2002) Data Warehousing Fundamentals-Instructor Guide, Publisher Nita K. Brozowski.

[40]

Rahim, M.A., Musirin, I., Abidin, I.Z. and Othman, M.M. (2010) 'Contingency based congestion management and cost minimization using bee colony optimization technique', Power and Energy (PECon), 2010 IEEE International Conference on, pp. 891-896.

[41]

Roussopoulos, N. (1997) 'Materialized views and data warehouse', 4th Workshop KRDB, Athens, Greece, August.

[42]

Seeley, T.D. and Visscher, P.K. (1988) 'Assessing the benefits of cooperation in honeybee foraging: search costs, forage quality, and competitive ability', Behavioral Ecology and Sociobiology, Vol. 22, No. 4, pp. 229-237.

[43]

Shah, B., Ramachandran, K. and Raghavan, V. (2006) 'A hybrid approach for data warehouse view selection', International Journal of Data Warehousing and Mining, Vol. 2, No. 2, pp. 1-37.

[44]

Shukla, A., Deshpande, P.M. and Naughton, J.F. (1998) 'Materialized view selection for multidimensional datasets', Proc. of VLDB, pp. 488-500.

Digital Library

[45]

Sun, X. and Wang, Z. (2009) 'An efficient materialized views selection algorithm based on PSO', 2009 International Workshop on Intelligent Systems and Applications, pp. 1-4.

[46]

Teodorovic, D. and Dell'Orco, M. (2005) 'Bee colony optimization - a cooperative learning approach to complex transportation problems', Advanced OR and AI Methods in Transportation: Proceedings of 16th Mini-EURO Conference and 10th Meeting of EWGT, 13-16 September, pp. 51-60, Publishing House of the Polish Operational and System Research, Poznan.

[47]

Teodorovic, D., Lucic, P., Markovic, G. and Dell'Orco, M. (2006) 'Bee colony optimization: principles and applications', Neural Network Applications in Electrical Engineering, 2006: NEUREL 2006, 8th Seminar on, pp. 151-156.

[48]

Teodorovic, D., ¿elmic, M. and Mijatovic-Teodorovic, L. (2013) 'Combining case-based reasoning with bee colony optimization for dose planning in well differentiated thyroid cancer treatment', Expert Systems with Applications, Vol. 40, No. 6, pp. 2147-2155.

Digital Library

[49]

Todorovic, N. and Petrovic, S. (2013) 'Bee colony optimization algorithm for nurse rostering', Systems, Man, and Cybernetics: Systems, IEEE Transactions on, Vol. 43, No. 2, pp. 467-473.

[50]

Uchiyama, H., Runapongsa, K. and Teorey, T.J. (1999) 'A progressive view materialization algorithm', Proc. of DOLAP, pp. 36-41.

Digital Library

[51]

Valluri, S., Vadapalli, S. and Karlapalem, K. (2002) 'View relevance driven materialized view selection in data warehousing environment', Australian Computer Science Communications, Vol. 24, No. 2, pp. 187-196.

Digital Library

[52]

Vijay Kumar, T.V. and Devi, K. (2012) 'Materialized view construction in data warehouse for decision making', International Journal of Business Information Systems (IJBIS), Vol. 11, No. 4, pp. 379-396, Inderscience Publishers.

Digital Library

[53]

Vijay Kumar, T.V. and Ghoshal, A. (2009) 'A reduced lattice greedy algorithm for selecting materialized views', Communications in Computer and Information Science (CCIS), Vol. 31, pp. 6-18, Springer Verlag.

[54]

Vijay Kumar, T.V. and Haider, M. (2010) 'A query answering greedy algorithm for selecting materialized views', Lecture Notes in Artificial Intelligence (LNAI), Vol. 6422, pp. 153-162, Springer Verlag.

[55]

Vijay Kumar, T.V. and Haider, M. (2011a) 'Greedy views selection using size and query frequency', Communications in Computer and Information Science (CCIS), Vol. 125, pp. 11-17, Springer Verlag.

[56]

Vijay Kumar, T.V. and Haider, M. (2011b) 'Selection of views for materialization using size and query frequency', Communications in Computer and Information Science (CCIS), Vol. 147, pp. 150-155, Springer Verlag.

[57]

Vijay Kumar, T.V. and Haider, M. (2012) 'Materialized views selection for answering queries', Lecture Notes in Computer Science (LNCS), Vol. 6411, pp. 43-51, Springer Verlag.

[58]

Vijay Kumar, T.V. and Haider, M. (2015) 'Query answering based view selection', International Journal of Business Information Systems (IJBIS), Vol. 18, No. 3, pp. 338-353, Inderscience Publishers.

Digital Library

[59]

Vijay Kumar, T.V. and Kumar, S. (2012a) 'Materialized view selection using iterative improvement', Advances in Intelligent Systems and Computing (AISC), Vol. 178, pp. 205-214, Springer Verlag.

[60]

Vijay Kumar, T.V. and Kumar, S. (2012b) 'Materialized view selection using genetic algorithm', Communications in Computer and Information Science (CCIS), Vol. 306, pp. 225-237, Springer Verlag.

[61]

Vijay Kumar, T.V. and Kumar, S. (2012c) 'Materialized view selection using simulated annealing', Lecture Notes in Computer Science (LNCS), Vol. 7678, pp. 168-179, Springer Verlag.

[62]

Vijay Kumar, T.V. and Kumar, S. (2013) 'Materialized view selection using memetic algorithm', Lecture Notes in Artificial Intelligence (LNAI), Vol. 8284, pp. 316-327, Springer Verlag.

[63]

Vijay Kumar, T.V. and Kumar, S. (2014) 'Materialized view selection using differential evolution', International Journal of Innovative Computing and Applications (IJICA), Vol. 6, No. 2, pp. 102-113, Inderscience Publishers.

Digital Library

[64]

Vijay Kumar, T.V. and Kumar, S. (in press) 'Materialized view selection using randomized algorithms', International Journal of Business Information Systems (IJBIS), Inderscience Publishers.

[65]

Vijay Kumar, T.V., Goel, A. and Jain, N. (2010a) 'Mining information for constructing materialised views', International Journal of Information and Communication Technology (IJICT), Vol. 2, No. 4, pp. 386-405, Inderscience Publishers.

Digital Library

[66]

Vijay Kumar, T.V., Haider, M. and Kumar, S. (2010b) 'Proposing candidate views for materialization', Communications in Computer and Information Science (CCIS), Vol. 54, pp. 89-98, Springer Verlag.

[67]

Vijay Kumar, T.V., Haider, M. and Kumar, S. (2011) 'A view recommendation greedy algorithm for materialized views selection', Communications in Computer and Information Science (CCIS), Vol. 141, pp. 61-70, Springer Verlag.

[68]

Vijay Kumar. T.V. (2013) 'Answering query-based selection of materialised views', International Journal of Information and Decision Sciences (IJIDS), Vol. 5, No. 1, pp. 103-116, Inderscience Publishers.

[69]

Wong, L.P., Low, M.Y.H. and Chong, C.S. (2008a) 'A bee colony optimization algorithm for traveling salesman problem', Proceedings of the 2008 Second Asia International Conference on Modelling & Simulation (AMS), pp. 818-823.

[70]

Wong, L.P., Puan, C.H., Low, M.Y.H. and Chong, C.S. (2008b) 'Bee colony optimization algorithm with Big Valley landscape exploitation for job shop scheduling problems', Proceedings of the 2008 Winter Simulation Conference, Vol. 2, No. 2, pp. 85-99.

[71]

Wong, L.P., Low, M.Y.H. and Chong, C.S. (2009) 'An efficient bee colony optimization algorithm for traveling salesman problem using frequency-based pruning', Industrial Informatics, 2009: INDIN 2009: 7th IEEE International Conference on, pp. 775-782.

[72]

Wong, L.P., Low, M.Y.H. and Chong, C.S. (2010) 'Bee colony optimization with local search for traveling salesman problem', International Journal on Artificial Intelligence Tools, Vol. 19, No. 3, pp. 305-334.

[73]

Yu, J.X., Yao, X., Choi, C.H. and Gou, G. (2003) 'Materialized view selection as constrained evolutionary optimization', Systems, Man, and Cybernetics, Part C: Applications and Reviews, IEEE Transactions on, Vol. 33, No. 4, pp. 458-467.

Digital Library

[74]

Zeng, F., Decraene, J., Low, M.Y.H., Hingston, P., Wentong, C., Suiping, Z. and Chandramohan, M. (2010) 'Autonomous bee colony optimization for multi-objective function', Evolutionary Computation (CEC), 2010 IEEE Congress on, pp. 1-8.

[75]

Zhang, C., Yao, X. and Yang, J. (1999) 'Evolving materialized views in data warehouse', Evolutionary Computation, 1999: CEC 99: Proceedings of the 1999 Congress on, Vol. 2.

[76]

Zins, C. (2007) 'Conceptual approaches for defining data, information, and knowledge', Journal of the American Society for Information Science and Technology, Vol. 58, No. 4, pp. 479-493.

Cited By

Sebaa ANouicer ATari A(2019)Impact of technology evolution on the materialised viewsInternational Journal of Business Information Systems10.1504/ijbis.2019.09930530:4(427-462)Online publication date: 1-Jan-2019
https://dl.acm.org/doi/10.1504/ijbis.2019.099305
Kumar TKumar A(2018)Materialized View Selection Using Set Based Particle Swarm OptimizationInternational Journal of Cognitive Informatics and Natural Intelligence10.4018/IJCINI.201807010212:3(18-39)Online publication date: 1-Jul-2018
https://dl.acm.org/doi/10.4018/IJCINI.2018070102
Arun BKumar T(2017)Materialized View Selection using Artificial Bee Colony OptimizationInternational Journal of Intelligent Information Technologies10.4018/IJIIT.201701010213:1(26-49)Online publication date: 1-Jan-2017
https://dl.acm.org/doi/10.4018/IJIIT.2017010102
Show More Cited By

Recommendations

The bee colony optimization algorithm and its convergence

The bee colony optimization BCO algorithm is a nature-inspired meta-heuristic method for dealing with hard, real-life combinatorial and continuous optimisation problems. It is based on the foraging habits of honeybees and was proposed by Lučić and ...
Materialized View Selection using Artificial Bee Colony Optimization

Data warehouse is an essential component of almost every modern enterprise information system. It stores huge amount of subject-oriented, time-stamped, non-volatile and integrated data. It is highly required of the system to respond to complex online ...
TSP Problem Using Modified ABC Based on Dynamically Division of Bees
ICCUBEA '15: Proceedings of the 2015 International Conference on Computing Communication Control and Automation

Artificial Bee Colony Algorithm (ABC) is an optimization algorithm used to find out the global optima. In ABC, each bee stores the information of feasible solution or candidate solution and stochastically modifies this over time, based on the ...

Comments

Information & Contributors

Information

Published In

cover image International Journal of Business Information Systems

International Journal of Business Information Systems Volume 22, Issue 3

January 2016

137 pages

ISSN:1746-0972

EISSN:1746-0980

Issue’s Table of Contents

Publisher

Inderscience Publishers

Geneva 15, Switzerland

Publication History

Published: 01 January 2016

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 01 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Sebaa ANouicer ATari A(2019)Impact of technology evolution on the materialised viewsInternational Journal of Business Information Systems10.1504/ijbis.2019.09930530:4(427-462)Online publication date: 1-Jan-2019
https://dl.acm.org/doi/10.1504/ijbis.2019.099305
Kumar TKumar A(2018)Materialized View Selection Using Set Based Particle Swarm OptimizationInternational Journal of Cognitive Informatics and Natural Intelligence10.4018/IJCINI.201807010212:3(18-39)Online publication date: 1-Jul-2018
https://dl.acm.org/doi/10.4018/IJCINI.2018070102
Arun BKumar T(2017)Materialized View Selection using Artificial Bee Colony OptimizationInternational Journal of Intelligent Information Technologies10.4018/IJIIT.201701010213:1(26-49)Online publication date: 1-Jan-2017
https://dl.acm.org/doi/10.4018/IJIIT.2017010102
Kumar TArun B(2017)Materialized View Selection Using Bumble Bee Mating OptimizationInternational Journal of Decision Support System Technology10.4018/IJDSST.20170701019:3(1-27)Online publication date: 1-Jul-2017
https://dl.acm.org/doi/10.4018/IJDSST.2017070101

View Options

View options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Issue’s Table of Contents