Detecting redundant materialized views in data warehouse evolution

Information Systems

Volumn 26, Issue 3, 2001, Pages 363-381

  Theodoratos, D ^a  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

Author keywords

Data warehouse evolution; Materialized views; Redundant views; View maintenance; View usability

Indexed keywords

ALGORITHMS; INFORMATION RETRIEVAL; ONLINE SYSTEMS; QUERY LANGUAGES; REDUNDANCY; TABLE LOOKUP;

MATERIALIZED VIEWS;

DATA WAREHOUSES;

EID: 0035328353     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: None     Document Type: Article

References (43)

1. Research problems in data warehousing
2. Answering queries using views
3. Maintaining views incrementally
4. Incremental maintenance of views with duplicates
5. View maintenance in a warehousing environment
6. Multiple query optimization
7. Improvements on a heuristic algorithm for multiple-query optimization
8. Common subexpression isolation in multiple query optimization
9. Materialized view maintenance and integrity constraint checking: Trading space for time
10. Data integration using self-maintainable views
11. A framework for supporting data integration using the materialized and virtual approaches
12. Making views self maintainable for data warehousing
13. Incremental design of a data warehouse
14. Optimizing queries with materialized views
15. Currency-based updates to distributed materialized views
16. Data currency quality factors in data warehouse design
17. Principles and techniques in the design of ADMS±
18. A performance analysis of view materialization strategy
19. Aggregate-query processing in data warehousing environments
20. Answering SQL queries with aggregation using views
21. Adapting materialized views after redefinitions
22. Maintenance of materialized views: Problems, techniques and applications
23. Implementing data cubes efficiently
24. Selection of views to materialize in a data warehouse
25. Algorithms for materialized view design in data warehousing environment
26. Selection of views to materialize under a maintenance cost constraint
27. Data warehouse configuration
28. Designing the global data warehouse with SPJ views
29. DynaMat: A dynamic view management system for data warehouses
30. Detecting redundancy in data warehouse evolution
31. Updating derived relations: Detecting irrelevant and autonomously computable updates
32. Queries independent of updates
33. Efficiently updating materialized views
34. Deriving production rules for incremental view maintenance
35. Updating distributed materialized views
36. Maintenance expressions for views with aggregation
37. View indexing in relational databases
38. The volcano optimizer generator: Extensibility and efficient search
39. Performing group-by before join
40. The logical access path schema of a database
41. Constructing GPSJ view graphs