article

Maintaining materialized views without accessing base data

Authors:

F. W. Tompa,

J. A. BlakeleyAuthors Info & Claims

Information Systems, Volume 13, Issue 4

Pages 393 - 406

https://doi.org/10.1016/0306-4379(88)90005-1

Published: 01 October 1988 Publication History

Abstract

No abstract available.

Cited By

View all

Sebaa A(2022)View Materialization for Query Processing in IoT SystemsInternational Journal of Technology Diffusion10.4018/IJTD.30074613:1(1-19)Online publication date: 20-May-2022
https://dl.acm.org/doi/10.4018/IJTD.300746
Gjengset JSchwarzkopf MBehrens JAraújo LEk MKohler EKaashoek MMorris RArpaci-Dusseau AVoelker G(2018)NoriaProceedings of the 13th USENIX conference on Operating Systems Design and Implementation10.5555/3291168.3291185(213-231)Online publication date: 8-Oct-2018
https://dl.acm.org/doi/10.5555/3291168.3291185
Kate BKohler EKester MNarula NMao YMorris RMahajan RStoica I(2014)Easy freshness with Pequod cache joinsProceedings of the 11th USENIX Conference on Networked Systems Design and Implementation10.5555/2616448.2616487(415-428)Online publication date: 2-Apr-2014
https://dl.acm.org/doi/10.5555/2616448.2616487
Show More Cited By

Index Terms

Maintaining materialized views without accessing base data
1. Information systems
  1. Data management systems
    1. Database design and models
    2. Database management system engines
      1. Database query processing
2. Theory of computation
  1. Computational complexity and cryptography
    1. Complexity classes
  2. Theory and algorithms for application domains
    1. Database theory
      1. Database query processing and optimization (theory)

Recommendations

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 ...
Materialized views selection for answering queries
ICDEM'10: Proceedings of the Second international conference on Data Engineering and Management

A data warehouse stores historical data to support analytical query processing. These analytical queries are long and complex and processing these against a large data warehouse consumes a lot of time. As a result, the query response time is high. One ...
Answering XML queries using materialized views revisited
CIKM '09: Proceedings of the 18th ACM conference on Information and knowledge management

Answering 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 ...

Comments

Information & Contributors

Information

Published In

Information Systems Volume 13, Issue 4

Oct. 1, 1988

99 pages

ISSN:0306-4379

Editor:
H. J. Schneider

Issue’s Table of Contents

Publisher

Elsevier Science Ltd.

United Kingdom

Publication History

Published: 01 October 1988

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

20
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to

Other Metrics

View Author Metrics

Citations

Cited By

View all

Sebaa A(2022)View Materialization for Query Processing in IoT SystemsInternational Journal of Technology Diffusion10.4018/IJTD.30074613:1(1-19)Online publication date: 20-May-2022
https://dl.acm.org/doi/10.4018/IJTD.300746
Gjengset JSchwarzkopf MBehrens JAraújo LEk MKohler EKaashoek MMorris RArpaci-Dusseau AVoelker G(2018)NoriaProceedings of the 13th USENIX conference on Operating Systems Design and Implementation10.5555/3291168.3291185(213-231)Online publication date: 8-Oct-2018
https://dl.acm.org/doi/10.5555/3291168.3291185
Kate BKohler EKester MNarula NMao YMorris RMahajan RStoica I(2014)Easy freshness with Pequod cache joinsProceedings of the 11th USENIX Conference on Networked Systems Design and Implementation10.5555/2616448.2616487(415-428)Online publication date: 2-Apr-2014
https://dl.acm.org/doi/10.5555/2616448.2616487
Hu YDessloch S(2014)Extracting deltas from column oriented NoSQL databases for different incremental applications and diverse data targetsData & Knowledge Engineering10.1016/j.datak.2014.07.00293:C(42-59)Online publication date: 1-Sep-2014
https://dl.acm.org/doi/10.1016/j.datak.2014.07.002
Mohapatra AGenesereth M(2014)Incremental Maintenance of Aggregate ViewsProceedings of the 8th International Symposium on Foundations of Information and Knowledge Systems - Volume 836710.1007/978-3-319-04939-7_20(399-414)Online publication date: 3-Mar-2014
https://dl.acm.org/doi/10.1007/978-3-319-04939-7_20
Thomsen JClausen CAndersen KDanaher JErnst E(2013)Reducing lookups for invariant checkingProceedings of the 27th European conference on Object-Oriented Programming10.1007/978-3-642-39038-8_18(426-450)Online publication date: 1-Jul-2013
https://dl.acm.org/doi/10.1007/978-3-642-39038-8_18
DeHaan DParedaens JSu J(2009)Equivalence of nested queries with mixed semanticsProceedings of the twenty-eighth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems10.1145/1559795.1559828(207-216)Online publication date: 29-Jun-2009
https://dl.acm.org/doi/10.1145/1559795.1559828
Lee WHwang YKang SKim SKim CLee Y(2002)Self-maintainable Data Warehouse Views Using Differential FilesProceedings of the 13th International Conference on Database and Expert Systems Applications10.5555/648315.756336(216-225)Online publication date: 2-Sep-2002
https://dl.acm.org/doi/10.5555/648315.756336
Roussopoulos NKotidis YLabrinidis ASismanis Y(2001)The Opsis projectProceedings of the 8th Panhellenic conference on Informatics10.5555/1756269.1756274(64-81)Online publication date: 8-Nov-2001
https://dl.acm.org/doi/10.5555/1756269.1756274
Garcia-Molina HLabio WYang J(1998)Expiring Data in a WarehouseProceedings of the 24rd International Conference on Very Large Data Bases10.5555/645924.671164(500-511)Online publication date: 24-Aug-1998
https://dl.acm.org/doi/10.5555/645924.671164
Show More Cited By

View Options

View options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

Cited By

Index Terms

Recommendations

Processing Aggregate Queries with Materialized Views in Data Warehouse Environment

Materialized views selection for answering queries

Answering XML queries using materialized views revisited

Comments

Information

Published In

Publisher

Publication History

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

Get Access

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations