A Design and Implementation of Efficient Algorithm for Materialized View Selection with its Preservation in a Data Warehouse Environment
Journal: International Journal of Science and Research (IJSR) (Vol.4, No. 11)Publication Date: 2015-11-05
Authors : Sapna Choudhary; Roshna Mahajan;
Page : 1598-1606
Keywords : Data warehouse DW; Materialized View MV; Processing time; Query Frequency; Area; Performance and Preservation;
Abstract
Though, different approaches designed by the researchers to select views in order to materialized it in a data warehouse (DW) with aim of speed up to access the requisite information, most of having still a sort of limitations/constraints. In order to remove constraints/limitations, we have designed an efficient algorithm of MV selections with its preservation by considering the three operating parameters viz. processing time, query frequency and query area required. The performance of selected MV of any query with respect to those query selected directly from data warehouse was presented in term of access time required. The result shows that MVs access time of any queries was found to be very less as compared to that queries access directly from data warehouse. The results also presented that the performance of selected MV for any query in terms of access time should be outstanding if our data warehouse contains huge data. The preservation of selected MVs depended upon the area required and frequency of the query. Assigning the same frequency to all queries of selected MVs, then the preservation depended upon only area required to be stored by any query. The result shows the preservation of query also.
Other Latest Articles
- Developed Forward and Inverse Modelling of Vertical Electrical Sounding (VES) Using MATLAB Implementation
- Study of Controlling Cloud Data Access Privilege and Attribute Based Data Sharing with Attribute Revocation
- Multiple Objectives and Outsourcing Contracts in IT Outsourcing
- Data Hiding in H.264/AVC Video Encryption with XOR-ed User Information and Data in File Format
- Design and Analysis of Stimulated Brillouin Scattering in Fiber Optic System for Distributed Sensing Using Optisystem
Last modified: 2021-07-01 14:26:37