Incremental Maintenance of a Materialized view in Data Warehousing : An Effective Approach

Dr. Sanjay S Solanki

Incremental Maintenance of a Materialized view in Data Warehousing : An Effective Approach

Dr. Sanjay S Solanki * §

Contact

§ JSPMs Abacus Institute of Computer Application

Incremental Maintenance of a Materialized view in Data Warehousing : An Effective Approach

Article Fingerprint

ReserarchID

CST6O0N6

Incremental Maintenance of a Materialized view in Data Warehousing : An Effective Approach Banner

Key Research Insights

Synthesized scholarly intelligence & interactive research assistant

Abstract

A view is a derived relation defined in terms of base relations. A view can be materialized by storing its extent in the database. An index can be made of these views and access to materialized view is much faster that recomputing the view from scratch. A Data Warehouse stores large amount of information collected from a different data sources. In order to speed up query processing, warehouse usually contains a large number of materialized views. When the data sources are updated, the views need to be updated. The process of keeping view up to date called as materialize view maintenance. Accessing base relations for view maintenance can be difficult, because the relations may be being used by users. Therefore materialize view maintenance in data warehousing is an important issue. For these reasons, the issue of self-maintainability of the view is an important issue in data warehousing. In this paper we have shown that a materialized view can be maintained without accessing the view itself by materializing additional relations at the data warehouse site.

References

28 Cites in Article

Reference Format

A Segev,J Park (1989). Maintaining materialized views in distributed databases.
A Segev,W Fang (1990). Currency-based updates to distributed materialized views.
S Abdulaziz,Almazyad,Khubeb Mohammad,Siddiqui (2009). Incremental View Maintenance: An Algorithmic Approach.
Bin Liu,Elke Rundensteiner (2006). Optimizing Cyclic Join View Maintenance over Distributed Data Sources.
D Agarwal,A Abbadi,A Singh,T Yurek (1997). Efficient View Maintenance at Data Warehouses.
D Lomet,J Widom (1995). Special Issue on Materialized Views and Data Warehousing.
Eric Hanson (1987). A performance analysis of view materialization strategies.
Gianluca Moro,Claudio Sartori (2001). Incremental maintenance of multi-source views.
C Gray,William Yeung,Gruver (2005). Multi agent Immediate Incremental View Maintenance for Data 10. Warehouses.
Hao He,Junyi Xie,Jun Yang,Hai Yu (2005). Asymmetric Batch Incremental View Maintenance.
E Heney,Abraham Korth,Silberschatz (1986). Database System Concepts.
Jose Blakeley,Per-Ake Larson,Frank Tompa (1986). Efficiently updating materialized views.
Jun Chen,Xin Zhang,Songting Chen,Andreas Koeller,Elke Rundensteiner (2001). DyDa.
J Hammer,H Garcia-Molina,J Widom,W Labio,Zhuge (1995). The Stanford Data Ware housing Project.
Jingren Zhou,Perake Larson,G Hicham Elmongui: Lazy Maintenance of Materialized Views.
Latha Colby,Akira Kawaguchi,Daniel Lieuwen,Inderpal Mumick,Kenneth Ross (1977). Supporting multiple view maintenance policies.
S Latha,Timothy Colby,Leonid Griffin,Inderpal Libkin,Howard Singh Mumick,Tricky (1996). Algorithms for Defered View Maintenance.
M Adiba,B Line\dsay (1980). Database Snapshots.
M Mohnia (1997). Avoiding re-computation: View Adaptation in Data Warehouses.
N Hyun (1996). Efficient View Self-Maintenance.
Nicholas Roussopoulos (1991). An incremental access method for ViewCache.
Ouri Wolfson,Hasanat Dewan,Salvatore Stolfo,Yechiam Yemini (1991). Incremental evaluation of rules and its relationship to parallelism.
Richard Hull,Gang Zhou (1996). A framework for supporting data integration using the materialized and virtual approaches.
R Ramakrishan,K Ross,D Srivastava,S Sudarshan (1994). Efficient Incremental Evaluation of Queries with Aggregation.
Surajit Chaudhuri,Umeshwar Dayal (1974). An overview of data warehousing and OLAP technology.
Songting Chen,Bin Liu,Elke Rundensteiner (2004). Multiversion-based view maintenance over distributed data sources.
S Solanki,Dr,Ajay Kumar (2011). A Comparative Study of Materialized View Maintenance Techniques in Data Warehousing.
S Solanki,Dr,Ajay Kumar (2012). A Comprehensive Study of Data Warehousing.

Download References

Funding

No external funding was declared for this work.

Conflict of Interest

The authors declare no conflict of interest.

Ethical Approval

No ethics committee approval was required for this article type.

Data Availability

Not applicable for this article.

How to Cite This Article

Dr. Sanjay S Solanki. 2018. "Incremental Maintenance of a Materialized view in Data Warehousing : An Effective Approach". Global Journal of Computer Science and Technology - C: Software & Data Engineering GJCST-C Volume 18 (GJCST Volume 18 Issue C3).

More Citation Formats

Select Citation Style:

Download Citation

GJCST Volume 18 Issue C3

Explore Journals Explore Volume Read This Issue

Journal Specifications

Crossref Journal DOI 10.17406/gjcst

Print ISSN 0975-4350

e-ISSN 0975-4172

Keywords

Not Found

Classification

GJCST-C Classification H.2.7

Submission ReceivedDecember 11, 2017
Peer Review Double Blind
Handling Editor
Accepted January 2, 2018
Published January 15, 2018

Version of record

v1.2

Issue date

July 27, 2018

Language

English

Experiance in AR

Explore published articles in an immersive Augmented Reality environment. Our platform converts research papers into interactive 3D books, allowing readers to view and interact with content using AR and VR compatible devices.

View in VR

Read in 3D

Your published article is automatically converted into a realistic 3D book. Flip through pages and read research papers in a more engaging and interactive format.

View in 3D

Article Matrices

Total Score: 146

Country: India

Subject: Global Journal of Computer Science and Technology

Authors: Dr. Sanjay S Solanki (PhD/Dr. count: 1)

View Count (all-time): 381

Total Views (Real + Logic): 1337

Total Downloads (simulated): 92

Publish Date: 2018 01, Mon

Monthly Totals (Real + Logic):

Month 1: 60 views
Month 2: 61 views
Month 3: 31 views
Month 4: 24 views
Month 5: 35 views
Month 6: 49 views
Month 7: 47 views
Month 8: 29 views
Month 9: 47 views
Month 10: 51 views
Month 11: 36 views
Month 12: 45 views
Month 13: 20 views
Month 14: 21 views
Month 15: 26 views
Month 16: 37 views
Month 17: 37 views
Month 18: 19 views
Month 19: 20 views
Month 20: 20 views
Month 21: 18 views
Month 22: 21 views
Month 23: 37 views
Month 24: 37 views
Month 25: 32 views
Month 26: 23 views
Month 27: 34 views
Month 28: 36 views
Month 29: 33 views
Month 30: 27 views
Month 31: 37 views
Month 32: 24 views
Month 33: 18 views
Month 34: 33 views
Month 35: 46 views
Month 36: 25 views
Month 37: 34 views
Month 38: 46 views
Month 39: 38 views
Month 40: 30 views
Month 41: 45 views
Month 42: 47 views
Month 43: 30 views
Month 44: 34 views
Month 45: 35 views
Month 46: 40 views
Month 47: 49 views
Month 48: 21 views
Month 49: 26 views
Month 50: 42 views
Month 51: 34 views
Month 52: 38 views
Month 53: 37 views
Month 54: 30 views
Month 55: 42 views
Month 56: 45 views
Month 57: 37 views
Month 58: 50 views
Month 59: 45 views
Month 60: 35 views
Month 61: 30 views
Month 62: 20 views
Month 63: 32 views
Month 64: 22 views
Month 65: 41 views
Month 66: 35 views
Month 67: 30 views
Month 68: 24 views
Month 69: 36 views
Month 70: 14 views
Month 71: 27 views
Month 72: 30 views
Month 73: 29 views
Month 74: 27 views
Month 75: 32 views
Month 76: 35 views
Month 77: 30 views
Month 78: 37 views
Month 79: 36 views
Month 80: 23 views
Month 81: 27 views
Month 82: 27 views
Month 83: 42 views
Month 84: 38 views
Month 85: 17 views
Month 86: 35 views
Month 87: 42 views
Month 88: 29 views
Month 89: 32 views
Month 90: 41 views
Month 91: 61 views
Month 92: 49 views
Month 93: 41 views
Month 94: 37 views
Month 95: 41 views
Month 96: 23 views
Month 97: 41 views
Month 98: 46 views
Month 99: 38 views
Month 100: 29 views
Month 101: 28 views
Month 102: 49 views
Month 103: 45 views
Month 104: 38 views
Month 105: 54 views

Total Views: 1.3K

Total Downloads: 92

All Trends