Google Visualization Mapper

Dr. Mike MitriJames Madison University

Data-to-Visualization Mapping Algorithms

Data Source

Data Source

Visualization

Object

Visualization

Object

Visualization

Object

User-generated SQL queries

SQL

SQL

SQL

SQL

Query results

Data –to- Visualization Mappings

Google Data Visualizations

• JavaScript library of objects and functions for various types of interactive charts, images, and animations

• Google’s visualization API website: http://code.google.com/apis/chart/interactive/docs/index.html

Some Google Visualizations

Motion Chart

Gauge

TreeMap

Dygraph (time series)

All of these are interactive and can respond to user events.

Mapping Recursive Query to Google Data Visualization Org Chart

• Query should be a “recursive query” (e.g. based on a unary relationship of employees and their managers)

• Result set has two required fields (and one optional field)– The dependent entity (e.g. the employee)– The parent entity (e.g. the manager)– Any extra information to display

• Result set is used to generate HTML and JavaScript• Javascript executes in a browser to produce the org chart• Org chart object in Google Documentation (note expected

data format):• http://code.google.com/apis/chart/interactive/docs/gallery/

orgchart.html

Result Set (from AdventureWorks database)

JavaScript Generated from Query and Result Set

JavaScript Generated from Query and Result Set

Create data table

JavaScript Generated from Query and Result Set

Define columns

From result set metadata

JavaScript Generated from Query and Result Set

Add a row of data

From result set data

JavaScript Generated from Query and Result Set

Create and draw visualization based on data table. The visualization should be associated with a <DIV> element in the html document.

Resulting Google Visualization

Screenshot of Google Visualization Generator

WebBrowser control contains resulting visualization

JavaScript generated from query

User enters connection string and SQL query, and selects visualization type