dbTalk Databases Forums  

Relational Calculus, which subset of FOL is supported

comp.databases.theory comp.databases.theory


Discuss Relational Calculus, which subset of FOL is supported in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tbeer
 
Posts: n/a

Default Relational Calculus, which subset of FOL is supported - 07-11-2008 , 08:54 AM






Hi all!

It is often stated that relational calculus (tuple domain calculus) is
a subset of first order logic.
In the dbforum, wikipedia, wapedia articles:
- http://en.wikipedia.org/wiki/Relational_algebra
- http://wapedia.mobi/en/Relational_algebra
- http://www.dbforums.com/archive/index.php/t-424876.html
it is claimed that:
1) "Codd's algebra is not in fact complete with respect to first-order
logic, he restricted the operands to finite relations only and also
proposed restricted support for negation (NOT) and disjunction (OR)"
2) "Relational algebra actually corresponds to a subset of first-order
logic that is Horn clauses without recursion and negation."
3) ">What is the relation between the relational model and first oder
logic? They are one and the same."

Which "subset" of FOL is supported by the relational calculus in
detail?
I know Codd's (original) paper from 1970 (unfortunately I don't have
the original one from 1969), but I wasn't able to find an answer to my
question.

I'm looking for a more "serious comparison" of relational algebra (or
relational calculus) and FOL (or predicate logic in general), i.e.
expressive power, limitations, etc.

I really appreciate your help.


Best regards,
Tom

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.