Organization and Query of Point Clouds Data Based on SQL Server Spatial

被引：1
|
作者：
Chen, Yijin [1 ]
Zhang, Huixia [1 ]
Fu, Xiaoxue [1 ]
机构：
[1] China Univ Min & Technol, Coll Geosci & Surveying Engn, Beijing, Beijing, Peoples R China
来源：
PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 7 | 2010年
关键词：
point cloudss data; SQL Server 2008 Spatial; index;
D O I：
10.1109/ICCSIT.2010.5564615
中图分类号：
TP301 [理论、方法];
学科分类号：
081202 ;
摘要：
Three-dimensional laser scanning produces a large number of point clouds data. In order to efficiently retrieve the point clouds data, this paper stores the point clouds data in SQL Server 2008, and create a spatial index. Using C # software and SQL Server 2008 Spatial technology to achieve the storage and inquiry of point clouds data, and the results of the inquiry is carried out visualization in the MapObjects component, preparing for the follow-up feature extraction. The test shows that the method greatly improves the efficiency of point clouds data retrieval.
引用
收藏
页码：178 / 181
页数：4
相关论文
共 50 条
  • [31] Utility based query dissemination in Spatial Data Grid
    Yin, Dafei
    Chen, Bin
    Huang, Zhou
    Lin, Xin
    Fang, Yu
    SIXTH INTERNATIONAL CONFERENCE ON GRID AND COOPERATIVE COMPUTING, PROCEEDINGS, 2007, : 574 - 581
  • [32] SQL QUERY OPTIMIZATION FOR HIGHLY NORMALIZED BIG DATA
    Golov, Nikolay I.
    Ronnback, Lars
    BIZNES INFORMATIKA-BUSINESS INFORMATICS, 2015, 33 (03): : 7 - 14
  • [33] Scalable and data-aware SQL query recommendations
    Arzamasova, Natalia
    Boehm, Klemens
    INFORMATION SYSTEMS, 2021, 96
  • [34] Advanced Studying on Microsoft SQL Server Data Mining
    Ren, Zhijun
    2010 INTERNATIONAL CONFERENCE ON INNOVATIVE COMPUTING AND COMMUNICATION AND 2010 ASIA-PACIFIC CONFERENCE ON INFORMATION TECHNOLOGY AND OCEAN ENGINEERING: CICC-ITOE 2010, PROCEEDINGS, 2010, : 87 - 89
  • [35] Building Data Mining Applications with SQL Server 2005
    Wang, Dongyun
    Ren, Zhijun
    2008 4TH INTERNATIONAL CONFERENCE ON WIRELESS COMMUNICATIONS, NETWORKING AND MOBILE COMPUTING, VOLS 1-31, 2008, : 10859 - 10862
  • [36] SQL query to increase data accuracy and completeness in PATSTAT
    Pasimeni, Francesco
    WORLD PATENT INFORMATION, 2019, 57 : 1 - 7
  • [37] Distributed data organization and parallel data retrieval methods for huge laser scanner point clouds
    Ma, Hongchao
    Wang, Zongyue
    COMPUTERS & GEOSCIENCES, 2011, 37 (02) : 193 - 201
  • [38] Translating XQuery to SQL based on query forests
    Chang, YH
    Liu, G
    Wu, SS
    DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PROCEEDINGS, 2005, 3453 : 894 - 899
  • [39] Deductive database system based on SQL Server
    Tao, S.Q.
    Yuan, J.H.
    Jisuanji Gongcheng/Computer Engineering, 2001, 27 (03):
  • [40] Constitution of database on data sets for prediction of protein secondary structures based on SQL server
    College of Life Science, Nankai University, Tianjin 300071, China
    Gaojishu Tongxin, 2006, 6 (619-623):
12345