slugThe Approaches of Materialize View Maintenance Process in Data Warehousing
Journal Title: International Journal of Management, IT and Engineering - Year 2012, Vol 2, Issue 4
Abstract
Materialized view maintenance is a significant issue due to the growing use of warehouse technology for information integration and data analysis. Materialized views are used to speed up query processing on large amounts of data. In large databases particularly in distributed database, query response time plays an important role as timely access to information and it is the basic requirement of successful business application. These views need to be maintained in response to updates in the source data. Typically, a view is maintained immediately, as a part of the transaction that updates the base tables called as eager view maintenance. Immediate view maintenance imposes a significant overhead on update transaction that cannot be tolerated in many applications. A materialized view can be maintained lazily as maintenance is postponed until the system has free cycle or after a specific time period called a deferred view maintenance. Experiments using a prototype implementation in Oracle 9i show much faster response times for updates and also significant reduction in maintenance cost when combining updates.
Authors and Affiliations
Mr. Sanjay S. Solanki and Dr. Ajay Kumar
Keywords
Related Articles
- EP ID EP18251
- DOI -
- Views 314
- Downloads 13
STUDY THE EFFECT OF CHANNEL DOPING CONCENTRATION AND SOI LAYER THICKNESS ON ELECTRICAL BEHAVIOUR OF SOI MOSFET USING SILVACO TCAD SIMULATOR
This paper presents the result of process and device simulation using silvaco TCAD tools to develop SOI MOSFET. The aim of this simulation work is to study effect of channel doping concentration and SOI layer thickness...
RP – THE CHANGES TRENDS OF INFORMATION TECHNOLOGY
This research presents an overview of the Systems Applications and Products in Data Processing (SAP) Enterprise Resource Planning (ERP) implementation methodology and important tools that make SAP a complete solution t...
An Application of Porters Stemming Algorithm for Text Mining in Healthcare
Text mining has diverse applications in variety of fields where manual analysis and generating effective knowledge discovery from information is not possible because of huge availability of information on website. Ther...
Role of Mobile computing in developing technologies
Mobile computing has changed the complete panorama of our everyday lifestyles. It is fitting most important due to the upward thrust within the number of transportable computer systems and the wish to have steady commu...
A Case Study on Customer Review based Sentiment Analysis
Abstract – Today large number of companies are shifting their businesses online due to growing trend among customer to shop online. There arises a need for effective visual analysis of online customer opinions. It has...