Distributed Data Warehouse Architecture: An Efficient Priority Allocation Mechanism for Query Formulation
Nouman MaqboolRao, Muheet Ahmed Butt, Majid Zaman, Waseem Jeelani Bakshi · 2013
Data warehouse is the repository where data for an enterprise is stored using a centralized approach. A data warehouse environment includes an extraction, transportation, transformation and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users. The category of users which access this warehouse is differentiated with respect to priority level. This paper discusses the priority of accessing the warehouse which is assigned to various set of users on the basis of the stature in the enterprise. An efficient priority balancing mechanism has been proposed in this research so that the data retrieved from the warehouse depends on the stature of the users.