db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nirmal Fernando <nirmal070...@gmail.com>
Subject Most appropriate place to locate the new Visualizer tool
Date Tue, 25 May 2010 03:15:31 GMT
Hi All,

I need your help to find out the most appropriate place (in the Derby
folder structure) to locate the new tool, that will be developed in
this summer as the GSoC project of mine.

The Visualizer tool: Derby-4587


Quite frequently, users of Derby have troubles in comprehending the
steps followed by the optimizer when it translates a query into a
query plan, and details such as time to execute, resource utilization
at each step of the query plan. There are low-level features in Derby
which capture this information and record it, such as logQueryPlan,
and the XPLAIN tables, so this project will lead to a development of a
new tool which can process the query plan and execution statistics
information and present it in a more comprehensible fashion i.e. a
graphical interpretation of the query plan.

You can find information about the design at

Your suggestions are highly appreciated.

Thank you very much.

Best Regards,

C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.

View raw message