Filters








231,394 Hits in 6.6 sec

Efficient Maintenance of Materialized Mediated Views [chapter]

1999 Materialized Views  
Within this paper, we i n v estigate the materialization of these views by unfolding the view de nition and the e cient maintenance of the resulting materialized mediated view in case of updates.  ...  semantics without any recomputation of the materialized view.  ...  To our knowledge, this is the rst paper that addresses the view maintenance problem for constrained databases and or for heterogeneous, mediated systems.  ... 
doi:10.7551/mitpress/4472.003.0025 fatcat:gt3l5ajvuzcwpii7336w6c7bee

Analytical modeling of materialized view maintenance

Jaideep Srivastava, Doron Rotem
1988 Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems - PODS '88  
algorithms are presented We show that the optimal refresh pobcy 1~ sensitive to (1) the structure and maintenance pollcles of the files storing the materlahzed view etc , (II) the relatrve importance  ...  , either at complle-time or at run-time, to decide If an update needs to be done to the view at all Second 1s the problem of refresh frequency of the materlabsed view that maintins It up-to-date, and incurs  ...  describes the mechamcs of malntalmng materialized views, develop9 a queuelng model for It, and discusses the crlterla for comparative evaluation of view maintenance algorithms 2 1 Mechanics of Materialized  ... 
doi:10.1145/308386.308425 dblp:conf/pods/SrivastavaR88 fatcat:ukbiz6q63jafridgph5osf7bbq

Maintenance of top-k materialized views

Eftychia Baikousi, Panos Vassiliadis
2009 Distributed and parallel databases  
In this paper we present results on the problem of maintaining materialized top-k views and provide results in two directions.  ...  The first problem we tackle concerns the maintenance of top-k views in the presence of high deletion rates.  ...  Acknowledgements We would like to thank the anonymous reviewers of the paper for constructive comments concerning the intuition and the experimental validation of our approach.  ... 
doi:10.1007/s10619-009-7057-4 fatcat:z26ttg4ngvf6vdcxlwuaubz3ti

Incremental Maintenance of Materialized XQuery Views

M. El-Sayed, E.A. Rundensteiner, M. Mani
2006 22nd International Conference on Data Engineering (ICDE'06)  
Keeping views fresh by maintaining the consistency between materialized views and their base data in the presence of base updates is a critical problem for many applications, including data warehousing  ...  This dissertation proposes a comprehensive solution for the general problem of maintaining materialized XQuery views.  ...  We provide proofs of correctness of our proposed techniques for materialized XQuery maintenance.  ... 
doi:10.1109/icde.2006.80 dblp:conf/icde/El-SayedRM06 fatcat:gb6ngzxjgberzfpnjkj6zkptze

Efficient Maintenance of Materialized Outer-Join Views

Per-Ake Larson, Jingren Zhou
2007 2007 IEEE 23rd International Conference on Data Engineering  
In this paper we show how to efficiently maintain general outer-join views, that is, views composed of selection, projection, inner and outer joins.  ...  Materialized outer-join views could greatly speed up many such queries but most database systems do not allow outer joins in materialized views.  ...  Materialized views can speed up query processing greatly, but to realize the benefits two subproblems must be solved: view matching and incremental view maintenance.  ... 
doi:10.1109/icde.2007.367851 dblp:conf/icde/LarsonZ07 fatcat:uj3e4tndpjdojjzeahdbv4xc7a

A new solution for asynchronous incremental maintenance of materialized views

Nguyen Tran Quoc Vinh, Le Van Khanh, Tran Trong Nhan, Tran Dang Hung, PW Chandana Prasad, Abeer Alsadoon, Pham Duong Thu Hang
2020 Eastern-European Journal of Enterprise Technologies  
The work [2] proposes a solution for synchronous incremental of recursive materialized view based on SQL query.  ...  It supports materialized view with the asynchronous full update of MV, which re-executes the underlying query and replaces the previous result in the MV table.  ...  x i T removing it may affect the post-update state of . x i T Once the last inserted record is not duplicate of the first deleted one, the two records with the same key values have different values for  ... 
doi:10.15587/1729-4061.2020.193715 fatcat:muysxd2kmbcc7bdkjcfcq6obwe

Materialized view maintenance and integrity constraint checking

Kenneth A. Ross, Divesh Srivastava, S. Sudarshan
1996 Proceedings of the 1996 ACM SIGMOD international conference on Management of data - SIGMOD '96  
We investigate the problem of incremental maintenance of an SQL view in the face of database updates, and show that it is possible to reduce the total time cost of view maintenance by materializing (and  ...  to be essentially equivalent to the view maintenance problem.  ...  The research of Kenneth Ross was supported by a grant from the AT&T Foundation, by a David and Lucile Packard Foundation Fellowship in Science and Engineering, by a Sloan Foundation Fellowship, by NSF  ... 
doi:10.1145/233269.233361 dblp:conf/sigmod/RossSS96 fatcat:hqpez2bjjfe7lpxbb24seoidsa

Incremental maintenance for materialized XPath/XSLT views

Makoto Onizuka, Fong Yee Chan, Ryusuke Michigami, Takashi Honishi
2005 Proceedings of the 14th international conference on World Wide Web - WWW '05  
This paper discusses the XPath/XSLT features of incremental view maintenance for subtree insertion/deletion and applies them to the maintenance algorithm.  ...  This paper proposes an incremental maintenance algorithm that efficiently updates the materialized XPath/XSLT views defined using XPath expressions in XP {[], * ,//,vars} .  ...  This example suggests that SQL view maintenance techniques [11] are not directly applicable to the XPath view maintenance problem. Here, we have somewhat good news.  ... 
doi:10.1145/1060745.1060843 dblp:conf/www/OnizukaCMH05 fatcat:em7sqlqfcveg5i4azyrlp2dtme

Incremental maintenance of materialized object-oriented views in MultiView: strategies and performance evaluation

H.A. Kuno, E.A. Rundensteiner
1998 IEEE Transactions on Knowledge and Data Engineering  
View materialization is a promising technique for achieving the data sharing and virtual restructuring capabilities needed by advanced applications such as data warehousing and workflow management systems  ...  Much existing work addresses the problem of how to maintain the consistency of materialized relational views under update operations.  ...  , for valuable discussions and suggestions throughout the development of the MultiView system.  ... 
doi:10.1109/69.729731 fatcat:j5igj2edm5hlzox4qxbscfjkme

Selection & Maintenance of Materialized View and It's Application for Fast Query Processing: A Survey

P.P Karde, V.M Thakare
2010 International Journal of Computer Science & Engineering Survey  
The materialization of all views is not possible because of the space constraint and maintenance cost constraint.  ...  Materialized views are found useful for fast query processing. This paper gives an overview of various techniques that are implemented in past recent for selection of materialized view.  ...  Therfore the node selection, materialized view selection and maintenance of materialized views in distributed environment and its implication for fast query processing and query optimization comes in the  ... 
doi:10.5121/ijcses.2010.1202 fatcat:4cb2kuhl2nhxzddyc7p2hm2k3m

Materialized view selection and maintenance using multi-query optimization

Hoshi Mistry, Prasan Roy, S. Sudarshan, Krithi Ramamritham
2001 Proceedings of the 2001 ACM SIGMOD international conference on Management of data - SIGMOD '01  
These trends necessitate efficient techniques for the maintenance of materialized views.  ...  In this paper, we show how to find an efficient plan for the maintenance of a set of materialized views, by exploiting common subexpressions between different view maintenance expressions.  ...  Our work addresses the problem of optimizing the maintenance of a set of materialized views.  ... 
doi:10.1145/375663.375703 dblp:conf/sigmod/MistryRSR01 fatcat:n7lzktbsnrd7lg3btenra4zo5m

Incremental Maintenance of Materialized Ontologies [chapter]

Raphael Volz, Steffen Staab, Boris Motik
2003 Lecture Notes in Computer Science  
We present a novel solution that allows to cope with changes in rules and facts. To achieve this we extend a known approach for the incremental maintenance of views in deductive databases.  ...  Central to materialization are maintenance techniques that allow to incrementally update a materialization when changes occur.  ...  Conclusion We have presented an incremental maintenance technique for the materialization of intentional predicates (views).  ... 
doi:10.1007/978-3-540-39964-3_45 fatcat:zg3vjvvmpzco7d2r57nnxklydy

Content-based filtering for efficient online materialized view maintenance

Gang Luo, Philip S. Yu
2008 Proceeding of the 17th ACM conference on Information and knowledge mining - CIKM '08  
Real-time materialized view maintenance has become increasingly popular, especially in real-time data warehousing and data streaming environments.  ...  A traditional method to mitigate this problem is to use the where clause condition in the materialized view definition to detect whether an update to a base relation is relevant and can affect the materialized  ...  This problem is not limited to real-time data warehousing, as real-time materialized view maintenance is a general requirement of modern database applications.  ... 
doi:10.1145/1458082.1458107 dblp:conf/cikm/LuoY08 fatcat:l5x6zmmrzrcztovtj6gmc7fq34

A solution for synchronous incremental maintenance of materialized views based on SQL recursive query

Nguyen Tran Quoc Vinh, Dang Thanh Hao, Pham Duong Thu Hang, Abeer Alsadoon, PW Chandana Prasad, Nguyen Viet Anh
2019 Eastern-European Journal of Enterprise Technologies  
Acknowledgment This research is supported by the Ministry of Education and Training (Vietnam) under the grant B2017.DNA.06_ KYTH-01 "Building a system for supporting materialized views in open source database  ...  From 1998, Oracle started supporting another kind of view called materialized view (MV) although its idea was raised from the 1980s.  ...  So that selection of views [16] [17] [18] [19] to be materialized is a very important task.  ... 
doi:10.15587/1729-4061.2019.180226 fatcat:esdvntdzurhgfd7oeuw6apz67a

An integrative multi-criteria decision making techniques for supplier evaluation problem with its application

D Fatrias, I Kamil, D Meilani
2018 IOP Conference Series: Materials Science and Engineering  
Hisjam An integrative multi-criteria decision making techniques for supplier evaluation problem with its application Process Improvement in Outpatient Installation RSUD dr.  ...  • OPEN ACCESS An integrative multi-criteria decision making techniques for supplier evaluation problem with its application To cite this article: D Fatrias et al 2018 IOP Conf.  ... 
doi:10.1088/1757-899x/319/1/012076 fatcat:3m3ntx62v5ctrg6tupgegp2pg4
« Previous Showing results 1 — 15 out of 231,394 results