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 条
  • [21] SQL Query Optimization in Content Based Image Retrieval Systems
    Angelescu, Nicoleta
    Coanda, Henri George
    Caciula, Ion
    Dragoi, Ioan Catalin
    Albu, Felix
    2016 INTERNATIONAL CONFERENCE ON COMMUNICATIONS (COMM 2016), 2016, : 395 - 398
  • [22] A Graph-Based Framework for Analyzing SQL Query Logs
    Wahl, Andreas M.
    Endler, Gregor
    Schwab, Peter K.
    Rith, Julian
    Herbst, Sebastian
    Lenz, Richard
    GRADES-NDA '18: PROCEEDINGS OF THE 1ST ACM SIGMOD JOINT INTERNATIONAL WORKSHOP ON GRAPH DATA MANAGEMENT EXPERIENCES & SYSTEMS (GRADES) AND NETWORK DATA ANALYTICS (NDA) 2018 (GRADES-NDA 2018), 2018,
  • [23] Complex GIS Query Based on Rule Engine
    Liu Chen-fan
    Liu Hai-yan
    2013 FOURTH INTERNATIONAL CONFERENCE ON COMPUTING FOR GEOSPATIAL RESEARCH AND APPLICATION (COM.GEO), 2013, : 144 - 145
  • [24] GIS Chinese Query System Based on CBR
    XU Aiping1
    2. 61512 Troops
    Wuhan University Journal of Natural Sciences, 2009, 14 (05) : 399 - 403
  • [25] Enhancing Natural Language Query to SQL Query Generation Through Classification-Based Table Selection
    Chopra, Ankush
    Azam, Rauful
    ENGINEERING APPLICATIONS OF NEURAL NETWORKS, EANN 2024, 2024, 2141 : 152 - 165
  • [26] An efficient Join-Engine to the SQL query based on Hive with Hbase
    Zhao Zhi-cheng
    Jiang Yi
    PROCEEDINGS OF THE 2015 INTERNATIONAL CONFERENCE ON APPLIED SCIENCE AND ENGINEERING INNOVATION, 2015, 12 : 991 - 996
  • [27] An SQL-Based Query Language and Engine for Graph Pattern Matching
    Krause, Christian
    Johannsen, Daniel
    Deeb, Radwan
    Sattler, Kai-Uwe
    Knacker, David
    Niadzelka, Anton
    GRAPH TRANSFORMATION, 2016, 9761 : 153 - 169
  • [28] A JIT Compilation-based Unified SQL Query Optimization System
    Lee, Myungcheol
    Lee, Miyoung
    Kim, ChangSoo
    2016 6TH INTERNATIONAL CONFERENCE ON IT CONVERGENCE AND SECURITY (ICITCS 2016), 2016, : 193 - 194
  • [29] On query completion in web search engines based on query stream mining
    Barouni-Ebrahimi, M.
    Ghorbani, Ali A.
    PROCEEDINGS OF THE IEEE/WIC/ACM INTERNATIONAL CONFERENCE ON WEB INTELLIGENCE: WI 2007, 2007, : 317 - 320
  • [30] SQL-Based Fuzzy Query Mechanism Over Encrypted Database
    Liu, Zheli
    Li, Jingwei
    Li, Jin
    Jia, Chunfu
    Yang, Jun
    Yuan, Ke
    INTERNATIONAL JOURNAL OF DATA WAREHOUSING AND MINING, 2014, 10 (04) : 71 - 87