120 likes | 131 Views
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.
E N D
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.
Introduction • Framework for geospatial data visualization • Integrates XML data from multiple sources • Application scenario: 2000 U.S. Presidential Election Results
System Design query Results Browser Geospatial Authority Declarative Lookup Java API results XML Database
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>
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>
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
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!
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>
User Study The average rating for the interface was 7.3 on a scale of 10 Sample size = 17
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
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.