Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-08-26 Thread Dmitry Pashkevich
I recommend this free online class from Stanford: Introduction to Databases It's pretty comprehensive (but not too in-depth) if want to get started with database theory. Here's the syllabus copied from the website: This course covers database design and the

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-08-26 Thread Gerry Snyder
O'Reilly just started a 50%-off sale on all ebooks (60% on orders of $100 or more), good through Sept. 10. A good chance to pick up these or anything else, SQL-oriented or otherwise. The discount code* *is B2S3 (but is also shown on the website). Gerry * * On Thu, Jul 18, 2013 at 5:31 AM,

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-18 Thread Keith Medcalf
FWIW, these titles and many more are all available in the Safari Books collection. http://www.safaribooksonline.com/ I am not affiliated with Safari Books Online -- just a long time subscriber ... On Thu, 18 Jul 2013 17:14:34 + Konrad Hambrick wrote: >> -Original

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-18 Thread Konrad Hambrick
> -Original Message- > On Tue, Jul 9, 2013 at 9:27 PM, Jay A. Kreibich wrote: > > > > If you want to learn more about the theory and concepts behind SQL, I > > would strongly recommend these two books: > > > > SQL and Relational Theory (2nd Ed) by C.J. Date > >

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-18 Thread Stephan Beal
On Thu, Jul 18, 2013 at 2:31 PM, Richard Hipp wrote: > On Tue, Jul 9, 2013 at 9:27 PM, Jay A. Kreibich wrote: > > If you want to learn more about the theory and concepts behind SQL, I > > would strongly recommend these two books: > > > > SQL and

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-18 Thread Richard Hipp
On Tue, Jul 9, 2013 at 9:27 PM, Jay A. Kreibich wrote: > > If you want to learn more about the theory and concepts behind SQL, I > would strongly recommend these two books: > > SQL and Relational Theory (2nd Ed) by C.J. Date >

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-10 Thread Stephan Beal
On Wed, Jul 10, 2013 at 11:57 AM, Stephan Beal wrote: > On Wed, Jul 10, 2013 at 3:27 AM, Jay A. Kreibich wrote: > >> SQL and Relational Theory (2nd Ed) by C.J. Date >> > http://shop.oreilly.com/product/0636920022879.do > > Follow-up... To quote the

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-10 Thread Stephan Beal
On Wed, Jul 10, 2013 at 3:27 AM, Jay A. Kreibich wrote: > ... There are two mathematical systems that can be used to define and prove > the self-consistency of the Relational Model. One system is called > "Relational Algebra" and the other "Relational Calculus." The two >

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-10 Thread Paolo Bolzoni
On Wed, Jul 10, 2013 at 3:27 AM, Jay A. Kreibich wrote: > really *know* OOP. Similarly, even if you're an expert C++ developer, > if C++ is you're only OOP language, you still don't really get what > clean OOP is all about (because C++ sure as heck isn't that, even if >

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-09 Thread Jay A. Kreibich
On Tue, Jul 09, 2013 at 11:22:35PM +0200, Stephan Beal scratched on the wall: > On Tue, Jul 9, 2013 at 7:24 PM, Paolo Bolzoni > wrote: > > > I am sorry the part that look Greek to you is actually fairly > > important base of the theory behind SQL, the relational

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-09 Thread Stephan Beal
On Tue, Jul 9, 2013 at 7:24 PM, Paolo Bolzoni wrote: > I am sorry the part that look Greek to you is actually fairly > important base of the theory behind SQL, the relational algebra. > Bad news for me ;), but you've given me a new search term: relational

Re: [sqlite] Literature on the information theory behind SQL(lite)?

2013-07-09 Thread Paolo Bolzoni
I am sorry the part that look Greek to you is actually fairly important base of the theory behind SQL, the relational algebra. A possible answer to your question is the classic book: Database Systems, The complete book of Ullman et. all. It is comprehensive, so it should satisfy all your

[sqlite] Literature on the information theory behind SQL(lite)?

2013-07-09 Thread Stephan Beal
Hi, all, i am looking for literature which describes the data/information theory/formalisms behind sqlite and similar projects. Google has so far led me to the extremes of "introduction to SQL" (don't need it) and articles which start using Greek symbols in the 3rd paragraph (and which point my