Data warehousing hastens the process of retrieving information needed for decision making. The spider web
diversity between both end-users and data marts inc reases traffic, load, and delay in accessing the requested information.
In this research, we have developed a query dispatc hing tool facilitating the access to the information within data marts,
eventually data warehouse in fast, and an organized fashionable way. The dispatching tool takes the query, analyzes it, and
decides which data mart as a destination that query should be forwarded to. This research is based on Ralph Kimball’s
methodology. The results show that the dispatching tool reduces the check time spent in the data dictionary within a logical
side of the data warehouse deciding the intended da ta mart and hence, minimizing execution time.
[1] Adhikari A., Ramachandrarao P., Prasad B., and Adhikari J., Mining Multiple Large Data Sources, The International Arab Journal of Information Technology , vol. 7, no. 3, pp 241' 249, 2010.
[2] BaOaran B., A Comparison of Data Warehouse Design Models, MSc Thesis, Computer Engineering, Atilim University, Turkey, 2005.
[3] Bontempo C. and Zagelow G., The IBM Data Warehouse Architecture, Communications of the ACM , vol. 41, no. 9, pp 38'48, 1998.
[4] Hamad M., Building Data Warehouse For Decision Support Systems, PhD Dissertation, Informatics Institute for Postgraduate Studies at Iraqi Commission for Computer and Informatics, Iraq, 2004.
[5] Kimball R., Ross W., and Thornthwaite W., The Data Warehouse Toolkit: Expert Methods for Designing , Developing , and Deploying Data Warehouse , Wiley, New York, 1998.
[6] Kumar P., The Data Warehousing: Continuing the Evolution, The Data Warehousing Institute World Conference , USA, http://www.docstoc.com/docs/23482116/The' Data'Warehousing, 2009.
[7] Nagabhushana S., Data Warehousing: OLAP and Data Mining , New Age International Ltd. Publishers, India, 2006.
[8] Ponniah P., Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals , John Wiley & Sons, Inc., New York, 2001.
[9] Wu L., Miller L., and Nilakanta S., Design of Data Warehouses Using Metadata, Information and Software Technology , vol. 43, no. 2, pp. 109' 119, 2001. Anmar Aljanabi is presently assistant lecturer at Computer Science Department, University of Technology, Iraq. He earned his BSc in computer science from Baghdad University, Iraq in 2003, and his MSc in computer science from Al' Balqa Applied University, Jordan in 2010. His research interest is in data warehouse, and image processing. Query Dispatching Tool Supporting Fast Access to Data Warehouse 275 Alaa Alhamami is presently professor of database security and dean of Computer Science and Informatics College, Amman Arab University, Jordan. He is a reviewer for several national and international journals and a keynote speaker for many conferences. He is supervising a lot of PhD, MSc, and Diploma theses. His research is focused on distributed databases, data warehouse, data mining, cryptography, steganography, and network security. Basim Alhadidi is presently an associate professor at The Department of Computer Science, Al'Balqa Applied University, Jordan. He earned his PhD in 2000, in Engineering Science (Computers, Systems and Networks). He received his MSc in 1996 in engineering science (Computer an d Intellectual Systems and Networks). He published many research papers in many topics such as: computer networks, image processing, and artificial neural networks. He is a reviewer for several journ als. He was appointed in many conferences as keynote speaker, reviewer, track chair and track co'chair.
Cite this
1Computer Science Department, University of Technolo gy, Iraq 2Computer Science and Informatics College, Amman Ara b University, Jordan 3Computer Science Department, Al'Balqa’ Applied University, Jordan, " Query Dispatching Tool Supporting Fast Access to Data Warehouse ", The International Arab Journal of Information Technology (IAJIT) ,Volume 10, Number 03, pp. 58 - 64, May 2013, doi: .
@ARTICLE{3351,
author={1Computer Science Department, University of Technolo gy, Iraq 2Computer Science and Informatics College, Amman Ara b University, Jordan 3Computer Science Department, Al'Balqa’ Applied University, Jordan},
journal={The International Arab Journal of Information Technology (IAJIT)},
title={ Query Dispatching Tool Supporting Fast Access to Data Warehouse },
volume={10},
number={03},
pages={58 - 64},
doi={},
year={1970}
}
TY - JOUR
TI - Query Dispatching Tool Supporting Fast Access to Data Warehouse
T2 -
SP - 58
EP - 64
AU - 1Computer Science Department
AU - University of Technolo gy
AU - Iraq 2Computer Science and Informatics College
AU - Amman Ara b University
AU - Jordan 3Computer Science Department
AU - Al'Balqa’ Applied University
AU - Jordan
DO -
JO - The International Arab Journal of Information Technology (IAJIT)
IS - 9
SN - 2413-9351
VO - 10
VL - 10
JA -
Y1 - Jan 1970
ER -
PY - 1970
1Computer Science Department, University of Technolo gy, Iraq 2Computer Science and Informatics College, Amman Ara b University, Jordan 3Computer Science Department, Al'Balqa’ Applied University, Jordan, " Query Dispatching Tool Supporting Fast Access to Data Warehouse ", The International Arab Journal of Information Technology (IAJIT) ,Volume 10, Number 03, pp. 58 - 64, May 2013, doi: .
Abstract: Data warehousing hastens the process of retrieving information needed for decision making. The spider web
diversity between both end-users and data marts inc reases traffic, load, and delay in accessing the requested information.
In this research, we have developed a query dispatc hing tool facilitating the access to the information within data marts,
eventually data warehouse in fast, and an organized fashionable way. The dispatching tool takes the query, analyzes it, and
decides which data mart as a destination that query should be forwarded to. This research is based on Ralph Kimball’s
methodology. The results show that the dispatching tool reduces the check time spent in the data dictionary within a logical
side of the data warehouse deciding the intended da ta mart and hence, minimizing execution time. URL: https://iajit.org/paper/3351
@ARTICLE{3351,
author={1Computer Science Department, University of Technolo gy, Iraq 2Computer Science and Informatics College, Amman Ara b University, Jordan 3Computer Science Department, Al'Balqa’ Applied University, Jordan},
journal={The International Arab Journal of Information Technology (IAJIT)},
title={ Query Dispatching Tool Supporting Fast Access to Data Warehouse },
volume={10},
number={03},
pages={58 - 64},
doi={},
year={1970}
,abstract={ Data warehousing hastens the process of retrieving information needed for decision making. The spider web
diversity between both end-users and data marts inc reases traffic, load, and delay in accessing the requested information.
In this research, we have developed a query dispatc hing tool facilitating the access to the information within data marts,
eventually data warehouse in fast, and an organized fashionable way. The dispatching tool takes the query, analyzes it, and
decides which data mart as a destination that query should be forwarded to. This research is based on Ralph Kimball’s
methodology. The results show that the dispatching tool reduces the check time spent in the data dictionary within a logical
side of the data warehouse deciding the intended da ta mart and hence, minimizing execution time. },
keywords={Data warehouse, metadata, query dispatching tool, e xecution time},
ISSN={2413-9351},
month={Jan}}
TY - JOUR
TI - Query Dispatching Tool Supporting Fast Access to Data Warehouse
T2 -
SP - 58
EP - 64
AU - 1Computer Science Department
AU - University of Technolo gy
AU - Iraq 2Computer Science and Informatics College
AU - Amman Ara b University
AU - Jordan 3Computer Science Department
AU - Al'Balqa’ Applied University
AU - Jordan
DO -
JO - The International Arab Journal of Information Technology (IAJIT)
IS - 9
SN - 2413-9351
VO - 10
VL - 10
JA -
Y1 - Jan 1970
ER -
PY - 1970
AB - Data warehousing hastens the process of retrieving information needed for decision making. The spider web
diversity between both end-users and data marts inc reases traffic, load, and delay in accessing the requested information.
In this research, we have developed a query dispatc hing tool facilitating the access to the information within data marts,
eventually data warehouse in fast, and an organized fashionable way. The dispatching tool takes the query, analyzes it, and
decides which data mart as a destination that query should be forwarded to. This research is based on Ralph Kimball’s
methodology. The results show that the dispatching tool reduces the check time spent in the data dictionary within a logical
side of the data warehouse deciding the intended da ta mart and hence, minimizing execution time.