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 条
  • [1] On Index-based Query in SQL Server Database
    Qi Chunxia
    PROCEEDINGS OF THE 35TH CHINESE CONTROL CONFERENCE 2016, 2016, : 9519 - 9523
  • [2] QUERY OPTIMIZATION IN MICROSOFT SQL SERVER
    Haxhijaha, Blerta
    Ajdari, Jaumin
    Raufi, Bujar
    Zenuni, Xhemal
    Ismaili, Florie
    INTERNATIONAL JOURNAL ON INFORMATION TECHNOLOGIES AND SECURITY, 2018, 10 (02): : 13 - 22
  • [3] Evaluation of Sub Query Performance in SQL Server
    Oktavia, Tanty
    Sujarwo, Surya
    ICASCE 2013 - INTERNATIONAL CONFERENCE ON ADVANCES SCIENCE AND CONTEMPORARY ENGINEERING, 2014, 68
  • [4] Seamless Integration of SQL Server Spatial Data on GIS Platform
    Zhou, Shunping
    Liu, Juan
    Wan, Bo
    Yang, Lin
    2010 18TH INTERNATIONAL CONFERENCE ON GEOINFORMATICS, 2010,
  • [5] Distributed/heterogeneous query processing in microsoft SQL server
    Blakeley, JA
    Cunningham, C
    Ellis, N
    Rathakrishnan, B
    Wu, MC
    ICDE 2005: 21ST INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2005, : 1001 - 1012
  • [6] A web page query technology based on ASP.NET and SQL Server
    Zhao, Guangshun
    Meng, Qingjin
    Bi, Jianxue
    2021 PROCEEDINGS OF THE 40TH CHINESE CONTROL CONFERENCE (CCC), 2021, : 6466 - 6469
  • [7] SPATIAL SQL - A QUERY AND PRESENTATION LANGUAGE
    EGENHOFER, MJ
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1994, 6 (01) : 86 - 95
  • [8] Research on the Remote Data Collection Based SQL Server
    QI Xiangyang~1 LIN Shuzhong~1 CUI Hui~2 WANG Jiangfeng~2 SUN Huilai~1 (1.School of Mechanical & Electronic Engineering
    武汉理工大学学报, 2006, (S3) : 828 - 832
  • [9] Research on the remote data collection based SQL Server
    Qi Xiangyang
    Lin Shuzhong
    Cui Hui
    Wang Jiangfeng
    Sun Huilai
    1ST INTERNATIONAL SYMPOSIUM ON DIGITAL MANUFACTURE, VOLS 1-3, 2006, : 828 - 832
  • [10] Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics
    Lee, Kukjin
    Konig, Arnd Christian
    Narasayya, Vivek
    Ding, Bolin
    Chaudhuri, Surajit
    Ellwein, Brent
    Eksarevskiy, Alexey
    Kohli, Manbeen
    Wyant, Jacob
    Prakash, Praneeta
    Nehme, Rimma
    Li, Jiexing
    Naughton, Jeff
    SIGMOD'16: PROCEEDINGS OF THE 2016 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2016, : 1753 - 1764
12345