Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Geo-Information Science》 2006-01
Add to Favorite Get Latest Update

Implementation of Geometric Objects Based on PostgreSQL Spatial Database with LibPQ

WU Liang, LU Feng, LIU Xingquan, SHEN Paiwei (Institute of Informational Physics and Engineering, Central South University, Changsha 410083, China; Institute of Geographic Sciences and Natural Resources Research, CAS, Beijing 100101, China)  
It is an important task in GIS research to efficiently access and manipulate the spatial data stored in database management systems. The author introduces the spatial data storage methods in database management systems, then puts forward a method accessing and manipulating geometric objects with LibPQ, which is provided by PostgreSQL DBMS. This method allows users to expand user_defined geometric models with inheritance from system geometric model. Moreover, the method can make full use of an expanded user_defined geometric model to process spatial operators. As a kind of open source database management system, PostgreSQL DBMS can provide users with conveniently operated procedures at a price lower than the non-open source database management systems. Users can code inside the database management system to solve some problems which can not be dealt using the non-open source database management systems.
【Fund】: 本研究由国家863重大项目(2003AA135070);; 国家自然科学基金项目(40201043);; 中国科学院知识创新工程项目(CXIOG-D04-02)资助。
【CateGory Index】: P208
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 4 Hits
1 LU Jin-ge,YANG Yong-guo(College of Resources and Earth Science,China University of Mining and Technology,Xuzhou 221008,China);Constructing WebGIS Server Based on Open Source Software[J];Geomatics & Spatial Information Technology;2008-05
2 JI Guangrong,WANG Lianbo,ZHEN Haiyong(Information Science and Engineering College,Ocean University of China,Qingdao 266100,China);Design and Realization of Database in Liaohe Estuary Wetland Management Information System[J];Geospatial Information;2010-03
3 RUI Jianxun (School of Tourism,Shanghai Normal University,Shanghai,200234,China);Research on Tourism Information and Electronic Commerce Lab Construction[J];Tourism Science;2007-01
4 JU Shang(Ministry of Education Engineering Research Center for Enterprise Digital Technology,Tongji University,Shanghai 200092,China);Research of Feature-Based Municipal Data Management[J];Computer Technology and Development;2010-02
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 ZHANG Zai-rong~1,JI Jun~1,ZHAO Jin~2 (1.Department of Urban & Resource Science,Nanjing University,Nanjing 210093,China; 2.The No.3 Oil Factory of Daqing Ltd.,Daqing 163113,China);Semantic Based GIS Web Services[J];Journal of Jiangxi Normal University (Natural Sciences Edition);2004-03
2 LIN Wen-peng~①,WANG Chang-yao~①,LIN Hui-hua~②(①The State Key Laboratory of Remote Sensing Science,Institute of Remote Sensing Applications,Chinese Academy of Sciences,Beijing 100101,China;②College of geographical Sciences,Fujian Teachers University,Fuzhou 350007,China);Developing and implementing of enterprise geographical information network issuing based on servlet[J];Science of Surveying and Mapping;2004-05
3 LAN Xiao-ji ①②,ZHANG Shu-liang②,LIU De-er①,LU Guo-nian②(①Jiangxi University of Science and Technology,Ganzhou 341000;②Jiangsu Provincial Key Lab of GIS Science,Nanjing Normal University,Nanjing 210097);Study on GML spatial database[J];Science of Surveying and Mapping;2005-05
4 WANG Ya-qin~~(①②),TAO Hua-xue~~①,GAO Hua~②,SUN Cui-yu~~①(①College of Geo Info.Science and Technology,SUST,Shandong Tsingdao 266510;②College of Info.Science and Engineering,SDAU,Shandong Taian 271018);The research of multi-source heterogeneous spatial data exchange model based on GML[J];Science of Surveying and Mapping;2006-02
5 TIAN Mao-yi~(①),ZHANG Yan~(②),LU Xiu-shan~(①)(①Geoinformation Science & Engineering College,Shangdong University of Science and Technology,Qingdao 266510,China;②Department of Resource and civil engineering,Shangdong University of Science and Technology,Tai'an 271019);Framework of cyber-city's spatial information platform based on grid computing[J];Science of Surveying and Mapping;2006-03
6 ZHANG Ai-guo,WU Qun-yong,WANG Qin-min(Spatial Information Research Center of Fujian Province, Key lab of Data Mining and Information sharing of Ministry of Education, Fuzhou University, Fuzhou 350002);Research on GML storage based on PostgreSQL database[J];Science of Surveying and Mapping;2008-01
7 LI Lin~(1,2), WANG Hong~(1,2), ZHAO Ning~(1,2), XU Ming~(1,2)(1.School of Resources and Environment Science, Wuhan University,Wuhan 436079,China:on of China, Wuhan University,Wuhan 430079, China);Classification of Fundamental Geographical Information Based on Ontology[J];Geomatics World;2004-06
8 GUI Zhi ming,YAN Lei;A Study of Web Map Service Based on XML Web Service Architecture[J];Bulletin of Surveying and Mapping;2003-01
9 HU Yun;Problems and countermeasures of the information trend development on the tourism in china[J];Urban Problems;2004-02
10 WU Lun1, TANG Da-shi2, LIU Yu1(1.Department of RS & GIS, Peking University, Beijing 100871;2.Department of Computer Science, Peking University, Beijing 100871, China);Interoperable and Distributed Geographical Information Systems Based on Web Service[J];Geography and Geo-Information Science;2003-04
【Secondary References】
Chinese Journal Full-text Database 9 Hits
1 GAO Wan-lin,YU Li-na,WU Bin(China Agricultural University,Beijing 100083,China);The Research of WebGIS Application for Agricultural Irrigation Information Management[J];Geomatics World;2010-02
2 ZHENG Feng-ling,CHU Shao-lin,REN Yu-ping,Sailike·Douman(Grassland Research Institute of Xinjiang Academy of Animal Science,Xingjiang Urumqi 830000,China);An application study of the open source spatial information technology in grassland——Taking the topographical map processing by using GRASS GIS as an example[J];Pratacultural Science;2010-11
3 DONG Yan1, GENG Jie2, TAN Jing-xin1 (1. North China Institute of Computing Technology, Beijing 100083, China; 2. Navy Air Traffic Management Office, Beijing 100071, China);Design and implementation of radar surveillance display system based on OGR library[J];Computer Engineering and Design;2009-19
4 Zhu Songjie (Tourism Department in Suzhou Economics and Trade Vocational and Technological College, Su Suzhou, Jiangsu Province 215009);Practically Teaching Research on Tourism Electronic Commerce for the Professional Education[J];Journal of Shaanxi Vocational & Technical College;2009-04
5 LV Zi-qi,HUANG Ze-chun ( School of Civil Engineering,Southwest Jiaotong University,Chengdu 610031,China );Application of PostgreSQL to railway spatial data management[J];Railway Computer Application;2010-04
6 WU Li(Ministry of Education Engineering Research Center for Enterprise Digital Technology,Tongji University,Shanghai 200092,China);Design of City Infrastructure Management System Based on WebGIS[J];Computer Technology and Development;2010-01
7 JU Shang(Ministry of Education Engineering Research Center for Enterprise Digital Technology,Tongji University,Shanghai 200092,China);Research of Feature-Based Municipal Data Management[J];Computer Technology and Development;2010-02
8 WANG Qian-kun,LIU Kun-yu(School of Civil Engineering and Architecture,Wuhan University of Technology,Wuhan 430070,China);Design of Emergency Management Information System for Metro Engineering Construction[J];Journal of Civil Engineering and Management;2011-02
9 Dong Gui (Institute of Scientific & Technical Information of China,Beijing 100038,China);Research on PostgreSQL-based TMX Storage and Implementation of Corpus Retrieval Platform[J];New Technology of Library and Information Service;2011-Z1
China Proceedings of conference Full-text Database 1 Hits
1 Bin Wu~1,Wanlin Gao~1,Qing Wang~1,Zhen Li~1,Xiang Sun~2,Jianhui Du~3 1 College of Information and Electrical Engineering,China Agricultural University, Beijing,P.R.China 2 National Engineering Research Center for Information Technology in Agriculture, Beijing,P.R.China 3 Yunnan Agriculture Department,Yunnan Province,P.R.China;Research on Information Management System of Agricultural Irrigation Based on WebGIS[A];[C];2009
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved