Query Dispatching Tool Supporting Fast Access to Data Warehouse
Anmar Aljanabi1, Alaa Alhamami2, and Basim Alhadidi3
1Computer Sciences Department, University of Technology, Iraq
2Computer Sciences and Informatics College, Amman Arab University, Jordan
3Information Technology Department, Prince Abdullah Bin Ghazi Faculty of Science and Information
Technology, Al-Balqa’ Applied University, Jordan
1Computer Sciences Department, University of Technology, Iraq
2Computer Sciences and Informatics College, Amman Arab University, Jordan
3Information Technology Department, Prince Abdullah Bin Ghazi Faculty of Science and Information
Technology, Al-Balqa’ Applied University, Jordan
Abstract: Data warehousing hastens the process of retrieving information needed for decision making. The spider web diversity between both end-users and data marts increases traffic, load, and delay in accessing the requested information. In this research, we have developed a query dispatching 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 data mart and hence, minimizing execution time.
Keywords: Data warehouse, metadata, query dispatching tool, and execution time.
Received October 12, 2010; accepted May 24, 2011