1 / 14

Albert Godfrind GeoSpatial and Multimedia Technologies Oracle Corporation Sophia Antipolis, France

Oracle9 i XML Database. Albert Godfrind GeoSpatial and Multimedia Technologies Oracle Corporation Sophia Antipolis, France. Applications. Enterprise Manager. Development Tools. Oracle9 i Application Server. Oracle9 i Database. The Oracle Platform. Spatial Data.

doli
Télécharger la présentation

Albert Godfrind GeoSpatial and Multimedia Technologies Oracle Corporation Sophia Antipolis, France

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle9i XML Database Albert Godfrind GeoSpatial and Multimedia Technologies Oracle Corporation Sophia Antipolis, France

  2. Applications Enterprise Manager Development Tools Oracle9i Application Server Oracle9i Database The Oracle Platform

  3. Spatial Data Object Relational Data Employee Emplo EXsdfe EXs Abcd Documents XML Multimedia Messages Managing all the information … Field Prospects Customers Infrastructure

  4. To supply a foundation for the distribution and integration of spatial data such that any application can use it To make Spatial Data An Integral Component of the Overall Information Technology Strategy of an Organization Our Mission ...

  5. Products Oracle Spatial, Oracle Locator Partnerships With Leading Spatial Vendors Software vendors Integrators, Data suppliers Service providers Commitment To Standards Open GIS Consortium, OpenLS, ... SQL, LIF, ISO TC-211, TC-204 Integration with Oracle applications E-Business Suite CRM Location Based Services Our Strategy ... SQL3/MM Spatial

  6. Element 0 P6 P7 H4 P8 P5 H3 Element 1 (Hole) H1 P1 H2 P4 P2 P3 Oracle Spatial Database Services Abstract Data Type ROADS RNAME ID TYPE LANES GEOMETRY M40 140 HWY 6 M25 141 HWY 4 Geometry Data Type X Y Indexing Quadtree, Rtree x1 x1 x2 x2 x3 x3 Query/Analysis Select, join, buffer, within distance, nearest neighbor, intersection, union, convex hull, centroid, ... x4 x4 x5 x5

  7. Why XML in the Database • Enforce and leverage the XML data model • Loosely coupled, flexible applications • XML Schema, DOM • Enable richer semantics and better management for content-oriented applications • Store as XML vs. Files or LOBs • Queryability, Integrity, RAS etc. • Process XML close to data for high scalability and performance • Generation, Transformation • Superior memory management for large XML

  8. Why XML in the Database • Reduce maintenance costs of extra moving parts • Eliminate separate ‘XML-processing’ layers • Keep applications standards-based • W3C, IETF, ANSI/ISO, J2EE • Eliminate proprietary file formats, message formats, delimited columns

  9. Oracle9iR2: XML DB • Enhanced XMLType • XML Repository

  10. Enhanced XMLType • XMLSchema Support • Object-Relational Storage Maintaining DOM fidelity • XML-specific memory mgmt for better scalability and performance • Built-in XML operators for SQL/XML interchangability • XPath Search in the server, and piecewise update of XML via XPath • XSL Transforms in the server • Enhanced XML Views for creating your own efficient representations of XML

  11. XML Repository • FTP, WebDAV, HTTP protocol servers to move XML content in and out • ‘Foldering’ and Repository view over XML Content including access control • Hierarchical Index, SQL Versioning • SQL Repository Search

  12. JAVA Client OCI Client XML/DOM Parser XQuery XML Schema Cache SQL XMLType Views/Tables Repository 9i XML DB B-TreeBitmap Index Text Index Path Index Text Index XML DB Architecture Data-oriented Access Application Clients JDBC/OCI Oracle Net

  13. Protocol Handlers B-Tree Bitmap Index Text Index XML DB Architecture Content-oriented Access HTTP Client FTP Client WebDAV Client HTTP WebDAV FTP XMLType Views/Tables Repository XML DB Text Index Path Index

More Related