Domains, and Why We Need Them
Tony Douglas and Roy Hann, first presented at the October 2003 IUA Autumn Conference, Manchester

 

Home

From its very beginning in 1969, relational theory has depended upon the concept of a domain.  For more or less the entire history of relational database management none of the mainstream SQL products has supported domains.  Instead we have a collection of data types hardly richer than that of FORTRAN IV.  Far from being a mere theoretical deficiency, this had led to vast amounts of unnecessary application code, data corruption, misunderstanding, design errors, and endless other practical, real, and expensive consequences.

In this presentation we introduce the concept of a domain, explain how a domain is defined, and show some of the enormous practical benefits that would follow if they were properly supported. We also show how Ingres can be made to support domains in a limited way.

The presentation is in the form of 40 Microsoft PowerPoint 2000 slides, zipped to 218kb and inflating to 367kb.

Topics

>> What is a domain?
>>
The problem with using hardware data types
>>
Type systems in use elsewhere
>>
SQL "domains"
>>
Ingres and User-defined types
>>
Difficulty of exploiting UDTs

Download now. (218kb)


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