Query Dispatching Tool Supporting Fast Access to Data Warehouse

TLDR: 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.

Abstract: D ata 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