XML Database Integration for Visualizing US Election Results

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
lt!ELEMENT state (county)gt lt!ELEMENT county
(municipality)gt lt!ELEMENT municipality
EMPTYgt lt!ATTLIST state name CDATA
REQUIREDgt lt!ATTLIST county name CDATA
REQUIREDgt lt!ATTLIST municipality name
CDATA REQUIREDgt
5
Wisconsin Election Results DTD
Created by each State
Wisconsin
lt!ELEMENT state (county)gt lt!ELEMENT county
(municipality)gt lt!ELEMENT municipality
(wardgroup)gt lt!ELEMENT wardgroup(candidate)gt lt!EL
EMENT candidate EMPTYgt lt!ATTLIST state
name CDATA REQUIREDgt lt!ATTLIST county
name CDATA REQUIREDgt lt!ATTLIST municipality
name CDATA REQUIREDgt lt!ATTLIST wardgroup
name CDATA REQUIREDgt lt!ATTLIST candidate
name CDATA REQUIRED votes
CDATA REQUIREDgt
6
Transformations between Databases
WICounty
ILCounty
name
name
WIMunicipality
ILCandidate
name
votes
name
Transformation
WIWardgroup
name
Transformation
GeospatialAuthority
WICandidate
votes
name
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
• ltargumentgtltnamegtcounty_namelt/namegtltvaluegtparent
  county/attributenamelt/valuegtlt/argumentgt
• ltargumentgtltnamegtmunicipality_namelt/namegtltvaluegt
  attributenamelt/valuegtlt/argumentgt
• ltxpath-exprgt/childstateattributename"state_
  name"/childcountyattributename"county_nam
  e"/childmunicipalityattributename"municip
  ality_name"/childlt/xpath-exprgt

9
Query Interface
10
User Study
The average rating for the interface was 7.3 on a
scale of 10 Sample size 17
11
Current Work

• 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

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.