Package edu.gsu.cs.dmlab.solgrind.database

Class SolgrindDBConnectionSimple

java.lang.Object

edu.gsu.cs.dmlab.solgrind.database.SolgrindDBConnectionSimple

All Implemented Interfaces:

SolgrindDBConnection

public class SolgrindDBConnectionSimple
extends Object
implements SolgrindDBConnection

Created by ahmetkucuk on 28/09/16.

Constructor Summary

Constructors

Constructor	Description
SolgrindDBConnectionSimple(DataSource source)

Method Summary

Modifier and Type	Method	Description
boolean	createTable(String tableName)
boolean	dropTable(String tableName)
List<Instance>	getAllInstances(String tableName, String eventType)
Instance	getInstance(String tableName, InstanceData instanceData)	get trajectory with given trajectory identifier
Set<Instance>	getInstances(InstanceData[] instanceDatas)	//get a set of trajectories given an array of identifiers
boolean	insertInstance(Instance trj, String tablename)	this inserts a trajectory to tablename it could be ideal if one checks the table is correctly modeled
boolean	insertInstances(Set<Instance> instances, String tablename)	this inserts a set of trajectories to a table in batch
Set<Instance>	searchInstances(org.joda.time.Interval twindow, org.locationtech.jts.geom.Envelope mbr, String eventType)	//this is spatiotemporal windows search on an event type
HashMap<Instance,Instance>	stJoin(String predicate, String table1, String table2)	this performs a spatiotemporal join (first do overlap) select * from table1 as t1, table2 as t2 where t1.timerange intersects with t2.timerange abd t1.geom intersercts with t2.geom

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SolgrindDBConnectionSimple

public SolgrindDBConnectionSimple(DataSource source)

Method Detail

getInstance

public Instance getInstance(String tableName,
                            InstanceData instanceData)

Description copied from interface: SolgrindDBConnection

get trajectory with given trajectory identifier

Specified by:

getInstance in interface SolgrindDBConnection

Returns:

getInstances

public Set<Instance> getInstances(InstanceData[] instanceDatas)

Description copied from interface: SolgrindDBConnection

//get a set of trajectories given an array of identifiers

Specified by:

getInstances in interface SolgrindDBConnection

Returns:

getAllInstances

public List<Instance> getAllInstances(String tableName,
                                      String eventType)

Specified by:

getAllInstances in interface SolgrindDBConnection

Returns:

set of instances

searchInstances

public Set<Instance> searchInstances(org.joda.time.Interval twindow,
                                     org.locationtech.jts.geom.Envelope mbr,
                                     String eventType)

Description copied from interface: SolgrindDBConnection

//this is spatiotemporal windows search on an event type

Specified by:

searchInstances in interface SolgrindDBConnection

Returns:

insertInstance

public boolean insertInstance(Instance trj,
                              String tablename)

Description copied from interface: SolgrindDBConnection

this inserts a trajectory to tablename it could be ideal if one checks the table is correctly modeled

Specified by:

insertInstance in interface SolgrindDBConnection

Returns:

insertInstances

public boolean insertInstances(Set<Instance> instances,
                               String tablename)

Description copied from interface: SolgrindDBConnection

this inserts a set of trajectories to a table in batch

Specified by:

insertInstances in interface SolgrindDBConnection

Returns:

stJoin

public HashMap<Instance,Instance> stJoin(String predicate,
                                               String table1,
                                               String table2)

Description copied from interface: SolgrindDBConnection

this performs a spatiotemporal join (first do overlap) select * from table1 as t1, table2 as t2 where t1.timerange intersects with t2.timerange abd t1.geom intersercts with t2.geom

Specified by:

stJoin in interface SolgrindDBConnection

Returns:

createTable

public boolean createTable(String tableName)

Specified by:

createTable in interface SolgrindDBConnection

dropTable

public boolean dropTable(String tableName)

Specified by:

dropTable in interface SolgrindDBConnection