1 / 12

XML Database Integration for Visualizing US Election Results

This research explores a framework for geospatial data visualization by integrating XML data from multiple sources for visualizing US election results. The system design includes a query browser, geospatial authority, and Java API for querying XML database. The transformation between databases and inter-document transformations are also discussed.

bdietz
Download Presentation

XML Database Integration for Visualizing US Election Results

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. XML Database Integration for Visualizing US Election Results Isabel F. Cruz, Afsheen Rajendran, and William Sunna University of Illinois at Chicago http://www.cs.uic.edu/~ifc/grants/DG/ This research was supported by the National Science Foundation under award EIA-0091489.

  2. Introduction • Framework for geospatial data visualization • Integrates XML data from multiple sources • Application scenario: 2000 U.S. Presidential Election Results

  3. System Design query Results Browser Geospatial Authority Declarative Lookup Java API results XML Database

  4. Geospatial Authority DTD Created by Domain Specialist <!ELEMENT state (county+)> <!ELEMENT county (municipality+)> <!ELEMENT municipality EMPTY> <!ATTLIST state name CDATA #REQUIRED> <!ATTLIST county name CDATA #REQUIRED> <!ATTLIST municipality name CDATA #REQUIRED>

  5. name state 1 n name county 1 n name municipality 1 n name wardgroup 1 name n candidate votes Wisconsin Election Results DTD Created by each State Wisconsin <!ELEMENT state (county+)> <!ELEMENT county (municipality+)> <!ELEMENT municipality (wardgroup)> <!ELEMENT wardgroup(candidate+)> <!ELEMENT candidate EMPTY> <!ATTLIST state name CDATA #REQUIRED> <!ATTLIST county name CDATA #REQUIRED> <!ATTLIST municipality name CDATA #REQUIRED> <!ATTLIST wardgroup name CDATA #REQUIRED> <!ATTLIST candidate name CDATA #REQUIRED votes CDATA #REQUIRED>

  6. Auth::State name Auth::County name Auth::Municipality name Transformations between Databases IL::County WI::County name name WI::Municipality IL::Candidate name name votes Transformation WI::Wardgroup name Transformation GeospatialAuthority WI::Candidate name votes

  7. Inter-document Transformations • Transformations between each state and the authority • A transformation is also an XML document • Transformations are declarative • Adding a state implies changing only the corresponding lookup file - it does not change the extensive program that parses and executes the lookups!

  8. Transformation fragment • Municipality <argument><name>$county_name</name><value>parent::county/attribute::name</value></argument> <argument><name>$municipality_name</name><value>attribute::name</value></argument> <xpath-expr>/child::state[attribute::name="$state_name"]/child::county[attribute::name="$county_name"]/child::municipality[attribute::name="$municipality_name"]/child::*</xpath-expr>

  9. Query Interface

  10. User Study The average rating for the interface was 7.3 on a scale of 10 Sample size = 17

  11. Visual tool to analyze and link document types I. F. Cruz, A. Rajendran, and W. Sunna “Handling Semantic Heterogeneities using Declarative Agreements”. Technical Report University of Illinois at Chicago, May 2002 Current Work

  12. References • N. Wiegand, I. F. Cruz, and S. J. Ventura. Digital Government: Integrating Metadata Development, XML, and DBMS Search and Query Techniques in a State of Wisconsin Land Information System, 2000. Technical Report - University of Wisconsin-Madison and University of Illinois at Chicago. • P. Calnan and I. F. Cruz. Object Interoperability for Geospatial Applications. In Proceedings of the First Semantic Web Working Symposium, pages 229-243, Stanford, CA, 2001. • I. F. Cruz and P. Calnan. Object Interoperability for Geospatial Applications. In book: The Emerging Semantic Web, OIS Press 2002.

More Related