Pro Oracle Spatial for Oracle Database 11g

  • 14h 15m
  • Albert Godfrind, Euro Beinat, Ravi Kothuri
  • Apress
  • 2007

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in today's mobile and highly connected world. In Pro Oracle Spatial for Oracle Database 11g, authors Ravi Kothuri and Albert Godfrind address:

  • The special nature of spatial data and its role in professional and consumer applications
  • Issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data
  • The Oracle Spatial solution and the integration of spatial data into enterprise databases
  • How spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users

When you read Pro Oracle Spatial for Oracle Database 11g, you’re learning from the very best. Ravi Kothuri is a key member of Oracle’s Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.

What you’ll learn

  • About new Oracle Spatial features in Oracle Database 11g, including support for the European Petroleum Standards Group (EPSG) data model, the ability to publish to Google Earth, integration with Google Maps, and much more
  • The use of Oracles built-in SDO_GEOMETRY data type for storing location–based data
  • How to geocode your data, beginning with postal addresses and ending with SDO_GEOMETRY objects that enable future analysis as well as forming the foundation of working with spatial data within Oracle
  • How to create and display maps to help you visualize and analyze your geocoded data
  • About network modeling, which is useful in computing routes, travel distances, and proximity based upon travel time
  • How to optimize analysis of your spatial data by creating spatial indexes and custom operators

Who this book is for

Pro Oracle Spatial for Oracle Database 11g is aimed at software developers who wish to develop applications using Oracles extensive and strong support for working with spatial, or geocoded, data.

About the Authors

RAVI KOTHURI has a PhD in computer science from the University of California, Santa Barbara, and has been an active researcher and developer in the spatial and multimedia areas for the past 15 years. Currently, he serves as project lead and software architect in the spatial development team of Oracle Corporation. He has more than 20 patents on specific Oracle technology and has authored numerous articles for database conferences and journals. Other activities include teaching database courses (most recently at Boston University), presenting at panel meetings and conferences, and reviewing of research articles for spatial and database conferences.

ALBERT GODFRIND has more than 25 years of experience in designing, developing, and deploying IT applications. His interest and enthusiasm for spatial information and geographical information systems started at Oracle when he discovered the spatial extensions of the Oracle database in 1998. Ever since, Albert has been "evangelizing" the use of spatial information both to GIS and IT communities across Europe, consulting with partners and customers, speaking at conferences, and designing and delivering in-depth technical training. Prior to joining Oracle Corporation, Albert held several positions in database engineering at Digital Equipment Corporation (DEC), where he worked on the development of the Rdb database system.

EURO BEINAT has a PhD in economics and a master's degree in electronics and systems engineering. He has been involved in consultancy for more than 10 years in evaluation and strategic advice in sectors ranging from IT, government, the oil industry, and large corporations. Currently, he is the managing director of Geodan Mobile Solutions and holds a chair on Location Services at the Vrije Universiteit of Amsterdam and at the University of Salzburg. His main skills combine geo-IT and the Internet, with an extensive competence in decision analysis and strategy.

In this Book

  • Spatial Information Management
  • Overview of Oracle Spatial
  • Location-Enabling Your Applications
  • The SDO_GEOMETRY Data Type
  • Loading, Transporting, and Validating Spatial Data
  • Geocoding
  • Manipulating SDO_GEOMETRY in Application Programs
  • Spatial Indexes and Operators
  • Geometry Processing Functions
  • Network Modeling
  • The Routing Engine
  • Defining Maps Using MapViewer
  • Using Maps in Your Applications
  • Sample Applications
  • Case Studies
  • Tips, Common Mistakes, and Common Errors