Apr. 2, 2001 to Apr. 6, 2001
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.
Jarek Gryz, Berni Schiefer, Jian Zheng, Calisto Zuzarte, "Discovery and Application of Check Constraints in DB2", ICDE, 2001, 2013 IEEE 29th International Conference on Data Engineering (ICDE), 2013 IEEE 29th International Conference on Data Engineering (ICDE) 2001, pp. 0551, doi:10.1109/ICDE.2001.914869