Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/articles/sql-server/)
-   -   Parsing technique in sql server (http://www.go4expert.com/articles/parsing-technique-sql-server-t9128/)

venkatesanj@hcl.in 4Mar2008 08:51

Parsing technique in sql server
 

Introduction



This article deals with parsing techniques involved in executing the sql server query. Nowadays, stored procedures forms a strong back ground in accessing the database. Why is it so???? how it's related to my query parsing technique

Background



If we think about the query execution there are various steps involved in executing the query such as,
  1. Lexical phase - Code break up will happen at this stage. All my code breaks up as individual tokens.
    Let us consider
    Code:

    int a;
    The code gets broken like "int" as a separate token and "a" as a seperate token.
  2. Syntax analysis - Here my code gets checked for its syntax.

    In C program we have a standard rule like, if i want to declare a variable we have to specify the variable and followed by variable name and you can specify the values(initialization) followed by semicolor (;)
    Code:

    int i=0;
    In sql server the syntax for select statement is,
    Code:

      select colname from tablename where condition on the columns
  3. Semantic phase - Here the semantics will be checked. For example i am trying to execute a simple piece of code in c#,

    Code:

      Console.Writeline(a.ToString());
      int a;

    In the above code my syntax is correct and i have missed my semantics :nonod: because i am trying to print the variable a with out declaring it and i am declaring the same after printing it.
  4. Intermediate code generation - Its the fourth stage where an intermediate code will be generated by the compiler its like converting the high level code to machine level code.
  5. Code Optimization - My compiler will holds some optimization technique to optimize the code so that we can achieve effective execution of our code.
  6. Optimized code generation - After code optimization a final code will be generated which can be used to retrieve the data. In sql server this optimized code will be stored and used frequently to fetch the data from the database.
  7. Code execution - The optimized code gets executed against the database engine.
Thus stored procedures and triggers are pre-compiled statements, gets executed and an optimized code will be ready to hit the database at any time.

Please provide me your valuable feedback regarding this article.

Regards,
Venkatesan Prabu . J

shabbir 4Apr2008 18:45

Re: Parsing technique in sql server
 
Nomination for article of the month of March

subashini 8Apr2008 19:35

Re: Parsing technique in sql server
 
Very good article.

I think we can relate this topic with compiler design concepts

shabbir 17Apr2008 15:51

Re: Parsing technique in sql server
 
Vote here - Voting for article of the month for Mar 2008

ramyasen 29Apr2008 15:52

Re: Parsing technique in sql server
 
:) :cuss: :undecided :wacky: :nonod: :p :goofy: ;) :lipsrseal
Quote:

Originally Posted by shabbir


ramyasen 29Apr2008 15:53

Re: Parsing technique in sql server
 
how will u give the payment

shabbir 29Apr2008 17:09

Re: Parsing technique in sql server
 
Quote:

Originally Posted by ramyasen
how will u give the payment

Read the rules pinned at the top of the competition forum

LenoxFinlay 17Jun2009 05:35

Re: Parsing technique in sql server
 
In my environment I have a few tables with thousands of rows that have URLs in particular columns. We are going through some changes in the environment and need to be able to parse out the data (base URL, file name, query parameters) from the specific columns then move the parsed data to another database design. Moving the data is no problem. I plan on using SQL Server 2005 Integration Services and I have a good sense of how to use that tool. By the way, all of the URLs are in varchar fields if that makes any difference. Can you provide any recommendations on how to parse that data?
Although there are probably a few different ways to approach this task, let's break it apart and see how we can code each one of these scenarios with T-SQL commands in SQL Server 2005. I assume you will be parsing the data from a single column to three new columns in a new database\table design. Since you are familiar with SQL Server 2005 Integration Services, I will not dig into those details and just focus on how to capture the data that you need. So let's take a look at each scenario and give an explanation on the T-SQL coding in SQL Server 2005.

technica 24Dec2009 14:05

Re: Parsing technique in sql server
 
Very good article. never new about this before.Thanks for sharing your writing with us all.


All times are GMT +5.5. The time now is 08:26.