Re: [sqlite] What is a Relation?

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

Re: [sqlite] What is a Relation?

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

Re: [sqlite] What is a Relation?

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

Re: [sqlite] What is a Relation?

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,

Re: [sqlite] What is a Relation?

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.,

Re: [sqlite] What is a Relation?

t; Sent: Monday, July 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 i

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 yes. Hence the recent rash of people on this list who can't dry- run their software, don't understand what an index is,

Re: [sqlite] What is a Relation?

pard [rshep...@appl-ecosys.com] Sent: 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

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, there > are all sorts of useful data items in those blobs, and many of the > capabilities of SQL are lost by

Re: [sqlite] What is a Relation?

and say, "you know, I've always thought OOP was a bunch of B.S" but the sentiment's out 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, Ju

Re: [sqlite] What is a Relation?

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.

Re: [sqlite] What is a Relation?

On 7/27/09 16:33 , "CityDev" 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

Re: [sqlite] What is a Relation?

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

Re: [sqlite] What is a Relation?

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

Re: [sqlite] What is a Relation?

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)

Re: [sqlite] What is a Relation?

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