基于Oracle9i松辽流域水资源管理大型空间数据库的建立方法研究
详细信息    本馆镜像全文|  推荐本文 |  |   获取CNKI官网全文
摘要
论文在分析空间数据库的研究现状、发展趋势及空间数据库建设关键技术的基础上,探讨了松辽流域水资源管理大型空间数据库系统的建立方法。对于松辽流域水资源综合规划、管理和决策数据平台建设以及提高松辽流域水资源管理的信息化水平具有重要意义。
    论文实现了基于Oracle Spatial空间数据库和MapX组件技术的各项主要功能开发(包括数据输入与编辑、空间检索与查询、统计分析、空间分析、决策分析、数据输出等);解决了海量空间数据与属性数据的无缝集成、查询检索,空间数据完整性、一致性维护,分布式数据处理与维护、事务处理,制图和数据安全性控制等问题。
    全文共分为五部分,第一章阐述空间数据库管理系统的研究现状、发展趋势,以及松辽流域水资源管理大型空间数据库建设的目标和意义,并说明本研究的数据资料来源和工作路线。第二章综述大型空间数据库建设的关键技术(包括海量空间数据集成管理、矢栅一体化技术、多源空间数据无缝集成、空间数据库引擎、空间数据的多重表达等)。第三章介绍本文的研究区域——松辽流域的自然及社会经济概况。第四章研究基于Oracle9i Spatial建立松辽流域空间数据库的方法,包括松辽流域空间数据库元数据管理、空间数据的访问、空间索引以及空间数据的组织等。第五章进行松辽流域水资源管理空间数据库系统开发研究,包括数据库准备,数据采集、编码、上载,空间数据库配置,系统功能实现等。最后提出本文的研究结论。
The thesis analyses firstly the research status, development trend and key construction technology of spatial database. Then the construction methods of Water Resource Management Large Spatial Database System for Song-Liao River Basin are discussed. This study is important for Song-Liao River Basin water resource comprehensive plan, management, decision-making data construction and significant for the improvement of Song-Liao River Basin water resource information management level.
    Based on “Oracle spatial” and “MapX”, the thesis achieves main function exploitation of the system, including data import and edit, spatial searches and query, statistic analysis, spatial analysis, decision-making analysis, data export and etc. The thesis also resolves a series of questions such as seamless integration of huge spatial data and attribute data, query and searches, spatial data maintenance of integrality and coherence, distributed data process and maintenance, transaction processing, cartography, data security control and so on.
    The thesis is divided into five chapters as follows: The first chapter introduces the research status and development trend of spatial database management system, explains the construction aim and significance of Song-Liao River Basin Water Resource Management Large Spatial Database System, shows the source of the data and materials using in the study, and demonstrates the work flow. The second chapter summarizes the key technologies of large spatial database construction, including huge spatial data integration management, vector and grid data integrating method, seamless integration of many source spatial data, spatial database engine, spatial data multiple representation and etc. The third chapter introduces the study area, including its nature environment and social economic development. The forth chapter studies the construction methods of Song-Liao River Basin spatial database based on “Oracle9i Spatial”, including Song-Liao River Basin spatial database metadata management, spatial data accessing, spatial index, spatial data organization and so on. The fifth chapter discusses the development methods of Song-Liao River Basin Water Resource Management Large Spatial Database System, including database preparation, data collection, encode, uploading, spatial database configuration, system function realization and so on. At last the research conclusion of this thesis is stated.
引文
[1] 吴信才.地理信息系统的基本技术与发展动态[J].地球科学,1998,23(4):329.
    [2] 周斌,杨柏林,汪红强,等.贵州省土壤信息系统空间数据库的设
    计与建立[J].地质地球化学,2000,28(1):68~71.
    [3] 杨春成,张清浦.Oracel8i新特性及其在空间数据库实现中的应用[J].测绘学院学报,2002,19(4):296~299.
    [4] 潘瑜春,钟耳顺,梁军. 基于空间数据库技术的地籍管理系统研究[J]. 地理研究,2003,22(2):237~244.
    [5] 朱光,季晓燕,戎兵.地理信息系统基本原理及应用[M].北京:测绘出版社,1997.70~82.
    [6] 陈晟等.空间数据库实例分析[J].计算机工程与应用,1998,(9):1~5.
    [7] Hanan Samet.Applications of Spatial Data Strcutures. Addison-
    wesley Publishing Company,1990.
    [8] 刘仁义,刘南,苏国中.基于RDBMS的空间数据管理模型及在土地产权产籍系统中的实现[J].中国图象图形学报,2000,5A(10):825~829.
    [9] Goodchild M F.Tiling Large Geographical Databases.In:Buchmann A,Güther O,Smith T R,Wang YF,eds.Design and Implementation of Large Spatial Databases.New York:Springer-Verlag,1990.137~146.
    [10] 於建峰,吴正升.面向对象数据库技术及其在空间信息系统中的应用[J]. 海洋测绘,2003,23(2):13~16.
    [11] 王映辉.基于ORDB的GIS空间数据组织与实现[J]. 计算机工
    程与应用,2003,4:45~47.
    [12] 毛锋.地理信息系统建库技术及应用.科学出版社,1999.
    [13] 陈晟.GIS空间数据库基础技术研究[D].博士学位论文,长沙:
    
    
    国防科技大学电子工程学院,1998.
    [14] 邬伦,张毅.分布式多空间数据库系统的集成技术[J]. 地理学与国土研究,2002,18(1):6~10.
    [15] 杨成韫,荣芳,彭子风.基于客户/服务器结构的空间数据分布式处理研究[J].计算机工程与应用,2001;37(8):87~89.
    [16] 王珊,陈红.数据库系统原理教程.北京:清华大学出版社,1998.
    [17] 郑振楣,于戈,郭敏.分布式数据库[M].北京:科学出版社,1998.
    [18] 张立峰.基于空间数据库的多媒体图形信息查询系统研究[J].地理研究,2002,21(3):365~370.
    [19] Stonebraker M.The integration of rule systems and database systems.IEEE Transactionon Knowledg eand Data Engineering,1992,4(5):415~423.
    [20] 唐新明,吴岚.时空数据库模型和时间地理信息系统框架[J].遥感信息,1999,1:4~8.
    [21] 张兵,张荣肖,潘玉平.联邦数据库系统[J].计算机系统应用,1995,1:50~54.
    [22] 冯玉才.数据库系统基础(第二版)[M].武汉:华中理工大学出版社,1997.
    [23] 谢榕.地理信息系统中空间数据库建立的关键技术[J].北京测绘,1998,(4):2~5.
    [24] 田增平,周傲英,施伯乐.地理信息系统中的数据库技术[J].计算机科学,1995,22(6).
    [25] Shepherd I D H.Information integration and GIS[A].In:Maguire D J,Goodchild M F,Rhind D W,eds.Geographical Information Systems:Principles and Application Vol2 [C].London: Longman,
    1991.337~360.
    [26] Martin D,Bracken I.The integration and socioeconomic and physical resource data for applied land management information systems[J].
    Applied Geography,1993,13:45~53.
    [27] Bolstad P V,Gessler P,Lilles and TM.Positional uncertainty in
    
    
    manually digitized map data[J].Int J Geographical Information Systems,1990,4:399~412.
    [28] Goodchild M K,Guooing S,Shiren Y.Development and test of an error model for categorical data[J].Int J Geographical Information Systems,1992,6:87~104.
    [29] Fisher P E.Algorithm and implementation uncertainty in view shed analysis[J].Int J Geographical Information Systems,1993,7:331~347.
    [30] Heuvelink G B M,Burrough P A.Error propagation incartographic modeling using Boolean logical and continuous classification[J].Int J Geographical Information Systems,1993,7:231~246.
    [31] Veregin H.Developing and testing of an error propagation model for GIS overlay operation[J].Int J Geographical Information Systems,1995,9:595~619.
    [32] LagacherieP,Holmes S.Addressing geographical data errors in a classification tree for soil unit prediction[J].Int J Geographical Information Systems,1997,11:183~198.
    [33] Dan Lee.An ideal means for multiple GIS data transformation and represents[J].Proceedings of the Third Workshop on Geographical Information System[C].Beijing:Surveying Publishing House,1993,(1):66~79.
    [34] Kinder D B,Jones C B.A Deductive object-oriented GIS for handling multiple representations[A].In:Waugh T C,Healey R G,eds.Advances in GIS:Proceedings of the Sixth International Symposium on Spatial Data Handling[C].London:Taylor and Francis.1996.882~900.
    [35] Jones C B,Kidner D B,Luo L Q,etal.Database design for multi-scale spatial information system[J].Int J Geographical Information Systems,1996,10:901~920.
    [36] Shiryaev E E.Computers and the Representation of Geographical
    
    
    Data[M].Londan:John Weiley & Sons,1987.1~11.
    [37]Vckovski A.Digital representation of continuous random fields[A].In:Craglia M,CouclelisH,eds.Geographic Information Research[C].Londan:Taylor & Francis,1997.382~396.
    [38]Howlding S W.3D geoscience Modeling-Computer Techniques for Geological Characterization[M].Berlin:Springer,1994.71~86.
    [39]Rhind D.Data accessing,charging and copyright and their implications for geographical information systems[J].Int J Geographical Information Systems,1992,6(1):13~30.
    [40]Kidner D B.Geometric signatures for determining polygon equivalence during multi-scale GIS update[A].In:Geographical Information.Second Joint European Conference & Exhibition on Geographical Information[C].Barcelona,Spain:ISO Press,1996.238~247.
    [41]Bruegger B,Frank A.Hierarchies over topological data structures[A].Proceedings of the ASPRS-ACSM Annual Convention[C].Baltimore,M D,1989.137~145.
    [42] Frank A U,Timpf S.Multiple representations for cartographic objects in a multi-scaletree-an intelligent graphical zoom[J].Computer Graph,1994,18:823~829.
    [43] Puppo E,Dettori G.Towards a formal model for multi-resolution spatial maps[A].Proceedings of the 4th International Symposium on Large Spatial Database[C].Portland,Maine,1995.
    [44]Leila de Floriani.Multi-resolution modelling in geographical information systems[A].In:David Parkered eds.Innovation in GIS[C].Londan:Taylor & Francis,1996.9~19.
    [45] 杨树强,陈火旺,王峰.矢量和栅格一体化的数据模型[J].软件
    学报,1998,9(2):91~96.
    [46] 谈国新.一体化空间数据结构及其索引机制[J].测绘学报,1998,27(4):293~299.
    
    [47] 叶为民,张玉龙,朱合华,李元海.地理信息系统中的栅格结构与矢量结构[J].同济大学学报(自然科学版),2002,30(1):101~105.
    [48] Open GIS Consortium,Inc.Open GIS OR Simple Features Specification For SQL Revision1.0 Release Date:13 March,1998.
    [49] 钟耳顺,王康弘,宋关福等.GIS多源数据集成模式评述[A].中国GIS年会(深圳)论文集[C],1999.
    [50] 李军,费川云.地球空间数据集成研究概况[J].地理科学,2000,(7):18~26.
    [51] 宋关福,钟耳顺,刘纪远,等.多源空间数据库无缝集成研究[J].地理科学进展,2000,19(2):110~115.
    [52] 李清文.面向组件的空间数据库引擎的研究与实现[D].北京:北京工业大学,1999.
    [53] Bobrowski S M ORACLE与客户/服务器计算技术从入门到精通.刘建元译.北京:电子工业出版社,1996.
    [54] 方起兴.CLIENT/SERVER计算.计算机世界报,1994.6.15.
    [55] 夏启斌.空间数据库引擎的设计与实践[D].郑州:信息工程大学测绘学院,2002,6.
    [56] Environment Systems Research Institute.INC:Spatial Database Engine,ESRI White Paper[R/OL] http://www.esri.com,1998,4.
    [57] 方涛,龚健雅,李德仁.影像数据库建立的若干关键技术.武汉测绘科技大学学报,1997,22(3):266~269.
    [58] 李滨,王青山,冯猛.空间数据库引擎关键技术剖析测[J].绘学院学报,2003,20(1):35~38.
    [59] Siva Ravada.Handle Geo Referenced Images In Oracle Database.
    Paper of ISPRS,2000.
    [60] Robert West.Understanding ArcSDE[M].GIS by ESRI,2001.
    [61] Egenhofer M J,Eliseo Clementini,Paolino Di Felice.Evaluation incons is tencies am ong multiple representations[A].Advances in
    
    
    GIS Research:Proceedings of the Sixth International Symposium on Spatial Data Handling[C].Waugh T C,Healey G(ed.).Published by Taylor & Francis,1994.
    [62] Kidner D B,Jones C B.A Deductive Object-oriented GIS for handling multiple representations[A].Advances in GIS Research:Proceedings of the Sixth International Symposium on Spatial Data Handling[C].
     Waugh T C,Healey R G(ed.).Published by Taylor & Francis,1994.
    [63] Adrijana Car,Andrew Frank.General principles of hierarchical spatial reasoning-Thecase of Way-finding[A].Advances in GIS Research:
    Proceedings of the Sixth International Symposium on Spatial Data Handling[C].Waugh T C,Healey R G(ed.).Published by Taylor &
    Francis,1994.
    [64] Tang E S K.Investigate the objected-Oriented Approach to Modeling the Cartographic Data and Cartographic Generalization Process[M].
    Proceedings of Geo-Informatics'95 Hong Kong,published By Chung
    Chi College,1995.
    [65] Dimitris Papadias,Marinos Kavouras.Acquiring,representing and processing spatial relationships[A].Advances in GIS Research:
    Proceedings of the Sixth International Symposium on Spatial Data Handling[C].Waugh T C,Healey R G(ed.).Published by Taylor &
    Francis,1994.
    [66] Martinez J,Molenaar A.Aggregation hierarchies for multiple scale representations of hydrographic networks[M].Proceedings of 17th ICA Conference,Barcerona,1995.
    [67] Kilpelainen T.Requirements of a multiple representation database for a topographical data with emphasis incremental generalization[M] .
    Proceedings of 17th ICA Conference,Barcerona,1995.
    [68] Peter Van Oosterom,Vincent Schenkelaars .The development of an interactive Multi-scale GIS, INT[J]. Geographical Information Systems,1995,9(5).
    
    [69] Govorov M.Representation of the generalized data structures for multi-scale GIS[M].Proceedings of 17th ICA Conference, Barcerona,1995.
    [70] Woodsford P.Objected-Orientation,Cartographic Generalization and multi-product databases[M].Proceedings of 17th ICA Conference,
    Barcerona,1995.
    [71] Timp f S,Frank A U.Amulti-scale datastructure for cartographic review[M].Proceedings of 17th ICA Conference,Barcerona,1995.
    [72] 齐清文,张安定.关于多比例尺GIS中数据库多重表达的几个问题的研究[J]. 地理研究,1999,2:161~170.
    [73] Buttenfield B P.Multiple Representations[M].NCGIA Research Initiative 3,1993.
    [74] 白花琴,赵琳,王振宝.松辽流域2001年水资源分析[J].东北水利水电,2003,1:21~23.
    [75] 于洪民,赵万智.松辽流域水利可持续发展对策[J].东北水利水电,2003,1:18~19.
    [76] 牟志录,马爱茹,于红,付贵林.松辽流域洪涝灾害及特点[J].东北水利水电,1995,5:33~42.
    [77] 齐玉亮,赵立华,迟鹏超.松辽流域水资源管理工作回顾[J].东北水利水电,1999,183(10):34~36.
    [78] John Adolph Palinsk.ORACLE8数据库构造工具[M].北京:机械工业出版社.
    [79] Oracle8完全参考手册[M].
    [80] David Austin著.Oracle8使用指南[M].
    [81] 李滨,王青山,赵家强.Oracle数据库空间数据插件技术初探[J].测绘学院学报,2002,19(1):45~49.
    [82] 瓮正科,王新英.Oracle8.X for Windows NT实用教程:北京:清华大学出版社,1999.
    [83] 潘农菲.基于Oracle Spatial的GIS空间数据处理及应用系统开发[J].计算机工程,2002,28(2):278~280.
    
    [84] Kevin Loney.ORACLE8数据库管理员手册[M].北京:机械工业出版社.
    [85] MapX Reference Guide.MapInfoCorportion.
    [86] MapX Develop's Guide.MapInfoCorportion.
    [87] MapX Online Help.MapInfoCorportion.
    [88] 戴技才,刘南,刘仁义.OO4O对Oracle 9i Spatial的空间数据访问及管理[J].计算机应用研究,2003,(6):39~40.
    [89] Oracle Corporation.Oracle Spatial8.1.6Documentation[A].User’s Guide and[Z].2000,9.
    [90] 曹云刚,范东明.Oracle Spatial在GIS中的应用[J].四川测绘,2002,25(4):167~173.
    [91] [美]Michael Abbey,Michael Corey,Ian Abramson著.王海峰,莫伟锋,等译.Oracle9i初学者指南.机械工业出版社,2002.3.
    [92] 胡欣杰.Oracle9i数据库管理员指南(V9.0.1).北京:希望电子出版社,2002.4.
    [93] 史森,夏丽丽等译.Oracle数据库开发指南[M].清华大学出版社,1998.
    [94] Paul J.Fortier等著.Database Systems Handbook[M].
    [95] 高旭,袁翔.Oracle远程数据库访问技术及实现[J].计算机工程与应用,2001,22:107~108.
    [96] 张剑平,任福继,叶荣华等.地理信息系统与MapInfo应用[M].北京:科学出版社,1999.
    [97] 胡来林.MapX构件简介及在开发GIS软件中的运用[J].微型电脑应用,2002,18(5):32~35. 
    [98] MapInfo通用技术白皮书[R].北京:北大方正,2000.
    [99] MAPX45_DevGuide[OL].MapInfo Corporation(http://www.
    mapinfo.com/),2000.
    [100] 范大凯,吴健平.基于MapX的GIS应用开发实例[J].东北测绘,2001,24(2):31~35.                               
    [101] 张凡,吕汉兴.使用MapX组件实现地理图形与数据库的结合
    
    
    [J].计算机应用研究,2000,(10):4~6.
    [102] 林春,王波,贺贵明.利用MapX实现的组件式GIS技术[J].计算机工程,2002,28(5):216~218.
    [103] 谢仕义.基于MapX的COM GIS技术研究及实现[J].计算机应用研究,2003,(5):51~54.
    [104] 王德文.组件式地理信息系统的研究与应用[J].信息技术,2002,(8):41~44.                          
    [105] 王利军.Oracle Spatial Cartridge在土地利用规划管理信息系统中的应用[J].中国GIS 2001年会论文集,2001.
    [106] 程彬.ORACLE 8i Spatial空间数据仓库空间数据特性简析[J].电脑开发与应用,2002,15(9):6~7.

© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号

地址:北京市海淀区学院路29号 邮编:100083

电话:办公室:(+86 10)66554848;文献借阅、咨询服务、科技查新:66554700