Dataset and Query information for:

What, Where and When: Supporting Semantic, Spatial and Temporal Queries in a DBMS

Matthew Perry, Amit P. Sheth, Farshad Hakimpour and Prateek Jain

Ontologies:

Upper-level Theme and Space Ontology: Schema

Military Ontology: Schema

Instance Files: Small Medium Large

[Note: These files only contain thematic data. Temporal intervals were assigned randomly after loading into Oracle. Spatial Features were assigned randomly after loading into Oracle.]

Spatial Feature Data [Census 2000 Block Group Boundaries]

Small Dataset: NH

Medium Dataset: OH

Large Dataset: GA, IL, IN, KY, MD, NJ, NY, NC, OH, PN, TN, VA, WV

Queries:

Experiment 1:

-- small dataset --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- medium dataset --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- large dataset --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

Experiment 2:

-- small dataset --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> <http://lsdis.cs.uga.edu/military/Air_Vehicle_12709>) (<http://lsdis.cs.uga.edu/military/Air_Vehicle_12709> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12828>) (<http://lsdis.cs.uga.edu/military/Platoon_12828> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12843>) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> <http://lsdis.cs.uga.edu/military/Platoon_12986>) (?z <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12986>) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2191>)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

-- medium dataset --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> <http://lsdis.cs.uga.edu/military/Air_Vehicle_17125>) (<http://lsdis.cs.uga.edu/military/Air_Vehicle_17125> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_10597>) (<http://lsdis.cs.uga.edu/military/Platoon_10597> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_8587>) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> <http://lsdis.cs.uga.edu/military/Platoon_11116>) (?z <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_11116>) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_14765>)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

-- large dataset --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> <http://lsdis.cs.uga.edu/military/Air_Vehicle_164455>) (<http://lsdis.cs.uga.edu/military/Air_Vehicle_164455> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_110802>) (<http://lsdis.cs.uga.edu/military/Platoon_110802> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_108844>) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> <http://lsdis.cs.uga.edu/military/Platoon_92820>) (?z <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_92820>) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_148572>)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

Experiment 3:

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x

<http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id')) where rownum < 1001;

-- med dataset --

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id')) where rownum < 1001;

-- lrg dataset --

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id')) where rownum < 1001;

Experiment 4:

-- small dataset --

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> <http://lsdis.cs.uga.edu/military/Air_Vehicle_12709>) (<http://lsdis.cs.uga.edu/military/Air_Vehicle_12709> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12828>) (<http://lsdis.cs.uga.edu/military/Platoon_12828> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12843>) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id')) where rownum < 1001;

-- medium dataset --

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> <http://lsdis.cs.uga.edu/military/Air_Vehicle_17125>) (<http://lsdis.cs.uga.edu/military/Air_Vehicle_17125> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_10597>) (<http://lsdis.cs.uga.edu/military/Platoon_10597> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_8587>) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id')) where rownum < 1001;

-- lrg dataset --

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> <http://lsdis.cs.uga.edu/military/Air_Vehicle_164455>) (<http://lsdis.cs.uga.edu/military/Air_Vehicle_164455> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_110802>) (<http://lsdis.cs.uga.edu/military/Platoon_110802> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id')) where rownum < 1001;

select count(*) from table (spatial_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_108844>) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id')) where rownum < 1001;

Experiment 5:

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a)',

to_date('1942-10-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1944-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#leader_of> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1942-12-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1944-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'BEFORE',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1941-06-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-05-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'AFTER',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)(?y <http://lsdis.cs.uga.edu/military#trains_at> ?a)',

to_date('1941-04-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1944-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT'));

-- med dataset --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a)',

to_date('1942-12-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-02-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#leader_of> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1941-08-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-05-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'BEFORE',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1941-06-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-11-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'AFTER',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)(?y <http://lsdis.cs.uga.edu/military#trains_at> ?a)',

to_date('1942-11-16 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- large dataset --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1942-12-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#leader_of> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1941-03-05 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-05-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'BEFORE',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1941-06-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-12-25 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'AFTER',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)(?y <http://lsdis.cs.uga.edu/military#trains_at> ?a)',

to_date('1942-07-17 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

Experiment 6:

-- small dataset --

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'SDO_GEOMETRY(2001, 8265, SDO_POINT_TYPE(-71.796531, 44.304772, NULL), NULL, NULL)',

'GEO_DISTANCE(distance=45 unit=mile)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'SDO_GEOMETRY(2003, 8265, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-72.269336, 43.424149, -70.989037, 44.8805994))',

'GEO_RELATE(mask=coveredby)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'SDO_GEOMETRY(2003, 8265, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-72.066166, 44.068919, -71.726997, 44.313941))',

'GEO_RELATE(mask=overlapbdyintersect)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

-- med dataset --

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'SDO_GEOMETRY(2001, 8265, SDO_POINT_TYPE(-81.09576, 41.82171, NULL), NULL, NULL)',

'GEO_DISTANCE(distance=10 unit=mile)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'SDO_GEOMETRY(2003, 8265, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-81.970263, 41.061209, -80.518693, 41.964041))',

'GEO_RELATE(mask=coveredby)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'SDO_GEOMETRY(2003, 8265, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-81.191093, 41.75856, -81.003034, 41.8548038))',

'GEO_RELATE(mask=overlapbdyintersect)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

-- lrg dataset --

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'SDO_GEOMETRY(2001, 8265, SDO_POINT_TYPE(-85.126774775259, 34.9863959928757, NULL), NULL, NULL)',

'GEO_DISTANCE(distance=3 unit=mile)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'SDO_GEOMETRY(2003, 8265, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-85.187025, 34.908372, -85.083618, 35.006155))',

'GEO_RELATE(mask=overlapbdyintersect)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

select count(*) from table (spatial_find('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'SDO_GEOMETRY(2003, 8265, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-85.187025, 34.908372, -85.083618, 35.006155))',

'GEO_RELATE(mask=overlapbdyintersect)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id',

'shape')) where rownum < 1001;

Experiment 7:

-- small dataset --

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12951>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12827>)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12990>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12827>)',

'INTERSECT',

'AFTER',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 150;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12871>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_12910>)',

'INTERSECT',

'BEFORE',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2186>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#leader_of> ?b) (?b <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2191>)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2186>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#assigned_to> ?b) (?b <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2191>)',

'INTERSECT',

'DURIN_INV',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 200;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2191>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#leader_of> ?b) (?b <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2190>)',

'INTERSECT',

'DURING',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

-- medium dataset --

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_10685>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_8847>)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_10160>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_8813>)',

'INTERSECT',

'AFTER',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_10016>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_9694>)',

'INTERSECT',

'BEFORE',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_14810>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#leader_of> ?b) (?b <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_14844>)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> <http://lsdis.cs.uga.edu/military/Platoon_8813>) (<http://lsdis.cs.uga.edu/military/Platoon_8813> <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?y <http://lsdis.cs.uga.edu/military#battalion_of> ?z)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_9573>) (<http://lsdis.cs.uga.edu/military/Platoon_9573> <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> ?d)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_14878>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#leader_of> ?b) (?b <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_14829>)',

'INTERSECT',

'DURING',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

-- lrg dataset --

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_108844>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_110802>)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_114183>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_112788>)',

'INTERSECT',

'AFTER',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_89035>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#on_crew_of> ?b) (?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_113369>)',

'INTERSECT',

'BEFORE',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_147960>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#leader_of> ?b) (?b <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_147852>)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> <http://lsdis.cs.uga.edu/military/Platoon_102456>) (<http://lsdis.cs.uga.edu/military/Platoon_102456> <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?y <http://lsdis.cs.uga.edu/military#battalion_of> ?z)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#assigned_to> <http://lsdis.cs.uga.edu/military/Platoon_96210>) (<http://lsdis.cs.uga.edu/military/Platoon_96210> <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> ?d)',

'INTERSECT',

'ANYINTERACT',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (temporal_eval('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?z <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2191>)',

'INTERSECT',

'(?a <http://lsdis.cs.uga.edu/military#leader_of> ?b) (?b <http://lsdis.cs.uga.edu/military#platoon_of> ?c) (?c <http://lsdis.cs.uga.edu/military#battalion_of> <http://lsdis.cs.uga.edu/military/Division_2190>)',

'INTERSECT',

'DURING',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'FIRST_ROWS')) where rownum < 1001;

Experiment 8:

-- small dataset --

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Air_Vehicle_12691> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)', 'd',

'GEO_DISTANCE(distance=10 unit=mile)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Air_Vehicle_12705> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#located_at> ?d)', 'd',

'GEO_DISTANCE(distance=30 unit=mile)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Soldier_11996> <http://lsdis.cs.uga.edu/military#participates_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)', 'd',

'GEO_DISTANCE(distance=5 unit=mile)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_12996> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#trains_at> ?c) (?c <http://lsdis.cs.uga.edu/STT#located_at> ?d)',

'd',

'GEO_DISTANCE(distance=30 unit=mile)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_12828> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#used_in> ?c) (?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)',

'd',

'GEO_DISTANCE(distance=30 unit=mile)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_12851> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#used_in> ?c) (?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)',

'd',

'GEO_DISTANCE(distance=8 unit=mile)',

SDO_RDF_Models('military'),

SDO_RDF_Rulebases('RDFS'),

'military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

-- medium dataset --

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Air_Vehicle_17093> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)', 'd',

'GEO_DISTANCE(distance=0.15 unit=mile)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Ground_Vehicle_12510> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#located_at> ?d)', 'd',

'GEO_DISTANCE(distance=7 unit=mile)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Soldier_147729> <http://lsdis.cs.uga.edu/military#participates_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)', 'd',

'GEO_DISTANCE(distance=1 unit=mile)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_10704> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#trains_at> ?c) (?c <http://lsdis.cs.uga.edu/STT#located_at> ?d)',

'd',

'GEO_DISTANCE(distance=10 unit=mile)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_8847> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#used_in> ?c) (?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)',

'd',

'GEO_DISTANCE(distance=20 unit=mile)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_10982> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#used_in> ?c) (?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)',

'd',

'GEO_DISTANCE(distance=5 unit=mile)',

SDO_RDF_Models('med_military'),

SDO_RDF_Rulebases('RDFS'),

'med_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

-- lrg dataset --

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Air_Vehicle_167636> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)', 'd',

'GEO_DISTANCE(distance=1.7 unit=mile)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Air_Vehicle_171710> <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#located_at> ?d)', 'd',

'GEO_DISTANCE(distance=12 unit=mile)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Soldier_532914> <http://lsdis.cs.uga.edu/military#participates_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

'l',

'(?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)', 'd',

'GEO_DISTANCE(distance=0.25 unit=mile)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_110802> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#trains_at> ?c) (?c <http://lsdis.cs.uga.edu/STT#located_at> ?d)',

'd',

'GEO_DISTANCE(distance=4 unit=mile)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_94178> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#used_in> ?c) (?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)',

'd',

'GEO_DISTANCE(distance=0.5 unit=mile)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

select count(*) from table (spatial_eval('(<http://lsdis.cs.uga.edu/military/Platoon_85006> <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

'l',

'(?b <http://lsdis.cs.uga.edu/military#used_in> ?c) (?c <http://lsdis.cs.uga.edu/STT#occurred_at> ?d)',

'd',

'GEO_DISTANCE(distance=15 unit=mile)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'lrg_military_rdfs_geo$',

'id', 'shape', 'FIRST_ROWS')) where rownum < 1001;

Experiment 9:

-- 1 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 2 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 3 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#leader_of> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 4 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 5 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?a <http://lsdis.cs.uga.edu/military#platoon_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a) (?a <http://lsdis.cs.uga.edu/military#battalion_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?z) (?z <http://lsdis.cs.uga.edu/military#platoon_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a) (?a <http://lsdis.cs.uga.edu/military#battalion_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 1 hop --

-- Range Queries --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 2 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 3 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#leader_of> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 4 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?z)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 5 hop --

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?a <http://lsdis.cs.uga.edu/military#platoon_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z) (?z <http://lsdis.cs.uga.edu/STT#located_at> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a) (?a <http://lsdis.cs.uga.edu/military#battalion_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#participates_in> ?y) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?z) (?y <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?z) (?z <http://lsdis.cs.uga.edu/military#platoon_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_extent('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#participates_in> ?l) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?a) (?a <http://lsdis.cs.uga.edu/military#battalion_of> ?b)',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

Experiment 10:

-- Intersect --

-- 1 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y)',

to_date('1942-11-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

to_date('1941-02-03 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1941-02-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?z)',

to_date('1943-06-15 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-07-25 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y)',

to_date('1942-06-17 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 2 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z)',

to_date('1942-11-25 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z)',

to_date('1941-02-03 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1941-02-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x)',

to_date('1943-07-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-07-26 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)',

to_date('1942-08-21 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 3 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a)',

to_date('1942-12-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?l)',

to_date('1941-01-21 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1941-02-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?x)',

to_date('1941-07-13 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1941-07-25 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)(?y <http://lsdis.cs.uga.edu/military#trains_at> ?a)',

to_date('1942-08-17 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 4 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a)(?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1942-12-05 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?a)(?y <http://lsdis.cs.uga.edu/military#platoon_of> ?b)',

to_date('1941-01-25 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1941-02-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?x)(?z <http://lsdis.cs.uga.edu/military#participates_in> ?b)',

to_date('1943-10-31 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-11-22 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)(?y <http://lsdis.cs.uga.edu/military#trains_at> ?a) (?a <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

to_date('1942-09-10 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-09-19 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- 5 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a) (?a <http://lsdis.cs.uga.edu/military#trains_at> ?b)',

to_date('1942-12-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?a)(?y <http://lsdis.cs.uga.edu/military#platoon_of> ?b) (?x <http://lsdis.cs.uga.edu/military#participates_in> ?c)',

to_date('1941-01-30 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1941-02-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?x)(?z <http://lsdis.cs.uga.edu/military#participates_in> ?b) (?b <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1943-07-13 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-07-25 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?a) (?a <http://lsdis.cs.uga.edu/STT#located_at> ?l) (?b <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

to_date('1942-09-10 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'INTERSECT')) where rownum < 1001;

-- Range --

-- 1 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y)',

to_date('1942-11-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

to_date('1942-01-30 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-02-08 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?z)',

to_date('1943-06-15 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-07-25 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y)',

to_date('1942-06-17 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 2 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z)',

to_date('1942-10-25 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-07-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?z)',

to_date('1941-08-03 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-02-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x)',

to_date('1943-09-04 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1944-07-26 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)',

to_date('1942-07-21 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 3 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a)',

to_date('1942-10-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?l)',

to_date('1941-01-21 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-06-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?x)',

to_date('1941-05-13 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1942-04-25 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)(?y <http://lsdis.cs.uga.edu/military#trains_at> ?a)',

to_date('1942-03-17 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 4 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a)(?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1942-07-05 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?a)(?y <http://lsdis.cs.uga.edu/military#platoon_of> ?b)',

to_date('1941-07-25 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-03-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?x)(?z <http://lsdis.cs.uga.edu/military#participates_in> ?b)',

to_date('1943-01-29 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1944-12-22 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z)(?y <http://lsdis.cs.uga.edu/military#trains_at> ?a) (?a <http://lsdis.cs.uga.edu/STT#located_at> ?l)',

to_date('1942-07-10 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-10-19 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

-- 5 hop --

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?y) (?y <http://lsdis.cs.uga.edu/military#used_in> ?z) (?z <http://lsdis.cs.uga.edu/STT#occurred_at> ?l) (?x <http://lsdis.cs.uga.edu/military#assigned_to> ?a) (?a <http://lsdis.cs.uga.edu/military#trains_at> ?b)',

to_date('1942-05-01 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-12-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#assigned_to> ?y) (?z <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?x <http://lsdis.cs.uga.edu/military#on_crew_of> ?a)(?y <http://lsdis.cs.uga.edu/military#platoon_of> ?b) (?x <http://lsdis.cs.uga.edu/military#participates_in> ?c)',

to_date('1941-06-30 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-03-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#platoon_of> ?y) (?z <http://lsdis.cs.uga.edu/military#assigned_to> ?x) (?a <http://lsdis.cs.uga.edu/military#leader_of> ?x)(?z <http://lsdis.cs.uga.edu/military#participates_in> ?b) (?b <http://lsdis.cs.uga.edu/STT#occurred_at> ?l)',

to_date('1942-09-13 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1944-08-25 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;

select count(*) from table (temporal_restrict('(?x <http://lsdis.cs.uga.edu/military#leader_of> ?y) (?y <http://lsdis.cs.uga.edu/military#platoon_of> ?z) (?y <http://lsdis.cs.uga.edu/military#trains_at> ?a) (?a <http://lsdis.cs.uga.edu/STT#located_at> ?l) (?b <http://lsdis.cs.uga.edu/military#assigned_to> ?y)',

to_date('1942-02-10 00:26:01', 'yyyy-mm-dd hh24:mi:ss'),

to_date('1943-09-21 08:22:00', 'yyyy-mm-dd hh24:mi:ss'),

'DURING',

SDO_RDF_Models('lrg_military'),

SDO_RDF_Rulebases('RDFS'),

'RANGE')) where rownum < 1001;