DataSplash

1
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
2
Browsing a Visualization
Navigation Mode Buttons
Layer Manager
Main Canvas
3
Navigation

• Interactively browse large data sets

• Pan by dragging directly on the canvas

• Zoom by dragging up and down in the layer manager

4
Layers

• Just like stacked transparency slides!

• Layers contain different objects

• Zooming controls which layers are visible

State Polygon Layer
Current Zoom
State Abbreviation Layer
Visible Layers
Layer Not Visible
5
Creating a Visualization

• Paint Program Interface
• Paint objects as in a standard paint program
• Assign graphical properties of objects to
  database table attributes

6
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
7
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
8
Visual Joins

• Each presidential candidate has an associated
  portal (sub-window)
• Each portal shows the states that voted for the
  candidate

Presidential Candidates States
9
Specifying Visual Joins

• Pick up the visualization of one table and drop
  it into the visualization of another table

• Result A 3-way visual join

Parties Candidates States