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

Abstract

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.

Keywords

Alien species / Database application system / Distribution map / SQL Server / Visual Studio.net / Shandong Province

References

[1] Chen H., Zheng Y., Li F. Shandong florae species, 2002 Beijing: China Forestry Press

[2] Li Z.Y., Xie Y. Chinese alien invasion D. Environmental and economic costs of non-indigenous species in the United States Bioscience, 2000, 50: 53-65.

[3] Liang J., Zhang X. Ecological control of forest pest: a new strategy for forest pest control Journal of Forestry Research, 2005, 16(4): 339-342.

[4] Liu J., Wang R., Zhang Z. Advances in Nonindigenous Plant Species Research Advance of Plant Science, 2001, 4: 335-344.

[5] Pimentel D., Zuniga R., Morrison D. Update on the environmental and economic costs associated with alien-invasive species in the United States Ecological Economics, 2005, 52(3): 273-288.

[6] Rejmanek M. A theory of seed plant invasiveness: the first sketch Biological Conservation, 1996, 78: 171-181.

[7] Rejmanek M., Richardson D.M. What attributes make some plant species more invasive? Ecology, 1996, 77: 1655-1661.

[8] Shan S. Applied compendious tutorial of SQL Server, 2002 Beijing: Tsinghua University Press

[9] Simberloff D. How risky is biological control? Ecology, 1996, 77: 1965-1974.

[10] Species Survival Commission IUCN guidelines for the prevention of biodiversity loss caused by alien invasive species, 2000 Gland Switzerland: The 51st Meeting of the IUCN Council

[11] Stachowicz J.J., Whitlatch R.B., Osman R.W. Species diversity and invasion resistance in a marine ecosystem Science, 1999, 286: 1577-1579.

[12] Tian J. Alien invasive harmful species of Shandong and the integrative prevention and cure technology, 2004 Beijing: Science Press

[13] User M.B. Biological invasions of nature reserves: a search for generalizations Bio. Conserv., 1998, 44: 119-135.

[14] Venette R.C., Carey J.R. Invasion biology: Rethinking our response to alien species California Agriculture, 1998, 52: 13-17.

[15] Wan F.H., Guo J.Y., Wang D.H. Alien invasive species in China: their damages and management strategies Biodiversity Science, 2002, 10: 119-125.

[16] Wilcove D.S., Rothstein D., Dubow J., Phillips A., Losos E. Quantifying threats to imperiled species in the United States Bioscience, 1998, 48(8): 607-615.

[17] Zhong Y.D., Li M.H., Kraeuchi N. Global warming facilitates plant migration and biological invasion Geographical Research, 2004, 23: 347-356.