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 条
  • [31] Organization and Query of Point Clouds Data Based on SQL Server Spatial
    Chen, Yijin
    Zhang, Huixia
    Fu, Xiaoxue
    PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 7, 2010, : 178 - 181
  • [32] Natural Language Based SQL Query Verification Against Relational Schema
    Khan, Shoaib Saleem
    Saeed, Abid
    Majeed, Yasir
    Kamran, Muhammad
    INTELLIGENT TECHNOLOGIES AND APPLICATIONS, INTAP 2018, 2019, 932 : 391 - 400
  • [33] On Query-Based Search Of Possible Design Flaws Of SQL Databases
    Department of Informatics, Tallinn University of Technology, Akadeemia tee 15A, Tallinn
    12618, Estonia
    Lect. Notes Electr. Eng., (53-60):
  • [34] Query Reuse Based Query Planning for Searches over the Deep Web
    Wang, Fan
    Agrawal, Gagan
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, PT 2, 2010, 6262 : 64 - 79
  • [35] Research on Financial Data Query and Distribution Scheme Based on SQL Database
    Fu, Xiaolan
    WIRELESS COMMUNICATIONS & MOBILE COMPUTING, 2020, 2020 (2020):
  • [36] MULTI_LEVEL SECURE FROM WEB INTRUSION AND QUERY ATTACKS ON WEB DATABASE
    Kumari, R. Nirmala
    Mala, V
    INTERNATIONAL JOURNAL ON SMART SENSING AND INTELLIGENT SYSTEMS, 2022, 10 (05): : 271 - 283
  • [38] Web log mining and parallel SQL based execution
    Kitsuregawa, M
    Shintani, T
    Yoshizawa, T
    Pramudiono, I
    DATABASES IN NETWORKED INFORMATION SYSTEMS, PROCEEDINGS, 2001, 1966 : 20 - 32
  • [39] Design of county-level soil information system based on Web-GIS
    Li, Baoguo, 1600, Chinese Society of Agricultural Engineering (30):
  • [40] Query based Personalization in Semantic Web Mining
    Thakur, Mahendra
    Jain, Yogendra Kumar
    Silakari, Geetika
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2011, 2 (02) : 117 - 123