You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Thomas Rebele <tr...@tibco.com.INVALID> on 2021/08/12 17:09:59 UTC
Visualization of Graphviz
Hello,
the dot graphs generated by the planner get quite confusing even for medium
sized plans. I've added line breaks in the labels with a script and
displayed it with the xdot tool, which makes it a bit better, but there is
still a lot of room for improvement. I've looked around for other tools
(Gephi, Cytoscape), but no tool fulfills the requirements:
- algorithm(s) to avoid overlap of nodes
- line breaks in node labels
- provide a way to visualize RelSubset
- allow to move nodes, hide them (this should update the visualization of
the subsets)
- search nodes by substrings of the label
- find and highlight paths between nodes
Closest was Cytoscape, but I couldn't find a way to visualize the subsets.
Do you have any recommendations? One possibility would be to implement it
with d3js.org, which would allow the integration of the tool in the Calcite
repository. Would there be interest in such a tool?
Cordialement / Best Regards,
*Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com
Re: Visualization of Graphviz
Posted by Julian Hyde <jh...@gmail.com>.
Thomas,
Would you mind reviewing that commit for inclusion in master? I have logged https://issues.apache.org/jira/browse/CALCITE-4737 <https://issues.apache.org/jira/browse/CALCITE-4737> to track.
Julian
> On Aug 13, 2021, at 2:03 AM, Thomas Rebele <tr...@tibco.com.INVALID> wrote:
>
> Thank you for pointing out the visualizer in the Tempura branch. It looks
> quite promising.
>
> Cordialement / Best Regards,
> *Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com
>
>
> On Thu, Aug 12, 2021 at 7:19 PM Julian Hyde <jh...@gmail.com> wrote:
>
>> I don’t have a strong opinion on this, but I want to point out that there
>> are some GraphViz improvements as part of Tempura (the case is
>> https://issues.apache.org/jira/browse/CALCITE-4568 <
>> https://issues.apache.org/jira/browse/CALCITE-4568>; the specific commit
>> is
>> https://github.com/hbtoo/calcite/commit/c1240ca7bd054830ebb3107c7509e09a998d4b55
>> <
>> https://github.com/hbtoo/calcite/commit/c1240ca7bd054830ebb3107c7509e09a998d4b55
>>> ).
>>
>>
>>
>>> On Aug 12, 2021, at 10:09 AM, Thomas Rebele <tr...@tibco.com.INVALID>
>> wrote:
>>>
>>> Hello,
>>>
>>> the dot graphs generated by the planner get quite confusing even for
>> medium
>>> sized plans. I've added line breaks in the labels with a script and
>>> displayed it with the xdot tool, which makes it a bit better, but there
>> is
>>> still a lot of room for improvement. I've looked around for other tools
>>> (Gephi, Cytoscape), but no tool fulfills the requirements:
>>>
>>> - algorithm(s) to avoid overlap of nodes
>>> - line breaks in node labels
>>> - provide a way to visualize RelSubset
>>> - allow to move nodes, hide them (this should update the visualization of
>>> the subsets)
>>> - search nodes by substrings of the label
>>> - find and highlight paths between nodes
>>>
>>> Closest was Cytoscape, but I couldn't find a way to visualize the
>> subsets.
>>> Do you have any recommendations? One possibility would be to implement it
>>> with d3js.org, which would allow the integration of the tool in the
>> Calcite
>>> repository. Would there be interest in such a tool?
>>>
>>> Cordialement / Best Regards,
>>> *Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com
>>
>>
Re: Visualization of Graphviz
Posted by Thomas Rebele <tr...@tibco.com.INVALID>.
Thank you for pointing out the visualizer in the Tempura branch. It looks
quite promising.
Cordialement / Best Regards,
*Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com
On Thu, Aug 12, 2021 at 7:19 PM Julian Hyde <jh...@gmail.com> wrote:
> I don’t have a strong opinion on this, but I want to point out that there
> are some GraphViz improvements as part of Tempura (the case is
> https://issues.apache.org/jira/browse/CALCITE-4568 <
> https://issues.apache.org/jira/browse/CALCITE-4568>; the specific commit
> is
> https://github.com/hbtoo/calcite/commit/c1240ca7bd054830ebb3107c7509e09a998d4b55
> <
> https://github.com/hbtoo/calcite/commit/c1240ca7bd054830ebb3107c7509e09a998d4b55
> >).
>
>
>
> > On Aug 12, 2021, at 10:09 AM, Thomas Rebele <tr...@tibco.com.INVALID>
> wrote:
> >
> > Hello,
> >
> > the dot graphs generated by the planner get quite confusing even for
> medium
> > sized plans. I've added line breaks in the labels with a script and
> > displayed it with the xdot tool, which makes it a bit better, but there
> is
> > still a lot of room for improvement. I've looked around for other tools
> > (Gephi, Cytoscape), but no tool fulfills the requirements:
> >
> > - algorithm(s) to avoid overlap of nodes
> > - line breaks in node labels
> > - provide a way to visualize RelSubset
> > - allow to move nodes, hide them (this should update the visualization of
> > the subsets)
> > - search nodes by substrings of the label
> > - find and highlight paths between nodes
> >
> > Closest was Cytoscape, but I couldn't find a way to visualize the
> subsets.
> > Do you have any recommendations? One possibility would be to implement it
> > with d3js.org, which would allow the integration of the tool in the
> Calcite
> > repository. Would there be interest in such a tool?
> >
> > Cordialement / Best Regards,
> > *Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com
>
>
Re: Visualization of Graphviz
Posted by Julian Hyde <jh...@gmail.com>.
I don’t have a strong opinion on this, but I want to point out that there are some GraphViz improvements as part of Tempura (the case is https://issues.apache.org/jira/browse/CALCITE-4568 <https://issues.apache.org/jira/browse/CALCITE-4568>; the specific commit is https://github.com/hbtoo/calcite/commit/c1240ca7bd054830ebb3107c7509e09a998d4b55 <https://github.com/hbtoo/calcite/commit/c1240ca7bd054830ebb3107c7509e09a998d4b55>).
> On Aug 12, 2021, at 10:09 AM, Thomas Rebele <tr...@tibco.com.INVALID> wrote:
>
> Hello,
>
> the dot graphs generated by the planner get quite confusing even for medium
> sized plans. I've added line breaks in the labels with a script and
> displayed it with the xdot tool, which makes it a bit better, but there is
> still a lot of room for improvement. I've looked around for other tools
> (Gephi, Cytoscape), but no tool fulfills the requirements:
>
> - algorithm(s) to avoid overlap of nodes
> - line breaks in node labels
> - provide a way to visualize RelSubset
> - allow to move nodes, hide them (this should update the visualization of
> the subsets)
> - search nodes by substrings of the label
> - find and highlight paths between nodes
>
> Closest was Cytoscape, but I couldn't find a way to visualize the subsets.
> Do you have any recommendations? One possibility would be to implement it
> with d3js.org, which would allow the integration of the tool in the Calcite
> repository. Would there be interest in such a tool?
>
> Cordialement / Best Regards,
> *Thomas Rebele, PhD* | R&D Developer | Germany | www.tibco.com