dbTalk Databases Forums  

Informal Survey #1 -- joins on foreign keys

comp.databases.theory comp.databases.theory


Discuss Informal Survey #1 -- joins on foreign keys in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
James K. Lowden
 
Posts: n/a

Default Re: Informal Survey #1 -- joins on foreign keys - 04-04-2012 , 08:23 PM






On Wed, 4 Apr 2012 16:06:47 -0700 (PDT)
vldm10 <vldm10 (AT) yahoo (DOT) com> wrote:

Quote:
However db also
works with real word objects.
I am not aware of any such DBMS. Every DBMS I've ever seen manages
(let us call them) "objects" that are mere software. They are in no
way "real world objects". It is the designer's job to define those
objects reflective of the real world, and the user's job to maintain
the modelled objects such that accurately reflect the real world. Only
then is the DBMS able to provide logical inferences from the
model that can be meanfully applied to the real world (again, by the
user).

--jkl

Reply With Quote
  #22  
Old   
vldm10
 
Posts: n/a

Default Re: Informal Survey #1 -- joins on foreign keys - 04-06-2012 , 08:00 AM






On 5 tra, 03:23, "James K. Lowden" <jklow... (AT) speakeasy (DOT) net> wrote:
Quote:
On Wed, 4 Apr 2012 16:06:47 -0700 (PDT)

vldm10 <vld... (AT) yahoo (DOT) com> wrote:
However db also
works with real word objects.

I am not aware of any such DBMS. *Every DBMS I've ever seen manages
(let us call them) "objects" that are mere software. *They are in no
way "real world objects". *It is the designer's job to define those
objects reflective of the real world, and the user's job to maintain
the modelled objects such that accurately reflect the real world. *Only
then is the DBMS able to provide logical inferences from the
model that can be meanfully applied to the real world (again, by the
user).

--jkl

I have not mentioned the DBMS. Please note that the db is very
different from the DBMS. Note also that the db is different from the
data model. So take time for yourself and clarify basic concepts.
Then, I hope, you will understand what it is "a real world
application".

Reply With Quote
  #23  
Old   
compdb@hotmail.com
 
Posts: n/a

Default Re: Informal Survey #1 -- joins on foreign keys - 04-09-2012 , 05:49 PM



On Wednesday, 4 April 2012 16:06:47 UTC-7, vldm10 wrote:

Quote:
We do not understand one another regarding some important issues.
Unfortunately you don't understand my references to many that are basic, simple and common in logic and mathematics.

Quote:
I also think that you pay attention only to the model. However db also works with real word objects.
Predicate logic wffs and relational expressions correspond. Each connects the database to the world by its predicate extensions holding the tuples of values giving true propositions. Thus every predicate and relation expression connects the database and the world. Other connection is unnecessary. (Though perhaps useful.) I have explained that a foreign key asserts that certain tuple subsetting occurs and that correspondingly a certain implicationholds in the world. (About entities, if you wish). Sorry I haven't been able to make this or much else clear for you. Sorry but your papers are mostly incomprehensible and they misunderstand the RM.

philip

Reply With Quote
  #24  
Old   
vldm10
 
Posts: n/a

Default Re: Informal Survey #1 -- joins on foreign keys - 04-29-2012 , 01:12 PM



Dana utorak, 10. travnja 2012. 00:49:44 UTC+2, korisnik com... (AT) hotmail (DOT) com napisao je:
Quote:
On Wednesday, 4 April 2012 16:06:47 UTC-7, vldm10 wrote:

We do not understand one another regarding some important issues.

Unfortunately you don't understand my references to many that are basic, simple and common in logic and mathematics.

I also think that you pay attention only to the model. However db also works with real word objects.

Predicate logic wffs and relational expressions correspond. Each connectsthe database to the world by its predicate extensions holding the tuples of values giving true propositions. Thus every predicate and relation expression connects the database and the world. Other connection is unnecessary. (Though perhaps useful.) I have explained that a foreign key asserts that certain tuple subsetting occurs and that correspondingly a certain implication holds in the world. (About entities, if you wish). Sorry I haven't been able to make this or much else clear for you. Sorry but your papers are mostly incomprehensible and they misunderstand the RM.

philip

Reply With Quote
  #25  
Old   
vldm10
 
Posts: n/a

Default Re: Informal Survey #1 -- joins on foreign keys - 04-29-2012 , 01:46 PM



Dana utorak, 10. travnja 2012. 00:49:44 UTC+2, korisnik com... (AT) hotmail (DOT) com napisao je:
Quote:
On Wednesday, 4 April 2012 16:06:47 UTC-7, vldm10 wrote:

We do not understand one another regarding some important issues.

Unfortunately you don't understand my references to many that are basic, simple and common in logic and mathematics.

I also think that you pay attention only to the model. However db also works with real word objects.

Predicate logic wffs and relational expressions correspond. Each connectsthe >database to the world by its predicate extensions holding the tuples of values >giving true propositions.

It seems to me that you claim that the Relational model solves some problems in mathematics and logic.

As I already wrote, “This whole story about "predicates-relations-statements”, has already been done by Gottlob Frege, 120 years ago.” See my message from March 6th 2012.
Frege, in fact, did a lot more. He is the father of "Predicate Calculus" and modern logic. His Predicate logic is not limited by wffs. It is on the level of natural language. The RM is not on the level of natural languages.

Quote:
Thus every predicate and relation expression connects the database and the>world. Other connection is unnecessary. (Though perhaps useful.)
Sorry, but I disagree with this claim. One important part of this “connects the database to the world” is semantics. E. Codd hasn’t done anything significant within the field of Semantics.
G. Frege was the founder of Semantics, and many other people have given significant contribution to it.

Another important part related to this “connection” is the logic. Let me mention A. Tarski and his definition of truth.
Tarski worked on this definition for 10 years. Bela von Juhos also gave an important contribution to this definition of truth (where is the truth – in an object or in a meta language?)

E. Codd used truth tables because they work with compound propositions. Note that truth tables are on the intuitive level. In contrast to RM, my data model uses atomic propositions. Therefore the extensions correspond to atomic predicates.
Note that G. Frege used trees for compound propositions, instead of the truth tables.

I also presented definition of the predicate, which is based on G. Frege work:
A predicate is any incomplete phrase with specified gaps such that when thegaps are filled with names of things the phrase becomes a proposition.

Regarding to this definition, it is clear that G. Frege introduces the relation with named attributes, long before E. Codd.

This link between the database and the world, is one of the fundamental questions, which is only partially resolved. Famous mathematician in the last 100 years, have dealt with this subject. Some other sciences as philosophy,cognitive science and linguistics are also dealt with this topic.

So, if your intention is to show that E. Codd's relational model is able tofit into an existing mathematical theory, then I agree with you. But if your intention is to prove that the results that I mentioned above are Codd'scontribution, then I'm sorry, I disagree.
There is no doubt that E. Codd results from db theory have lasting value.

Quote:
Sorry but your papers are mostly incomprehensible and they misunderstand the >RM.

Here you are much generalized, so that no one sees what you mean. I publishmy papers on the user group so that they are public and subject to criticism. Of course I do not think that I am infallible. But the criticism must be PRECISE and CONCRETE.

I'll try to explain my paper with a few extras.
Section 3 defines the truth conditions. It also provides a link between meaning and truth. The truth conditions are often referred too by Frege, Godel, Tarski and Montague. Yet they do not define these terms.
Here I have tried to define the truth conditions in a language that works with entities, relationships, attributes, states and events.
Section 5 is about identification. For example OO approach extensively usedidentification, which is not defined in OO theory. RM also makes extensiveuse of identifiers, but there is no theory for them.
Section 7 can be understood if you look at the theory of Abstract State Machine (ASM). As far as I know the two groups at Microsoft Research are working on this. Unlike them, my paper provides a concrete solution.

Vladimir Odrljin

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.