Recently, attention has been focused on spatial query language which is used to query spatial databases. A design of spatial query language has been presented in this paper by extending the standard relational databas...Recently, attention has been focused on spatial query language which is used to query spatial databases. A design of spatial query language has been presented in this paper by extending the standard relational database query language SQL. It recognizes the significantly different requirements of spatial data handling and overcomes the inherent problems of the application of conventional database query languages. This design is based on an extended spatial data model, including the spatial data types and the spatial operators on them. The processing and optimization of spatial queries have also been discussed in this design. In the end, an implementation of this design is given in a spatial query subsystem.展开更多
In this paper,an overview of phases for modelling and mapping third dimension of spatial objects in a database is presented based on a selected spatial database management system(DBMS).These phases include(1)defining ...In this paper,an overview of phases for modelling and mapping third dimension of spatial objects in a database is presented based on a selected spatial database management system(DBMS).These phases include(1)defining a spatial reference system for representing three-dimensional(3D)objects with real-world coordinates,(2)geometric modelling of 3D objects in the database,(3)3D spatial indexing for fast accessing/querying the 3D data,3D spatial queries and representation of 3D data.Then,a case study is performed to assess needs,possibilities and potential limitations of 3D data modelling in the spatial database.展开更多
地学数据具有结构复杂、多尺度、数据量大的特点.将多源地学数据库集成在同一操作平台与数据库中进行分析使用,使用传统的空间数据储存方法有一定的难度.采用大型数据库系统Oracle 9 i Spatial构建地学空间数据库方法,提供了建立空间数...地学数据具有结构复杂、多尺度、数据量大的特点.将多源地学数据库集成在同一操作平台与数据库中进行分析使用,使用传统的空间数据储存方法有一定的难度.采用大型数据库系统Oracle 9 i Spatial构建地学空间数据库方法,提供了建立空间数据库的实例与应用程序访问空间数据库方法.实践表明,采用Oracle Spatial构建多源地学空间数据库具有空间数据格式统一、数据安全性高、数据存储量大的优点.展开更多
基金This work is supported by the National High Technology Research and Development Program ofChina(2 0 0 2 AA135 2 30 ) and the Major Project of National Natural Science Foundation of Beijing(4 0 110 0 2 ) .
文摘Recently, attention has been focused on spatial query language which is used to query spatial databases. A design of spatial query language has been presented in this paper by extending the standard relational database query language SQL. It recognizes the significantly different requirements of spatial data handling and overcomes the inherent problems of the application of conventional database query languages. This design is based on an extended spatial data model, including the spatial data types and the spatial operators on them. The processing and optimization of spatial queries have also been discussed in this design. In the end, an implementation of this design is given in a spatial query subsystem.
基金This research project was supported by the Scientific Research Projects Programme established under the Karadeniz Technical University(number:2008.112.006.1).
文摘In this paper,an overview of phases for modelling and mapping third dimension of spatial objects in a database is presented based on a selected spatial database management system(DBMS).These phases include(1)defining a spatial reference system for representing three-dimensional(3D)objects with real-world coordinates,(2)geometric modelling of 3D objects in the database,(3)3D spatial indexing for fast accessing/querying the 3D data,3D spatial queries and representation of 3D data.Then,a case study is performed to assess needs,possibilities and potential limitations of 3D data modelling in the spatial database.
文摘地学数据具有结构复杂、多尺度、数据量大的特点.将多源地学数据库集成在同一操作平台与数据库中进行分析使用,使用传统的空间数据储存方法有一定的难度.采用大型数据库系统Oracle 9 i Spatial构建地学空间数据库方法,提供了建立空间数据库的实例与应用程序访问空间数据库方法.实践表明,采用Oracle Spatial构建多源地学空间数据库具有空间数据格式统一、数据安全性高、数据存储量大的优点.
