| The theory of object-oriented modeling for geospatial database management recently gained great attention in the GIS community and started to cast extensive and far-reaching influence on GIS applications in many fields. Specifically, the object-oriented schema supported in Oracle llg Spatial has brought a series of technical innovation in spatial data management. This research explored the Oracle Spatial schema to manage mass floating car trajectory data collected for the purpose of urban transport survey and planning, attempted to optimize the performance of the spatial database, and integrated web-based map publication services into the database itself. The entire procedure of system design and development was introduced, and the theoretical basis and key technologies involved in the development were discussed in details. Finally, the Oracle Maps architecture was implemented using the JavaScript API (AJAX) technology to build a Web2.0map service based prototype system.The following four points can be highlighted as the contribution of this research.(1) A variety of data indexing methods for managing mass FCD point data were compared on the basis of the two-layer spatial query model. The optimal scheme was selected from the comparative analysis.(2) A practical procedure of integrating spatial database and related applications was formalized with respect to the characteristics of specific FCD data applications. The integration spanned regular data management as well as such trajectory-related editing functions for as meta-data management, extraction of feature points, map matching, and trip-oriented segmentation of trajectory.(3) An integrative solution to mass spatial data management and map publishing on one single platform was provided, including the definition and symbolic rendering of spatial objects, database performance optimization, generation of the cache tiles for data retrieval efficiency, and map visualization.(4) A prototype system was developed using the open JavaScript (AJAX) API and Web2.0technology to demonstrate how a features of interest (FOI) database was built from massive floating car GPS data and how the map publishing was done. |
PDF Full Text Request