Skip to search form
Skip to main content
Skip to account menu
Semantic Scholar
Semantic Scholar's Logo
Search 218,356,657 papers from all fields of science
Search
Sign In
Create Free Account
Materialized view
Known as:
Materialised view
, MV
, Materialised views
Expand
In computing, a materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located…
Expand
Wikipedia
(opens in a new tab)
Create Alert
Alert
Related topics
Related topics
22 relations
Aggregate function
Apache Hive
Bitmap index
Cache (computing)
Expand
Broader (1)
Data modeling
Papers overview
Semantic Scholar uses AI to extract papers important to this topic.
2019
2019
A novel coral reefs optimization algorithm for materialized view selection in data warehouse environments
Hossein Azgomi
,
M. Sohrabi
Applied intelligence (Boston)
2019
Corpus ID: 157068312
High response time of analytical queries is one of the most challenging issues of data warehouses. Complicated nature of…
Expand
Highly Cited
2007
Highly Cited
2007
Lazy Maintenance of Materialized Views
Jingren Zhou
,
P. Larson
,
Hicham G. Elmongui
Very Large Data Bases Conference
2007
Corpus ID: 971610
Materialized views can speed up query processing greatly but they have to be kept up to date to be useful. Today, database…
Expand
2007
2007
Efficient Maintenance of Materialized Outer-Join Views
P. Larson
,
Jingren Zhou
IEEE International Conference on Data Engineering
2007
Corpus ID: 207699
Queries containing outer joins are common in data warehousing applications. Materialized outer-join views could greatly speed up…
Expand
Highly Cited
2002
Highly Cited
2002
Automating physical database design in a parallel database
Jun Rao
,
Chun Zhang
,
N. Megiddo
,
G. Lohman
ACM SIGMOD Conference
2002
Corpus ID: 662423
Physical database design is important for query performance in a shared-nothing parallel database system, in which data is…
Expand
Highly Cited
2001
Highly Cited
2001
An evolutionary approach to materialized views selection in a data warehouse environment
Chuan Zhang
,
X. Yao
,
Jian Yang
IEEE Trans. Syst. Man Cybern. Part C
2001
Corpus ID: 16803564
A data warehouse (DW) contains multiple views accessed by queries. One of the most important decisions in designing a DW is…
Expand
2001
2001
Optimizing queries using materialized views
Paul Larson
,
Jonathan Goldstein Microsoft
2001
Corpus ID: 215926641
Materialized views can provide massive improvements in query processing time, especially for aggregation queries over large…
Expand
Highly Cited
1999
Highly Cited
1999
Answering Queries Using Materialized Views with Disjunctions
F. Afrati
,
M. Gergatsoulis
,
Theodoros G. Kavalieros
International Conference on Database Theory
1999
Corpus ID: 426233
We consider the problem of answering datalog queries using materialized views. More specifically, queries are rewritten to refer…
Expand
Highly Cited
1999
Highly Cited
1999
Architecture and Quality in Data Warehouses: An Extended Repository Approach
M. Jarke
,
M. Jeusfeld
,
C. Quix
,
Panos Vassiliadis
Information Systems
1999
Corpus ID: 9437343
Highly Cited
1989
Highly Cited
1989
Updating Distributed Materialized Views
A. Segev
,
Jooseok Park
IEEE Transactions on Knowledge and Data…
1989
Corpus ID: 37647143
The problem of updating materialized views in distributed database systems is discussed. An architecture and detailed procedures…
Expand
Highly Cited
1987
Highly Cited
1987
A performance analysis of view materialization strategies
E. Hanson
ACM SIGMOD Conference
1987
Corpus ID: 2117821
The conventional way to process commands for relational views is to use query modification to translate the commands into ones on…
Expand
By clicking accept or continuing to use the site, you agree to the terms outlined in our
Privacy Policy
(opens in a new tab)
,
Terms of Service
(opens in a new tab)
, and
Dataset License
(opens in a new tab)
ACCEPT & CONTINUE