Life-Cycle of SQL Query

#1

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

#2

On 11.09.2009 23:31, David 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.

I can say for sure that Oracle as well as Microsoft cover this in their
product documentation - which is available online.

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

#3

On Sep 11, 5:31*pm, David <david.p.wat... (AT) gmail (DOT) 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/M...ternals-Manual

http://www.redhat.com/docs/manuals/d.../overview.html
http://www.scribd.com/doc/7800905/Po...rough-Pictures
http://www.scribd.com/doc/7800904/In...-Shared-Memory

and older:
http://www.scribd.com/doc/4844939/Th...on-Of-POSTGRES

Quote:

-David

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Life-Cycle of SQL Query

comp.databases comp.databases

Life-Cycle of SQL Query - 09-11-2009 , 04:31 PM

Re: Life-Cycle of SQL Query - 09-12-2009 , 11:12 AM

Re: Life-Cycle of SQL Query - 10-22-2009 , 09:37 PM