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

α
Dr. Sanjay S Solanki
Dr. Sanjay S Solanki
α Savitribai Phule Pune University Savitribai Phule Pune University

Send Message

To: Author

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

Article Fingerprint

ReserarchID

CSTSDE6O0N6

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

AI TAKEAWAY

Connecting with the Eternal Ground
  • English
  • Afrikaans
  • Albanian
  • Amharic
  • Arabic
  • Armenian
  • Azerbaijani
  • Basque
  • Belarusian
  • Bengali
  • Bosnian
  • Bulgarian
  • Catalan
  • Cebuano
  • Chichewa
  • Chinese (Simplified)
  • Chinese (Traditional)
  • Corsican
  • Croatian
  • Czech
  • Danish
  • Dutch
  • Esperanto
  • Estonian
  • Filipino
  • Finnish
  • French
  • Frisian
  • Galician
  • Georgian
  • German
  • Greek
  • Gujarati
  • Haitian Creole
  • Hausa
  • Hawaiian
  • Hebrew
  • Hindi
  • Hmong
  • Hungarian
  • Icelandic
  • Igbo
  • Indonesian
  • Irish
  • Italian
  • Japanese
  • Javanese
  • Kannada
  • Kazakh
  • Khmer
  • Korean
  • Kurdish (Kurmanji)
  • Kyrgyz
  • Lao
  • Latin
  • Latvian
  • Lithuanian
  • Luxembourgish
  • Macedonian
  • Malagasy
  • Malay
  • Malayalam
  • Maltese
  • Maori
  • Marathi
  • Mongolian
  • Myanmar (Burmese)
  • Nepali
  • Norwegian
  • Pashto
  • Persian
  • Polish
  • Portuguese
  • Punjabi
  • Romanian
  • Russian
  • Samoan
  • Scots Gaelic
  • Serbian
  • Sesotho
  • Shona
  • Sindhi
  • Sinhala
  • Slovak
  • Slovenian
  • Somali
  • Spanish
  • Sundanese
  • Swahili
  • Swedish
  • Tajik
  • Tamil
  • Telugu
  • Thai
  • Turkish
  • Ukrainian
  • Urdu
  • Uzbek
  • Vietnamese
  • Welsh
  • Xhosa
  • Yiddish
  • Yoruba
  • Zulu

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

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. \u201cIncremental Maintenance of a Materialized view in Data Warehousing : An Effective Approach\u201d. Global Journal of Computer Science and Technology - C: Software & Data Engineering GJCST-C Volume 18 (GJCST Volume 18 Issue C3): .

Download Citation

Issue Cover
GJCST Volume 18 Issue C3
Pg. 11- 16
Journal Specifications

Crossref Journal DOI 10.17406/gjcst

Print ISSN 0975-4350

e-ISSN 0975-4172

Keywords
Classification
GJCST-C Classification: H.2.7
Version of record

v1.2

Issue date

July 27, 2018

Language
en
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.

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.

Article Matrices
Total Views: 6047
Total Downloads: 1537
2026 Trends
Related Research

Published Article

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.

Our website is actively being updated, and changes may occur frequently. Please clear your browser cache if needed. For feedback or error reporting, please email [email protected]

Request Access

Please fill out the form below to request access to this research paper. Your request will be reviewed by the editorial or author team.
X

Quote and Order Details

Contact Person

Invoice Address

Notes or Comments

This is the heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

High-quality academic research articles on global topics and journals.

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

Dr. Sanjay S Solanki
Dr. Sanjay S Solanki Savitribai Phule Pune University

Research Journals