Speaker: Ping-Lin Chang Research Center for Information Technology Innovation Academia Sinica

Project Report and Hand Over Speaker: Ping-Lin Chang Research Center for Information Technology Innovation Academia Sinica 2009/08/03

Outline Introduction PaPaGo!SDK GIS Database ROAD Framework Conclusions Research Center for Information Technology Innovation, Academia Sinica

Introduction • The work is separated into two parts • ROAD framework for LDSQ • efficient object search algorithms for various queries • incremental update techniques for framework maintenance in presence of object and network changes • PaPaGo!SDK • for comparing purpose • acquiring 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 Sinica

Introduction • Estimate of the respective progresses • 10% for ROAD framework • yet any programming but infrastructure building and materials survey • 90% for PaPaGo!SDK • remains works of data transforming into GIS database Research Center for Information Technology Innovation, Academia Sinica

PaPaGo!SDK • Newer evaluation version • can be downloaded from the website • http://www.papagosdk.com • restriction • cannot read the newest 2009 map file (.g15) • only 500 scene spots can be retrieved • demo • Older evaluation version • appended CD from the book • PaPaGo!SDK GIS系統建置理論與實務 • restriction • can only read order map file (.nv5) • demo Research Center for Information Technology Innovation, Academia Sinica

PaPaGo!SDK • Details • COM model for direct usage of APIs • please refer to the book, “PaPaGo!SDKGIS系統建置理論與實務” • only for windows programming (i.e., Visual C++ and Visual Basic) • sample code is programmed in Win32 API • please refer to the book, “Programming Windows, Fifth Edition” • entire scene spots acquiring • use FindByLocation( nGisX, nGisY, nRange); • please refer to an article, “http://kuso.us/blog/archives/109” Research Center for Information Technology Innovation, Academia Sinica

GIS Database • Raw map data • 交通部運輸研究所路網數值圖97年版 • from GIS center of Academia Sinica • shape file format (shp, shx, dbf) • a GIS database is necessary • PostgreSQL 8.3 • with PostGIS module • abundant functions for managing GIS database • demo • Quantum GIS • provides GIS data viewing, editing, and analysis capabilities • demo Research Center for Information Technology Innovation, Academia Sinica

ROAD Framework • Implementation of the paper • K. 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, 2009 • Main framework • Original paper exploits CCAM to organize network nodes in storage • we use PostgreSQL with PostGIS instead • Route Overlay and Association Directory (ROAD) • principle concepts • Rnets, shortcuts, and object abstracts • overview can be referred to my previous presentation Research Center for Information Technology Innovation, Academia Sinica

ROAD Framework Rnet hierarchy Research Center for Information Technology Innovation, Academia Sinica

ROAD Framework Route Overlay (RO) Research Center for Information Technology Innovation, Academia Sinica

ROAD Framework Association Directory (AD) Research Center for Information Technology Innovation, Academia Sinica

ROAD Framework • Rnet hierarchy building • network partitioning • the original paper uses KL algorithm, which is one of the early fundamental works in the field • performance is O(N^2), so it is no longer commonly used • METIS - Family of Multilevel Partitioning Algorithms • library for the implementation of the state of the art • http://glaros.dtc.umn.edu/gkhome/metis/metis/overview Research Center for Information Technology Innovation, Academia Sinica

ROAD Framework • ROand AD data structure • implemented by the description in the paper • stored in database • the table should be designed correspondingly • Search algorithms • should be easier than implementing the ROAD data structure • just follow the pseudo in the paper • Road network updating • should be considered in the future Research Center for Information Technology Innovation, Academia Sinica

Conclusions • The ROAD data structure is the point of the project • next step is to build the un-direction graph for network partition • utilize the existing API directly • store partitioned Rnets • Rnet hierarchy need to be stored at the beginning for building the ROAD data structure • build ROAD data structure, meanwhile, design the corresponding tables for storing the data structure • this part should be implemented carefully since it is the infrastructure for the search algorithms • implement the search algorithms • kNN query and range query • design the demo • map provider maybe also an issue Research Center for Information Technology Innovation, Academia Sinica

Speaker: Ping-Lin Chang Research Center for Information Technology Innovation Academia Sinica