1

Speaker: Ping-Lin ChangResearch Center for Information Technology Innovation Academia Sinica2009/08/03Project Report and Hand Over1OutlineIntroductionPaPaGo!SDKGIS DatabaseROAD FrameworkConclusionsResearch Center for Information Technology Innovation, Academia Sinica2OutlineIntroductionPaPaGo!SDKGIS DatabaseROAD FrameworkConclusionsResearch Center for Information Technology Innovation, Academia Sinica3IntroductionThe work is separated into two partsROAD framework for LDSQefficient object search algorithms for various queriesincremental update techniques for framework maintenance in presence of object and network changesPaPaGo!SDKfor comparing purposeacquiring the objects (i.e., scene spots) from map provided by PaPaGo!thus we can compare the performance of kNN query based on the same object set

Research Center for Information Technology Innovation, Academia Sinica44IntroductionEstimate of the respective progresses 10% for ROAD frameworkyet any programming but infrastructure building and materials survey90% for PaPaGo!SDKremains works of data transforming into GIS databaseResearch Center for Information Technology Innovation, Academia Sinica5OutlineIntroductionPaPaGo!SDKGIS DatabaseROAD FrameworkConclusionsResearch Center for Information Technology Innovation, Academia Sinica6PaPaGo!SDKNewer evaluation versioncan be downloaded from the websitehttp://www.papagosdk.comrestrictioncannot read the newest 2009 map file (.g15)only 500 scene spots can be retrieveddemoOlder evaluation versionappended CD from the bookPaPaGo!SDK GISrestrictioncan only read order map file (.nv5)demo

Research Center for Information Technology Innovation, Academia Sinica7PaPaGo!SDKDetailsCOM model for direct usage of APIsplease refer to the book, PaPaGo!SDK GISonly for windows programming (i.e., Visual C++ and Visual Basic)sample code is programmed in Win32 APIplease refer to the book, Programming Windows, Fifth Editionentire scene spots acquiringuse FindByLocation( nGisX, nGisY, nRange );please refer to an article, http://kuso.us/blog/archives/109Research Center for Information Technology Innovation, Academia Sinica8OutlineIntroductionPaPaGo!SDKGIS DatabaseROAD FrameworkConclusionsResearch Center for Information Technology Innovation, Academia Sinica9GIS DatabaseRaw map data97 from GIS center of Academia Sinicashape file format (shp, shx, dbf)a GIS database is necessaryPostgreSQL 8.3with PostGIS moduleabundant functions for managing GIS databasedemoQuantum GISprovides GIS data viewing, editing, and analysis capabilitiesdemoResearch Center for Information Technology Innovation, Academia Sinica10OutlineIntroductionPaPaGo!SDKGIS DatabaseROAD FrameworkConclusionsResearch Center for Information Technology Innovation, Academia Sinica11ROAD FrameworkImplementation of the paperK. C. K. Lee, W.-C. Lee, andB. Zheng, Fast Object Search on Road Networks, proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, volume 360, pages 1018-1029, Saint Petersburg, Russia, March 24-26, 2009Main frameworkOriginal paper exploits CCAM to organize network nodes in storagewe use PostgreSQL with PostGIS insteadRoute Overlay and Association Directory (ROAD)principle conceptsRnets, shortcuts, and object abstractsoverview can be referred to my previous presentation

Research Center for Information Technology Innovation, Academia Sinica12ROAD FrameworkRnet hierarchyResearch Center for Information Technology Innovation, Academia Sinica13

ROAD FrameworkRoute Overlay (RO)Research Center for Information Technology Innovation, Academia Sinica14

ROAD FrameworkAssociation Directory (AD)Research Center for Information Technology Innovation, Academia Sinica15

ROAD FrameworkRnet hierarchy buildingnetwork partitioningthe original paper uses KL algorithm, which is one of the early fundamental works in the fieldperformance is O(N^2), so it is no longer commonly usedMETIS - Family of Multilevel Partitioning Algorithmslibrary for the implementation of the state of the arthttp://glaros.dtc.umn.edu/gkhome/metis/metis/overview

Research Center for Information Technology Innovation, Academia Sinica16ROAD FrameworkRO and AD data structureimplemented by the description in the paperstored in databasethe table should be designed correspondinglySearch algorithmsshould be easier than implementing the ROAD data structure just follow the pseudo in the paperRoad network updatingshould be considered in the future

Research Center for Information Technology Innovation, Academia Sinica17OutlineIntroductionPaPaGo!SDKGIS DatabaseROAD FrameworkConclusionsResearch Center for Information Technology Innovation, Academia Sinica18ConclusionsThe ROAD data structure is the point of the projectnext step is to build the un-direction graph for network partitionutilize the existing API directlystore partitioned RnetsRnet hierarchy need to be stored at the beginning for building the ROAD data structurebuild ROAD data structure, meanwhile, design the corresponding tables for storing the data structurethis part should be implemented carefully since it is the infrastructure for the search algorithmsimplement the search algorithmskNN query and range querydesign the demomap provider maybe also an issue

Research Center for Information Technology Innovation, Academia Sinica19