Transcript Definable Maps for Database Visualization

Architectural Support for
Database Visualization
Dennis Groth
Indiana University Computer Science
2002
Talk Structure
 Problem Motivation
 Overview of Visualization Process
 Mapping
 Summary and Future Research
7/7/2015
Dennis Groth
2
Motivation
 What is visualization?
“the act or process of interpreting in visual terms or
of putting into visible form.”
[Webster’s]
“Transforming the symbolic into the geometric.”
[McCormick et al, 1987]
“The binding (or mapping) of data to representations that
can be perceived.”
[Foley, 1994]
7/7/2015
Dennis Groth
3
The Goal of Visualization
 Gain insight into data
 Understand the “whole”
 Identify relationships
 Dynamic interaction
 Different than presentation graphics:

7/7/2015
Used to communicate information to others
Dennis Groth
4
Scientific Visualization
 Visual representation of scientific data.
Rainfall in Peru over 3 day period
[Goldberg et al, 1987]
7/7/2015
Dennis Groth
5
Information Visualization
 Visual representation of abstract data.
[Document Spiral , Cugini et al]
7/7/2015
Dennis Groth
6
What’s the Difference?
 Scientific data:


Often, already numeric
Natural mapping to coordinates
 Abstract data:


7/7/2015
May not be numeric (No order, No scale)
Mappings must be defined or constructed
Dennis Groth
7
Visualization Process (KDD)
7/7/2015
Dennis Groth
8
Architecture
7/7/2015
Dennis Groth
9
Applying a Map
Input Data
t1
t2
t3
.
.
.
tn
7/7/2015
Map
Output
m1
m2
m3
.
.
.
mn
Dennis Groth
10
Database Activities
Sex
Salary
Age
…
M
640001
57
…
…
…
…
…
Salary
SalaryRank
640001
3318
…
…
SalaryRank
Select SalaryRank,Age, Count(*)
From Employee, SalaryMap
Where Employee.Salary = SalaryMap.Salary
Group By SalaryRank,Age
7/7/2015
Dennis Groth
Age
11
User Interaction
 Rotation, Translation, Scaling
 Drill-down queries
 Select data-points for use in other contexts
 Scatterplots, barcharts, parallel coordinates,
surface plots, line, …
 Combining plots


7/7/2015
Scaled independently or dependently
Overlay, Offset, Tile
Dennis Groth
13
Summary and Future Work




Architecture supporting visualization
Mapping language (Declarative approach)
Implementation
Future Research

Visualization

Extensions driven by applications
 Document search
 Cluster visualization

Data Mining

7/7/2015
Association rule discovery
Dennis Groth
14