Integrity Constraints in Spatial Databases

Integrity Constraints in Spatial Databases

Karla A.V. Borges (Universidade Federal de Minas Gerais, Brazil), Clodoveu A. Davis Jr. (Prodabel’s Development and Studies Center, Brazil) and Alberto H.F. Laender (Universidade Federal de Minas Gerais, Brazil)
Copyright: © 2002 |Pages: 28
DOI: 10.4018/978-1-930708-38-9.ch005
OnDemand PDF Download:


This chapter addresses the relationship that exists between the nature of spatial information, spatial relationships, and spatial integrity constraints, and proposes the use of OMT-G (Borges et al., 1999; Borges et al., 2001), an object-oriented data model for geographic applications, at an early stage in the specification of integrity constraints in spatial databases. OMT-G provides appropriate primitives for representing spatial data, supports spatial relationships and allows the specification of spatial integrity rules (topological, semantic and user integrity rules) through its spatial primitives and spatial relationship constructs. Being an object-oriented data model, it also allows some spatial constraints to be encapsulated as methods associated to specific georeferenced classes. Once constraints are explicitly documented in the conceptual modeling phase, and methods to enforce the spatial integrity constraints are defined, the spatial database management system and the application must implement such constraints. This chapter does not cover integrity constraints associated to the representation of simple objects, such as constraints implicit to the geometric description of a polygon. Geometric constraints are related to the implementation, and are covered here in a higher level view, considering only the shape of geographic objects. Consistency rules associated with the representation of spatial objects are discussed in Laurini and Thompson (1992).

Complete Chapter List

Search this Book:
Table of Contents
Chapter 1
Jorge H. Doorn, Laura C. Rivero, Viviana E. Ferraggine
Data properties should be seen from the point of view of being as independent as possible from the representation model. In this way, data... Sample PDF
Introduction to Database Integrity: Challenges and Solutions
Chapter 2
Laura C. Rivero, Jorge H. Doorn, Viviana E. Ferraggine
In Part I, this chapter surveys the state of the art of the semantic integrity constraints in some relational and object relational available... Sample PDF
Database Integrity: Fundamentals and Current implementations
Chapter 3
Dolores Cuadra, Carlos Nieto, Paloma Martinez, Elena Castro, Manuel Velasco
This chapter is devoted to the study of the transformation of conceptual into logical schemata in a methodological framework focusing on a special... Sample PDF
Preserving Relationship Cardinality Constraints in Relational Schemata
Chapter 4
Juan M. Ale, Mauricio Minuto Espil
This chapter surveys the interaction between active rules and integrity constraints. First, we analyze the static case following the SQL-1999... Sample PDF
Integrity Constraints in an Active Database Environment
Chapter 5
Karla A.V. Borges, Clodoveu A. Davis Jr., Alberto H.F. Laender
This chapter addresses the relationship that exists between the nature of spatial information, spatial relationships, and spatial integrity... Sample PDF
Integrity Constraints in Spatial Databases
Chapter 6
Sergio Greco, Ester Zumpano
Integrity constraints represent an important source of information about the real world. They are usually used to define constraints on data... Sample PDF
Consistent Queries Over Databases with Integrity Constraints
Chapter 7
Hendrik Decker
The main goal of this chapter is to arrive at a coherent technology for deriving efficient SQL triggers from declarative specifications of arbitrary... Sample PDF
Translating Advanced Integrity Checking Technology to SQL
Chapter 8
Jochens Rasch, Hans-Joachim Klein
The Entity-Relationship (ER) model (Chen, 1976) is frequently used for the specification of conceptual database schemas. Entity types and... Sample PDF
Functional Dependencies For Value Based Identification In Object-Oriented Databases
Chapter 9
Jose F. Aladana Montes, Mariemma I. Yague del Valle, Antonio C. Gomez Lora
Issues related to integrity in databases and distributed databases have been introduced in previous chapters. Therefore, the integrity problem in... Sample PDF
Integrity Issues in the Web: Beyond Distributed Databases
Chapter 10
Ulrich Schiel
The use of databases for advanced applications is a rapidly growing and changing field, due to the continuous incorporation of new technologies and... Sample PDF
Integrity Maintenance In Extensible Databases
About the Authors