期刊名称:The International Arab Journal of Information Technology
印刷版ISSN:1683-3198
出版年度:2013
卷号:10
期号:3
出版社:Zarqa Private University
摘要: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.
关键词:Data warehouse; metadata; query dispatching tool; and execution time.