没有合适的资源?快使用搜索试试~ 我知道了~
Oracle Spatial Developer's Guide 11g Release 2 (11.2)-924
需积分: 5 0 下载量 106 浏览量
2023-06-18
10:03:24
上传
评论
收藏 14.88MB PDF 举报
温馨提示
试读
924页
Oracle Spatial Developer's Guide 11g Release 2 (11.2)-924
资源推荐
资源详情
资源评论
Oracle® Spatial
Developer's Guide
11g Release 2 (11.2)
E11830-15
November 2013
Provides usage and reference information for indexing and
storing spatial data and for developing spatial applications
using Oracle Spatial and Graph and Oracle Locator.
Oracle Spatial Developer's Guide, 11g Release 2 (11.2)
E11830-15
Copyright © 1999, 2013, Oracle and/or its affiliates. All rights reserved.
Primary Author: Chuck Murray
Contributors: Dan Abugov, Nicole Alexander, Bruce Blackwell, Raja Chatterjee, Dan Geringer, Mike
Horhammer, Ying Hu, Baris Kazar, Ravi Kothuri, Siva Ravada, Jack Wang, Ji Yang
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users
are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on
the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to
the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your
access to or use of third-party content, products, or services.
iii
Contents
Preface ............................................................................................................................................................ xxvii
Audience.................................................................................................................................................. xxvii
Documentation Accessibility................................................................................................................ xxvii
Related Documents ................................................................................................................................ xxvii
Conventions ........................................................................................................................................... xxviii
What's New in Oracle Spatial?.......................................................................................................... xxix
Release 11.2............................................................................................................................................... xxix
Release 11.1............................................................................................................................................... xxxi
Part I Conceptual and Usage Information
1 Spatial Concepts
1.1 What Is Oracle Spatial? .............................................................................................................. 1-2
1.2 Object-Relational Model ............................................................................................................ 1-2
1.3 Introduction to Spatial Data ...................................................................................................... 1-3
1.4 Geometry Types.......................................................................................................................... 1-3
1.5 Data Model................................................................................................................................... 1-4
1.5.1 Element.................................................................................................................................. 1-4
1.5.2 Geometry............................................................................................................................... 1-5
1.5.3 Layer...................................................................................................................................... 1-5
1.5.4 Coordinate System............................................................................................................... 1-5
1.5.5 Tolerance............................................................................................................................... 1-6
1.5.5.1 Tolerance in the Geometry Metadata for a Layer.................................................... 1-7
1.5.5.2 Tolerance as an Input Parameter................................................................................ 1-8
1.6 Query Model................................................................................................................................ 1-8
1.7 Indexing of Spatial Data............................................................................................................. 1-9
1.7.1 R-Tree Indexing.................................................................................................................... 1-9
1.7.2 R-Tree Quality................................................................................................................... 1-10
1.8 Spatial Relationships and Filtering ....................................................................................... 1-11
1.9 Spatial Operators, Procedures, and Functions .................................................................... 1-13
1.10 Spatial Aggregate Functions .................................................................................................. 1-14
1.10.1 SDOAGGRTYPE Object Type......................................................................................... 1-15
1.11 Three-Dimensional Spatial Objects ....................................................................................... 1-15
1.11.1 Modeling Surfaces ............................................................................................................ 1-18
iv
1.11.2 Modeling Solids ................................................................................................................ 1-19
1.11.3 Three-Dimensional Optimized Rectangles................................................................... 1-20
1.11.4 Using Texture Data........................................................................................................... 1-20
1.11.4.1 Schema Considerations with Texture Data ........................................................... 1-23
1.11.5 Validation Checks for Three-Dimensional Geometries .............................................. 1-23
1.12 Geocoding ................................................................................................................................. 1-24
1.13 Spatial Java Application Programming Interface ............................................................... 1-24
1.14 Predefined User Accounts Created by Spatial..................................................................... 1-25
1.15 Performance and Tuning Information.................................................................................. 1-26
1.16 OGC and ISO Compliance...................................................................................................... 1-26
1.17 Spatial Release (Version) Number......................................................................................... 1-26
1.18 Spatially Enabling a Table ...................................................................................................... 1-27
1.19 Moving Spatial Metadata (MDSYS.MOVE_SDO)............................................................... 1-29
1.20 Spatial Application Hardware Requirement Considerations ........................................... 1-29
1.21 Spatial Error Messages............................................................................................................ 1-29
1.22 Spatial Examples ...................................................................................................................... 1-29
1.23 README File for Spatial and Related Features.................................................................. 1-30
2 Spatial Data Types and Metadata
2.1 Simple Example: Inserting, Indexing, and Querying Spatial Data...................................... 2-1
2.2 SDO_GEOMETRY Object Type ................................................................................................ 2-5
2.2.1 SDO_GTYPE......................................................................................................................... 2-5
2.2.2 SDO_SRID............................................................................................................................. 2-7
2.2.3 SDO_POINT ......................................................................................................................... 2-7
2.2.4 SDO_ELEM_INFO............................................................................................................... 2-7
2.2.5 SDO_ORDINATES ........................................................................................................... 2-11
2.2.6 Usage Considerations ...................................................................................................... 2-11
2.3 SDO_GEOMETRY Methods................................................................................................... 2-12
2.4 SDO_GEOMETRY Constructors............................................................................................ 2-13
2.5 TIN-Related Object Types....................................................................................................... 2-14
2.5.1 SDO_TIN Object Type...................................................................................................... 2-15
2.5.2 SDO_TIN_BLK_TYPE and SDO_TIN_BLK Object Types.......................................... 2-18
2.6 Point Cloud-Related Object Types ........................................................................................ 2-18
2.6.1 SDO_PC Object Type ....................................................................................................... 2-18
2.6.2 SDO_PC_BLK_TYPE and SDO_PC_BLK Object Type ............................................... 2-20
2.7 Geometry Examples................................................................................................................. 2-20
2.7.1 Rectangle............................................................................................................................ 2-20
2.7.2 Polygon with a Hole......................................................................................................... 2-21
2.7.3 Compound Line String .................................................................................................... 2-23
2.7.4 Compound Polygon ......................................................................................................... 2-24
2.7.5 Point.................................................................................................................................... 2-25
2.7.6 Oriented Point................................................................................................................... 2-27
2.7.7 Type 0 (Zero) Element...................................................................................................... 2-29
2.7.8 Several Two-Dimensional Geometry Types................................................................. 2-31
2.7.9 Three-Dimensional Geometry Types............................................................................. 2-35
2.8 Geometry Metadata Views..................................................................................................... 2-44
2.8.1 TABLE_NAME.................................................................................................................. 2-45
v
2.8.2 COLUMN_NAME............................................................................................................ 2-45
2.8.3 DIMINFO........................................................................................................................... 2-45
2.8.4 SRID.................................................................................................................................... 2-46
2.9 Spatial Index-Related Structures ........................................................................................... 2-46
2.9.1 Spatial Index Views.......................................................................................................... 2-46
2.9.1.1 xxx_SDO_INDEX_INFO Views............................................................................... 2-46
2.9.1.2 xxx_SDO_INDEX_METADATA Views................................................................. 2-47
2.9.2 Spatial Index Table Definition ........................................................................................ 2-49
2.9.3 R-Tree Index Sequence Object ........................................................................................ 2-49
2.10 Unit of Measurement Support ............................................................................................... 2-49
2.10.1 Creating a User-Defined Unit of Measurement ........................................................... 2-50
3 SQL Multimedia Type Support
3.1 ST_GEOMETRY and SDO_GEOMETRY Interoperability.................................................... 3-1
3.2 ST_xxx Functions and Spatial Counterparts........................................................................... 3-7
3.3 Tolerance Value with SQL Multimedia Types ....................................................................... 3-8
3.4 Avoiding Name Conflicts.......................................................................................................... 3-8
3.5 Annotation Text Type and Views............................................................................................. 3-8
3.5.1 Using the ST_ANNOTATION_TEXT Constructor......................................................... 3-8
3.5.2 Annotation Text Metadata Views...................................................................................... 3-9
4 Loading Spatial Data
4.1 Bulk Loading .............................................................................................................................. 4-1
4.1.1 Bulk Loading SDO_GEOMETRY Objects ........................................................................ 4-1
4.1.2 Bulk Loading Point-Only Data in SDO_GEOMETRY Objects...................................... 4-3
4.2 Transactional Insert Operations Using SQL ........................................................................... 4-3
4.3 Recommendations for Loading and Validating Spatial Data............................................... 4-4
5 Indexing and Querying Spatial Data
5.1 Creating a Spatial Index............................................................................................................. 5-1
5.1.1 Constraining Data to a Geometry Type............................................................................ 5-2
5.1.2 Creating a Cross-Schema Index......................................................................................... 5-2
5.1.3 Using Partitioned Spatial Indexes..................................................................................... 5-2
5.1.3.1 Creating a Local Partitioned Spatial Index ............................................................... 5-4
5.1.4 Exchanging Partitions Including Indexes ........................................................................ 5-5
5.1.5 Export and Import Considerations with Spatial Indexes and Data ............................. 5-5
5.1.6 Distributed Transactions and Spatial Index Consistency .............................................. 5-6
5.1.7 Rollback Segments and Sort Area Size............................................................................. 5-6
5.2 Querying Spatial Data................................................................................................................ 5-7
5.2.1 Spatial Query........................................................................................................................ 5-7
5.2.1.1 Primary Filter Operator............................................................................................... 5-8
5.2.1.2 Primary and Secondary Filter Operator.................................................................... 5-9
5.2.1.3 Within-Distance Operator........................................................................................ 5-10
5.2.1.4 Nearest Neighbor Operator ..................................................................................... 5-11
5.2.1.5 Spatial Functions........................................................................................................ 5-12
5.2.2 Spatial Join ......................................................................................................................... 5-12
剩余923页未读,继续阅读
资源评论
weixin_40191861_zj
- 粉丝: 63
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功