TY - JOUR ID - 281 TI - A Solution to View Management to Build a Data Warehouse JO - AUT Journal of Electrical Engineering JA - EEJ LA - en SN - 2588-2910 AU - Daneshpour, N. AU - Abdollahzadeh Barfourosh, A. AD - Corresponding Author, N. Daneshpour is a PhD candidate of the Department of Computer Engineering & Information Technology, Amirkabir University of Technology, Tehran, Iran (email: daneshpour@aut.ac.ir). AD - A. Abdollahzadeh Barfourosh is with the Department of Computer Engineering & Information Technology, Amirkabir University of Technology, Tehran, Iran (e-mail: ahmad@ce.aut.ac.ir). Y1 - 2009 PY - 2009 VL - 41 IS - 2 SP - 17 EP - 27 KW - Algorithm classification KW - data warehousing KW - view management KW - view materialization KW - view selection DO - 10.22060/eej.2009.281 N2 - Several techniques exist to select and materialize a proper set of data in a suitable structure that manage the queries submitted to the online analytical processing systems. These techniques are called view management techniques, which consist of three research areas: 1) view selection to materialize, 2) query processing and rewriting using the materialized views, and 3) maintaining materialized views. There are several parameters should be considered in order to find the most important algorithm for view management. As various researches have been done to propose view selection algorithms, we should select and modify the most suitable algorithm for view materialization based on the properties of the applications. In this paper, we investigate and find relevant parameters to view selection algorithms and classify them based on these parameters. We also present a system to evaluate algorithms and compare them with respect to the values of the evaluation parameters. Based on the results of these activities, we propose a roadmap that helps us choose the most efficient view selection algorithm concerning application types. UR - https://eej.aut.ac.ir/article_281.html L1 - https://eej.aut.ac.ir/article_281_921feaff71a8f4754313270d116e8bbf.pdf ER -