Dataset and Query Information for:
A Framework to Support Spatial, Temporal and Thematic Analytics over Semantic Web Data
Matthew Perry, Ph.D. Dissertation, Wright State University 2008
Ontologies:
Upper Level STT Ontology: Schema (.rdfs)
Historical Battlefield Analysis Ontology: Schema (.rdfs)
GovTrack Ontologies: Available Here
Instance Data (SynHist Dataset):
SH1
SH2
SH3
SH4
SH5
Note: These files only contain thematic data. Temporal intervals were assigned randomly after loading into Oracle.
Spatial Regions were assigned randomly after loading into Oracle.
Spatial Region Data: 2000 Census Block Group Boundaries
States for each dataset:
SH1: OR
SH2: OR, KY, OH
SH3: OR, GA, KY, NC, OH, PN, TN
SH4: OR, GA, IL, IN, KY, MD, NJ, NY, NC, OH, PN, TN, VA, WV
SH5: OR, AL, AR, FL, GA, IL, IN, IA, KY, LA, MD, MN, MS, MO, NJ, NY, NC, OH, PN, SC, TN, VA, WV, WI
Instance Data (GovTrack Dataset): Available Here
Note: These files only contain thematic data and ad hoc temporal data.
Temporal RDF was created after the files were loaded into Oracle by
removing ad-hoc temporal statements and creating a mapping between (s, p, o)
triples and appropriate temporal intervals.
Spatial Regions were assigned after loading into Oracle.
Code for creating the temporal mapping is available here:
gov_temp_trans.sql
Spatial Region Data (Congressional Districts):
103rd
104th
105th
106th
107th
108th
109th
110th
Queries used for testing:
Note: There are 6 table functions defined and used in these queries. temporal_restrict was presented as
a temporal_extent with filtering parameters in the dissertation for simplicity of presentation. The same applies
for spatial_restrict (spatial_find). In addition, an extra parameter is defined to allow passing an optimizer
hint to the database.
Table 7.3 Queries: tab7-3.sql
Table 7.4 Queries: tab7-4.sql
Figure 7.1 Queries: fig7-1.sql
Figure 7.2 Queries: fig7-2.sql
Figure 7.3 Queries: fig7-3.sql
Figure 7.4 Queries: fig7-4.sql
Table 7.5 Queries: tab7-5.sql
Table 7.6 Queries: tab7-6.sql
Figure 7.5 Queries: fig7-5.sql