ගූගල් සමර් ඔෆ් කෝඩ් -2010 ඉවරායී....

අගෝස්තු 20 වෙනිදා "ගූගල් සමර් ඔෆ් කෝඩ් -2010" වැඩ නිල වශයෙන් අවසන් කලා :),එ අවසන් ප්‍රතිඵල නිකුත් වීමත් සමගයි. ගූගල් නිල වශයෙන් ප්‍රතිඵල 23 වෙනිදා දැනුම් දීමට නියමිතයි. මගේ ප‍්රජෙක්ට් එක වූනේ Apache Derby වලට අලුත් ටූල් එකක් හදන්නයි. Derby කියන්නේ සරලව කිව්වොත් දත්ත ගබඩා කරන්න සහ අවශ්ය දත්ත ලබාගන්න උදව්වෙන FOSS software එකක්, ඉන්ග්‍රිසියෙන් කිව්වොත් Relational Database Management System (RDBMS) එකක්.

මගේ ටූල් එක ගැන කිව්වොත් එය Derby යූසර්ස්ලට තමා execute කරපු query එකක් execute වෙන අවස්ථාවෙදී Derby අනුගමනය කරපු පියවරවල් tree අකෘතියක් ලෙස බලා ගන්න හැකියාව සලසනවා. Tree අකෘතියේ තියෙන හැම node එකක් ගැනම තෝරා ගත් විස්තර සමූහයක් අන්තර්ගතයි. මෙමගින් Derby යූසර්ස්ලට තමා execute කරපු query එකේ performance බලාගන්න පුලුවන් වීම නිසා, performance අඩුයි වගේ පෙනෙනවානම් එ query එක වෙන විදියකට ලියන්න උනන්දු කරවනවා. මෙම අලුත් ටූල් එක Derby මීළග release එකට එ කියන්නේ 10.7 වලට අන්තර්ගත කරන්න ඉන්නෙ. ටූල් එකේ එක interface එකක් මෙතනින් බලන්න පූලූවන්.

මගේ ප‍්රජෙක්ට් මෙන්ට වුනේ Bryan Pendleton. Bryan ගෙ උදවූ මට ගොඩාක් උපකාරී වුනා ප‍්රජෙක්ට් එක වෙලාවටත් ඉස්සෙල්ලා ඉවර කරන්න, මට කියන්න බරිවුනානේ ප‍්රජෙක්ට් එක මම වෙලාවටත් ඉස්සෙල්ලා ඉවර කලා (අගෝස්තු 4) (මෙන්ට බලාපොරොත්තු වුන විදියට), ඊට පස්සෙ community එකෙන් පොඩි පොඩි අදහස් මතු වුනා. එ අදහස් වලට ගරැ කරමින් මට අගෝස්තු 16 ට ඉස්සෙල්ලා කල හැකි දේවල් මම කලා, community එක එකග වුනා අනිත් අදහස් ඉදිරියේදී කරන්න, තව සාකච්චා වලින් පස්සෙ. මෙහෙම තමා FOSS ප‍්රජෙක්ට් එකක් ඉදිරියටම යන්නේ.:)

Community එකේ හැමෝම මට ගොඩාක් උදවු කලා Derby එක්ක familiar වෙන්න. හැමෝටම ගොඩාක් Thanks! ගොඩාක් අය මට සුබ පැතුවා, එ අයටත් Thanks! මේ මගේ පළමු සිංහල බ්ලොග් පෝස්ට් එකයි.:)

ස්තූතියි!

My Work at Google Summer of Code -2010

As I am reaching the end of successful summer, with Apache Derby and Google, I like to share with you a prototype that I've done using the tool, PlanExporter, which I've developed to Apache Derby.

You can visit this page to see the prototype.

This tool provides a high level view of the execution plans of complex queries you have executed. You can see the steps followed by the "Query Optimizer" of Derby, in order to execute the particular query. In this case Optimizer had followed a query plan with four "plan nodes", namely PROJECTION, HASH JOIN, TABLE SCAN and HASH SCAN. Intermediate results flow from the bottom of the tree to the top. In this case the filtered results of TABLE SCAN and HASH SCAN was given as the input for HASH JOIN. After performing the HASH JOIN the filtered result set given as a input to the PROJECTION node.

You can move the mouse point over an any node of the query plan to view set of available details about the execution at that step.

It is just the output that shown there. To convert to this output I had done lot of coding :).

Thanks for reading!

Mid term evaluations of GSoC-2010

It's being a while from my last post, but can't help, I hardly got time to write a post :(.

I had my mid term evaluations of GSoC-2010 in mid July, and I received my results on 17th of July at 01:12 AM through a SPAM mail :D.

Here it is:

Hi Nirmal Fernando,

We have processed the evaluation for your project named Apache Derby-4587- Add tools for improved analysis and understanding of query plans and execution statistics with Apache Software Foundation.

Congratulations, from our data it seems that you have successfully passed the Midterm Evaluations. Please contact your mentor to discuss the results of your evaluation and to plan your goals and development plan for the rest of the program

Greetings,

The Google Open Source Programs Team

This was another thrilling moment to me :). After the evaluation day, I saw following on Derby-dev mailing list, sent by my mentor Bryan.

"I think that the core mission of PlanExporter is to enable the export

of query plan data in a complete and well-structured XML document, with

a documented schema, tested by our test suite.

I think that Nirmal's current patch in DERBY-4587 is extremely close

to meeting that goal. ..."

This boosted me up !! :)

Here's a basic vanilla HTML, that shows a small portion of what I'm doing in Derby.

I have lot of things to post and I'm waiting till I finish my training on 30th of July.

See you soon with a post !

Google Summer of Code- 2010 - A Moment of thrill

Finally the 26th of April came after waiting for sometime. The nervousness was maximum. Google planned to announce the names of the students who are accepted by UTC 19:00 (00:30 on April 27th from SL time(GMT +5:30)).

It was exactly 00:16, I saw a tiny window appearing at the right bottom of my screen, subjected "Congratulations !!", I murmured "Oh My God !! (with full of excitement)" and rushed to my gmail tab. Yeppy, I was thrilled with happy, after seen the mail (I have no words to express my feelings) from GSoC Admin team. Here I quote from that mail:

Dear Nirmal,

Congratulations! Your proposal "Apache Derby-4587- Add tools for improved analysis and understanding of query plans and execution statistics" as submitted to "Apache Software Foundation" has been accepted for Google Summer of Code 2010. ...........

The happy I got doubled after seen many of my colleagues also got through it. At about 00:30 I refreshed the GSoC web site and got confirmed my acceptance after seen the list of accepted students.

Following are the statistics:

CSE-Batch-07: 12 students
CSE-Batch-06: 10 students
____________________
CSE : 22 students

ENTC-Batch-07: 1 student

IT Faculty: 3 (not confirmed)

You can find my proposal to Apache Derby from here.
Here are some comments I received for my proposal.

Your proposal looks very good to me, thanks for letting me preview it. I think it is well written and clear.

bryan

--------------------------------------------------------
Nirmal,

I do not have any specific technical input, but wanted to say that I think this is a very good and thoughtful proposal and appreciate your efforts to provide this capability for Derby. I also think your interaction with the community has been very focussed, relevant and and shows good technical understanding.

Kathey

Few days before this day (26th of April), I was asked to submit my ICLA to The ASF, normally only major contributors get this chance to become an Apache committer, this implied some things to happen in the future, but I didn't take it that seriously.

This is the mail I received from my mentor as a reply to my thanking mail to him.

Congratulations! I am pleased. Several other members of the community voted positively on your application, as they felt that you had been working well in the community this spring.

I hope that you will have a productive and rewarding experience, and I'm looking forward to helping you with the project over the summer!

bryan

First and foremost I would like to thank Almighty God for bestowing his eternal blessings on me. Next to my mentor for this project Mr. Bryan Pendleton for the enormous support he gave me throughout this period, and I hope to get his help for a successful completion of the project. It's my duty to thank the Derby community, for the helpfulness and commitment they showed, it's a privilege to be a member of this wonderful community. Sincere thanks to the Head of Department, and the dearest staff members for guiding us to reach the success. To my dear colleagues who encouraged me a lot. Last but not least I would like to thank my family for the remarkable support they gave to me.

My GSoC-2010 Proposal

GSoC-2010-ProposalByNirmalFernando -