Mastering the challenges of 3d data management
1 / 19

Mastering the Challenges of 3D Data Management - PowerPoint PPT Presentation

  • Uploaded on

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Mastering the Challenges of 3D Data Management' - belden

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




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

  • for Windows, download and install pre-build binaries in the OSGeo4W package

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

  • main tools (see 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


  • 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