Results 1 to 4 of 4

Thread: What actually happens at the backend?

  1. #1
    Junior Member
    Join Date
    May 2007
    Answers
    5

    What actually happens at the backend?

    What actually happens at the backend when we write a SQL query and execute it.

    Is it similar like flow of C, C++ programs. I would like to understand the architecture of the database for the better understanding.

    Can anybody help me out?


  2. #2
    Contributing Member
    Join Date
    Jul 2006
    Answers
    63

    Re: What actually happens at the backend?

    The processing logic for getting results or final output of your actual query is same as you do for regular programming language. But how it gets processed only differs. In programming language like C, C++ you have compilers checking syntax and taking care of usage semantics. In database you have optimizers like cost based optimizers which check the query written by users for analyzing statistics and uses the best path of execution.


  3. #3
    Junior Member
    Join Date
    May 2007
    Answers
    5

    Re: What actually happens at the backend?

    Thanks!! for your very clear answer, but can u tell me what is this "best path" choosen. Is this similar to execution plan? what actually is this execution plan? can i know the stepwise/linewise output or execution result of my SQL written?

    Please help by providing some useful links also if u can..

    Thanks,
    Neel.



    Quote Originally Posted by christia View Post
    The processing logic for getting results or final output of your actual query is same as you do for regular programming language. But how it gets processed only differs. In programming language like C, C++ you have compilers checking syntax and taking care of usage semantics. In database you have optimizers like cost based optimizers which check the query written by users for analyzing statistics and uses the best path of execution.



  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: What actually happens at the backend?

    use tkprof utility tool to get details of execution plan.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact