1 / 13

Google Visualization Mapper

Map recursive SQL queries to Google Org Chart visualization object to display entities and relationships. JavaScript library used for interactive charts. Learn data-to-visualization mappings.

bensont
Download Presentation

Google Visualization Mapper

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Google Visualization Mapper Dr. Mike Mitri James Madison University

  2. Data –to- Visualization Mappings Visualization Object User-generated SQL queries Data-to-Visualization Mapping Algorithms Data Source SQL Visualization Object SQL Query results SQL Data Source SQL Visualization Object

  3. 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

  4. Some Google Visualizations Gauge TreeMap Motion Chart Dygraph (time series) All of these are interactive and can respond to user events.

  5. 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

  6. Result Set (from AdventureWorks database)

  7. JavaScript Generated from Query and Result Set

  8. JavaScript Generated from Query and Result Set Create data table

  9. JavaScript Generated from Query and Result Set Define columns From result set metadata

  10. JavaScript Generated from Query and Result Set Add a row of data From result set data

  11. 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.

  12. Resulting Google Visualization

  13. Screenshot of Google Visualization Generator User enters connection string and SQL query, and selects visualization type WebBrowser control contains resulting visualization JavaScript generated from query

More Related