Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / April 2007

Tip: Looking for answers? Try searching our database.

Why relational division is so uncommon?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vadim Tropashko - 25 Apr 2007 19:16 GMT
http://vadimtropashko.wordpress.com/why-relational-division-is-so-uncommon/
V.J. Kumar - 26 Apr 2007 02:08 GMT
> http://vadimtropashko.wordpress.com/why-relational-division-is-so-uncom
> mon/

You wrote: "Informally, Relational Division corresponds to the any
quantifier in calculus, which should be as frequent as its exists
counterpart!"

In which calculus ? In SQL, ANY is a synonym for SOME (see a SQL
reference). In spoken English,  ANY can be interpreted either universally
or existentially. Perhaps,  you've meant FORALL ?

"
In a word, it one of the most distinguished relational database features
— referential integrity — that undermines a possibility for a non vacuous
relational division query.
"

That's a strange conclusion based on a trivial Emp/Dept schema ! I hope
you are not denying that relational division can be quite useful to
express some queries. Consider  a query:  what patients have all of such
and so symptoms, or any similar question.

The problems with the r.d. are that it arguably cannot be implemented
efficiently and is not as easy to understand as a typical SPJ query.
jefftyzzer - 26 Apr 2007 19:55 GMT
On Apr 25, 11:16 am, Vadim Tropashko <vadimtro_inva...@yahoo.com>
wrote:
> http://vadimtropashko.wordpress.com/why-relational-division-is-so-unc...

In my experience, those "find (exactly) matching sets" type questions
are particularly tricky. On the subject of Rel Div, I thought Itzik
Ben-Gan's June and July '03 articles in SQL Server Magazine were
exemplary:

July 2003
A Different Setup
When your query needs to find items with certain relationships, you
can use relational division, or you can try these new tricks.

June 2003
Set Members and Relationships
You can use Set Theory to identify groups of items that have a certain
relationship to other items.

Looking forward to the receipt of your book ("it's in the mail").

--Jeff
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.