Structure design and establishment of database application system for alien species in Shandong Province, China

• Published in: Journal of forestry research Vol. 18; no. 1; pp. 11 - 16
• Main Authors: Guo, Wei-hua, Liu, Heng, Du, Ning, Zhang, Xin-shi, Wang, Ren-qing
• Format: Journal Article
• Language: English
• Published: Key Laboratory of Environmental Change and Natural Disaster of Ministry of Education,Beijing Normal University,Beijing 100875,P R.China%College of Life Sciences,Shandong University,Jinan 250100,P.R.China%College of Life Sciences,Shandong University,Jinan 250100,P.R.China 01.03.2007; College of Life Sciences,Shandong University,Jinan 250100,P.R.China; Laboratory of Quantitative Vegetation Ecology,Institute of Botany,Chinese Academy of Sciences,Beijing 100093,P.R.China; Key Laboratory of Environmental Change and Natural Disaster of Ministry of Education,Beijing Normal University,Beijing 100875,P R.China
• Subjects: 分布图; 外来物种; 数据库应用系统; 结构设计; Alien species; Database application system; Distribution map; Shandong Province; SQL Server; Visual Studio.net
• ISSN: 1007-662X; 1993-0607
• DOI: 10.1007/s11676-007-0002-3

This paper presents a case study on structure design and establishment of database application system for alien species in Shandong Province, integrating with Geographic Information System, computer network, and database technology to the research of alien species. The modules of alien species database, including classified data input, statistics and analysis, species pictures and distribution maps, and out date input, were approached by Visual Studio.net 2003 and Microsoft SQL server 2000. The alien species information contains the information of classification, species distinction characteristics, biological characteristics, original area, distribution area, the entering fashion and route, invasion time, invasion reason, interaction with the endemic species, growth state, danger state and spatial information, i.e. distribution map. Based on the above bases, several models including application, checking, modifying, printing, adding and returning models were developed. Furthermore, through the establishment of index tables and index maps, we can also spatially query the data like picture, text and GIS map data. This research established the technological platform of sharing information about scientific resource of alien species in Shandong Province, offering the basis for the dynamic inquiry of alien species, the warning technology of prevention and the fast reaction system. The database application system possessed the principles of good practicability, friendly user interface and convenient usage. It can supply full and accurate information inquiry services of alien species for the users and provide functions of dynamically managing the database for the administrator.