Result: View matching for outer-join views
Title:
View matching for outer-join views
Authors:
Source:
Best papers of VLDB 2005The VLDB journal. 16(1):29-53
Publisher Information:
Heidelberg: Springer, 2007.
Publication Year:
2007
Physical Description:
print, 18 ref
Original Material:
INIST-CNRS
Subject Terms:
Computer science, Informatique, Sciences exactes et technologie, Exact sciences and technology, Sciences appliquees, Applied sciences, Informatique; automatique theorique; systemes, Computer science; control theory; systems, Logiciel, Software, Organisation des mémoires. Traitement des données, Memory organisation. Data processing, Systèmes d'information. Bases de données, Information systems. Data bases, Analyse syntaxique, Syntactic analysis, Análisis sintáxico, Base donnée très grande, Very large databases, Forme normale, Normal form, Forma normal, Interrogation base donnée, Database query, Interrogación base datos, Méthode ascendante, Bottom up method, Método ascendente, SQL, Sémantique, Semantics, Semántica, Traitement requête, Query processing, Tratamiento pregunta, Vue matérialisée, Materialized view, Vista materializada, Aggregation, Materialized views, Outer joins, View matching
Document Type:
Conference
Conference Paper
File Description:
text
Language:
English
Author Affiliations:
Microsoft Research, One Microsoft Way, Redmond, WA 98052, United States
ISSN:
1066-8888
Rights:
Copyright 2007 INIST-CNRS
CC BY 4.0
Sauf mention contraire ci-dessus, le contenu de cette notice bibliographique peut être utilisé dans le cadre d’une licence CC BY 4.0 Inist-CNRS / Unless otherwise stated above, the content of this bibliographic record may be used under a CC BY 4.0 licence by Inist-CNRS / A menos que se haya señalado antes, el contenido de este registro bibliográfico puede ser utilizado al amparo de una licencia CC BY 4.0 Inist-CNRS
CC BY 4.0
Sauf mention contraire ci-dessus, le contenu de cette notice bibliographique peut être utilisé dans le cadre d’une licence CC BY 4.0 Inist-CNRS / Unless otherwise stated above, the content of this bibliographic record may be used under a CC BY 4.0 licence by Inist-CNRS / A menos que se haya señalado antes, el contenido de este registro bibliográfico puede ser utilizado al amparo de una licencia CC BY 4.0 Inist-CNRS
Notes:
Computer science; theoretical automation; systems
Accession Number:
edscal.18441896
Database:
PASCAL Archive
Further Information
Prior work on computing queries from materialized views has focused on views defined by expressions consisting of selection, projection, and inner joins, with an optional aggregation on top (SPJG views). This paper provides a view matching algorithm for views that may also contain outer joins (SPOJG views). The algorithm relies on a normal form for outer-join expressions and is not based on bottom-up syntactic matching of expressions. It handles any combination of inner and outer joins, deals correctly with SQL bag semantics, and exploits not-null constraints, uniqueness constraints and foreign key constraints.