通过对SQL Server 2000分布式功能和机制的分析研究,给出实现SQL Server 2000分布式数据库系统的逻辑架构.介绍了SQL Server 2000服务器注册和构建链接服务器的步骤,讨论了SQL Server 2000数据库分布存储的数据分区概念、分区设计和实现...通过对SQL Server 2000分布式功能和机制的分析研究,给出实现SQL Server 2000分布式数据库系统的逻辑架构.介绍了SQL Server 2000服务器注册和构建链接服务器的步骤,讨论了SQL Server 2000数据库分布存储的数据分区概念、分区设计和实现,以及分布式分区视图的创建及其在分布式查询中的应用.展开更多
通过对SQL Server 2000数据库维护计划的深入研究,揭示配置数据库备份管理任务与系统提供的各项存储过程间的关系。对各相关系统存储过程进行详细分析,总结了存储过程的使用方法。结合网站技术,PHP技术等,探索通过网络操作SQL Server系...通过对SQL Server 2000数据库维护计划的深入研究,揭示配置数据库备份管理任务与系统提供的各项存储过程间的关系。对各相关系统存储过程进行详细分析,总结了存储过程的使用方法。结合网站技术,PHP技术等,探索通过网络操作SQL Server系统存储过程的方法。最终实现一个基于Web的远程数据库备份管理系统。展开更多
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.展开更多
文摘通过对SQL Server 2000分布式功能和机制的分析研究,给出实现SQL Server 2000分布式数据库系统的逻辑架构.介绍了SQL Server 2000服务器注册和构建链接服务器的步骤,讨论了SQL Server 2000数据库分布存储的数据分区概念、分区设计和实现,以及分布式分区视图的创建及其在分布式查询中的应用.
文摘通过对SQL Server 2000数据库维护计划的深入研究,揭示配置数据库备份管理任务与系统提供的各项存储过程间的关系。对各相关系统存储过程进行详细分析,总结了存储过程的使用方法。结合网站技术,PHP技术等,探索通过网络操作SQL Server系统存储过程的方法。最终实现一个基于Web的远程数据库备份管理系统。
基金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.
