Materialized views offer opportunities for significant performance gain in query evaluation by providing fast access to pi-e-computed data. The question of when and how to use a materialized view in processing agiven query is a difficult one attracting a significant amount of research. In previous works, only materialized views whose relations are contained in those of a query have been used and, as a result, certain potentially useful materialized views were excluded from consideration. Proposed in this paper are new ways of utilizing materialized views in answering a query with aggregation operations; Views including relations not referred to in the given query are utilized. We identify the conditions where a materialized view can be used...
Abstract. Queries to data warehouses often involve hundreds of complex aggregations over large volum...
Typical queries over data warehouses perform aggregation. One of the main ideas to optimize the exec...
Multiple Views can be formed and materialized from a data warehouses per the user requirements spec...
A data warehouse is a redundant collection of data replicated from several possibly distributed and ...
A data warehouse uses multiple materialized views to efficiently process a given set of queries. Mat...
Materialized views are a well-known optimization strategy with the potential for massive improvement...
Currently, database management systems have various tools such as backup and maintenance, and also p...
We consider the problem of rewriting queries using only materialized views. We first show that if th...
AbstractWe consider the problem of rewriting queries using only materialized views. We first show th...
OLAP queries involve a lot of aggregations on a large amount of data in data warehouses. To process ...
This is a draft of my contribution to a book chapter (doi: 10.4018/978-1-60566-816-1.ch005). We main...
Materialized views have been found to be very effective at speeding up queries, and are increasingly...
Abstract. The materialized view selection is a non-trivial task. Hence, its complexity must be reduc...
National audienceThe increasing interest in the RDF data model has turned the efficient processing o...
In recent years, query processing has become more complex as data sources are frequently replicated ...
Abstract. Queries to data warehouses often involve hundreds of complex aggregations over large volum...
Typical queries over data warehouses perform aggregation. One of the main ideas to optimize the exec...
Multiple Views can be formed and materialized from a data warehouses per the user requirements spec...
A data warehouse is a redundant collection of data replicated from several possibly distributed and ...
A data warehouse uses multiple materialized views to efficiently process a given set of queries. Mat...
Materialized views are a well-known optimization strategy with the potential for massive improvement...
Currently, database management systems have various tools such as backup and maintenance, and also p...
We consider the problem of rewriting queries using only materialized views. We first show that if th...
AbstractWe consider the problem of rewriting queries using only materialized views. We first show th...
OLAP queries involve a lot of aggregations on a large amount of data in data warehouses. To process ...
This is a draft of my contribution to a book chapter (doi: 10.4018/978-1-60566-816-1.ch005). We main...
Materialized views have been found to be very effective at speeding up queries, and are increasingly...
Abstract. The materialized view selection is a non-trivial task. Hence, its complexity must be reduc...
National audienceThe increasing interest in the RDF data model has turned the efficient processing o...
In recent years, query processing has become more complex as data sources are frequently replicated ...
Abstract. Queries to data warehouses often involve hundreds of complex aggregations over large volum...
Typical queries over data warehouses perform aggregation. One of the main ideas to optimize the exec...
Multiple Views can be formed and materialized from a data warehouses per the user requirements spec...