Mastering the challenges of 3d data management
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Mastering the Challenges of 3D Data Management PowerPoint PPT Presentation


  • 110 Views
  • Uploaded on
  • Presentation posted in: General

ORACLE PRODUCT LOGO. Mastering the Challenges of 3D Data Management. Hans Viehmann Product Manager EMEA. Specific challenges for 3D data. large amounts of data (acquisition & storage) expertise and specific tooling required for data processing data models and standards

Download Presentation

Mastering the Challenges of 3D Data Management

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Mastering the challenges of 3d data management

ORACLE

PRODUCT

LOGO

Mastering the Challenges of3D Data Management

Hans ViehmannProduct Manager EMEA


Specific challenges for 3d data

Specific challenges for 3D data

  • large amounts of data (acquisition & storage)

  • expertise and specific tooling required for data processing

  • data models and standards

  • adequate visualization tools

  • data dissemination


How do we fit in

How do we fit in?

  • Data Storage

  • Data Lifecycle Management

  • Data Analysis

  • for all variations of spatial data

    • Vector, Raster, Point Clouds, TINs, Networks, Topologies, ...


Why use a database

Why use a database?!

  • Moving Spatial data into IT infrastructure allows to

    • Lower data management cost

    • Simplify application development

    • Integrate with other enterprise data

  • Enable development teams to focus on business context, not infrastructure services

    • Database and Application Server manage deployment infrastructure

      • Security• Scalability • Standards Compliance

      • Load Balancing• Failover• HW/SW Dependencies

    • Support multiple application models with common data model

      • Java • GML • Future …

      • .Net• Web Services/SOA


Data acquisition in 3d

Data acquisition in 3D

  • large volumes of point data acquired by sensors

    • LIDAR (Light Detection and Ranging)

    • Seismic sensors

  • millions of points to model a scene

  • data type to efficiently manage this data

    • SDO_PC: can handle billions of points

  • Triangulated Irregular Network: create surfaces from point data sets

    • SDO_TIN: scalable storage


General 3d processing flow

General 3D processing flow

Convert to Geometries

LiDAR Files

LiDAR loader

Query and Clip

TIN tables

Generate TIN

SDO_PC tables

Load point cloud

Query and Clip

Convert to Geometries

Flat files

Point Tables


Data loading using liblas

Data loading using libLAS

  • available from http://liblas.org/

  • for Windows, download and install pre-build binaries in the OSGeo4W package http://trac.osgeo.org/osgeo4w/

    • A packaging of a number of open source tools: libraries, desktop GIS (Quantum, Grass, …), servers (UMN Mapserver, …)

  • main tools (see http://liblas.org/docs.html for details)

    • lasinfo = returns information about a LAS file

    • las2oci = loads a LAS file into Oracle

    • las2las = copy and transform a LAS file

    • las2txt = converts a LAS file to a text format

    • txt2las = the reverse


Management of 3d data

Management of 3D data

  • correct, integral usage of height information („z“)

    • 3D indexing and query

    • coordinate system support

  • ability to model 3D objects

    • points, lines, polygons with „z“

    • solids, surfaces

    • point clouds

  • need for higher-level data models

    • eg. support for CityGML data model


Constructing 3d objects

Constructing 3D objects

  • Simple Surfaces

    • Face = 3D Polygon

  • Composite Surface

    • Multiple connected faces

  • Simple Solid

    • Closed composite surface

  • Composite Solid

    • Multiple connected simple solids

  • Extrusion

    • Generating solids from 2D polygons


Data models for city modelling

Data models for City Modelling

  • Structures at multiple levels of detail

  • Textures and facades

  • Orthophotos

  • Versioning

  • 3DCityDB (open source data model) is widely used

LOD1 Building

LOD2 Building

LOD3 Building

LOD4 Building

Images courtesy of: Research Center Karlsruhe


City of berlin 3d city model

City of Berlin – 3D City Model

  • 550000 buildings, reconstructed from 2D cadastre and LIDAR data

  • Textures extracted from oblique aerial photography

  • Stored in 3DCityDB

  • 2012 Oracle Spatial Excellence Award

  • Implemented by TU Berlin

Images courtesy of: TU Berlin, Institute for Geodesy and Geoinformation


Engineering construction crossrail

Engineering & Construction - Crossrail


Publish kml in the xdb repository

Publish KML in the XDB Repository


View in google earth

View in Google Earth


Summary

Summary

  • integrated storage and management of all relevant data types

  • scalability to huge amounts of data and large numbers of users

  • comprehensive tooling and partner solution portfolio

  • leveraging key features of Oracle Database


Upcoming events

Upcoming Events

  • Oracle Spatial and Graph Users Conference 2013

    • Washington, DC, May 22

    • in conjunction with Location Intelligence 2013, May 21

    • new: attend by Webcast, „live“ or „on-demand“

    • see http://www.locationintelligence.net/dc/registration/


  • Login