Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c02.atl3!news.webusenet.com!telocity-west!DIRECTV!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!headwall.stanford.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: pbrazier@cosmos-uk.co.uk (Paul) Newsgroups: comp.databases.theory Subject: Re: Help! I can't support normalization Date: 20 Nov 2002 04:07:29 -0800 Organization: http://groups.google.com/ Lines: 36 Message-ID: <51d64140.0211200407.47b3cfa@posting.google.com> References: <4bbf8d70.0211010748.727d38ef@posting.google.com> <51d64140.0211070129.6fab7168@posting.google.com> <51d64140.0211150526.104fd27c@posting.google.com> <3DD547F9.B10179D4@oracle.com> <51d64140.0211190705.63bb11a6@posting.google.com> <3DDA5DFD.6020503@atbusiness.com> NNTP-Posting-Host: 195.92.141.89 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1037794049 7592 127.0.0.1 (20 Nov 2002 12:07:29 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 20 Nov 2002 12:07:29 GMT Xref: newsfeed1.easynews.com comp.databases.theory:23794 X-Received-Date: Wed, 20 Nov 2002 05:07:11 MST (news.easynews.com) Lauri Pietarinen wrote in message news:<3DDA5DFD.6020503@atbusiness.com>... > > > > > >I'm often having to programatically create tables containing integers > >1 to 100 say, it would be good if this was built-in so I could just do > >"SELECT integer FROM domain_integer WHERE integer BETWEEN 1 AND 100". ... > > It proposes a table called TableNum with just one column containing > integers from 1 to .... > It also has some proposed applications. > > Now, would such a table be a virtual or a real one?? Well, it depends what you man by "real". In a sense all tables are virtual because they are purely logical constructs. But what would it mean say to delete a row from such a "domain relation"? Really it shouldn't be allowed. I guess what you're meaning is that we would have two categories of table: ones where the rows are listed explicitly and ones where the rows are defined in some kind of induction process. These second sort of tables you could only SELECT from, as INSERT, UPDATE, DELETE might not make sense. Or maybe they would? Say I wanted to change my integer domain to be all integers (within a certain range) excluding "13"? Should I be allowed to do this or should the "built-in" domains remain as they are and I should define a new domain based on, but separate to, the integer domain (type inheritance?)? I've only briefly read about them but is this moving towards things like constraint databases? Does this violate Codd's principles? Should all relations be able in theory to be manipulated by any SQL DML statement? Paul.