Distributed Spatial Data Sharing with Database View Mechanism

摘要

With the snapshot-based method of sharing large-scale spatial data in a distributed database system, much storage resources are wasted to copy remote spatial data. A view-based sharing method is proposed to solve this problem. This method has two main steps. First, a local view is created based on a remote spatial table. Then, an instead-of trigger for modifying each row is set up on the view and coded to enable the view to be modified. The local access to remote spatial data is avaible based on the expended view-modifying function and the view- selecting function directly from Database Management System(DBMS). An application based on Oracle validates the feasibility of the view-based data sharing mechanisim.