Optimization of materialization strategies for derived data elements

Heuristics for selecting robust database structures with dynamic query patterns

“…In particular, large and frequent variations of queries are very likely to reduce the effectiveness of query optimization techniques and consequently degrade database performance. Recognizing this fact, materialized views [1,6,8,21,40] and the data warehouse concept [4,9,24,26] have been proposed and have gained commercial popularity. The goal is to provide the means to timely answer the most frequently posed queries and decision-oriented queries that the operational database system is poor at answering.…”

A multiagent update process in a database with temporal data dependencies and schema versioning

“…They are used to monitor the runtime execution, as discussed in Section 3, and they function as a validation tool, enabling the system designer to capture the global application behavior that is inferred from the various dependencies using a visualization tool. 5. Incremental calculations are possible in some cases [34].…”

“…Various models use the concepts of integrity constraints [8] and derived data [34] to materialize data dependencies. The feasibility of derivation materialization depends upon the ability to efficiently compute materialized data dependencies, as discussed in [29], [41], [5].…”

Robust optimization for performance tuning of modern database systems

“…In particular, large and frequent variations of queries are very likely to reduce the effectiveness of query optimization techniques and consequently degrade database performance. Prior research indicate that traditional databases have had a performance problem with query processing and as a result the materialized view technique (Agrawal et al, 2000;Botzer and Etzion, 1996;Chaudhuri et al, 1995;Hanson, 1987;Storey and Goldstein, 1988) and the data warehouse concept (Barquin and Edelstein, 1997;Chaudhuri et al, 2001;Inmon, 1996;Yang et al, 1997) have been proposed and have gained commercial popularity. The goal is to provide ways to timely answer the most frequently posted queries and decision-oriented queries that the operational database system is poor at answering.…”