VIE Lecture by Toon Koppelaars
On Thursday 27 November 2008, Toon Koppelaars (RuleGen) will give a VIE Lecture entitled "Database Constraints – The DBMS Vendors' Challenge".
Summary - Current SQL DBMS's still lack full support for integrity constraints. In this presentation I will offer a "polite excuse" for this state of affairs. I will demonstrate the challenges that need to be solved in order to end up with an efficient implementation of 'create assertion' or 'subqueries in check constraints', both being the concepts in the SQL standard for supporting declarative integrity constraints. Creating an efficient implementation of (full) declarative integrity constraint support, also allowing for sufficient concurrency of transactions, is by far no easy task. At the end of this presentation, you will understand why. I will use the Oracle DBMS to demonstrate the various issues. However, these issues also apply for other vendors DBMS's. During this presentation I will develop six executions models for implementing constraints. These are described in the recently published book "Applied Mathematics for Database Professionals" (Chapter 11). The complexity of these execution models ranges from very simple (and also inefficient) to more sophisticated (efficient). Execution model six lies at the basis of the RuleGen framework, which will be demonstrated at the end of this presentation.
|18:30||VIE Lecture by Toon Koppelaars|
The venue for this VIE Lecture is Room HG 5.91 of LaQuSo, the Laboratory for Quality Software of Eindhoven University of Technology and Radboud University Nijmegen. Participation is free for VIE Members after registration via e-mail.