Filters








410,291 Hits in 4.0 sec

Efficiently updating materialized views

Jose A. Blakeley, Per-Ake Larson, Frank Wm Tompa
1986 SIGMOD record  
the view expression The algonthm proposed exploits the knowledge provided by both the view defimtlon expression and the database update operations  ...  maintained We propose a method m which all database updates to base relations are first filtered to remove from consideration those that cannot possibly affect the view The condltlons given for the detection  ...  paper rs concerned w&h findmg efficient ways of keepmg materiahzed views up to date with the base relations The purpose of thus paper rs to present a framework for the efficient update of materialized  ... 
doi:10.1145/16856.16861 fatcat:y77ldekjxjf3dbvdimvk2ftghu

Efficiently updating materialized views

Jose A. Blakeley, Per-Ake Larson, Frank Wm Tompa
1986 Proceedings of the 1986 ACM SIGMOD international conference on Management of data - SIGMOD '86  
the view expression The algonthm proposed exploits the knowledge provided by both the view defimtlon expression and the database update operations  ...  maintained We propose a method m which all database updates to base relations are first filtered to remove from consideration those that cannot possibly affect the view The condltlons given for the detection  ...  paper rs concerned w&h findmg efficient ways of keepmg materiahzed views up to date with the base relations The purpose of thus paper rs to present a framework for the efficient update of materialized  ... 
doi:10.1145/16894.16861 dblp:conf/sigmod/BlakeleyLT86 fatcat:xwi2v22n3feh7b74s7fs6f2bdm

Selection Of Materialized View Using Query Optimization In Database Management : An Efficient Methodology

P.P Karde, V.M Thakare
2010 International Journal of Database Management Systems  
This paper focus on the issues of materialized views in Data warehousing to enable efficient Information Management.  ...  The issues include selection, maintenance and updating of Materialized views and how these issues create an impact in Business scenarios.  ...  Different factors are taken into consideration for efficient view selection.  ... 
doi:10.5121/ijdms.2010.2410 fatcat:mcuymhuy3rh43bimyaoucexzli

XML Views [chapter]

Murali Mani
2016 Encyclopedia of Database Systems  
SCIENTIFIC FUNDAMENTALS The views that database systems support can either be virtual or materialized [12] . When the view is virtual, only the view definition is stored in the system.  ...  Whenever a client application accesses the data by issuing a query over the view, the database system composes the user query with the view definition and this combined query is executed over the underlying  ...  Incremental and efficient maintenance of materialized views have been studied [6, 11, 9] and are supported by most commercial SQL engines.  ... 
doi:10.1007/978-1-4899-7993-3_781-2 fatcat:23de4cnl3zhilnv452ojmowttm

Deferred Incremental Refresh of XML Materialized Views [chapter]

Hyunchul Kang, JaeGuk Lim
2002 Lecture Notes in Computer Science  
Views are often materialized for query performance, and in that case, their consistency needs to be maintained against the updates of the underlying data.  ...  The view mechanism can provide the user with an appropriate portion of database through data filtering and integration.  ...  Finally and most importantly, the efficient algorithms to check relevance between an update and a view, to generate view refresh information for the relevant pairs, and to reflect the refresh information  ... 
doi:10.1007/3-540-47961-9_58 fatcat:zpgc2ht3wrdxfmwxcegabcgyuy

Materialized View Selection and Maintenance Using Multi-Query Optimization [article]

Hoshi Mistry, Prasan Roy, Krithi Ramamritham, S. Sudarshan
2000 arXiv   pre-print
Whenever the data warehouse is updated, the materialized views must also be updated.  ...  These trends necessitate efficient techniques for the maintenance of materialized views.  ...  These trends call for efficient techniques for maintaining the materialized views as and when the warehouse is updated.  ... 
arXiv:cs/0003006v1 fatcat:njyqduscija3jliv6exgiwfvqy

Materialized view selection and maintenance using multi-query optimization

Hoshi Mistry, Prasan Roy, S. Sudarshan, Krithi Ramamritham
2001 SIGMOD record  
Our algorithms can also be used to efficiently select materialized views to speed up workloads containing queries and updates.  ...  These trends necessitate efficient techniques for the maintenance of materialized views.  ...  These trends call for efficient techniques for maintaining the materialized views as and when the warehouse is updated.  ... 
doi:10.1145/376284.375703 fatcat:ciio3lczdrdzpnrrbo7xfkkicq

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  
Our algorithms can also be used to efficiently select materialized views to speed up workloads containing queries and updates.  ...  These trends necessitate efficient techniques for the maintenance of materialized views.  ...  These trends call for efficient techniques for maintaining the materialized views as and when the warehouse is updated.  ... 
doi:10.1145/375663.375703 dblp:conf/sigmod/MistryRSR01 fatcat:n7lzktbsnrd7lg3btenra4zo5m

IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy [article]

Chenghong Wang, Johes Bater, Kartik Nayak, Ashwin Machanavajjhala
2022 arXiv   pre-print
These databases allow untrusted servers to privately maintain a materialized view, such that they can use only the materialized view to process query requests instead of accessing the original data from  ...  Incshrink guarantees that the leakage satisfies DP in the presence of updates.  ...  Materialized view.  ... 
arXiv:2203.05084v1 fatcat:phddzgauubca7o2glzg6ypaykq

Implementing incremental view maintenance in nested data models [chapter]

Akira Kawaguchi, Daniel Lieuwen, Inderpal Mumick, Kenneth Ross
1998 Lecture Notes in Computer Science  
Previous research on materialized views has primarily been in the context of flat relational databases--materialized views defined in terms of one or more flat relations.  ...  This is one of the first pieces of work to explore the applicability of materialized views over complex objects.  ...  Introduction Most past research on materialized views has focused on high level incremental algorithms for updating materialized views efficiently when the base relations are updated [9, 37, 8, 31, 10  ... 
doi:10.1007/3-540-64823-2_12 fatcat:b5t7ymz23rbd5llcl4qnh5ux2y

Efficient Peer-To-Peer Searches Using Result-Caching [chapter]

Bobby Bhattacharjee, Sudarshan Chawathe, Vijay Gopalakrishnan, Pete Keleher, Bujor Silaghi
2003 Lecture Notes in Computer Science  
These results, which can also be thought of as materialized views, can then be used to efficiently answer future queries.  ...  Unfortunately, merely storing each view in the namespace with a canonical name is not sufficient to efficiently answer view queries, even if the underlying namespace can very efficiently locate each materialized  ... 
doi:10.1007/978-3-540-45172-3_21 fatcat:uaplj6iqbngyxiwp2paouye4gy

A Real-time Materialized View Approach for Analytic Flows in Hybrid Cloud Environments

Weiping Qu, Stefan Dessloch
2014 Datenbank-Spektrum  
In traditional databases, materialized views are used to optimize query performance.  ...  In cross-platform, large-scale data transformation environments, similar challenges (e.g. view selection) arise when using materialized views.  ...  However, by caching small size of analytic results in this relational database, it would be much more efficient for it to maintain these views with smaller update files.  ... 
doi:10.1007/s13222-014-0155-0 fatcat:innxetqcpbfufenyvgl5y3jype

Extending View Technology for Complex Integration Tasks [chapter]

Matthew C. Jones, Elke A. Rundensteiner
1995 Electronic Design Automation Frameworks  
We compare the bounds on query and update performance of our set-based mediator class for the symmetric transitive closure with a more traditional object-based materialization strategy.  ...  To achieve performance essential for EeAD tools, we introduce the mediator class as a general strategy for the materialization of these complex views.  ...  In addition, we presented the development of efficient materialization strategies which include support for updatable views.  ... 
doi:10.1007/978-0-387-34880-3_8 fatcat:fauaiuy5s5hrvad3xdmykgrf6u

Lazy Maintenance of Materialized Views

Jingren Zhou, Per-Åke Larson, Hicham G. Elmongui
2007 Very Large Data Bases Conference  
View maintenance overhead can be significant and it seems unfair to have updates bear the cost. We present a novel way to lazily maintain materialized views that relieves updates of this overhead.  ...  Materialized views can speed up query processing greatly but they have to be kept up to date to be useful.  ...  Eager maintenance updates all materialized views that reference R immediately after the update statement.  ... 
dblp:conf/vldb/ZhouLE07 fatcat:gepbmhniu5cuxlutjbv7tki5n4

State Transfer Graph: An Efficient Tool for Webview Maintenance [chapter]

Yan Zhang, Xiangdong Qin
2005 Lecture Notes in Computer Science  
It improves query performance up to 59.4% over the minimum-update approach, when we enhance it with a global structure.  ...  However, since it is meaningless to provide the stale data to users, the popularity of the materialized views necessitates efficient techniques for their maintenance, especially when the amount of data  ...  Agrawal et al. propose a SWEEP algorithm for efficient incremental view maintenance at data warehouses [2] . Mistry et al. exploit common sub-expressions in their efficient maintenance plan [14] .  ... 
doi:10.1007/11563952_45 fatcat:u2zmsli76bctpddnctso6yzire
« Previous Showing results 1 — 15 out of 410,291 results