A spatial database application should be designed just like any other database application. It should follow the same standard data model practices like any other database application. In this chapter, we introduced a data model that can be used in a city-wide spatial data management system. This data model is used throughout the book to illustrate different aspects of spatial database application development. We discussed the use of triggers and queues to manage spatial data in the database. We also showed how to design database level constraints for spatial data management. We introduced the concepts of database triggers and queues and showed how they can be used for spatial data management in the database.
The next chapter will show different techniques for loading spatial data from different formats into Oracle Spatial tables. We will also describe some of the common spatial data interchange formats and show some PL/SQL examples for generating data in these formats.