| 研究生: |
莊惠雯 Chuang, Hui-Wen |
|---|---|
| 論文名稱: |
物件關連式地理資料庫之設計與建置 Design and Establishment of An Object-Relational Geographic Database |
| 指導教授: |
郭英俊
Kuo, Ying-Jean |
| 學位類別: |
碩士 Master |
| 系所名稱: |
工學院 - 測量工程學系 Department of Surveying Engineering |
| 論文出版年: | 2002 |
| 畢業學年度: | 90 |
| 語文別: | 中文 |
| 論文頁數: | 114 |
| 中文關鍵詞: | 物件關連式資料模型 、地理資訊系統 、資料庫管理 |
| 外文關鍵詞: | Database Management, Object-relational Data Model, Geographic Information Systems |
| 相關次數: | 點閱:110 下載:5 |
| 分享至: |
| 查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統 勘誤回報 |
傳統之GIS通常將空間資料與非空間資料分開管理,空間資料一般以檔案管理系統儲存,非空間資料則利用關連式資料庫系統來管理。近年來,物件導向資料庫管理系統的發展使地理資料的模式化可維持高階語意,且可將空間資料與非空間資料結合在同一資料庫中。然而缺乏標準化的查詢語言卻衍生出資料應用及系統相容上的問題。本研究期以物件關連式資料庫系統結合上述兩大資料庫之優點應用至GIS上,以解決上述問題。
在地理資料庫設計部分,傳統之地理圖形資料儲存以圖層概念為主,將所有地形物依據地形圖資料庫地形資料分類編碼標準,以階層式架構分大類,中類,小類及細類的方式儲存,這樣的儲存方式主要是配合地圖應用上的可彈性選取主題資料之需求,然而它卻破壞了原本地理物件的整體性,並且無法表示出地理物件間的關係,使得資料在查詢及分析應用時,必須撰寫更複雜之程式,費時且無效率。
因此,本研究試圖建立一高階語意的地理物件資料模型做為發展物件關連式GIS應用系統的基礎。主要探討建立地理物件資料模型的一些設計考量,介紹一雙層式之物件資料模型架構,包括地理資料模型以及空間資料模型兩部分,用來將真實世界的地理資料高階語意模式化,明確地表達出地理物件之間的關係,並利用物件關連式資料庫管理系統(ORDBMS)來測試此物件資料模型及管理地理資料。
Traditionally, spatial data and non-spatial data are usually separately managed in geographic information systems. A file management system, is used to store spatial data, and non-spatial data is managed by a relational database system. Recently, the development of object-oriented database management system (OODBMS) makes geographic data modeling possible with high-level semantics, and also combines spatial data and non-spatial data into the same database. However, the lack of standard query language comes to some problems about data application and system compatibility. The research attempts to solve the problems above-mentioned in an object-relational database system (ORDBMS) which integrates the prominent features of RDBS and OODBS.
In designing the geographic database, geographic data was mainly stored underlying the concept of map layers traditionally. Each geographic data is classified into a category with the hierarchy of major, middle, minor and tiny codes, in accordance with a classification scheme defined in a topographic map database. With this arrangement, thematic data can be flexibly retrieved for applications. However, it will break the original geographic object entirety and lose the ability to indicate relationships among geographic objects. Users have to make efforts to write complex computer codes for dealing with data query and analysis. It is rather time-consuming and inefficient.
This paper attempts to establish a geographic object data model with high-level semantics to develop an object-oriented or object-relational GIS. The research mainly discusses the design considerations for constructing a geographic object data model. It introduces a two-tier object data model framework, which includes a geographic data model and a spatial data model, to represent geographic data of the real world in a highly semantic manner and express the relationships among geographic objects in an explicit way, then uses object-relational database management systems (ORDBMS) to test the object data model above-mentioned and manage the geographic data.
邱建豪, 1999. '利用物件導向資料庫系統管理交通網路資料之研究' , 成功大學測量工程研究所碩士論文
郭英俊, 2000. '空間資料模式及資料品質', 地理資料檢索及流通交換研討會講義, Mar., p.149-161.
陳建兆, 1998. '利用物件導向式資料庫系統管理地籍圖形資料之研究', 成功大學測量工程研究所碩士論文
楊正甫, 2000. '物件導向分析與設計'
內政部, 1998. '基本地形圖資料庫地形資料分類編碼表', [網頁資料],
http://ngis.moi.gov.tw/doc/stan/classify..htm
Barton, D., 2002. 'Object Relational Databases' [網頁資料], http://www.computing.surrey.ac.uk/personal/st/D.Barton/CS363/4e-ORDBMS.pdf
Bobrowski, S., 潘得龍(譯), 2000. 'Oracle8i for Windows NT'
Chamberlin, D., 莊濟誠, 藍孝裕(譯), 1997. 'IBM's Object-Relational Database System'
David, B., Raynal, L., Schorter, G. and Mansart, V., 1993. 'Geo2: Why Objects in a Geographical DBMS' , Lecture Notes in Computer Science 693, Abel, D. and Ooi, B. C. (Eds.), Springer-Verlag, Heidelberg, p.264-276.
Fowler, M. and Scott K., 1997. 'UML Distilled: applying the standard object modeling language', Addison Wesley Longman, 179pages.
Karla A. V., Clodoveu A. Davis, Alverto H.F., 2001. 'OMT-G: An Object-Oriented DataModel for Geographic Applications', GeoInformatica 5:3, p221-260.
Khoshafian, S. and Razmik, A.,1995. 'Object Orientation: concepts, languages, databases, graphical user interfaces, standards.', second edition., John Wiley&Sons, 504pages.
Leavitt, N., 2000. 'Whatever happened to Object-Oriented Databases' , Industry Trends, Aug., p.16-19.
McClure, S., 1997. IDC Bulletin #1482E. Aug.
Nayak, S. K., Mishra, M., 2002. 'Object-Relational Database Management Systems: the next generation database' , Department of Computer Science National Institute of Science and Technology Palur Hills, Berhampur, Orissa – 761 008, India.
Object Services and Consulting, Inc., 1997. 'SQL3 Object Model' [網頁資料], http://www.objs.com/x3h7/sql3.htm
Open GIS Consortium, Inc., 1999. 'OpenGIS Simple Features Specification For SQL Revision 1.1' , OpenGIS Project Document 99-049, Release Date: May 5, 1999.
Oracle 8i, 1999. 'concepts', Release 2 (8.1.6), Part No. A76965-01, Dec.
Oracle 9i Application Server Release 2 (v9.0.2), 2002. 'Install FAQ', May.
Oracle Spatial, 1999. 'User’s Guide and Reference', Release 8.1.6, Part No. A77132-01, Dec.
Oracle Technical White paper, 2002. 'Simple Strategies for Complex Data:
Oracle9i Object-Relational Technology', May.
SDTS, 1999. 'the Spatial Data Transfer Standard Information Site', [網頁資料], http://mcmcweb.er.usgs.gov/sdts/index.html
Stoimenov, L., Mitrovic, A., Djordjevic-Kajan, S., Mitrovic, D., 1999. 'Bridge objects and relations: a mediator for an OO front-end to RDBMSs' , Information and Software Technology 41, p.57-66.
Stonbraker, M., 1996. 'Object-Relational DBMSs—The Next Great Wave'
Tang, A. Y., Adams, T. M., Usery E. L., 1996. 'A Spatial Data Model Design for Feature-Based Geographical Information Systems' , IJGIS, Vol. 10, No. 5, p.643-659.
Worboys, M. F.,1994. 'Object-Oriented Approaches to Geo-Referenced Information' , IJGIS, Vol. 8, No. 4, p.385-399.