90 likes | 181 Views
DataSplash. A Database Visualization Environment. The UC Berkeley Tioga Project Chris Olston, Allison Woodruff, Alexander Aiken, Michael Chu, Vuk Ercegovac, Mark Lin, Mybrid Spalding, Michael Stonebraker. Browsing a Visualization. Navigation Mode Buttons. Layer Manager. Main Canvas. PAN.
E N D
DataSplash A Database Visualization Environment The UC Berkeley Tioga Project Chris Olston, Allison Woodruff, Alexander Aiken, Michael Chu, Vuk Ercegovac, Mark Lin, Mybrid Spalding, Michael Stonebraker
Browsing a Visualization Navigation Mode Buttons Layer Manager Main Canvas
PAN ZOOM Current Zoom Navigation • Interactively browse large data sets • Pan by dragging directly on the canvas • Zoom by dragging up and down in the layer manager
Layers • Just like stacked transparency slides! • Zooming controls which layers are visible • Layers contain different objects State Polygon Layer Current Zoom State Abbreviation Layer Visible Layers Layer Not Visible
Height = Elevation Creating a Visualization • Paint Program Interface • Paint objects as in a standard paint program • Assign graphical properties of objects to database table attributes
Programming Layers • Resize layer bars in layer manager • Controls which layers are visible at which zoom levels • For example, we only want fine detail layers to be visible when the user zooms in Resize Current Zoom
Querying a Visualization • This visualization shows which political party each state has favored since 1952 • But which states voted for which presidential candidates in which elections? Red: Democrat Blue: Republican
Visual Joins • Each presidential candidate has an associated portal (sub-window) • Each portal shows the states that voted for the candidate Presidential Candidates States
Specifying Visual Joins • Result: A 3-way visual join • Pick up the visualization of one table and drop it into the visualization of another table Parties Candidates States