Constraints are Liberating
Roy Hann, first presented at CA World 2004, Las Vegas

 

Home

This presentation reviews the support for integrity constraints provided by  Ingres™ 2.6. We look at the importance of the built-in check, entity, and referential integrity constraints.   Two additional kinds of constraints are introduced, and techniques for implementing them are illustrated.  We then examine the use of all the different types of constraint to dramatically decrease the size and complexity of application programs.   The use of server-side constraints to facilitate end-user access and rapid response to changing business requirements is demonstrated.  Finally we remark on the massive performance gains that can be achieved once it is possible to presume that the data are completely correct.  

The presentation is in the form of 53 Microsoft PowerPoint 2000 slides, zipped to 900kb and inflating to 1.2Mb.

Topics

>> Built-in ANSI declarative constraints
>>
Non-ANSI constraints
>>
Front-end versus back-end constraint checking
>>
Constraints and predicates encode meaning
>>
Transition constraints
>>
General constraints
>>
Empowering end-users and verifying business models

 

Download now. (900kb)


Ingres® is a trademark of Ingres Corporation | ©Rational Commerce Ltd. | Last updated 13/11/2006 14:54