[ Top page ]

« October 2008 | Main | May 2012 »

December 2008 Archives

December 29, 2008

Database

Simulation of RDB queries using Perl

Relational databases are widely used. However, it is not very clear how queries written by SQL are executed by the DBMS. Queries are usually interpreted by DBMS but not compiled into native code. The reason why not compiled into machine code is that it is very important to optimize queries by looking at the properties of tables at run time for the query to be applied. However, in this article, to look at the execution mechanism of queries, I try to simulate them using Perl programs (i.e., “compiled code”).

Continue...

About December 2008

This page contains all entries posted to Small and Large Stones of Programming in December 2008. They are listed from oldest to newest.

October 2008 is the previous archive.

May 2012 is the next archive.

Many more can be found on the main index page or by looking through the archives.

Creative Commons License
This weblog is licensed under a Creative Commons License.
Powered by
Movable Type 3.36