def runMySQL(numberOfExecutions, polygonID):
print('Started MySQL Benchmark')
db = mysql.Mysql()
results = db.runQueries(mysqlqueries(polygonID), numberOfExecutions)
db.disconnect()
print('Finished MySQL Benchmark')
output.printSingleResult(results)
return results
def runMonetDB(numberOfExecutions, polygonID):
print('Started MonetDB Benchmark')
db = monetdb_db.Monetdb()
results = db.runQueries(monetdbqueries(polygonID), numberOfExecutions)
db.disconnect()
print('Finished MonetDB Benchmark')
output.printSingleResult(results)
return results
def runHana(numberOfExecutions, polygonID):
print('Starting Hana Benchmark')
hanaDB = hana.Hana()
hanaResults = hanaDB.runQueries(hanaqueries(polygonID), numberOfExecutions)
hanaDB.disconnect()
print('Finished Hana Benchmark')
output.printSingleResult(hanaResults)
return hanaResults
def runHana(numberOfExecutions, polygonID):
print('Starting Hana Benchmark')
hanaDB = hana.Hana()
hanaResults = hanaDB.runQueries(hanaqueries(polygonID), numberOfExecutions)
hanaDB.disconnect()
print('Finished Hana Benchmark')
output.printSingleResult(hanaResults)
return hanaResults
def runMonetDB(numberOfExecutions, polygonID):
print('Started MonetDB Benchmark')
db = monetdb_db.Monetdb()
results = db.runQueries(monetdbqueries(polygonID), numberOfExecutions)
db.disconnect()
print('Finished MonetDB Benchmark')
output.printSingleResult(results)
return results
def runPostgis(numberOfExecutions, params):
print('Started postgis Benchmark')
postgisDB = postgis.Postgis()
postgisResults = postgisDB.runQueries(postgisqueries(), numberOfExecutions, params)
postgisDB.disconnect()
print('Finished postgis Benchmark')
output.printSingleResult(postgisResults)
return postgisResults
def runMySQL(numberOfExecutions, polygonID):
print('Started MySQL Benchmark')
db = mysql.Mysql()
results = db.runQueries(mysqlqueries(polygonID), numberOfExecutions)
db.disconnect()
print('Finished MySQL Benchmark')
output.printSingleResult(results)
return results
def runPostgis(numberOfExecutions):
print('Starting postgresql (postgis) Benchmark')
postgisDB = postgis.Postgis()
postgisResults = postgisDB.runQueries(postgisqueries(), numberOfExecutions)
postgisDB.disconnect()
print('Finished postgresql (postgis) Benchmark')
output.printSingleResult(postgisResults)
return postgisResults
def runMySQL(numberOfExecutions):
print('Starting MySQL Benchmark')
mysqlDB = mysql.Mysql()
mySQLResults = mysqlDB.runQueries(mysqlqueries(), numberOfExecutions)
mysqlDB.disconnect()
print('Finished MySQL Benchmark')
output.printSingleResult(mySQLResults)
return mySQLResults
def runSpatialiteMain(numberOfExecutions, params):
print('Started spatialite Benchmark')
db = spatialite.Spatialite(':memory:')
db.loadDiskData('benchmark.db')
spatialiteResults = db.runQueries(spatialitequeries(), numberOfExecutions, params)
db.disconnect()
print('Finished spatialite Benchmark')
output.printSingleResult(spatialiteResults)
return spatialiteResults
def runSpatialiteMain(numberOfExecutions, params):
print('Started spatialite Benchmark')
db = spatialite.Spatialite(':memory:')
db.loadDiskData('benchmark.db')
spatialiteResults = db.runQueries(spatialitequeries(), numberOfExecutions,
params)
db.disconnect()
print('Finished spatialite Benchmark')
output.printSingleResult(spatialiteResults)
return spatialiteResults
def runPostgis(numberOfExecutions, areaPoints):
print('Started postgis Benchmark')
postgisDB = postgis.Postgis()
areaString = postgisDB.polygonString(areaPoints)
postgisResults = postgisDB.runQueries(postgisqueries(areaString),
numberOfExecutions)
postgisDB.disconnect()
print('Finished postgis Benchmark')
output.printSingleResult(postgisResults)
return postgisResults
def runSpatialiteMain(numberOfExecutions):
enableIndex = False
print('Starting spatialite Benchmark - main-memory')
spatialiteDBMain = spatialite.Spatialite(':memory:')
# spatialiteDBMain = spatialite.Spatialite('benchmark.db')
spatialiteDBMain.setUpSoccerData(enableIndex)
spatialiteResultsMain = spatialiteDBMain.runQueries(
spatialitequeries(), numberOfExecutions)
spatialiteDBMain.disconnect()
print('Finished spatialite Benchmark - main-memory')
output.printSingleResult(spatialiteResultsMain)
return spatialiteResultsMain