{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,8,8]],"date-time":"2024-08-08T04:34:20Z","timestamp":1723091660647},"reference-count":19,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2015,8]]},"abstract":"<jats:p>Earth observation sciences, astronomy, and seismology have large data sets which have inherently rich spatial and geospatial information. In combination with large collections of semantically rich objects which have a large number of thematic properties, they form a new source of knowledge for urban planning, smart cities and natural resource management.<\/jats:p>\n          <jats:p>Modeling and storing these properties indicating the relationships between them is best handled in a relational database. Furthermore, the scalability requirements posed by the latest 26-attribute light detection and ranging (LIDAR) data sets are a challenge for file-based solutions.<\/jats:p>\n          <jats:p>In this demo we show how to query a 640 billion point data set using a column store enriched with GIS functionality. Through a lightweight and cache conscious secondary index called Imprints, spatial queries performance on a flat table storage is comparable to traditional file-based solutions. All the results are visualised in real time using QGIS.<\/jats:p>","DOI":"10.14778\/2824032.2824110","type":"journal-article","created":{"date-parts":[[2015,9,16]],"date-time":"2015-09-16T12:18:17Z","timestamp":1442405897000},"page":"1956-1959","source":"Crossref","is-referenced-by-count":9,"title":["GIS navigation boosted by column stores"],"prefix":"10.14778","volume":"8","author":[{"given":"Foteini","family":"Alvanaki","sequence":"first","affiliation":[{"name":"Centrum Wiskunde &amp; Informatica, Amsterdam, The Netherlands"}]},{"given":"Romulo","family":"Goncalves","sequence":"additional","affiliation":[{"name":"NLeSC Amsterdam, The Netherlands"}]},{"given":"Milena","family":"Ivanova","sequence":"additional","affiliation":[{"name":"NuoDB Cambridge MA"}]},{"given":"Martin","family":"Kersten","sequence":"additional","affiliation":[{"name":"Centrum Wiskunde &amp; Informatica, Amsterdam, The Netherlands"}]},{"given":"Kostis","family":"Kyzirakos","sequence":"additional","affiliation":[{"name":"Centrum Wiskunde &amp; Informatica, Amsterdam, The Netherlands"}]}],"member":"320","published-online":{"date-parts":[[2015,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.asprs.org\/a\/society\/committees\/lidar\/lidar\\_format.html.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.asprs.org\/a\/society\/committees\/lidar\/lidar\\_format.html."},{"key":"e_1_2_1_2_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.laszip.org.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.laszip.org."},{"key":"e_1_2_1_3_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.arcgis.com.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.arcgis.com."},{"key":"e_1_2_1_4_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.ahn.nl.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.ahn.nl."},{"key":"e_1_2_1_5_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/rapidlasso.com.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/rapidlasso.com."},{"key":"e_1_2_1_6_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.qgis.org.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.qgis.org."},{"key":"e_1_2_1_7_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.openstreetmap.org.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.openstreetmap.org."},{"key":"e_1_2_1_8_1","unstructured":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.eea.europa.eu\/data-and-maps\/data\/urban-atlas.  https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.eea.europa.eu\/data-and-maps\/data\/urban-atlas."},{"key":"e_1_2_1_9_1","volume-title":"OpenGIS Implementation Standard","author":"Open Geospatial Consortium","year":"2010"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1007\/s007780050076"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687618"},{"key":"e_1_2_1_12_1","volume-title":"IEEE TKDE, 2002","author":"Manegold S.","year":"2002"},{"key":"e_1_2_1_13_1","unstructured":"O. Martinez-Rubi et al. A column-store meets the point cloud. FOSS4G-Europe 2014.  O. Martinez-Rubi et al. A column-store meets the point cloud. FOSS4G-Europe 2014."},{"key":"e_1_2_1_14_1","unstructured":"S. Ottens. Loading AHN2 into PostgreSQL pointcloud. https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.geodan.nl\/loading-ahn2-into-postgresql-pointcloud\/ 2014.  S. Ottens. Loading AHN2 into PostgreSQL pointcloud. https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/http\/www.geodan.nl\/loading-ahn2-into-postgresql-pointcloud\/ 2014."},{"key":"e_1_2_1_15_1","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1007\/978-1-4612-0871-6_2","volume-title":"Space-Filling Curves","author":"Sagan H.","year":"1994"},{"key":"e_1_2_1_16_1","volume-title":"SIGMOD","author":"Sidirourgos L.","year":"2013"},{"key":"e_1_2_1_17_1","volume-title":"VLDB","author":"Stonebraker M.","year":"2005"},{"key":"e_1_2_1_18_1","volume-title":"Computer Graphics, 2015","author":"van Oosterom P.","year":"2015"},{"key":"e_1_2_1_19_1","volume-title":"SDH","author":"van Oosterom P.","year":"1996"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/https\/dl.acm.org\/doi\/pdf\/10.14778\/2824032.2824110","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:07:15Z","timestamp":1672222035000},"score":1,"resource":{"primary":{"URL":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/https\/dl.acm.org\/doi\/10.14778\/2824032.2824110"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2015,8]]},"references-count":19,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2015,8]]}},"alternative-id":["10.14778\/2824032.2824110"],"URL":"https:\/\/summer-heart-0930.chufeiyun1688.workers.dev:443\/https\/doi.org\/10.14778\/2824032.2824110","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2015,8]]}}}