Kothuri / Godfrind / Beinat Pro Oracle Spatial for Oracle Database 11g

1. ed
ISBN: 978-1-4302-0446-6
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 787 Seiten

Pro Oracle Spatial for Oracle Database 11g shows you how to take advantage of Oracle Database's built-in feature set for working with location-based data. The book addresses the special nature of spatial data and its role in professional and consumer applications. It also details issues in spatial data management and covers 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 this book, you're learning from the very best, the authors are key players on the team that develops the Oracle Spatial feature set.

Ravi Kothuri holds a Ph.D. 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 12 years. He serves as the project lead and software architect for various projects in Oracle Spatial. He has around 15 patents (some pending) on specific Oracle technology and has authored numerous articles for database conferences and journals. Other activities include teaching database courses for undergrads and reviewing of research articles for spatial and database conferences. Ravi enjoys music, movies, and playing with children.

Autoren/Hrsg.

Kothuri, Ravikanth

Godfrind, Albert

Beinat, Euro

Inhaltsverzeichnis

1;Contents at a Glance;3
2;Contents;5
3;About the Authors;18
4;About the Technical Reviewer;19
5;Acknowledgments;20
6;Introduction;22
6.1;What Does This Book Cover?;23
6.2;Who Should Read This Book?;26
6.3;Copyrights and Disclaimer;27
7;Setting Up;28
7.1;Downloads;28
7.2;Setting Up Oracle Spatial and MapViewer;28
7.3;The Example Data;29
8;Overview;32
8.1;Spatial Information Management;33
8.1.1;Using Spatial Information in Various Industries;35
8.1.2;Sources of Spatial Data;37
8.1.3;Managing and Analyzing Spatial Data;37
8.1.4;Benefits of Oracle Spatial;45
8.1.5;Summary;48
8.1.6;References;48
8.2;Overview of Oracle Spatial;49
8.2.1;Technology and Architecture Overview;49
8.2.2;Getting Started with Oracle Spatial;52
8.2.3;Oracle Spatial Technology Products;60
8.2.4;What to Expect in an Oracle Spatial Install;63
8.2.5;Summary;66
8.3;Location-Enabling Your Applications;67
8.3.1;Adding Location Information to Tables;68
8.3.2;Metadata for Spatial Tables;75
8.3.3;Populating Spatial Metadata for Your Application;79
8.3.4;Summary;81
9;Basic Spatial;82
9.1;The SDO_GEOMETRY Data Type;83
9.1.1;Types of Spatial Geometries in Oracle;84
9.1.2;SDO_ GEOMETRY Type, Attributes, and Values;88
9.1.3;Simple Two- Dimensional Geometry Examples;104
9.1.4;Complex Two- Dimensional Geometry Examples;112
9.1.5;Three- Dimensional Examples;123
9.1.6;Summary;142
9.2;Loading, Transporting, and Validating Spatial Data;143
9.2.1;Inserting Data into an SDO_ GEOMETRY Column;144
9.2.2;Loading and Converting Spatial Data;145
9.2.3;Extruding a Two- Dimensional Geometry to Three Dimensions;157
9.2.4;Validating Spatial Data;160
9.2.5;Debugging Spatial Data;170
9.2.6;Summary;177
9.3;Geocoding;178
9.3.1;What Is Geocoding?;178
9.3.2;Architecture of the Oracle Geocoder;180
9.3.3;Setting Up the Reference Data for the Geocoder;183
9.3.4;Using Geocoder Functions;185
9.3.5;Geocoding Using Structured Addresses;209
9.3.6;Reverse Geocoding;211
9.3.7;Geocoding Business Data;213
9.3.8;The Geocoding Server;223
9.3.9;Summary;233
9.4;Manipulating SDO_GEOMETRY in Application Programs;234
9.4.1;Manipulating Geometries Using PL/ SQL;236
9.4.2;Manipulating Geometries in Java;250
9.4.3;Summary;267
10;Spatial and Network Analysis;268
10.1;Spatial Indexes and Operators;269
10.1.1;Spatial Indexes;271
10.1.2;Spatial Index Parameters;275
10.1.3;Spatial Operators;279
10.1.4;A Closer Look at Spatial Operators;282
10.1.5;Advanced Spatial Index Features;313
10.1.6;Summary;329
10.2;Geometry Processing Functions;330
10.2.1;Buffering Functions;332
10.2.2;Relationship Analysis Functions;335
10.2.3;Geometry Combination Functions;345
10.2.4;Geometric Analysis Functions;351
10.2.5;Aggregate Functions;362
10.2.6;Summary;368
10.3;Network Modeling;369
10.3.1;General Network Modeling Concepts;371
10.3.2;Data Structures: The Network Tables;375
10.3.3;Defining Networks;379
10.3.4;Analyzing and Managing Networks Using the Java API;394
10.3.5;Debugging Network Structures;420
10.3.6;Analyzing Networks Using the PL/ SQL API;421
10.3.7;The Network Editor;436
10.3.8;Summary;440
10.4;The Routing Engine;441
10.4.1;Architecture;442
10.4.2;Installation and Configuration;444
10.4.3;Data Structures;446
10.4.4;Example Data: The Streets of San Francisco;448
10.4.5;Partitioning;449
10.4.6;Using the Router: XML Queries and Responses;451
10.4.7;Summary;458
11;Visualization;459
11.1;Defining Maps Using MapViewer;460
11.1.1;Why Use Maps in Location- Enabled Applications?;460
11.1.2;Overview of MapViewer and Oracle Maps;463
11.1.3;Getting Started;466
11.1.4;Configuring MapViewer;471
11.1.5;Defining Maps;480
11.1.6;Defining Map Caches;514
11.1.7;Summary;525
11.2;Using Maps in Your Applications;526
11.2.1;Overview of MapViewer’s APIs;526
11.2.2;Anatomy of a Map Request;530
11.2.3;Interacting with Maps;532
11.2.4;Oracle Maps: The JavaScript API;533
11.2.5;Using the Java API;553
11.2.6;Using the XML API;575
11.2.7;Using the PL/ SQL API;589
11.2.8;Using the Administrative API;591
11.2.9;Web Map Service ( OGC WMS) Interface;596
11.2.10;Summary;601
12;Spatial in Applications;602
12.1;Sample Applications;603
12.1.1;Data Preparation and Setup;604
12.1.2;Applications Setup;605
12.1.3;The JavaScript Application;606
12.1.4;The Java ( JSP) Application;625
12.1.5;Summary;644
12.2;Case Studies;645
12.2.1;Overview of the Case Studies;645
12.2.2;Spatial Information for Managing the London Bus Network;646
12.2.3;P- Info: A Mobile Application for Police Forces;653
12.2.4;Risk Repository for Hazardous Substances;660
12.2.5;USGS National Land Cover Visualization and Analysis Tool;666
12.2.6;U.S. Department of Defense MilitaryHOMEFRONT LBS;674
12.2.7;Summary;684
12.3;Tips, Common Mistakes, and Common Errors;685
12.3.1;Tips;685
12.3.2;Common Mistakes;700
12.3.3;Common Errors;703
12.3.4;Summary;707
13;Appendixes;708
13.1;Additional Spatial Analysis Functions;709
13.1.1;Tiling- Based Analysis;709
13.1.2;Neighborhood Analysis;714
13.1.3;Clustering Analysis;716
13.1.4;Refining the Candidates for Site Selection;717
13.1.5;Geometry Simplification for Speeding Up Analysis;718
13.1.6;Summary;719
13.2;Linear Referencing;720
13.2.1;Concepts and Definitions;721
13.2.2;Creating Linear Referenced Geometries;724
13.2.3;Dynamic Segmentation Operations;726
13.2.4;Summary;731
13.3;Topology Data Model in Oracle;732
13.3.1;Sharing Boundaries;733
13.3.2;Benefits of the Topology Data Model;734
13.3.3;Storing a Topology Data Model in Oracle;734
13.3.4;Operating on a Topology in Oracle;737
13.3.5;Hierarchical Feature Model;742
13.3.6;Summary;743
13.4;Storing Raster Data in Oracle;744
13.4.1;The SDO_ GEORASTER Data Type;745
13.4.2;Populating SDO_ GEORASTER Columns;750
13.4.3;Manipulating Raster Objects;751
13.4.4;Using Compression in GeoRaster;757
13.4.5;Visualizing Raster Data in Oracle MapViewer;758
13.4.6;Summary;760
13.5;Three-Dimensional Modeling Using Point Clouds and TINs in Oracle;761
13.5.1;Storing Large Point Sets;762
13.5.2;Storing Triangulated Irregular Networks;767
13.5.3;Summary;773
14;INDEX;775