Home » SQL & PL/SQL » SQL & PL/SQL » Mathematical Theory of Structured Query Language?
Mathematical Theory of Structured Query Language? [message #209771] Sun, 17 December 2006 18:49 Go to next message
zozogirl
Messages: 77
Registered: November 2005
Location: Seoul, Korea
Member

Hi, gurus.
I'm very interested in the mathematical theory of structured query language.
Could anyone recommend me some books or sites on the mathematical theory of structured query language?

Thx, in advance.
Re: Mathematical Theory of Structured Query Language? [message #209834 is a reply to message #209771] Mon, 18 December 2006 01:13 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Hi,

I have found some articles here that seem to be dealing with set theory.
Furthermore, there are quite some hits if you combine sql mathematics and "set theory".
Re: Mathematical Theory of Structured Query Language? [message #211144 is a reply to message #209771] Tue, 26 December 2006 13:40 Go to previous message
vadimtro
Messages: 8
Registered: December 2006
Junior Member
Let me start with lowering your expectations. SQL was developed in ad-hock manner, so there is little theory involved. Yet the book

http://www.rampant-books.com/book_2006_1_sql_coding_styles.htm

advances in this direction. There you'll find matrices, nested sets, relational division, transitive closure, and many other quering idioms. Needless to add, that Celko's Nested Sets method has been advanced into Nested Intervals. (See

http://www.dbazine.com/oracle/or-articles/tropashko4

for a very basic introduction into the subject).

Attached please find a sample chapter.

  • Attachment: ch3.pdf
    (Size: 365.28KB, Downloaded 937 times)

[Updated on: Tue, 26 December 2006 13:48]

Report message to a moderator

Previous Topic: sql query doubt
Next Topic: error using If statement in procedure
Goto Forum:
  


Current Time: Thu Dec 08 00:35:07 CST 2016

Total time taken to generate the page: 0.09490 seconds