143 lines
4.6 KiB
Plaintext
143 lines
4.6 KiB
Plaintext
|
|
################################################################################
|
|
## File: CreateNetwork Objects #################################################
|
|
################################################################################
|
|
## This file is part of SECONDO. ##
|
|
## ##
|
|
## Copyright (C) 2010, University in Hagen, Faculty of Mathematics and ##
|
|
## Computer Science, Database Systems for New Applications. ##
|
|
## ##
|
|
## SECONDO is free software; you can redistribute it and/or modify ##
|
|
## it under the terms of the GNU General Public License as published by ##
|
|
## the Free Software Foundation; either version 2 of the License, or ##
|
|
## (at your option) any later version. ##
|
|
## ##
|
|
## SECONDO is distributed in the hope that it will be useful, ##
|
|
## but WITHOUT ANY WARRANTY; without even the implied warranty of ##
|
|
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ##
|
|
## GNU General Public License for more details. ##
|
|
## ##
|
|
## You should have received a copy of the GNU General Public License ##
|
|
## along with SECONDO; if not, write to the Free Software ##
|
|
## Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA ##
|
|
################################################################################
|
|
|
|
# This file performs translates the spatial and spatio-temporal data objects #
|
|
# of the BerlinMOD benchmark in the Secondo DBMS into their network data #
|
|
# model representation and builds the aCCording indexes. #
|
|
# #
|
|
# It is assumed that there is a database berlinmod with the data objects #
|
|
# created by the BerlinMOD_DataGenerator.SEC script. #
|
|
# #
|
|
################################################################################
|
|
# #
|
|
# Open Database Berlinmod #
|
|
# #
|
|
################################################################################
|
|
|
|
open database berlinmod;
|
|
|
|
################################################################################
|
|
# #
|
|
# Delete Objects Created by JNetwork_CreateObjectsBMOD.SEC #
|
|
# #
|
|
################################################################################
|
|
|
|
delete RoadsTmp;
|
|
|
|
delete RoadEndPoints;
|
|
|
|
delete RoadCrossings;
|
|
|
|
delete JunctionsTmp;
|
|
|
|
delete RoadsTmp2;
|
|
|
|
delete RoadsTmp3;
|
|
|
|
delete RoadsTmp4;
|
|
|
|
delete RoadsTmp5;
|
|
|
|
delete RoadJuncList;
|
|
|
|
delete JuncRLocList;
|
|
|
|
delete SectTmp;
|
|
|
|
delete RoadSectList;
|
|
|
|
delete SectRouteIntervals;
|
|
|
|
delete JuncInAndOutList;
|
|
|
|
delete InJunc;
|
|
|
|
delete InSect;
|
|
|
|
delete InRoad;
|
|
|
|
delete JBNet;
|
|
|
|
delete QueryPointsJNet;
|
|
|
|
delete QueryPointsJNetAll;
|
|
|
|
delete QueryPoints1JNet;
|
|
|
|
delete QueryPoints1JNetAll;
|
|
|
|
delete dataSJcar;
|
|
|
|
delete dataMJtrip;
|
|
|
|
delete routeslinej;
|
|
|
|
delete QRlinesj;
|
|
|
|
delete QueryRegionsJNet;
|
|
|
|
delete dataSJcar_Licence_btree;
|
|
|
|
# delete dataMcar_Licence_btree = dataMcar createbtree[Licence];
|
|
|
|
# delete dataMcar_Moid_btree = dataMcar createbtree[Moid];
|
|
|
|
delete dataMJtrip_Moid_btree;
|
|
|
|
delete dataSJcar_BoxNet_timespace;
|
|
|
|
delete dataMJtrip_BoxNet_timespace;
|
|
|
|
delete dataSJcar_BoxNet;
|
|
|
|
delete dataMJtrip_BoxNet;
|
|
|
|
delete dataSJcar_TrajBoxNet;
|
|
|
|
delete dataMJtrip_TrajBoxNet;
|
|
|
|
delete dataMJtrip_SpatioTemp;
|
|
|
|
#delete dataMNtrip_SpatioTempUnits;
|
|
|
|
#delete QueryLicences1;
|
|
|
|
#delete QueryLicences2;
|
|
|
|
# delete QueryPeriods1;
|
|
|
|
# delete QueryInstant1;
|
|
|
|
delete QueryRegions1JNet;
|
|
|
|
################################################################################
|
|
# #
|
|
# Finished Close Database #
|
|
# #
|
|
################################################################################
|
|
|
|
close database;
|
|
|
|
|