Hi, I have gone through some resources regarding visualization of trace info on database servers (Postgres/MySQL, MSSQL).
- The DTrace function in MySQL is a profiler that creates flame graphs. [1] - A tool for visualizations of a database system [2] - Generates images with help of GraphViz for - Some data modeling tools [4] - DBVisualizer Tool [5] - Data Visualization Application where data is input from a database or a file and exported as image or a customized template [6] - Visualizing Postgres [7] - A Research Paper on Modeling Trace Information[8] - A Tool for visualizing Trace Info Given above is a brief summary of the details I found. Hope it would help me to better understand the formats and values of the input traces and different available methods of graphically representing them. Based on them I hope to come up with the most suitable method of Visually representing the said data. Thank you. BR, Nishani [1] http://www.brendangregg.com/FlameGraphs/cpuflamegraphs.html [2] http://docs.cartodb.com/cartodb-editor.html#visualizations [3] https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/SchemaDisplay [4] http://www.databaseanswers.org/modelling_tools.htm [5] http://www.dbvis.com/ [6] https://sites.google.com/site/datavisualizationapplication/ [7] http://www.pgcon.org/2013/schedule/track/Performance/588.en.html [8] http://link.springer.com/chapter/10.1007%2F978-3-642-40787-1_13 [9] http://www.upscene.com/documentation/fbtm3/index.html?qsg_trace_data_visualization.htm On Sun, Mar 15, 2015 at 2:32 PM, Nishani (JIRA) <j...@apache.org> wrote: > > [ > https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14362302#comment-14362302 > ] > > Nishani commented on PHOENIX-1118: > ----------------------------------- > > Hi, > > I have started a new thread on developer mailing list of Apache Phoenix > regarding this issue[1]. Please note the steps I'm currently following. I'm > communicating with the Community and all of your feedback is highly > appreciated. > > Am I on the correct path as per [1]? Any suggestions for writing a better > proposal? > > Thank you. > Best Regards, > Nishani > > [1] Subject : Provide a tool for visualizing Phoenix tracing information > (PHOENIX-1118) > > http://mail-archives.apache.org/mod_mbox/phoenix-dev/201503.mbox/%3CCAGsXwjMKL6kNamCuXUt3dmshHgSKjYXfbVtqmL8FGR7hEQ5zaQ%40mail.gmail.com%3E > > > > Provide a tool for visualizing Phoenix tracing information > > ---------------------------------------------------------- > > > > Key: PHOENIX-1118 > > URL: https://issues.apache.org/jira/browse/PHOENIX-1118 > > Project: Phoenix > > Issue Type: Sub-task > > Reporter: James Taylor > > Assignee: Nishani > > Labels: Java, SQL, Visualization, gsoc2015, mentor > > > > Currently there's no means of visualizing the trace information provided > by Phoenix. We should provide some simple charting over our metrics tables. > Take a look at the following JIRA for sample queries: > https://issues.apache.org/jira/browse/PHOENIX-1115?focusedCommentId=14323151&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14323151 > > > > -- > This message was sent by Atlassian JIRA > (v6.3.4#6332) > -- Best Regards, Ayola Jayamaha
