Just to kill time over coffee - what do you take the word to mean?
I've just been reading a 1991 James Martin book on Object Orientation and he
was using it to talk about links between entities. Chris Date was very
specific that a relation was essentially a table. Mainly however, people
seem to
CityDev wrote:
Just to kill time over coffee - what do you take the word to mean?
I've just been reading a 1991 James Martin book on Object Orientation and he
was using it to talk about links between entities. Chris Date was very
specific that a relation was essentially a table. Mainly
On Mon, 27 Jul 2009, Darren Duncan wrote:
Object orientation has nothing to do with all this per se, though objects
can easily be mapped to tuples.
Darren,
A related issue is that object orientation is almost always used in the
context of procedural languages (e.g., C++, Python, Ruby)
On Sun, Jul 26, 2009 at 11:42:23PM -0700, CityDev scratched on the wall:
Just to kill time over coffee - what do you take the word to mean?
http://en.wikipedia.org/wiki/Relational_model
A relation is a data structure that anyone familiar with SQL would
call a table. It comes from the
It's true that Codd and Date used the term 'relational' (They championed the
N-ary Relational Model - others were around at the same time) but it's not
easy to track the origin of the term in mathematics. Certainly the word
implies joining things together. I guess the joining refers to fields
On 7/27/09 16:33 , CityDev nab...@recitel.net wrote:
it's not
easy to track the origin of the term in mathematics.
For what it's worth (ie probably not much), my formal mathematics training
in set theory taught me that a relation from a set A to a set B is a subset
R of the cartesian
On Jul 27, 2009, at 10:33 AM, CityDev wrote:
It's true that Codd and Date used the term 'relational' (They
championed the
N-ary Relational Model - others were around at the same time) but
it's not
easy to track the origin of the term in mathematics.
there and it's justified.
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On
Behalf Of CityDev [nab...@recitel.net]
Sent: Monday, July 27, 2009 9:33 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] What is a Relation?
It's true
On Mon, 27 Jul 2009, Beau Wilkinson wrote:
I am dealing with such a project now. The schema consists of time stamp
plus blob, where the blobs map directly to C++ structs. Of course, there
are all sorts of useful data items in those blobs, and many of the
capabilities of SQL are lost by
: Monday, July 27, 2009 10:46 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] What is a Relation?
On Mon, 27 Jul 2009, Beau Wilkinson wrote:
I am dealing with such a project now. The schema consists of time stamp
plus blob, where the blobs map directly to C++ structs. Of course
On 27 Jul 2009, at 2:49pm, Jay A. Kreibich wrote:
That's because most people are, unfortunately, taught SQL in a vacuum
with none of the theory or background.
Yes yes. Hence the recent rash of people on this list who can't dry-
run their software, don't understand what an index is, have
27, 2009 12:34 PM
To: j...@kreibi.ch; General Discussion of SQLite Database
Subject: Re: [sqlite] What is a Relation?
On 27 Jul 2009, at 2:49pm, Jay A. Kreibich wrote:
That's because most people are, unfortunately, taught SQL in a vacuum
with none of the theory or background.
Yes
Rich Shepard wrote:
On Mon, 27 Jul 2009, Darren Duncan wrote:
Object orientation has nothing to do with all this per se, though objects
can easily be mapped to tuples.
A related issue is that object orientation is almost always used in the
context of procedural languages (e.g., C++,
Beau Wilkinson wrote:
There are still people who just want
a cursor to a chunk of data which they pull in and iterate over rather than
use SQL's power to manage data a set-at-a-time
I am dealing with such a project now. The schema consists of time stamp plus
blob, where the blobs
On Mon, 27 Jul 2009, Paul Claessen wrote:
So .. would anyone know a good book for seasoned programmers, who are new
to databases, that addresses all these issues?
Paul,
Any of Joe Celko's books. His SQL Programming Style is particularly good
for an overview. The amazon.com listing lets you
Paul Claessen wrote:
So .. would anyone know a good book for seasoned programmers, who are new to
databases, that addresses all these issues?
I suggest one of C. J. Date's latest works:
See http://oreilly.com/catalog/9780596523060/ .
SQL and Relational Theory
How to Write Accurate SQL Code
On 27 Jul 2009, at 7:37pm, Paul Claessen wrote:
So .. would anyone know a good book for seasoned programmers, who
are new to databases, that addresses all these issues?
If you're a seasoned programmer you probably don't need my advice.
The problem is not databases, it's an understanding
17 matches
Mail list logo