SQL level global query resolving for web based GIS

被引:0
|
作者
Chen, Bin [1 ]
Huang, Fengru [1 ]
Huang, Zhou [1 ]
Sun, Yumei [1 ,2 ]
Fang, Yu [1 ]
机构
[1] Peking Univ, Inst Remote Sensing & Geog Informat Syst, Beijing 100871, Peoples R China
[2] Shijiazhuang Inst Railway Technol, Shijiazhuang, Hebei, Peoples R China
关键词
SQL; GIS; spatial database; global query resolve;
D O I
10.1117/12.764934
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
This paper introduced a SQL level approach to resolve global spatial query in Web based heterogeneous distributed spatial database environment. The main prohibit of this SQL level approach was its widespread compatibility and standardization. Firstly, a SQL based Equivalent Distributed Program (EDP) was introduced to express distributed spatial processing transactions. Then global resource directories for virtual global view describing were discussed to organize information that resolving need. The contents of global resource directories included data storage directory, hosts directory and working status directory. With these mechanisms, relational algebra expression equivalence principles were utilized to resolve global spatial queries to EDPs. Finally, several samples were presented to show the process of resolving. This approach was suitable to all sorts of distributed computing environments either centralized such as CORBA or decentralized such as P2P computing platforms.
引用
收藏
页数:10
相关论文
共 50 条
  • [1] SQL reasoning of GIS Chinese query based on case
    School of Computer Science, Wuhan University, 129 Luoyu Road, Wuhan 430079, China
    不详
    不详
    Geomatics Inf. Sci. Wuhan Univ., 2007, 4 (369-372):
  • [2] Translation of Chinese query sentence of gis to SQL based on semantic meaning query tree
    Wuhan Daxue Xuebao (Xinxi Kexue Ban), 2006, 10 (924-927):
  • [3] An efficient Web-based semantic SQL query generator
    Rishe, N
    Naboulsi, K
    Wolfson, O
    Ehlmann, B
    19TH IEEE INTERNATIONAL CONFERENCE ON DISTRIBUTED COMPUTING SYSTEMS WORKSHOP, PROCEEDINGS, 1999, : 23 - 30
  • [4] 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
  • [5] Fragmented Query parse tree based SQL Injection Detection System for Web Applications
    Priyaa, B. Deva
    Devi, M. Indra
    2016 INTERNATIONAL CONFERENCE ON COMPUTING TECHNOLOGIES AND INTELLIGENT DATA ENGINEERING (ICCTIDE'16), 2016,
  • [6] Translating XQuery to SQL based on query forests
    Chang, YH
    Liu, G
    Wu, SS
    DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PROCEEDINGS, 2005, 3453 : 894 - 899
  • [7] Global and Personalized Query Probability for Obfuscation-Based Web Search
    Wang, Hao
    Liu, Wenyan
    Wang, Xiaoling
    Zhang, Yingjie
    11TH IEEE INTERNATIONAL CONFERENCE ON KNOWLEDGE GRAPH (ICKG 2020), 2020, : 259 - 266
  • [8] SQL/SDA: A query language for supporting spatial data analysis and its Web-based implementation
    Lin, H
    Huang, B
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2001, 13 (04) : 671 - 682
  • [9] 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
  • [10] Grid global structure query language G2SQL
    Xie, Z.
    Chen, Z. L.
    Wu, L.
    Tian, G.
    2008 PROCEEDINGS OF INFORMATION TECHNOLOGY AND ENVIRONMENTAL SYSTEM SCIENCES: ITESS 2008, VOL 2, 2008, : 847 - 852