Efficient maintenance of materialized outer-join views

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2007, Pages 56-65

  Larson, Per Åke ^a   Zhou, Jingren ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

CONSTRAINT THEORY; DATA REDUCTION; DATABASE SYSTEMS; WAREHOUSES;

BASE TABLES; DATA WAREHOUSING APPLICATIONS; FOREIGN KEY CONSTRAINTS; OUTER-JOIN VIEWS;

QUERY PROCESSING;

EID: 34548785539     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2007.367851     Document Type: Conference Paper

References (10)

1. C. Galindo-Legaria. Outerjoins as disjunctions. In SIGMOD Conference, 1994.
2. C Galindo-Legaria and A. Rosenthal. Outerjoin simplification and reordering for query optimization. ACM Transactions on Database Systems, 22(1), 1997.
3. T. Griffin and B. Kumar, Algebraic change: propagation for semijoin and outerjoin queries. SIGMOD Record, 27(3):22-27, 1998.
4. A. Gupta and I. S. Mumick, Maintenance of materialized views: Problems, techniques, and applications. Data Engineering Bulletin, 18(2), 1995.
5. A. Gupta, L S. Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In SIGMOD Conference, 1993.
6. H. Gupta and I. S. Mumick. Incremental, maintenance of aggregate and outerjoin expressions. Information Systems, 31(6), 2006.
7. P.-Å. Larson and J. Zhou, View matching for outerjoin views. In VLDB Conference, 2005.
8. P.-Å. Larson and J. Zhou. Maintenance of materialized outer-join views. Technical Report (to appear), Microsoft Research, 2006.
9. Oracle Corp. Oracle Database Data Warehousing Guide 10g Release 2, 2006. http://download-west.oracle,com /docs/cd/B19306_01/server.102/bl4223/b asicmv.htm.
10. J. Rao, H. Pirahesh, and C Zuzarte. Canonical abstraction for outerjoin optimization. In SIGMOD Conference, 2004.