Query dispatching tool supporting fast access to data warehouse

Abstract EN

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.