Paper Info
Title
Octree-based indexing for 3D pointclouds within an Oracle Spatial DBMS
Abstract
A large proportion of today's digital datasets have a spatial component. The effective storage and management of which poses particular challenges, especially with light detection and ranging (LiDAR), where datasets of even small geographic areas may contain several hundred million points. While in the last decade 2.5-dimensional data were prevalent, true 3-dimensional data are increasingly commonplace via LiDAR. They have gained particular popularity for urban applications including generation of city-scale maps, baseline data disaster management, and utility planning. Additionally, LiDAR is commonly used for flood plane identification, coastal-erosion tracking, and forest biomass mapping. Despite growing data availability, current spatial information systems do not provide suitable full support for the data's true 3D nature. Consequently, one system is needed to store the data and another for its processing, thereby necessitating format transformations. The work presented herein aims at a more cost-effective way for managing 3D LiDAR data that allows for storage and manipulation within a single system by enabling a new index within existing spatial database management technology. Implementation of an octree index for 3D LiDAR data atop Oracle Spatial 11g is presented, along with an evaluation showing up to an eight-fold improvement compared to the native Oracle R-tree index.
Year
DOI
Venue
2013
10.1016/j.cageo.2012.08.021
Computers & Geosciences
Keywords
DocType
Volume
oracle spatial dbms,new index,octree index,octree-based indexing,spatial component,current spatial information system,data availability,native oracle r-tree index,3-dimensional data,spatial database management technology,lidar data,baseline data disaster management,octree,laser scanning
Journal
51,
ISSN
Citations 
PageRank 
0098-3004
3
0.55
References 
Authors
12
4
Name
Order
Citations
PageRank
Bianca Schön1313.28
Abu Saleh Mohammad Mosa2838.83
Debra F. Laefer3547.45
Michela Bertolotto486391.77