城市道路交通事故信息系统空间数据库设计

Spatial database design for urban traffic-accident information system

有效的空间数据库存储结构是实现以集成型数据管理方式为基础的应用系统的关键问题之一,它将决定整个系统的功能和效率。按照为用户的数据视图建模、定义实体及其关系、选择地理表达方式、匹配到Geodatabase元素、组织Geodatabase结构和制定数据库存储方案等六个步骤对城市道路交通事故信息系统之空间数据库进行了规范化设计。设计所得的空间数据库接近于其逻辑数据模型。分析结果表明,该设计方法有利于优化实现城市道路交通事故信息系统的系统功能。

An effective spatial database structure is one of the key issues in developing an information system application based on spatial database management with integrated architecture.It determines the ways of implementing system functions and the efficiency of entire application system.This paper studied spatial database normalization design using a procedure of six steps,including: to model the data in user's view,to define the objects and their relationships,to select geographic representations,to match with Geodatabase elements to organize Geodatabase structure,and to make a storage schema for the spatial database.The obtained spatial database approaches closely to its logical data model.The analysis on the results shows that this design optimizes the implementation of the functions in urban traffic accident information system applications.