Loading menu…

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

§ JSPMs Abacus Institute of Computer Application

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

Key Research Insights

Synthesized scholarly intelligence & interactive research assistant
  • 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
Reading Preferences
Font Size
Line Spacing
Background
This converted HTML version may contain rendering inconsistencies. Please refer to the PDF for the authoritative version, or click here to provide feedback.

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. 1. A Segev,J Park (1989). Maintaining materialized views in distributed databases. [1989] Proceedings. Fifth International Conference on Data Engineering, 262-270.
  2. 2. A Segev,W Fang (1990). Currency-based updates to distributed materialized views. [1990] Proceedings. Sixth International Conference on Data Engineering, 512-520.
  3. 3. S Abdulaziz,Almazyad,Khubeb Mohammad,Siddiqui (2009). Incremental View Maintenance: An Algorithmic Approach. Internatioinal Journal of Electrical & Computer Sciences IJECS-IJENS, 10(03)
  4. 4. Bin Liu,Elke Rundensteiner (2006). Optimizing Cyclic Join View Maintenance over Distributed Data Sources. IEEE Transactions on Knowledge and Data Engineering, 18(3)
  5. 5. D Agarwal,A Abbadi,A Singh,T Yurek (1997). Efficient View Maintenance at Data Warehouses. Proc. ACM SIGMOD, 417-427.
  6. 6. D Lomet,J Widom (1995). Special Issue on Materialized Views and Data Warehousing. IEEE Data Engineering Bulletin, 18(2)
  7. 7. Eric Hanson (1987). A performance analysis of view materialization strategies. ACM SIGMOD Record, 16(3), 440-453.
  8. 8. Gianluca Moro,Claudio Sartori (2001). Incremental maintenance of multi-source views. Proceedings 12th Australasian Database Conference. ADC 2001, 13-20.
  9. 9. C Gray,William Yeung,Gruver (2005). Multi agent Immediate Incremental View Maintenance for Data 10. Warehouses. IEEE Transaction on Systems, Man & Cybermetics-Part A: Systems & Human, 35(2)
  10. 10. Hao He,Junyi Xie,Jun Yang,Hai Yu (2005). Asymmetric Batch Incremental View Maintenance. 21st International Conference on Data Engineering (ICDE'05), 106-117.
  11. 11. E Heney,Abraham Korth,Silberschatz (1986). Database System Concepts. Database System Concepts
  12. 12. Jose Blakeley,Per-Ake Larson,Frank Tompa (1986). Efficiently updating materialized views. ACM SIGMOD Record, 15(2), 61-71.
  13. 13. Jun Chen,Xin Zhang,Songting Chen,Andreas Koeller,Elke Rundensteiner (2001). DyDa. ACM SIGMOD Record, 30(2), 619.
  14. 14. J Hammer,H Garcia-Molina,J Widom,W Labio,Zhuge (1995). The Stanford Data Ware housing Project. IEEE Data Engineering Bulletin
  15. 15. Jingren Zhou,Perake Larson,G Hicham Elmongui: Lazy Maintenance of Materialized Views. Proceddings of 33 rd International conference on VLDB 2007
  16. 16. Latha Colby,Akira Kawaguchi,Daniel Lieuwen,Inderpal Mumick,Kenneth Ross (1977). Supporting multiple view maintenance policies. Proceedings of the 1997 ACM SIGMOD international conference on Management of data - SIGMOD '97, 405-416.
  17. 17. S Latha,Timothy Colby,Leonid Griffin,Inderpal Libkin,Howard Singh Mumick,Tricky (1996). Algorithms for Defered View Maintenance. proceedings of ACM SIGMOD
  18. 18. M Adiba,B Line\dsay (1980). Database Snapshots. Proceedings of the sixth International Conference on Very Large Databases, 86-91.
  19. 19. M Mohnia (1997). Avoiding re-computation: View Adaptation in Data Warehouses. Proc. Of 8 th International Database Workshop, 151-165.
  20. 20. N Hyun (1996). Efficient View Self-Maintenance. Proceeding of ACM workshop on Materialized views: Techniques & Applications
  21. 21. Nicholas Roussopoulos (1991). An incremental access method for ViewCache. ACM Transactions on Database Systems, 16(3), 535-563.
  22. 22. Ouri Wolfson,Hasanat Dewan,Salvatore Stolfo,Yechiam Yemini (1991). Incremental evaluation of rules and its relationship to parallelism. Proceedings of the 1991 ACM SIGMOD international conference on Management of data - SIGMOD '91, 78-87.
  23. 23. Richard Hull,Gang Zhou (1996). A framework for supporting data integration using the materialized and virtual approaches. Proceedings of the 1996 ACM SIGMOD international conference on Management of data - SIGMOD '96, 481-492.
  24. 24. R Ramakrishan,K Ross,D Srivastava,S Sudarshan (1994). Efficient Incremental Evaluation of Queries with Aggregation. International Logic Programming Symposium
  25. 25. Surajit Chaudhuri,Umeshwar Dayal (1974). An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26(1), 65-74.
  26. 26. Songting Chen,Bin Liu,Elke Rundensteiner (2004). Multiversion-based view maintenance over distributed data sources. ACM Transactions on Database Systems, 29(4), 675-709.
  27. 27. S Solanki,Dr,Ajay Kumar (2011). A Comparative Study of Materialized View Maintenance Techniques in Data Warehousing. IJRIME, 1(2)
  28. 28. S Solanki,Dr,Ajay Kumar (2012). A Comprehensive Study of Data Warehousing. IJMR, 1(1)

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

Download Citation

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
English
Order Article Reprint
Experience 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: 1.4K
Total Downloads: 94
All Trends

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

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. Solanki
Dr. Solanki JSPMs Abacus Institute of Computer Application