Transforming GML into an Oracle Spatial Enterprise Database

1
Transforming GML into an Oracle Spatial
Enterprise Database

• Ian Painter
• Eddie Curtis

2
Snowflake Software

• Based in Southampton, founded October 2001
• Key Partnerships Ordnance Survey, OpenGIS and
  Oracle
• Development of software products which provide
  turn key solutions to integrating XML GML
  within mainstream technologies such as Oracle
  10g.

3
What do we do?

• We are not a GIS company
• Focus on server side Interoperability through
  Oracle and XML
• GO Loader is our flagship product
• GO Publisher - XML and GML publishing

4
Working with GML and Oracle
5
Demonstration

• Eddie Curtis
• Snowflake Software

6
The Value Proposition

• GO Loader gets the server side up and running
  quickly allowing you to focus on developing the
  business benefit applications

7
GO Loader and GML

• Supports any GML given GML2/3 Schema
• ISO 19107 architecture
• Specific OS MasterMap Support
• Change Only Update
• Duplicate Removal
• Archiving

8
Telematics Demonstrator

• National Coverage OS MM
• Address
• ITN
• Topo

9
LCP London CABI Pilot
10

• National Coverage OS MasterMap
• In determining a tool to use for the OS
  MasterMap load process we found GO Loader to be
  by far the quickest in terms of features loaded
  per second and the easiest to configure. We also
  found the accompanying GUI very intuitive and
  easy to use.
• Terry Barnett, Oracle Development Manager,
• Landmark Information Group

11
National Coverage OSMM Statistics

• Machine Spec
• 1.3Ghz Desktop PC,
• 1.5Gb Ram, 3 120Gb hard disks
• Windows 2000 SP3
• Data Volume Size (417,827,201 rows)
  168.1Gb
• Index Volume Size 60.3Gb
• Total Size 228.4Gb
• Initial Load 8 days 16 hrs 54 mins
• Fid Index Build 3 hrs 17 mins
• Duplicate Removal 7 hrs 32 mins
• Spatial Index Build 1 days 23 hrs 11 mins
• Total Time 11 days 2 hrs 54 mins

12
In Summary

• GML
• Is easy to work with
• Solves interoperability
• Is an International Standard
• Is intelligent and self validating
• Is very efficient to load into Oracle
• GML is XML and XML is mainstream IT

13
In Summary

• GO Loader
• Covers the entire database lifecycle
• Reduces development costs
• Dramatically shortens lead times
• Reduces dependency on key Oracle skills
• Enables you to focus on developing the
  business benefit applications

14

• Any Questions?
• For further information on GO Loader visit
• www.snowflakesoftware.co.uk/goloader