[Savannah-register-public] [task #4766] Submission of sqlKensho

[Walter Weinmann]

URL:
  <http://savannah.gnu.org/task/?func=detailitem&item_id=4766>

                 Summary: Submission of sqlKensho
                 Project: Savannah Administration
            Submitted by: weinmann
            Submitted on: Di 11.10.2005 um 07:08
         Should Start On: Di 11.10.2005 um 00:00
   Should be Finished on: Fr 21.10.2005 um 00:00
                Category: Project Approval
                Priority: 5 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
        Percent Complete: 0%
             Open/Closed: Open
                  Effort: 0.00

    _______________________________________________________

Details:

A new project has been registered at Savannah 
The project account will remain inactive until a site admin approve or
discard the registration.


######### REGISTRATION ADMINISTRATION #########

While this item will be useful to track the registration process, approving
or discarding the registration must be done using the specific "Group
Administration" page, accessible only to site administrators, effectively
logged as site administrators (superuser):

  <https://savannah.gnu.org/admin/groupedit.php?group_id=8040>


######### REGISTRATION DETAILS ######### 

Full Name:
----------
  sqlKensho

System Group Name:
-----------------
  sqlkensho

Type:
-----
  non-GNU software &amp; documentation

License:
-------- 
  GNU General Public License V2 or later

Description:
------------
  Student who learn SQL often have only pencil and paper or hand-recoding to
show them what is taking place when complex statements are evaluated. A
development aid which takes a complex query and restructures the code to show
intermediate results and the effect of subquery or partial execution can act
as a diagnostic and teaching support tool. (For example by showing the
intermediate tables that result during the execution of the SQL according to
the logical model taught in the OU courses M876/M358)

The transformation of SQL (and relational representations of SQL queries) is
an essential part of the automatic optimsation used in every SQL DBMS. There
are well known transformational rules that can translate between semantically
equivalent statements that have different execution costs. This research is
not focussed on the execution costs - but on the transformation aspects that
would show how a complex query is evaluated under the logical execution model
- so that the effect of different sub-statements and their interaction in a
complex query could be seen. It is not expected that you would need to
translate the SQL into relational algbra expressions for this, but being able
to see how this is achieved for query optimisation would give some insights.


Other Software Required:
------------------------
  The tool will be develped as an Eclipse plugin.

Other Comments:
---------------
  I'll develop the tool described above as a part of my dissertation in
Software Development at the Open University (UK).








    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/task/?func=detailitem&item_id=4766>

_______________________________________________
  Nachricht geschickt von/durch Savannah
  http://savannah.gnu.org/