Strabon

changeset 667:6438a594cf66 temporals

Added index on period_values
author Konstantina Bereta <Konstantina.Bereta@di.uoa.gr>
date Fri Oct 26 18:41:15 2012 +0300 (2012-10-26)
parents 38625b0939f0
children 68f4e9215b28
files generaldb/src/main/java/org/openrdf/sail/generaldb/GeneralDBSqlTable.java generaldb/src/main/java/org/openrdf/sail/generaldb/schema/PeriodTable.java monetdb/src/main/java/org/openrdf/sail/monetdb/MonetDBSqlTable.java postgis/src/main/java/org/openrdf/sail/postgis/PostGISSqlTable.java
line diff
     1.1 --- a/generaldb/src/main/java/org/openrdf/sail/generaldb/GeneralDBSqlTable.java	Fri Oct 26 18:12:21 2012 +0300
     1.2 +++ b/generaldb/src/main/java/org/openrdf/sail/generaldb/GeneralDBSqlTable.java	Fri Oct 26 18:41:15 2012 +0300
     1.3 @@ -53,13 +53,7 @@
     1.4  	
     1.5  	public abstract String buildWhere();
     1.6  
     1.7 -	public String buildIndexOnPeriodCollumn() {
     1.8 -		// TODO Auto-generated method stub
     1.9 -		return null;
    1.10 -	}
    1.11 +	public abstract  String buildIndexOnPeriodColumn();
    1.12  
    1.13 -	public String buildInsertPeriodValue() {
    1.14 -		// TODO Auto-generated method stub
    1.15 -		return null;
    1.16 -	}
    1.17 +	public  abstract String buildInsertPeriodValue(); 
    1.18  }
     2.1 --- a/generaldb/src/main/java/org/openrdf/sail/generaldb/schema/PeriodTable.java	Fri Oct 26 18:12:21 2012 +0300
     2.2 +++ b/generaldb/src/main/java/org/openrdf/sail/generaldb/schema/PeriodTable.java	Fri Oct 26 18:41:15 2012 +0300
     2.3 @@ -390,10 +390,10 @@
     2.4  		table.createTable(sb);
     2.5  		
     2.6  		/*String extension = ((GeneralDBSqlTable)table).buildGeometryCollumn();
     2.7 -		table.execute(extension);
     2.8 +		table.execute(extension);*/
     2.9  		
    2.10 -		String index = ((GeneralDBSqlTable)table).buildIndexOnGeometryCollumn();
    2.11 -		table.execute(index);*/
    2.12 +		String index = ((GeneralDBSqlTable)table).buildIndexOnPeriodColumn();
    2.13 +		table.execute(index);
    2.14  	}
    2.15  
    2.16  	/**
     3.1 --- a/monetdb/src/main/java/org/openrdf/sail/monetdb/MonetDBSqlTable.java	Fri Oct 26 18:12:21 2012 +0300
     3.2 +++ b/monetdb/src/main/java/org/openrdf/sail/monetdb/MonetDBSqlTable.java	Fri Oct 26 18:41:15 2012 +0300
     3.3 @@ -80,6 +80,20 @@
     3.4  		return " WHERE (1=1 OR 1=1) ";
     3.5  	}
     3.6  
     3.7 +
     3.8 +
     3.9 +	@Override
    3.10 +	public String buildIndexOnPeriodColumn() {
    3.11 +		// TODO Auto-generated method stub
    3.12 +		return null;
    3.13 +	}
    3.14 +
    3.15 +	@Override
    3.16 +	public String buildInsertPeriodValue() {
    3.17 +		// TODO Auto-generated method stub
    3.18 +		return null;
    3.19 +	}
    3.20 +
    3.21  	@Override
    3.22  	public String buildPeriodCollumn() {
    3.23  		// TODO Auto-generated method stub
     4.1 --- a/postgis/src/main/java/org/openrdf/sail/postgis/PostGISSqlTable.java	Fri Oct 26 18:12:21 2012 +0300
     4.2 +++ b/postgis/src/main/java/org/openrdf/sail/postgis/PostGISSqlTable.java	Fri Oct 26 18:41:15 2012 +0300
     4.3 @@ -40,7 +40,7 @@
     4.4  	}
     4.5  	
     4.6  	@Override
     4.7 -	public String buildIndexOnPeriodCollumn() {
     4.8 +	public String buildIndexOnPeriodColumn() {
     4.9  		//return "CREATE INDEX geoindex ON geo_values USING GIST (strdfgeo)";
    4.10  		return "CREATE INDEX test_period_idx ON period_values USING GiST (period)";
    4.11  	}