Sunday, August 22, 2010

ගූගල් සමර් ඔෆ් කෝඩ් -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! මේ මගේ පළමු සිංහල බ්ලොග් පෝස්ට් එකයි.:)

ස්තූතියි!

Saturday, August 7, 2010

My Second Project at IFS as an Intern

It was a requirement of the training division itself, and an idea of Nalin, my training manager. He wanted me to write a C# GUI application, which will automate a hectic, tedious manual process. They already have a pretty old GUI, which is capable of doing 2/3 of work that the new tool should cover. But the problem with that is they need to follow a process which is sequentially ordered and they have to closely watch till one step over to proceed with the other step. So a successful solution will save lot of money and effort.


I was not familiar with any of scripting languages before start up of the project. The most challenging task was to find a scripting language which can be used to automate a Windows GUI. After searching in the Internet I found a scripting language called AutoIt (AutoIt), which is capable of automating Windows GUIs, and also very easy to learn type of language. After went through some tutorials on AutoIt, I started writing small scripts, which are basically will automate a simple installation process. Next I got familiar with the tool that is currently used at IFS. After designing a process view I implemented the needed functionality.



GUI is a most important part of an application, which I haven’t done enough thinking into. But Nalin gave me wonderful ideas and best practices of designing a GUI, which I think will help me in my future work as well. GUI has created using C# programming language, such that it takes the minimum possible inputs from a user.
·         GUI consists with four steps.
·         Easy to use, user friendly design.
·         User will be guided through steps, minimized the number of scary messages.
Following our the screen shots of the GUI.





Thursday, August 5, 2010

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!

Friday, July 30, 2010

Last day as an intern at IFS

It's 30th of July, 2010, the last day of another remarkable journey of my life at IFS R&D Internationals as an intern. A day with full of emotions. Really happy after seen following at the back end of my diary, from my training manager Mr. Nalin Sugathapala:


Thank you Nalin, for all the wonderful comments on me.

Following our the few of many mails I received today(30th):

HI Nirmal,

I saw the Linked in request. Give me a bit of time on that pls, will send a recommendation, but want to make sure that it reads well :D Best of luck with all that you do in the future and do let me know if there is anything that I or my chaps can do for you.

Cheers,
nalin (Training Manager)

Wish you all the best Nirmal. And thanks for the letter. :)))
You are such a brilliant and well motivated guy. Actually you motivated me as well. :D :D :D  
Keep up your good work.
Hope you will join with us soon. : )
Again wish you all the very best.

TC and KIT
Subhashini. (Senior SE)

We also felt that sad my friend. Really. Be the best u can be. Bcoz u r a really talented one. Also not to forget keep Ur good personal qualities forever. I’m sure u will. J Wish u all the best dr Nirmal ,from bottom of my heart.
-Ruwani (UCSC)

Hi Nirmal,
     The six months went really fast. It feels like a few days back when I showed you  guys around IFS. It is good to hear that you found your time spent at IFS useful. You can feel free to ask any help from me at any time. I will do my best to help you out.  Thank you very much for the hint on f12 I didn’t know that.
I will definitely add that next time when I do a training. Thank you once again for the hard work you put in and I wish you the very best in your future endeavors.

   Please do keep in touch.   

Kind regards,
    Roger (Senior SE, training dept.)

Hi Nirmal,

It was a pleasure working with you and I hope that we will meet again. Wish you all the very best in your future endeavors.

Keep in touch.

Regards,
Chanaka (Team lead- Senior SE)



Hey nirmal,
Indeed you were a very good friend..you made the environment comfortable for us when we were feeling quite alienated when we came here. We got to know others through you. So indeed it’s sad to see you guys leave today after the bond we have made during the last 3 months. But no matter what happens ,life has to go on. You have great talent mate. im more than sure you can reach limits beyond the sky.So keep it up..work well, and I hope all of you end up in a great place in this time space continuum. Indeed we’ll meet up again..no worries..we can keep in touch.
All the very best bro!!
Miraj  (Uni of Pera)

Dear Friend,
It’s hard even to think that we are missing you, anyway thanks a lot for being such a good friend for us.
WE will remember you with each and every line of code we do in C#. Actually it was the most enjoyable training I ever had in my life. We saw you NOT as a boss BUT as an innocent friend who is trying to help us to settle here.

As you are interested in higher studies, I wish you all the best for them. I surely know that you have more than enough potential to do  significant things for our field….

Sorry If anything wrong is done by words, actions and even thoughts of mine.

I wish to see your innocent smile in the near future……… J

Thank you very much
CHINTHAKA (Uni of Pera)


Hi Nirmal,

It is so sad that u guys are leaving us today… But we really enjoyed the time that  we spent with u.
You are the first friend that we  met @ IFS…You did a wonderful  C# training for us.
 It was  very useful to us  because these days we are working with it.
 Thanks  to everything….

And I wish all the best  to your future.. and also for the Gsoc 2010..
Though you are leaving us today, One day in near future we will definitely
Meet…..I  am sure..
HAVE  A NICE  LIFE……….

Regards,
Dananjaya. (Uni of Pera)

We are pleased to have you with us and also impressed with the work you did and the talent you showed.
In my humble opinion you should plan to do the higher studies now onwards and become good inventor one day.
Doors are always open for you. So do not hesitate to contact us at any time if you need any help from us.

Good luck and all the best for your future endeavors.

Regards,

/Ruchitha. (Senior SE, training dept.)





Thank you very much everyone for wonderful comments and well wishers, really happy to be with such a bunch of people :))).

I have a lot to post regarding my training period, hope to post them soon!!

Saturday, July 24, 2010

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 !

Monday, June 14, 2010

Why not create a PDF of your own?

My first project at IFS was about applying PDF/A standards to IFS reports. This project involved a conversion of PDF version. For that I needed a some kind of Java library which will provide me a set of functionality to perform a conversion.

While searching for few hours I found this wonderful Java library called iText. It has both Java and C# .NET versions.

You can use iText to:
  • Serve PDF to a browser
  • Generate dynamic documents from XML files or databases
  • Use PDF's many interactive features
  • Add bookmarks, page numbers, watermarks, etc.
  • Split, concatenate, and manipulate PDF pages
  • Automate filling out of PDF forms
  • Add digital signatures to a PDF file
  • and much more...

You can download iText binaries and source files from here.
 iText API from here.
An excellent tutorial on iText can be founded in here.

Create a small PDF file and enjoy seen it's working, if you like to do more work using this that would make my effort even more success.

Introduction to PDF/A Standards

Most of you may not familiar with PDF/A standards, neither me, before four months. So I decided to make a post on this to share what I know about PDF/A.

What is PDF/A?
I am sure at least some of you might got into some troubles if you tried to open PDF documents which are in different fonts,and if matching fonts not installed in your computer.This is because that PDF file does not contain embedded fonts. You can embed fonts that are used in the file at the moment of the creation of the file.
Not only fonts but the colour profiles used, and etc.
PDF/A standards ensure the documents can be reproduced in the exact same way, at any place and even after a long time. Current version is PDF/A-1.

DOs and DONT'S in PDF/A-1

PDF/A-1 files must include:
• Embedded fonts
• Device-independent color
• XMP metadata

PDF/A-1 files may not include:
• Encryption
• LZW Compression
• Embedded files
• External content references
• PDF Transparency
• Multi-media
• JavaScript



Levels of Standards
1.       PDF/A-1a: All the requirements of PDF/A-1b + additionally requires that document structure be included being "tagged
2.       PDF/A-1b: ensuring reliable reproduction of the visual appearance of the document



Reference: 
PDF/A FAQ 



I hope to put a post on PDF creation, as soon as I got some time. These days I'm busy with my work at IFS and GSoC.