Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of nirmal070125@gmail.com
 designates 209.85.221.181 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=uBZQgJW5xdm8E5FkEn1V+wBLg9+q32oV4DT3U3G5hJfhUMI9dltPHtv+8c7LGlz323
         2yTACAoEuCO2+yFJXsRqr89/vd8vkYnbYTwdEaCCw72Nj+hao4ypZIquxP+z+qXHNXQ9
         h2730iRwmkM8p6SQGaU/aI60esv0B4xZ8ILmI=
MIME-Version: 1.0
Date: Tue, 25 May 2010 08:45:31 +0530
Message-ID: <AANLkTik6iZdLQbgpY4ebZrO0BiOKPZTbKQeU-w0YsPJQ@mail.gmail.com>
Subject: Most appropriate place to locate the new Visualizer tool
From: Nirmal Fernando <nirmal070125@gmail.com>
To: derby-dev@db.apache.org
Content-Type: text/plain; charset=ISO-8859-1

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
(https://issues.apache.org/jira/browse/DERBY-4587)

Description:

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
http://wiki.apache.org/db-derby/Nirmal/Derby-4587-%20Design%20Details

Your suggestions are highly appreciated.

Thank you very much.


-- 
Best Regards,
Nirmal

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