O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Using Database Features in Spatial Applications

The goal of this chapter is to introduce some of the standard features that the Oracle database makes available to solve some common data processing, auditing, version management, and quality issues related to the maintenance of the spatial data. These database features allow developers to keep the data processing operations in the database instead of doing them in the application code. The topics covered in this chapter are:

  • Row-level and statement-level triggers
  • Avoiding the mutating table problem
  • Using materialized views
  • Logging changes independently of an application
  • Flashback queries
  • AWR reports and ADDM
  • Database replay
  • Workspace Manager
  • SecureFile compression

Using row-level and statement-level ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required