Skip header Section
Skip Bibliometrics Section
Materialized views: techniques, implementations, and applicationsJune 1999
- Editors:
- Ashish Gupta,
- Iderpal Singh Mumick
Abstract
No abstract available.
Cited By
- Niu X, Glavic B, Liu Z, Li P, Gawlick D, Krishnaswamy V, Liu Z and Porobic D (2022). Provenance-based data skipping, Proceedings of the VLDB Endowment, 15:3, (451-464), Online publication date: 1-Nov-2021.
Kleppmann M Thinking in events Proceedings of the 15th ACM International Conference on Distributed and Event-based Systems, (15-24)- Kassaie B and Tompa F A Framework for Extracted View Maintenance Proceedings of the ACM Symposium on Document Engineering 2020, (1-4)
- Wingerath W, Gessert F and Ritter N (2020). InvaliDB, Proceedings of the VLDB Endowment, 13:12, (3032-3045), Online publication date: 1-Aug-2020.
- Tang D, Shang Z, Elmore A, Krishnan S and Franklin M (2019). Intermittent query processing, Proceedings of the VLDB Endowment, 12:11, (1427-1441), Online publication date: 1-Jul-2019.
- Sebaa A, Nouicer A and Tari A (2019). Impact of technology evolution on the materialised views, International Journal of Business Information Systems, 30:4, (427-462), Online publication date: 1-Jan-2019.
- Elghandour I, Kara A, Olteanu D and Vansummeren S Incremental Techniques for Large-Scale Dynamic Query Processing Proceedings of the 27th ACM International Conference on Information and Knowledge Management, (2297-2298)
- Herrmann K, Voigt H, Pedersen T and Lehner W (2018). Multi-schema-version data management, The VLDB Journal — The International Journal on Very Large Data Bases, 27:4, (547-571), Online publication date: 1-Aug-2018.
- Sa C, Ratner A, Ré C, Shin J, Wang F, Wu S and Zhang C (2017). Incremental knowledge base construction using DeepDive, The VLDB Journal — The International Journal on Very Large Data Bases, 26:1, (81-105), Online publication date: 1-Feb-2017.
- Godfrey P, Gryz J and Lasek P (2016). Interactive Visualization of Large Data Sets, IEEE Transactions on Knowledge and Data Engineering, 28:8, (2142-2157), Online publication date: 1-Aug-2016.
- Li F, Das S, Syamala M and Narasayya V Accelerating Relational Databases by Leveraging Remote Memory and RDMA Proceedings of the 2016 International Conference on Management of Data, (355-370)
- Reps T and Thakur A Automating Abstract Interpretation Proceedings of the 17th International Conference on Verification, Model Checking, and Abstract Interpretation - Volume 9583, (3-40)
- Mitschke R, Erdweg S, Köhler M, Mezini M and Salvaneschi G (2014). i3QL, ACM SIGPLAN Notices, 49:10, (417-432), Online publication date: 31-Dec-2015.
- Mitschke R, Erdweg S, Köhler M, Mezini M and Salvaneschi G i3QL Proceedings of the 2014 ACM International Conference on Object Oriented Programming Systems Languages & Applications, (417-432)
- Aligon J, Golfarelli M, Marcel P, Rizzi S and Turricchia E (2014). Similarity measures for OLAP sessions, Knowledge and Information Systems, 39:2, (463-489), Online publication date: 1-May-2014.
- Savenkov V, Pichler R and Koch C Loop elimination for database updates Proceedings of the 29th British National conference on Big Data, (48-61)
- Liu Z, Jiang B and Heer J imMens Proceedings of the 15th Eurographics Conference on Visualization, (421-430)
- Goasdoué F, Manolescu I and Roatiş A Efficient query answering against dynamic RDF databases Proceedings of the 16th International Conference on Extending Database Technology, (299-310)
- Morzy T, Wrembel R, Chmiel J and Wojciechowski A (2012). Time-HOBI, Information Systems, 37:5, (412-429), Online publication date: 1-Jul-2012.
- Schüller G, Saul R and Behrend A AIMS Proceedings of the 24th international conference on Scientific and Statistical Database Management, (622-627)
- Levandoski J, Sarwat M, Mokbel M and Ekstrand M RecStore Proceedings of the 15th International Conference on Extending Database Technology, (86-96)
- Chirkova R Equivalence and minimization of conjunctive queries under combined semantics Proceedings of the 15th International Conference on Database Theory, (262-273)
- Lawrence M, Pottinger R and Staub-French S (2020). Data coordination, Proceedings of the VLDB Endowment, 4:11, (831-842), Online publication date: 1-Aug-2011.
- Schüller G, Behrend A and Manthey R AIMS Proceedings of the ACM SIGSPATIAL International Workshop on GeoStreaming, (31-38)
- Chmiel J, Morzy T and Wrembel R Time-HOBI Proceedings of the ACM 13th international workshop on Data warehousing and OLAP, (69-76)
- Cuzzocrea A, Hacid M and Grillo N Inheriting access control rules from large relational databases to materialized views automatically Proceedings of the 14th international conference on Knowledge-based and intelligent information and engineering systems: Part III, (426-437)
- Cuzzocrea A, Hacid M and Grillo N Effectively and efficiently selecting access control rules on materialized views over relational databases Proceedings of the Fourteenth International Database Engineering & Applications Symposium, (225-235)
- Reps T, Sagiv M and Loginov A (2010). Finite differencing of logical formulas for static analysis, ACM Transactions on Programming Languages and Systems, 32:6, (1-55), Online publication date: 1-Aug-2010.
- Luo G V locking protocol for materialized aggregate join views on B-tree indices Proceedings of the 11th international conference on Web-age information management, (768-780)
- Ghanem T, Elmagarmid A, Larson P and Aref W (2008). Supporting views in data stream management systems, ACM Transactions on Database Systems, 35:1, (1-47), Online publication date: 1-Feb-2010.
- Udrea O, Recupero D and Subrahmanian V (2010). Annotated RDF, ACM Transactions on Computational Logic, 11:2, (1-41), Online publication date: 1-Jan-2010.
- Cheney J, Chong S, Foster N, Seltzer M and Vansummeren S Provenance Proceedings of the 24th ACM SIGPLAN conference companion on Object oriented programming systems languages and applications, (957-964)
- Chen F, Gao B, Doan A, Yang J and Ramakrishnan R Optimizing complex extraction programs over evolving text data Proceedings of the 2009 ACM SIGMOD International Conference on Management of data, (321-334)
- Dalvi N, Kumar R, Pang B, Ramakrishnan R, Tomkins A, Bohannon P, Keerthi S and Merugu S A web of concepts Proceedings of the twenty-eighth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, (1-12)
- Badia A Supporting data exploration in databases Proceedings of the 2009 IEEE international conference on Intelligence and security informatics, (49-54)
- Furuse K, Sato K, Chen H and Ohbo N A materialized view selection technique for XPath queries Proceedings of the 2nd conference on European computing conference, (287-292)
- Behrend A, Dorau C, Manthey R and Schüeller G Incremental view-based analysis of stock market data streams Proceedings of the 2008 international symposium on Database engineering & applications, (269-275)
- Chandramouli B and Yang J (2008). End-to-end support for joins in large-scale publish/subscribe systems, Proceedings of the VLDB Endowment, 1:1, (434-450), Online publication date: 1-Aug-2008.
- Chui C The design and implementation of an OLAP system for sequence data analysis Proceedings of the 2nd SIGMOD PhD workshop on Innovative database research, (1-6)
- Lo E, Kao B, Ho W, Lee S, Chui C and Cheung D OLAP on sequence data Proceedings of the 2008 ACM SIGMOD international conference on Management of data, (649-660)
- Chaudhuri S, Kaushik R, Pol A and Ramamurthy R Stop-and-restart style execution for long running decision support queries Proceedings of the 33rd international conference on Very large data bases, (735-745)
- Adya A, Blakeley J, Melnik S and Muralidhar S Anatomy of the ADO.NET entity framework Proceedings of the 2007 ACM SIGMOD international conference on Management of data, (877-888)
- Behrend A, Dorau C and Manthey R TinTO Proceedings of the 12th international conference on Database systems for advanced applications, (1110-1114)
- Cohen S, Nutt W and Sagiv Y (2007). Deciding equivalences among conjunctive aggregate queries, Journal of the ACM, 54:2, (5-es), Online publication date: 1-Apr-2007.
- Wrembel R and Bębel B Metadata management in a multiversion data warehouse Journal on data semantics VIII, (118-157)
- Halashek-Wiener C, Parsia B and Sirin E Description logic reasoning with syntactic updates Proceedings of the 2006 Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, DOA, GADA, and ODBASE - Volume Part I, (722-737)
- Bebel B, Królikowski Z and Wrembel R Managing evolution of data warehouses by means of nested transactions Proceedings of the 4th international conference on Advances in Information Systems, (119-128)
- Luo G Efficient detection of empty-result queries Proceedings of the 32nd international conference on Very large data bases, (1015-1025)
- Hwang D, Kang H and Jeong B A scalable solution to XML view materialization on the web Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling, (270-273)
- Deshpande A and Madden S MauveDB Proceedings of the 2006 ACM SIGMOD international conference on Management of data, (73-84)
- Cohen S, Nutt W and Sagiv Y (2006). Rewriting queries with arbitrary aggregation functions using views, ACM Transactions on Database Systems, 31:2, (672-715), Online publication date: 1-Jun-2006.
- Braga D, Campi A and Martinenghi D Efficient integrity checking over XML documents Proceedings of the 2006 international conference on Current Trends in Database Technology, (206-219)
- Gemulla R and Lehner W Deferred maintenance of disk-based random samples Proceedings of the 10th international conference on Advances in Database Technology, (423-441)
- Keshav S (2006). Efficient and decentralized computation of approximate global state, ACM SIGCOMM Computer Communication Review, 36:1, (69-74), Online publication date: 10-Jan-2006.
- Wrembel R and Bębel B Metadata management in a multiversion data warehouse Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part II, (1347-1364)
- Rajugan R, Chang E, Dillon T and Feng L A three-layered XML view model Proceedings of the 24th international conference on Conceptual Modeling, (79-95)
- Munagala K, Yang J and Yu H Online view maintenance under a response-time constraint Proceedings of the 13th annual European conference on Algorithms, (677-688)
- Martinenghi D and Christiansen H Efficient integrity checking for databases with recursive views Proceedings of the 9th East European conference on Advances in Databases and Information Systems, (109-124)
- Barbosa D, Freire J and Mendelzon A Designing information-preserving mapping schemes for XML Proceedings of the 31st international conference on Very large data bases, (109-120)
- Martinenghi D and Christiansen H Transaction management with integrity checking Proceedings of the 16th international conference on Database and Expert Systems Applications, (606-615)
- Morzy M, Morzy T, Wojciechowski M and Zakrzewicz M Incremental data mining using concurrent online refresh of materialized data mining views Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery, (295-304)
- Olivé A Conceptual schema-centric development Proceedings of the 17th international conference on Advanced Information Systems Engineering, (1-15)
- Luo G, Naughton J, Ellmann C and Watzke M (2005). Locking Protocols for Materialized Aggregate Join Views, IEEE Transactions on Knowledge and Data Engineering, 17:6, (796-807), Online publication date: 1-Jun-2005.
- He H, Xie J, Yang J and Yu H Asymmetric Batch Incremental View Maintenance Proceedings of the 21st International Conference on Data Engineering, (106-117)
- Hung E, Deng Y and Subrahmanian V RDF Aggregate Queries and Views Proceedings of the 21st International Conference on Data Engineering, (717-728)
- Cohen S (2005). Containment of aggregate queries, ACM SIGMOD Record, 34:1, (77-85), Online publication date: 1-Mar-2005.
- Varró G, Friedl K and Varró D (2005). Graph Transformation in Relational Databases, Electronic Notes in Theoretical Computer Science (ENTCS), 127:1, (167-180), Online publication date: 1-Mar-2005.
- Kang H, Han S and Kim Y Schemes of storing XML query cache Proceedings of the 16th Australasian database conference - Volume 39, (55-64)
- Lehner W Data management support for notification services Data Management in a Connected World, (111-136)
- Morzy M, Morzy T and Królikowski Z Incremental association rule mining using materialized data mining views Proceedings of the Third international conference on Advances in Information Systems, (77-87)
- Barbosa D, Mendelzon A, Libkin L, Mignet L and Arenas M Efficient Incremental Validation of XML Documents Proceedings of the 20th International Conference on Data Engineering
- Bertossi L and Bravo L Consistent query answers in virtual data integration systems Inconsistency Tolerance, (42-83)
- Altinel M, Bornhövd C, Krishnamurthy S, Mohan C, Pirahesh H and Reinwald B Cache tables Proceedings of the 29th international conference on Very large data bases - Volume 29, (718-729)
- Luo G, Naughton J, Ellmann C and Watzke M Locking protocols for materialized aggregate join views Proceedings of the 29th international conference on Very large data bases - Volume 29, (596-607)
- Labrinidis A and Roussopoulos N Balancing performance and data freshness in web database servers Proceedings of the 29th international conference on Very large data bases - Volume 29, (393-404)
- Moon C, Kim S and Kang H Processing XML path expressions using XML materialised views Proceedings of the 20th British national conference on Databases, (19-37)
- Choi C, Yu J and Lu H Dynamic materialized view management based on predicates Proceedings of the 5th Asia-Pacific web conference on Web technologies and applications, (583-594)
- Reps T, Sagiv M and Loginov A Finite differencing of logical formulas for static analysis Proceedings of the 12th European conference on Programming, (380-398)
- Liu J and Vincent M (2003). Derivation of incremental equations for PNF nested relations, Acta Cybernetica, 16:1, (93-131), Online publication date: 1-Jan-2003.
- Paraboschi S, Sindoni G, Baralis E and Teniente E Materialized views in multidimensional databases Multidimensional databases, (222-251)
- Kang H, Sung H and Moon C Deferred incremental refresh of XML materialized views Proceedings of the 14th Australasian database conference - Volume 17, (217-226)
- Lehner W, Hümmer W, Schlesinger L and Bauer A On the problem of generating common predecessors Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP, (43-48)
- Luo Q, Krishnamurthy S, Mohan C, Pirahesh H, Woo H, Lindsay B and Naughton J Middle-tier database caching for e-business Proceedings of the 2002 ACM SIGMOD international conference on Management of data, (600-611)
- Weininger A Efficient execution of joins in a star schema Proceedings of the 2002 ACM SIGMOD international conference on Management of data, (542-545)
- Mokhtar H, Su J and Ibarra O On moving object queries Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, (188-198)
- Bloom T Data warehousing Handbook of data mining and knowledge discovery, (193-198)
- Weininger A XPS a database server for data warehousing Proceedings of the 4th ACM international workshop on Data warehousing and OLAP, (64-69)
- Nakamura H (2001). Incremental computation of complex object queries, ACM SIGPLAN Notices, 36:11, (156-165), Online publication date: 1-Nov-2001.
- Nakamura H Incremental computation of complex object queries Proceedings of the 16th ACM SIGPLAN conference on Object-oriented programming, systems, languages, and applications, (156-165)
- Stonebraker M and Hellerstein J (2001). Content integration for e-business, ACM SIGMOD Record, 30:2, (552-560), Online publication date: 1-Jun-2001.
- Stonebraker M and Hellerstein J Content integration for e-business Proceedings of the 2001 ACM SIGMOD international conference on Management of data, (552-560)
- Labrinidis A and Roussopoulos N (2000). WebView materialization, ACM SIGMOD Record, 29:2, (367-378), Online publication date: 1-Jun-2000.
- Labrinidis A and Roussopoulos N WebView materialization Proceedings of the 2000 ACM SIGMOD international conference on Management of data, (367-378)
- Maier D, Meredith M and Shapiro L (1998). Selected Research Issues in Decision Support Databases, Journal of Intelligent Information Systems, 11:2, (169-191), Online publication date: 1-Sep-1998.
Index Terms
- Materialized views: techniques, implementations, and applications
Recommendations
Optimizing queries using materialized views: a practical, scalable solution
Materialized views can provide massive improvements in query processing time, especially for aggregation queries over large tables. To realize this potential, the query optimizer must know how and when to exploit materialized views. This paper presents ...
Answering XML queries using materialized views revisited
CIKM '09: Proceedings of the 18th ACM conference on Information and knowledge managementAnswering queries using views is a well-established technique in databases. In this context, two outstanding problems can be formulated. The first one consists in deciding whether a query can be answered exclusively using one or multiple materialized ...
Processing Aggregate Queries with Materialized Views in Data Warehouse Environment
Materialized views, which are derived from base relations and stored in the database, offer opportunities for significant performance gain in query evaluation by providing quick access to the pre-computed data. A materialized view can be utilized in ...