Perfopticon: Visual Query Analysis for Distributed Databases

Computer Graphics Forum

Volumn 34, Issue 3, 2015, Pages 71-80

  Moritz, Dominik ^a   Halperin, Daniel ^a   Howe, Bill ^a   Heer, Jeffrey ^a  

^a UNIVERSITY OF WASHINGTON   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPLEX NETWORKS; DATABASE SYSTEMS; HUMAN COMPUTER INTERACTION; QUERY LANGUAGES; QUERY PROCESSING; VISUALIZATION;

DISTRIBUTED DATABASE; INTERACTIVE QUERIES; INTERACTIVE VISUALIZATIONS; NETWORK CONGESTIONS; PERFORMANCE BOTTLENECKS; PERFORMANCE DEBUGGING; PERFORMANCE ISSUES; SYSTEM COMPLEXITY;

DISTRIBUTED DATABASE SYSTEMS;

EID: 84937845113     PISSN: 01677055     EISSN: 14678659     Source Type: Journal    
DOI: 10.1111/cgf.12619     Document Type: Article

References (37)

1. Avin C., Brito C.,: Efficient and robust query processing in dynamic environments using random walk techniques. In Proceedings of the 3rd international symposium on Information processing in sensor networks (2004). 1
2. Bostock M., Ogievetsky V., Heer J.,: D3: Data-driven documents. Proc. IEEE InfoVis (2011). 7
3. Brewer C.A.,: Color use guidelines for data representation. In Journal of the ASA (1999). 3, 6
4. Byron L., Wattenberg M.,: Stacked graphs-geometry & aesthetics. IEEE TVCG 14, 6 (2008). 5
5. Chu S., Balazinska M., Suciu D.,: From theory to practice: Efficient join query evaluation in a parallel database system. In Proc. ACM SIGMOD (2015). 9
6. Cleveland W.S., McGill R.,: Graphical perception: Theory, experimentation, and application to the development of graphical methods. Journal of the ASA 79, 387 (1984). 3, 6
7. Card S.K., Mackinlay J.D., Shneiderman B.,: Readings in information visualization: using vision to think. Morgan Kaufmann, 1999. 6
8. DeWitt D., Gray J.,: Parallel database systems: the future of high performance database systems. Communications of the ACM 35, 6 (1992). 4
9. Di Giacomo E., Didimo W., Grilli L., Liotta G.,: Graph visualization techniques for web clustering engines. IEEE TVCG 13, 2 (2007). 9
10. Ellson J., Gansner E., Koutsofios L., North S.C., Woodhull G.,: Graphviz-open source graph drawing tools. In Graph Drawing (2002), Springer. 7
11. Engle C., Lupher A., Xin R., Zaharia M., Franklin M.J., Shenker S., Stoica I.,: Shark: fast data analysis using coarse-grained distributed memory. In Proc. ACM SIGMOD (2012). 2
12. Funika W., Zientarski M., Badia R.M., Labarta J., Bubak M.,: Performance visualization of grid applications based on ocm-g and paraver. In Grid Computing (2008), Springer. 2
13. Graham S.L., Kessler P.B., Mckusick M.K.,: Gprof: A call graph execution profiler. In ACM Sigplan Notices (1982), vol. 17, ACM. 2
14. Google: Performance profiling with the timeline. https://developer.chrome.com/devtools/docs/timeline. 2
15. Haritsa J.R.,: The picasso database query optimizer visualizer. Proc. VLDB 3 (2010). 4
16. Halperin D., de Almeida V.T., Choo L.L., Chu S., Koutris P., Moritz D., Ortiz J., Ruamviboonsuk V., Wang J., Whitaker A., et al.,: Demonstration of the Myria Big Data Management Service. 2
17. Heath M.T., Finger J.E.,: Paragraph: A performance visualization tool for MPI, 2003. 2
18. Hausenblas M., Nadeau J.,: Apache drill: interactive ad-hoc analysis at scale. Big Data 1, 2 (2013). 2
19. HP: Vertica. http://www.vertica.com/. 2
20. Heer J., Robertson G.G.,: Animated transitions in statistical data graphics. IEEE TVCG 13, 6 (2007). 3, 5
21. Isaacs K., Bremer P., Jusufi I., Gamblin T., Bhatele A., Schulz M., Hamann B.,: Combing the communication hairball: Visualizing large-scale parallel execution traces using logical time. 3
22. Javed W., McDonnel B., Elmqvist N.,: Graphical perception of multiple time series. IEEE TVCG 16, 6 (2010). 3, 5
23. Krzywinski M., Schein J., Birol İ., Connors J., Gascoyne R., Horsman D., Jones S.J., Marra M.A.,: Circos: an information aesthetic for comparative genomics. Genome research 19, 9 (2009). 6
24. Liu Z., Heer J.,: The effects of interactive latency on exploratory visual analysis. IEEE TVCG (2014). 5
25. Liu Z., Jiang B., Heer J.,: imMens: Real-time visual querying of big data. In Computer Graphics Forum (2013), vol. 32, Wiley Online Library. 6
26. Microsoft: Displaying Graphical Execution Plans (SQL Server Management Studio). http://technet.microsoft.com/en-us/library/ms178071(v=sql.105).aspx. 2
27. MacKenzie I.S., Ware C.,: Lag as a determinant of human performance in interactive systems. In Proc. INTERACT'93 and CHI'93 (1993), ACM. 5
28. Nagel W.E., Arnold A., Weber M., Hoppe H.-C., Solchenbach K.,: VAMPIR: Visualization and analysis of MPI resources. 2
29. Reddy N., Haritsa J.R.,: Analyzing plan diagrams of database query optimizers. In Proc. VLDB (2005). 1, 4
30. Sigelman B.H., Barroso L.A., Burrows M., Stephenson P., Plakal M., Beaver D., Jaspan S., Shanbhag C.,: Dapper, a Large-Scale Distributed Systems Tracing Infrastructure. Tech. rep., Google, Inc., 2010. URL: http://research.google.com/archive/papers/dapper-2010-1.pdf. 2
31. Shneiderman B.,: The eyes have it: A task by data type taxonomy for information visualizations. In Proc. IEEE Visual Languages (1996). 2
32. Stonebraker M.,: The case for shared nothing. IEEE Database Eng. Bull. 9, 1 (1986). 2, 3
33. Simitsis A., Wilkinson K., Blais J., Walsh J.,: VQA: vertica query analyzer. In Proc. ACM SIGMOD (2014). 2
34. Thusoo A., Sarma J.S., Jain N., Shao Z., Chakka P., Anthony S., Liu H., Wyckoff P., Murthy R.,: Hive: a warehousing solution over a map-reduce framework. Proc. VLDB (2009). 2
35. Twitter: Ambrose, 2013. http://github.com/twitter/ambrose/. 3, 6
36. Xu Y., Kostamaa P., Zhou X., Chen L.,: Handling data skew in parallel joins in shared-nothing systems. In Proc. ACM SIGMOD (2008), ACM. 4
37. Zakai A.,: Emscripten: an LLVM-to-JavaScript compiler. In Proc. ACM Object oriented programming systems languages and applications (2011). 7