Re: codegeneration / SQLparser

Hi, Tony,

I just found this on Google. I am not sure if it is just what You need, but it is worth reading.

http://www.dbazine.com/tropashko1.html

Jan=)

"Tony" <tbn99001_at_student.mdh.se> schrieb im Newsbeitrag news:25579391.0209250137.3b362856_at_posting.google.com...
> Hello
> My name is Tony and I am doing my master thesis on the subject
> databases. Now Iam in the stage to únderstand code generation and
> precompiled queries.
> This messege can be split in to parts first a need some
> help(litterature or links) that treats and explain precompiled
> queries.
>
> Second I need help with a question that concern code generation. If we
> consider the basics in relational algebra we talk about two kinds of
> operators
> Relational operators
> -SELECT
> -PROJECT
> -JOIN
> -DIVIDE
> Set operators
> -PRODUCT
> -UNION
> -INTERSECT
> -DIFFERENCE
>
> But a set of relational algebra operations is called a complete
> set, if and only if:
> Any relational algebra operator in the set cannot be derived in
> terms of a sequence of the others in the set. These operators are
> called fundamental or primitive operators. The set of algebra
> operations that contains all fundamental operators as:
> -selection
> -projection
> -union
> -difference
> -cartesian product
>
> this gives as I understand five fundamental operations.
> My question is where can i find information on how each of these
> translates to C-code. The information i can find contain information
> on query optimizing but nothing about code generation or even a clue
> to where to find this codegeneration.
> I have search for both an embedded SQL and ordinary SQl parser without
> any luck so if some know anything on this subject dont hesitate
>
> Thanks Tony
Received on Thu Sep 26 2002 - 19:03:48 CEST