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
关键词
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 条
  • [41] XML-SQL: An XML query language based on SQL and path tables
    Pankowski, T
    XML-BASED DATA MANAGEMENT AND MULTIMEDIA ENGINEERING-EDBT 2002 WORKSHOPS, 2002, 2490 : 184 - 209
  • [42] Research of Information Extraction from SQL Server Based on SQL-DMO
    Zheng, Wei
    Wu, Yaping
    Chen, Yaofei
    AUTOMATION EQUIPMENT AND SYSTEMS, PTS 1-4, 2012, 468-471 : 2878 - +
  • [43] POINT CLOUD SERVER (PCS) : POINT CLOUDS IN-BASE MANAGEMENT AND PROCESSING
    Cura, Remi
    Perret, Julien
    Paparoditis, Nicolas
    ISPRS GEOSPATIAL WEEK 2015, 2015, II-3 (W5): : 531 - 539
  • [44] An SQL-like Query Tool for Data Anonymization and Outsourcing
    Nassar, Mohamed
    Orabi, Adel Al-Rahal
    Doha, Marwan
    AL Bouna, Bechara
    2015 INTERNATIONAL CONFERENCE ON CYBER SITUATIONAL AWARENESS, DATA ANALYTICS AND ASSESSMENT (CYBERSA), 2015,
  • [45] Developing a Data Mining Model for Predicting with SQL Server 2008
    Wang, Dongyun
    2010 INTERNATIONAL CONFERENCE ON INNOVATIVE COMPUTING AND COMMUNICATION AND 2010 ASIA-PACIFIC CONFERENCE ON INFORMATION TECHNOLOGY AND OCEAN ENGINEERING: CICC-ITOE 2010, PROCEEDINGS, 2010, : 83 - 86
  • [46] Implementing data mining algorithms with Microsoft SQL server.
    Curotto, CL
    Ebecken, NFF
    DATA MINING III, 2002, 6 : 73 - 82
  • [47] Language-Integrated Querying of XML Data in SQL Server
    Terwilliger, James F.
    Melnik, Sergey
    Bernstein, Philip A.
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2008, 1 (02): : 1396 - 1399
  • [48] Research on the Principle and Application of Multiversion Data in SQL Server 2008
    Li, Aiwu
    Liu, Hongying
    COMMUNICATIONS AND INFORMATION PROCESSING, PT 2, 2012, 289 : 707 - +
  • [49] Storing High Volumes of Data in MS SQL Server Express
    Fojtik, David
    Podesva, Petr
    Gebauer, Jan
    2015 16TH INTERNATIONAL CARPATHIAN CONTROL CONFERENCE (ICCC), 2015, : 125 - 128
  • [50] Advanced Studying on Microsoft SQL Server 2008 Data Mining
    Wang, Dongyun
    INFORMATION TECHNOLOGY FOR MANUFACTURING SYSTEMS, PTS 1 AND 2, 2010, : 748 - 752