Title of article :
Indexed View Technique to Speed-up Data Warehouse Query Processing
Author/Authors :
Al Taleb ، Talib M. J. College of Information Engineering - Al-Nahrain University , Hasan ، Sami College of Information Engineering - Al-Nahrain University , Mahdi ، Yaqoob Yousif College of Information Engineering - Al-Nahrain University
Abstract :
The data warehouse size and query complexity may cause an unacceptable delay in decision support queries. A basic condition for the success of a data warehouse is the capability to supply decisionmakers with both precise information and best response time. For this purpose, the concept of indexed views is used. Indexed views help to speedup query processing and reduce the response time for tracing queries, especially for queries about past histories.
Keywords :
Data Warehouse (Star Schema) , Indexed View , Query Processing
Journal title :
ISeCure - The ISC International Journal of Information Security
Journal title :
ISeCure - The ISC International Journal of Information Security
