With growing reliance on spatial components for making critical and strategic decisions, there is great incentive to maximize the added value of spatial data. Enter __Pro Oracle Spatial.__ This highly anticipated book examines the potential for organizations to exploit spatial information by way of Oracle Spatial. Included are case studies of advanced spatial applications in healthcare, telecom, retail, and distribution industries. Further, the content is based on extensive feedback from training courses, discussion lists, and customers. This talented author team will also suggest best-practice approaches to common problems. In the past decade, location analysis has outgrown its traditional use in Geographic Information Systems (GIS) and has become a critical component in business applications. The vast majority of commercial franchises employ location-based analysis and services in their day-to-day activities. With this growing usage, scalable and manageable solutions for location-based analysis and management have become a necessity rather than an option. Oracle Spatial is the principal component of Oracle that effectively addresses this need for location or spatial information management. This product has evolved from its simple beginnings in Oracle8i and prior releases to a full-fledged suite of products in Oracle lOg. The suite supports efficient and scalable storage and retrieval of spatial data using native data types and indexes, and provides new functionality for analysis and visualization of spatial data. Consistent with Oracle's motto of enabling storage of "all" data inside an Oracle database, Oracle Spatial not only extends all the benefits of an Oracle database to spatial data, but also enhances this functionality by adding location-specific analysis and visualization. Front Matter....Pages i-xxxiv Front Matter....Pages 1-1 Spatial Information Management....Pages 3-20 Overview of Oracle Spatial....Pages 21-40 Location-Enabling Your Applications....Pages 41-57 Front Matter....Pages 59-59 The SDO_GEOMETRY Data Type....Pages 61-101 Loading, Transporting, and Validating Spatial Data....Pages 103-127 Geocoding....Pages 129-175 Manipulating SDO_GEOMETRY in Application Programs....Pages 177-223 Front Matter....Pages 225-225 Spatial Indexes and Operators....Pages 227-284 Geometry Processing Functions....Pages 285-320 Network Modeling....Pages 321-381 Generating Maps Using MapViewer....Pages 383-477 A Sample Application....Pages 479-531 Front Matter....Pages 533-533 Case Studies....Pages 535-573 Tips, Common Mistakes, and Common Errors....Pages 575-598 Back Matter....Pages 599-678
