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 datab...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.展开更多
在使用ASP.NET开发的WEB应用程序中,应用程序服务数据在实现成员资格、角色管理等功能中发挥着重要的作用。在实际应用环境中管理应用程序服务数据通常使用SQLServer企业版数据库而非默认的SQL Server Express数据库,这就需要对WEB应用...在使用ASP.NET开发的WEB应用程序中,应用程序服务数据在实现成员资格、角色管理等功能中发挥着重要的作用。在实际应用环境中管理应用程序服务数据通常使用SQLServer企业版数据库而非默认的SQL Server Express数据库,这就需要对WEB应用程序进行必要设置。具体设置步骤包括使用aspnet-regsql工具以向导或命令行方式创建和配置应用程序服务数据库,通过编辑WEB应用程序根web.config文件或编辑Internet信息服务设置2种方法修改LocalSqlServer连接字符串,进而实现使用SQL Server企业版数据库管理应用程序服务数据。展开更多
sql server 2012能够方便的帮助用户实现数据的管理功能,保障了数据库中数据的有效性、正确性和相容性,提供给用户多种技术实现数据的完整性。比如约束、规则、外键和触发器。约束其实是通过对规则的完整性来实现数据的完整性目标,本文...sql server 2012能够方便的帮助用户实现数据的管理功能,保障了数据库中数据的有效性、正确性和相容性,提供给用户多种技术实现数据的完整性。比如约束、规则、外键和触发器。约束其实是通过对规则的完整性来实现数据的完整性目标,本文结合具体应用场景,主要对约束这一技术进行介绍。展开更多
基金this study was supported by the Key Project of Natu-ral Science Foundation of Shandong Province(No. Z2003D05)Key Project of Environmental Protection Science of Shandong Province(No. 2004057)Outstanding Young Scientists Grants of Shandong Province(No.2005BS08010),China
文摘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.
文摘在使用ASP.NET开发的WEB应用程序中,应用程序服务数据在实现成员资格、角色管理等功能中发挥着重要的作用。在实际应用环境中管理应用程序服务数据通常使用SQLServer企业版数据库而非默认的SQL Server Express数据库,这就需要对WEB应用程序进行必要设置。具体设置步骤包括使用aspnet-regsql工具以向导或命令行方式创建和配置应用程序服务数据库,通过编辑WEB应用程序根web.config文件或编辑Internet信息服务设置2种方法修改LocalSqlServer连接字符串,进而实现使用SQL Server企业版数据库管理应用程序服务数据。
