This guide takes you straight into the attributes of Oracle Spatial and teaches you to extend, apply, and combine them with other Oracle and open source technologies. A vital manual for solving everyday problems.Key FeaturesUnderstand how to develop Oracle Spatial data models and applications that use PL/SQL and Java to solve common problems using practical, hands-on examplesDesign a data model for spatial applicationsUse standard database technologies for managing Spatial dataLearn how to combine spatial and non-spatial data in the databaseGet to grips with how to use Oracle Spatial's standards compliant geometry data types to develop cross-vendor database solutions to common problemsBook DescriptionSpatial applications should be developed in the same way that users develop other database applications: by starting with an integrated data model in which the SDO_GEOMETRY objects are just another attribute describing entities and by using as many of the database features as possible for managing the data. If a task can be done using a database feature like replication, then it should be done using the standard replication technology instead of inventing a new procedure for replicating spatial data. Sometimes solving a business problem using a PL/SQL function can be more powerful, accessible, and easier to use than trying to use external software. Because Oracle Spatial's offerings are standards compliant, this book shows you how Oracle Spatial technology can be used to build cross-vendor database solutions. Applying and Extending Oracle Spatial shows you the clever things that can be done not just with Oracle Spatial on its own, but in combination with other database technologies. This is a great resource book that will convince you to purchase other Oracle technology books on non-spatial specialist technologies because you will finally see that "spatial is not special: it is a small, fun, and clever part of a much larger whole".What you will learnDesign a data model for a spatial application„Build and use database triggers that manage data validation and other tasks„Use Oracle s materialized view, replication, and PL/SQL technologies with a spatial database„Understand and use Oracle s raster data management technology to implement solutions within a range of applications„Explore advanced queuing for managing spatial data processing„Apply linear referencing programming to solve business problems„Discover Oracle s OGC and SQLMM-compliant geometry types when implementing solutions capable of cross-vendor database deployment„Use partitioning to manage large spatial datasets in the database„Load spatial data (raster and vector) from different data sources in the databaseWho this book is forThis book is for existing users of Oracle and Oracle Spatial and so assumes you have a basic knowledge of Oracle in terms of understanding the SDO_GEOMETRY type, creating tables, indexes, and views, executing basic to moderately complex queries, and some idea of PL/SQL programming of triggers and stored procedures.

This guide takes you straight into the attributes of Oracle Spatial and teaches you to extend, apply, and combine them with other Oracle and open source technologies. A vital manual for solving everyday problems.Key FeaturesUnderstand how to develop Oracle Spatial data models and applications that use PL/SQL and Java to solve common problems using practical, hands-on examplesDesign a data model for spatial applicationsUse standard database technologies for managing Spatial dataLearn how to combine spatial and non-spatial data in the databaseGet to grips with how to use Oracle Spatial's standards compliant geometry data types to develop cross-vendor database solutions to common problemsBook DescriptionSpatial applications should be developed in the same way that users develop other database applications: by starting with an integrated data model in which the SDO_GEOMETRY objects are just another attribute describing entities and by using as many of the database features as possible for managing the data. If a task can be done using a database feature like replication, then it should be done using the standard replication technology instead of inventing a new procedure for replicating spatial data. Sometimes solving a business problem using a PL/SQL function can be more powerful, accessible, and easier to use than trying to use external software. Because Oracle Spatial's offerings are standards compliant, this book shows you how Oracle Spatial technology can be used to build cross-vendor database solutions. Applying and Extending Oracle Spatial shows you the clever things that can be done not just with Oracle Spatial on its own, but in combination with other database technologies. This is a great resource book that will convince you to purchase other Oracle technology books on non-spatial specialist technologies because you will finally see that "spatial is not special: it is a small, fun, and clever part of a much larger whole".What you will learnDesign a data model for a spatial application„Build and use database triggers that manage data validation and other tasks„Use Oracle s materialized view, replication, and PL/SQL technologies with a spatial database„Understand and use Oracle s raster data management technology to implement solutions within a range of applications„Explore advanced queuing for managing spatial data processing„Apply linear referencing programming to solve business problems„Discover Oracle s OGC and SQLMM-compliant geometry types when implementing solutions capable of cross-vendor database deployment„Use partitioning to manage large spatial datasets in the database„Load spatial data (raster and vector) from different data sources in the databaseWho this book is forThis book is for existing users of Oracle and Oracle Spatial and so assumes you have a basic knowledge of Oracle in terms of understanding the SDO_GEOMETRY type, creating tables, indexes, and views, executing basic to moderately complex queries, and some idea of PL/SQL programming of triggers and stored procedures.