research-article

Benchmarking and improving point cloud data management in MonetDB

Online:10 March 2015Publication History

Abstract

The popularity, availability and sizes of point cloud data sets are increasing, thus raising interesting data management and processing challenges. Various software solutions are available for the management of point cloud data. A benchmark for point cloud data management systems was defined and it was executed for several solutions. In this paper we focus on the solutions based on the column-store MonetDB, the generic out-of-the-box approach is compared with two alternative approaches that exploit the spatial coherence of the data to improve the data access and to minimize the storage requirements.

References

  1. Actueel Hoogtebestand Nederland (AHN). http://www.ahn.nl/.Google ScholarGoogle Scholar
  2. Massive point clouds for eSciences. http://www.pointclouds.nl/.Google ScholarGoogle Scholar
  3. MonetDB. https://www.monetdb.org.Google ScholarGoogle Scholar
  4. MonetDB binary bulk load. https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/BinaryBulkLoad.Google ScholarGoogle Scholar
  5. Oracle Database Online Documentation 12c Release 1 (12.1): Spatial and Graph Developer's Guide / SDO_PC_PKG Package (Point Clouds). http://docs.oracle.com/database/121/SPATL/sdo_pc_pkg_ref.htm.Google ScholarGoogle Scholar
  6. Oracle Exadata Database Machine X4-2. https://www.oracle.com/engineered-systems/exadata/database-machine-x4-2/index.html.Google ScholarGoogle Scholar
  7. Rapidlasso GmbH. http://rapidlasso.com/.Google ScholarGoogle Scholar
  8. rapidlasso GmbH LASzip - free and lossless LiDAR compression. http://www.laszip.org/.Google ScholarGoogle Scholar
  9. P. Boncz, S. Manegold, and M. Kersten. Optimizing main-Memory join on modern hardware. TKDE, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. J. R. Herring. OpenGIS Implementation Standard for Geographic information - Simple feature access - Part 1: Common architecture. http://portal.opengeospatial.org/files/?artifact_id=25355, May 2011.Google ScholarGoogle Scholar
  11. S. Manegold, M. Kersten, and P. Boncz. Database Architecture Evolution: Mammals Flourished Long Before Dinosaurs Became Extinct. VLDB, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. O. Martinez-Rubi, M. Kersten, R. Goncalves, and M. Ivanova. A column-store meets the point clouds. FOSS4GEurope, 2014.Google ScholarGoogle Scholar
  13. P. Ramsey. A PostgreSQL extension for storing point cloud (LIDAR) data. https://github.com/pramsey/pointcloud.Google ScholarGoogle Scholar
  14. L. Sidirourgos and M. Kersten. Column Imprints: A Secondary Index Structure. SIGMOD, 2013. Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. P. M. Suijker, I. Alkemade, M. P. Kodde, and A. E. Nonhebel. User requirements Massive Point Clouds for eSciences (WP1). Technical report, Delft University of Technology, April 2014.Google ScholarGoogle Scholar
  16. P. van Oosterom, O. Martinez-Rubi, M. Ivanova, M. Horhammer, D. Geringer, S. Ravada, T. Tijssen, M. Kodde, and R. Goncalves. Massive point cloud data management: design, implementation and execution of a point cloud benchmark. Computer Graphics, 2015. (Manuscript accepted for publication).Google ScholarGoogle Scholar

Index Terms

  1. Benchmarking and improving point cloud data management in MonetDB

            Comments

            Login options

            Check if you have access through your login credentials or your institution to get full access on this article.

            Sign in

            Full Access

            • Published in

              SIGSPATIAL Special cover image
              SIGSPATIAL Special  Volume 6, Issue 2
              Big Spatial Data (part 1)
              July 2014
              39 pages
              EISSN:1946-7729
              DOI:10.1145/2744700
              Issue’s Table of Contents

              Copyright © 2015 Authors

              Publisher

              Association for Computing Machinery

              New York, NY, United States

              Publication History

              • Online: 10 March 2015

              Qualifiers

              • research-article

            PDF Format

            View or Download as a PDF file.

            PDF

            eReader

            View online with eReader.

            eReader
            About Cookies On This Site

            We use cookies to ensure that we give you the best experience on our website.

            Learn more

            Got it!