Magic Lenses for Interactive Database Visualization

1
Magic Lenses for Interactive Database
Visualization

• Ken Fishkin
• SoftBook Press, Inc.

2
Traditional Database Queries

• Use a Special Language
• select title from movies where lead_actorConnery
  , Sean and (year lt 1960 or year gt 1975)
• Batch, non-visual

3
Dynamic Queries (example 1)

• One selector per attribute

4
Dynamic Queries (example 2)

• Selectors filter the display

5
Dynamic Queries (limitations)

• designed for a small number of attributes
• only global filters
• cant screen on an attribute more than once
• no disjunctions
• limited query set

6
Hybrid Techniques

• language for leaves of the query,
• visual interface for compound queries
• Still not all queries supported

Content Date Content
Contains is before contains
Document Management 05/01/94 Visual Recall OS
And
Or
7
Magic Lenses

• Movable local filters, which transform the data
  underneath them in some way, be it visual
  (magnifying lens), semantic (misspelled words),
  or other

8
Merging Lenses into Queries

• Put one attribute selector on a lens.

9
1 - local filters
10
2 - repeated attributes
11
3 - arbitrary number of attrs.

• Just stack em up.

12
Consistent UI
13
Query Power

• 2.5D order of windows implies a
  composition/evaluation order
• Put an AND/OR toggle on the lens to indicate how
  it should compose
• A AND B --gt ltA,ANDgt above ltBgt
• A OR B --gt ltA,ORgt above ltBgt

14
And/or in action
15
Query Power(2)

• NOT gets its own lens
• A AND NOT (B OR C)
• ltA,ANDgt
• ltNOTgt
• ltB,ORgt
• ltCgt

16
Grouping

• Introduce compound (grouped) lenses
• Allows parenthesizing
• allows macros
• Conjunction Negation Grouping gt support for
  arbitrary Boolean queries

17
Extensions

• No need to have just AND and OR - could have
  any/all of the 16 possible combinations.
• Could just have a NAND mode, but that would be
  non-intuitive. And/Or/Not are most common.

18
Fuzzy Selectors

• Selectors need not be pass/fail.

True
1
False
0
1
True
False
0
19
Selectors over 0..1
20
Numerical Operators
21
Fuzzy Composition

• Selectors on 0..1 implies composition on 0..1
• Replace AND by MIN, OR by MAX, NOT by complement
• Presently, have implemented arithmetic (DIFF),
  statistical (SQRT), and fuzzy (VERY)
• Many others possible

22
Fuzzy example
23
Missing Data - display
24
Missing Data - example
25
Missing Data - composition

• How do composition operators handle it? We treat
  it like IEEE NaN

26
Conclusion (1995)

• by merging Dynamic Queries with Magic Lenses, we
  keep the interactive, visual nature of queries,
  but add more functionality.
• Future work a slicker UI, user studies.

27
Conclusion (2000)

• If this is so great, why doesnt everyone use it?
• Inter-app. Requires lots of plumbing, Xerox
  licensing. OS X?
• Intra-app. Requires Xerox licensing. So far SGI
  only one determined enough to do it.