[ Top page ]

Main

Database and Stream processing Archives

January 1, 0001

This category and this category in the Japanese version of my blog contains topics on database and stream data processing. The upper category is Information, Computation and Programming.

BTW, as shown on the top of the category page, the submission date of this page is intentionally set 0001-01-01 00:00:00. However, the actual submission date is 2009-01-18 18:02:19.

December 29, 2008

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.

Continue...

Categories

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