[ Top page ]

« June 2008 | Main | January 2009 »

December 2008 Archives

December 29, 2008

Information, Computation and Programming:Database and Stream processing

Relational databases are widely used. However, it is not very clear how queries written by SQL are executed by the DBMS. Don't you think we can understand the execution mechanism better by simulating the query execution using a procedural language?

I tried to translate some SQL queries into Perl programs. Although there are many methods to implement a join operation, I tried only one. However, I could implement an optimized join within 20 lines of Perl code, and I recognized the power of Perl again.


About December 2008

This page contains all entries posted to Blog from Kanada in December 2008. They are listed from oldest to newest.

June 2008 is the previous archive.

January 2009 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