DocumentCode
3013364
Title
Discovery and application of check constraints in DB2
Author
Gryz, Jarek ; Schiefer, Berni ; Zheng, Jian ; Zuzarte, Calisto
Author_Institution
Dept. of Comput. Sci., York Univ., UK
fYear
2001
fDate
2001
Firstpage
551
Lastpage
556
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
Keywords
data description; data integrity; data mining; query processing; relational databases; DB2 database; check constraints; data regularities; integrity constraints; query optimization; syntactic form; Application software; Computer science; Databases; Humans; Protection; Query processing; Strain control; Warehousing;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 2001. Proceedings. 17th International Conference on
Conference_Location
Heidelberg
ISSN
1063-6382
Print_ISBN
0-7695-1001-9
Type
conf
DOI
10.1109/ICDE.2001.914869
Filename
914869
Link To Document