The Approaches of Materialize View Maintenance Process in Data Warehousing
Journal Title: International Journal of Engineering, Science and Mathematics - 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 EP26630
- DOI -
- Views 363
- Downloads 6
INTEGRATION OF EC & IC ENGINE’S WORKING.
It is known that when any kind of fossil fuel is burnt two phenomenons take place (i) Explosion and (ii) Heat generation. In the concept that is stated it is desired to merge the functioning of External Combustion (EC)...
MODERN PRACTICES FOR EFFECTIVE SOFTWARE DEVELOPMENT PROCESS IN PROJECT MANAGEMENT
The effectiveness of software project management is dependent on multi-disciplinary, interrelated factors including the management of project scope, project time, project cost, project quality, project human resource,...
ANALYSIS OF OPTICAL SOLITON PROPAGATION IN BIREFRINGENT FIBERS
Before the development of optical communication systems, two major forms of communication systems were employed. In the first of these, namely, electrical communication system, information is encoded as electrical puls...
Challenges in Allocation of Resources in Future Cellular Mobile Networks
Efficient resource sharing is very important in mobile networks to provide satisfactory service to customers. The resource demand is increasing due to increasing number of user population and high bandwidth demanding m...
VLSI IMPLEMENTATION OF SYSTOLIC ARRAY FOR DISCRETE WAVEELET TRANSFORM
This paper presents a VLSI implementation of Systolic architecture for discrete wavelet transform (DWT).This architecture consist of Input delay unit, filter, register bank and control unit. This performs the calculati...