: 653 周晓光 1 2, 陈军 1., 410083 2., 100044 摘要 :, ( 12 ) TGIS ( ) Oracle Spatial, VC++, 关键词 :,,, 中图分类号 : P208 文献标识码 : A 1 ( &, 1998),, ( &, 1998; Worboys, 1995; Raza, 2001) (Worboys, 1995; Raza, 2001), GIS, (Temporal Geographic Information System, TGIS), Worboys(1995) GIS 3 Claramunt Theriault(1995), 5 ;Badard(1999) 8 ( ) Raza(2001) 4 Hornsby Egenhofer(2000) 9, 18, 3 (1), Worboys 3 (2), Raza Claramunt and Theriault Badard (3) (identity-based changes), Hornsby Egenhofer 9 (Spatio-Temporal Database, STDB), 收稿日期 : 2007-09-27; 修订日期 : 2008-09-05 基金项目 : ( : 40571122); ( : 2006BAJ09B02) 第一作者简介 : (1969 ),,,, E-mail: zhouxiaog@gmail.com
654 Journal of Remote Sensing 遥感学报 2009, 13(4) ( ), ( ),, ( ),, ORACLE, ORACLE Oracle Object for OLE, VC++ 1 2 TGIS, 2000, (Couclelis, 1998) 1995 Claramunt Theriault 8 (Claramunt & Thèriault, 1995), TGIS ( ), 9 (Zhou, 2004), 1, X X={appearance, disappearance, stability, expansion, contraction, deformation, move, rotation, reappearance} (1) Hornsby Egenhofer(2000), (non-existence with history) (non-existence without history)3, ( 2 (a)) ( 2(b)) ( 2(c)) ( 2(d)) ( 2(e)) ( 2(f)) ( 2(g)) ( 2(h)) (continue non-existence with history), 2(i)) 9 2 2 (a) (continue non-existence without history),,, (continue non-existence) (continue non-existence with history) Y Y={create, recall, destroy, continue existence, eliminate, forget, reincarnate, continue non-existence} (2) X Y, X, Y, X Y, ( ) ( ) 3 9 ( 3)
: 655 3 3,, (appearance) (create) (disappearance) (eliminate), (, 1979), f X Y, X, Y, X Y, X Y f X Y f X Y ={ appearance, create, disappearance, eliminate, stability, continue-existence, expansion, continue-existence, contraction, continue- existence, deformation, continue-existence, move, continueexistence, rotation, continue-existence, reappearance, reincarnate } (3) 3, X { (stability), (expansion), (contraction), (deformation), (move), (rotation)} Y { (continue existence)}, { (expansion), (contraction), (deformation), (move), (rotation)},,, (geometricalchange),, f X Y f X Y ={ appearance, create, disappearance, eliminate, stability, continue-existence, geometrical-change, continue-existence, reappearance, reincarnate } (4) f X Y, Y {destroy, forget, recall, continue non-existence} X Y, recall continue non-existence, recall,,, Y recall continue non-existence, recall continue non-existence { (appearance), (disappearance), (reappearance), (stability), (geometrical-modification)} (supplement), {s-appearance, s-disappearance, s-reappearance, s-stability, s-geometrical-change}, 4 X X ={appearance, disappearance, stability, geometrical-change, reappearance, s-appearance, s-disappearance, s-stability, s-geometrical-change, s-reappearance} (5) Y (1), f X Y f X Y ={ appearance, create, disappearance, eliminate, stability, continue-existence, geometrical-change, continue-existence, reappearance, reincarnate, s-appearance, recall, s-disappearance, continue non-existence, s-stability, continue non-existence, s-geometrical-change, continue non-existence, s-reappearance, continue non-existence } (6)
656 Journal of Remote Sensing 遥感学报 2009, 13(4) 5 4,, X Y, 4 4.1 3 4 (5) (6) X Y, Y destroy( ) forget( ) X destroy( ) forget( ), destroy( ), forget( ), f X Y 5 5, create, delete, semantic-modify, geometrical-modify, reincarnate, recall, s-delete, s-semantic-modify, s-geomet rical- modify, s-reincarnate 10, destroy forget 2 ( ), 12 4.2 ( ),, [starttime. end-time], {(start-time, end-time) start-time end-time}, [start-time. *], [start-time, end-time] 12 新建 (create), [starttime,*] 存档 (delete), [start-time, end-time] 语义信息修改 (semantic-modify), [start-time, end-time],,, 空间信息修改 (geometrical-modify), [start-time, end-time],,,
: 657 唤醒 (reincarnate), [start-time,*] 忆起 (recall), [start-time, end-time] 历史对象存档 (s-delete) end-time 历史对象语义信息修改 (s-semantic-modify), [start-time, endtime],,,, 历史对象空间信息修改 (s-geometrical-modify) end-time,,,, 历史对象的唤醒 (s-reincarnate), [start-time, end-time] 清除 (destroy),, ( ),, 忘记 (forget), ( ) TGIS TGIS ( ) Claramunt Theriault production, reproduction, transmission Badard splitting, merging, production delete create 5 5.1, Oracle Spatial DB2 Spatial extender Informix Spatial datablade, GIS Oracle, Oracle Oracle, Insert, Update, Delete 3 DML Oracle Object for OLE Odatabase ExecuteSQL, VC ORACLE SQL (Oracle Corporation, 2003a, 2003b) ExecuteSQL insert, update, delete, (1) ExecuteSQL insert mydb. ExecuteSQL( insert into * values( ) ) mydb Odatabase, (2) ExecuteSQL update endtime mydb.executesql( update * set endtime = TODATE(, MM/DD/YYYY ) where ) (3) ExecuteSQL delete mydb.executesql( delete from * where ) Create, Delete Create insert Delete update endtime Destroy delete Semantic-modify, Geometrical-modify update insert Reincarnate insert, select 3 DML,,
658 Journal of Remote Sensing 遥感学报 2009, 13(4) 5.2, 6 TGIS ( ),, 12 Oracle Spatial ( Oracle Spatial ) REFERENCES 6 6(a), (b), A B A, b c m, e f n, C, (Zhou, 2004) 6 m, n B, b, c, e, f, g A A C C create (m), create (n) delete (B), delete (b), delete (c), delete (e), delete (f), delete (g) geometrical-modify (A A ) semantic-modify (C C ) ( ) 6, create, delete, semantic-modify, geometrical-modify, reincarnate, destroy, recall, s-delete, s-semantic-modify, s-geometrical-modify, s-reincarnate, forget 12 Badard T. 1999. On the automatic retrieval of updates in geographic databases based on geographic data matching tools. Peter Keller C. Touch the Past, Visualize the Future. Ottawa, Canada: the Organizing Committee for Ottawa ICA Claramunt C and Thériault M. 1995. Managing Time in GIS: An Event-Oriented Approach. Clifford J, Tuzhilin A. Recent Advances on Temporal Databases. Zurich Switzerland: Springer- Verlag Couclelis H. 1998. Aristotelian spatial dynamics in the age of geographic information systems. Egenhofer M J and Goliedge R G Spatial and Temporal Reasoning in Geographic Information Systems. New York Oxford: Oxford University Press Hornsby K and Egenhofer M. 2000. Identity-based change: a foundation for spatio-temporal knowledge representation. International Journal of Geographical Information Science, 14 (3): 207 224 Langran G. 1992. Time in Geographyic Information Systems. London: Taylor & Francis Li J Z and Wang S. 1998. Principles of Database Management System. Beijing: Publishing House of Electronic Industry. (In Chinese) Oracle Corporation. 2003a. Oracle Spatial User s Guide and Reference, http://otn.oracle.com/documentation/spatial.html, (2003-11-03) Oracle Corporation. 2003b. Oracle Objects for OLE C++ Class Library Help (Release 9.2), http://otn.oracle.com/documentation/spatial.html, (2003-11-03) Raza, A. 2001. Object-oriented temporal GIS for urban applications. AA enschede Netherland: ITC Publication The editors of Mathematical Handbook. Mathematical Handbook. 1979. Beijing: Publishing House of High Education Worboys M F. 1995. GIS: A computing Perspective. London: Taylor & Francis Zhou X G, Chen J, Jiang J, Zhu J J and Li Z L. 2004. Event-based incremental updating of spatio-temporal database. Journal of Central South University of Technology, 11(2): 192 198 附中文参考文献,. 1998.. :., 1979, :