loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
17th International Conference on Data Engineering (ICDE'01)
Discovery and Application of Check Constraints in DB2
Heidelberg, Germany
April 02-April 06
ISBN: 0-7695-1001-9
ASCII Text
x 
 
Jarek Gryz, Berni Schiefer, Jian Zheng, Calisto Zuzarte, "Discovery and Application of Check Constraints in DB2," Data Engineering, International Conference on, pp. 0551, 17th International Conference on Data Engineering (ICDE'01), 2001.
 
 
BibTex
x
 
@article{ 10.1109/ICDE.2001.914869,
author = {Jarek Gryz and Berni Schiefer and Jian Zheng and Calisto Zuzarte},
title = {Discovery and Application of Check Constraints in DB2},
journal ={Data Engineering, International Conference on},
volume = {0},
year = {2001},
isbn = {0-7695-1001-9},
pages = {0551},
doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2001.914869},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - CONF
JO - Data Engineering, International Conference on
TI - Discovery and Application of Check Constraints in DB2
SN - 0-7695-1001-9
SP
EP
A1 - Jarek Gryz,
A1 - Berni Schiefer,
A1 - Jian Zheng,
A1 - Calisto Zuzarte,
PY - 2001
VL - 0
JA - Data Engineering, International Conference on
ER -
 
Jarek Gryz, York University, Toronto
Berni Schiefer, IBM Toronto
Jian Zheng, IBM Toronto
Calisto Zuzarte, IBM Toronto
Abstract: The traditional role of integrity constraints is to protect the integrity of data. But integrity constraints can and do play other roles in databases; for example, they can be used for query optimization. In this role, they do not need to model the domain; it is sufficient that they describe regularities that are true about the data currently stored in a database. In this paper we describe two algorithms for finding such regularities (in the syntactic form of check constraints) and discuss some of their applications in DB2. In particular, we show their use in query optimization.
Citation:
Jarek Gryz, Berni Schiefer, Jian Zheng, Calisto Zuzarte, "Discovery and Application of Check Constraints in DB2," icde, pp.0551, 17th International Conference on Data Engineering (ICDE'01), 2001
Usage of this product signifies your acceptance of the Terms of Use.