Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-29 Thread Martijn Tonies
Hi, For decades, people have debated in comp.databases.theory and elsewhere how a 'relational database' should be defined. Codd's original 1970 paper sketches the relational algebra as a query language of a relational database, though Codd is not very precise about what the query language

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-29 Thread Martijn Tonies
Begging to differ, no vendor that I'm aware of claims to be compliant with a paper or textbook. They tend to comply with an adopted standard such as: ANSI/ISO/IEC 9075-1(through 5):1999 ISO/IEC 9075-1(through 5):1999 Yes, a strange thing too IMHO. The SQL standard defines a so-called

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread jeffrey_n_Dyke
I tend to agree with the past two posts that mysql is in fact relational, and would like to add that if we are going to make blanket statements that something IS or IS NOT that we qualify our responses. personlly i would like to know why Martijn views it as being a non relational db, without

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Martijn Tonies
Hi, If you are trying to determine whether MySQL is a relational database, the answer is yes. Ehm... the answer is no. It's getting better, that's for sure. MySQL may or may not conform to some standard or another, and it may or may not perform the tasks that you, personally, want it

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Saqib Ali
a question... is any DB that complies to the Relational Algebra a Relational DB??? Saqib Ali - http://validate.sourceforge.net --- XHTML/HTML/DocBook Validator On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote: I tend to agree with the past two posts that mysql is in fact relational, and

[Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)]

2003-10-28 Thread Juliana Gubert Ehrensperger
---BeginMessage--- Well, my database should be able to check some entry data and decide if these data will be accepted or rejected in a table that records all the received data. For example: I'll have a table 1 that contains a list of all the equipments that can send information to the database.

RE: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Saqib Ali
-Original Message- From: Saqib Ali [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 8:47 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Is MySQL Relational? (was: Foreigner keys in MySQL?) a question... is any DB that complies to the Relational

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread bluejack
On Tue, 28 Oct 2003 11:56:54 -0800, Jon Frisby [EMAIL PROTECTED] wrote: MySQL may or may not conform to some standard or another, and it may or may not perform the tasks that you, personally, want it to, but in fact it *is* a relational database, as opposed to a flat file or an object database.

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Heikki Tuuri
Ali [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, October 28, 2003 10:10 PM Subject: RE: Is MySQL Relational? (was: Foreigner keys in MySQL?) so funtions that can be performed by relation algebra are a subset of the functions performed by a relational database? however

RE: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Mike Brando
Senior Manager of Engineering Applied Biosystems 3833 North First Street San Jose, CA 95134-1701 -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:29 PM To: [EMAIL PROTECTED] Subject: Re: Is MySQL Relational? (was: Foreigner keys in MySQL

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Peter Brawley
so funtions that can be performed by relation algebra are a subset of the functions performed by a relational database? however isn't it required for a relational database to perform all the functions of relation algebra? Saqib, there are multiple relational algebras. No db fully implements