Interface SolgrindDBConnection

    • Method Detail

      • getInstance

        Instance getInstance​(String tableName,
                             InstanceData instanceData)
        get trajectory with given trajectory identifier
        Returns:
      • getInstances

        Set<Instance> getInstances​(InstanceData[] instanceDatas)
        //get a set of trajectories given an array of identifiers
        Returns:
      • getAllInstances

        List<Instance> getAllInstances​(String tableName,
                                       String eventType)
        Parameters:
        tableName -
        Returns:
        set of instances
      • searchInstances

        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
        Parameters:
        twindow -
        mbr -
        Returns:
      • insertInstance

        boolean insertInstance​(Instance trj,
                               String tablename)
        this inserts a trajectory to tablename it could be ideal if one checks the table is correctly modeled
        Parameters:
        trj -
        tablename -
        Returns:
      • insertInstances

        boolean insertInstances​(Set<Instance> trj,
                                String tablename)
        this inserts a set of trajectories to a table in batch
        Parameters:
        trj -
        tablename -
        Returns:
      • stJoin

        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
        Parameters:
        predicate -
        table1 -
        table2 -
        Returns:
      • createTable

        boolean createTable​(String tableName)
      • dropTable

        boolean dropTable​(String tableName)