Derby
  1. Derby
  2. DERBY-4587

Add tools for improved analysis and understanding of query plans and execution statistics

    Details

      Description

      I think it would be great to see some work in the area of tools for helping
      with the analysis of complex query execution. Quite frequently, users of
      Derby have trouble comprehending (a) how their query is being translated
      into a query plan by the optimizer, and (b) what the execution-time resource
      usage of the various parts of the query is.

      There are low-level features in Derby which capture this information and
      record it, such as logQueryPlan, and the XPLAIN tables, but there is a lot
      of opportunity for designing higher-level tools which can process the query
      plan and execution statistics information and present it in a more
      comprehensible fashion.

      1. PostgreSQL license.jpg
        142 kB
        Nirmal Fernando
      2. Read_Me.txt
        1 kB
        Nirmal Fernando
      3. Source.rar
        5 kB
        Nirmal Fernando
      4. Derby_Query_Plan_Screen_Shot.jpg
        20 kB
        Nirmal Fernando
      5. Derby Query Plan Screen Shot 2.jpg
        117 kB
        Nirmal Fernando
      6. DERBY-4587-tool.diff
        9 kB
        Nirmal Fernando
      7. DERBY-4587-tool-2.diff
        9 kB
        Nirmal Fernando
      8. DERBY-4587-tool-3.diff
        9 kB
        Nirmal Fernando
      9. DERBY-4587-tool-4.diff
        16 kB
        Nirmal Fernando
      10. screenshot-1.jpg
        165 kB
        Nirmal Fernando
      11. screenshot-2.jpg
        149 kB
        Nirmal Fernando
      12. test4.xsl
        3 kB
        Nirmal Fernando
      13. test.xml
        1 kB
        Nirmal Fernando
      14. screenshot-3.jpg
        149 kB
        Nirmal Fernando
      15. DERBY-4587-tool-5.diff
        17 kB
        Nirmal Fernando
      16. Simple HTML View (Pure XSL).jpg
        91 kB
        Nirmal Fernando
      17. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      18. xml_doc_screenshot.jpg
        111 kB
        Nirmal Fernando
      19. DERBY-4587-tool-6.diff
        17 kB
        Nirmal Fernando
      20. DERBY-4587-tool-test1.diff
        3 kB
        Nirmal Fernando
      21. basic_html-2.jpg
        75 kB
        Nirmal Fernando
      22. DERBY-4587-tool-7.diff
        18 kB
        Nirmal Fernando
      23. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      24. basic_html-2.2.jpg
        90 kB
        Nirmal Fernando
      25. basic_html-3.jpg
        93 kB
        Nirmal Fernando
      26. DERBY-4587-tool-7-b.diff
        19 kB
        Nirmal Fernando
      27. DERBY-4587-tool-test2.diff
        3 kB
        Nirmal Fernando
      28. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      29. basic_html-2.3.jpg
        73 kB
        Nirmal Fernando
      30. basic_html-4.1.jpg
        81 kB
        Nirmal Fernando
      31. basic_html-4.2.jpg
        74 kB
        Nirmal Fernando
      32. DERBY-4587-tool-8.diff
        25 kB
        Nirmal Fernando
      33. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      34. xml_doc_screenshot.jpg
        118 kB
        Nirmal Fernando
      35. DERBY-4587-tool-9.diff
        73 kB
        Nirmal Fernando
      36. DERBY-4587-tool-9.1.diff
        72 kB
        Nirmal Fernando
      37. DERBY-4587-tool-9.2.diff
        72 kB
        Nirmal Fernando
      38. DERBY-4587-tool-9.3.diff
        78 kB
        Nirmal Fernando
      39. DERBY-4587-tool-9.4.diff
        82 kB
        Nirmal Fernando
      40. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      41. derby-logo.png
        4 kB
        Nirmal Fernando
      42. DERBY-4587-tool-9.5.diff
        67 kB
        Nirmal Fernando
      43. DERBY-4587-tool-9.6.diff
        68 kB
        Nirmal Fernando
      44. advancedXSL-1.jpg
        65 kB
        Nirmal Fernando
      45. advancedXSL-2.jpg
        118 kB
        Nirmal Fernando
      46. advancedXSL-3.jpg
        138 kB
        Nirmal Fernando
      47. advancedViewXSL.xsl
        4 kB
        Nirmal Fernando
      48. AdavancedXSL-mouseover.jpg
        86 kB
        Nirmal Fernando
      49. advancedViewXSL.xsl
        4 kB
        Nirmal Fernando
      50. advancedViewXSL2.xsl
        4 kB
        Nirmal Fernando
      51. DERBY-4587-tool-9.7.diff
        81 kB
        Nirmal Fernando
      52. DERBY-4587-tool-9.7.diff
        82 kB
        Nirmal Fernando
      53. DERBY-4587-javadoc_fix.diff
        0.3 kB
        Nirmal Fernando
      54. DERBY-4587-tool-9.8.diff
        34 kB
        Nirmal Fernando
      55. DERBY-4587-tool-9.8-modified.diff
        33 kB
        Kristian Waagan
      56. DERBY-4587-tool-9.9-formatting.diff
        84 kB
        Kristian Waagan
      57. DERBY-4587-tool-9.10-eol_style_native.diff
        2 kB
        Kristian Waagan
      58. DERBY-4587-tool-9.11-license_header_inXSL.diff
        3 kB
        Nirmal Fernando
      59. DERBY-4587-tool-9.12.diff
        4 kB
        Nirmal Fernando
      60. DERBY-4587-tool-9.12.diff
        4 kB
        Nirmal Fernando
      61. DERBY-4587-tool-9.12.diff
        16 kB
        Nirmal Fernando

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Nirmal Fernando
              Reporter:
              Bryan Pendleton
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development