Main Page | Report this Page
Computers Forum Index  »  Computer - Databases  »  Life-Cycle of SQL Query...
Page 1 of 1    

Life-Cycle of SQL Query...

Author Message
David...
Posted: Fri Sep 11, 2009 9:31 pm
Guest
I am trying to get a top-down understanding of what it takes to go
from a SQL Query to actual data (records served up the RDBMS).

Your thoughts / Links to good resources that cover this would be much
appreciated.

-David
 
toby...
Posted: Fri Oct 23, 2009 2:37 am
Guest
On Sep 11, 5:31 pm, David <david.p.wat... at (no spam) gmail.com> wrote:
Quote:
I am trying to get a top-down understanding of what it takes to go
from a SQL Query to actual data (records served up the RDBMS).

Your thoughts / Links to good resources that cover this would be much
appreciated.

The open source RDBMS give you 100% visibility into implementation.
For example, a quick Google turns up:

http://forge.mysql.com/wiki/MySQL_Internals
http://www.scribd.com/doc/10035754/MySQL-Internals-Manual

http://www.redhat.com/docs/manuals/database/RHDB-2.0-Manual/admin_user/overview.html
http://www.scribd.com/doc/7800905/PostgreSQL-Internals-Through-Pictures
http://www.scribd.com/doc/7800904/Inside-PostgreSQL-Shared-Memory

and older:
http://www.scribd.com/doc/4844939/The-Implementation-Of-POSTGRES

Quote:

-David
 
 
Page 1 of 1    
All times are GMT
The time now is Wed Nov 25, 2009 1:03 am