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
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;
Conference_Titel :
Data Engineering, 2001. Proceedings. 17th International Conference on
Conference_Location :
Heidelberg
Print_ISBN :
0-7695-1001-9
DOI :
10.1109/ICDE.2001.914869
