Browse > Article

Design and Implementation of a Spatial-Operation-Trigger for Supporting the Integrity of Meet-Spatial-Objects  

Ahn, Jun-Soon (Dept.of Computer Science Engineering, Inha University)
Cho, Sook-Kyoung (Dept.of Computer Science Engineering, Inha University)
Chung, Bo-Hung (Electronics and Telecommunications Research Institute)
Lee, Jae-Dong (Dept.of Computer Science, Dankook University)
Bae, Hae-Young (Dept.of Computer Science Engineering, Inha University)
Publication Information
Journal of KIISE:Computing Practices and Letters / v.8, no.2, 2002 , pp. 127-140 More about this Journal
Abstract
In a spatial database system, the semantic integrity should be supported for maintaining the data consistency. In the real world, spatial objects In boundary layer should always meet neighbor objects, and they cannot hold the same name. This characteristic is an implied concept in real world. So, when this characteristic is disobeyed due to the update operations of spatial objects, it is necessary to maintain the integrity of a layer. In this thesis, we propose a spatial-operation-trigger for supporting the integrity of spatial objects. The proposed method is defined a spatial-operation-trigger based on SQL-3 and executed when the constraint condition is violated. A spatial-operation-trigger have the strategy of execution. Firstly, for one layer, the spatial and aspatial data triggers are executed respectively. Secondly, the aspatial data trigger for the other layers is executed. Spatial-operation-trigger for one layer checks whether the executed operation updates only spatial data, aspatial data, or both of them, and determines the execution strategy of a spatial-operation-trigger. Finally, the aspatial data trigger for the other layers is executed. A spatial-operation-trigger is executed in three steps for the semantic integrity of the meet-property of spatial objects. And, it provides the semantic integrity of spatial objects and the convenience for users using automatic correcting operation.
Keywords
Spatial-Operation-Trigger : meet; integrity;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 S. Cockcroft, Towards the Automatic Enforcement of Interity Rules in Spatial Database Systems, In Proc. Of the Spatial Information Research Center's 8th Colloquium, pp. 33-42, 1996
2 R. Ramakrishnan, J. Gehrke, Database Management System, 2th Ed. McGraw-Hill, 2000
3 Y. G. Lee, et. al., Spatial Data Integrity in Spatial Information Systems, Proc. Intl. Conf. On Applied Modelling and Simulation, pp. 267-271, 1998
4 W. Kim, et. al., Spatial Data Management In Database Systems : Research Directions, Proc. 3rd Symp. On Spatial Databases, pp. 1-13, 1993   DOI   ScienceOn
5 A. Borgida, Language Features for Flexible handling of Exceptions in Information Systems, ACM-TODS, pp. 234-245, 1985
6 W.G. Aref and H. Samet, Extending a DBMS with Spatial Operations, Proc. 2nd Symp. On Spatial Databases SSD'91, pp. 298-318, 1991
7 J. F. Savage, What is a data model, anyway ?, URISA Proceedings, pp. 434-444, 1995
8 L. D. Floriano and P. Marzano, Spatial queries and data models, European Conf. COSIT'93, pp. 113-138, 1993   DOI
9 F. Manola and J. A. Orenstein, Toward a General Spatial Data Model for Object-Oriented DBMS, Proc. 14th Intl. Conf. On VLDB, pp. 328-335, 1986
10 W. Kim, Modern Database Systems, ACM Press, 1997
11 이영훈, 유석인, 객체 지향 데이타베이스에서의 의미적 질의 최적화, 한국정보과학회 논문지, 22권, 6호, 1995
12 B.C. Ooi, R. Sacks-Davis and K. J. McDonell, Extending A DBMS for Geographic Applications, Proc. 5th int. Conf. Data Engineering, pp. 590-597, 1989   DOI
13 R. Laurini and D. Thompson, 'Fundamentals of spatial Information Systems,' Academic Press, 1992
14 J. Widom and S. Ceri, Active Database Systems : Triggers and Rules for Advanced Database Processing, Morgan Kaufmann, 1996
15 안준순, 정보홍, 김재홍, 배해영, 공간 레이어에서 상접한 공간 객체의 무결성 지원을 위한 능동적인 공간 연산 트리거의 설계, 한국 정보처리학회 논문집, 8권, 1호, pp. 933-936, 2001   과학기술학회마을
16 C. J. Date, An Introduction to Database Systems, Vol. 1, 5th Ed. Addison Wesley, 1997
17 P. A. Burrough, Principles of Geographical Information System for Land Resources Assesment, Clarendon, 1986
18 E. Puppo and G. Dettori, Towards a formal Modal for Multiresolution Spatial Maps, Proc. 4th Symp. On Spatial Databases, pp. 152-169, 1995   DOI   ScienceOn
19 T. Ubeda and M. J. Egenhofer, Topology Error Correcting in GIS, Proc. 5th Symp. On Spaital Databases, pp. 283-297, 1997   DOI   ScienceOn
20 이영걸, 공간 데이타베이스에서 의미적 무결성 관리기의 설계 및 구현, 박사학위논문, 인하대학교, 1999