摘要
文章主要介绍了SQL Server 2000的体系结构、安全模式、管理数据库文件的方法、数据的转换、备份、还原和复制以及Transact-SQL语言设计技术。叙述了应用系统存储过程和触发器来保证数据间的完整性和一致性的实现过程。重点对SQL Server数据库底层的配置、管理数据、性能优化和安全性管理进行详细阐述。最后,通过以上学习,将SQL Server 2000和oracle数据库的性能进行了比较,总结出它们各自的特点。目前,在数据库的实际应用领域中,很多数据库管理都还存在一定的问题,导致数据库性能较差。研究此课题对于数据库系统选择和应用有一定意义。
The article introduces the architecture,security model,database file management method,data conversion,backup,restore and replication as well as the Transact-SQL language design.Describes the application process and the flip-flop storage to ensure data integrity and consistency between the realization of the process.Focus on the underlying SQL Server database configuration,management data,performance optimization and security management in detail.Finally,the above study,the SQL Server 2000 and oracle database performance comparison,summed up the characteristics of their own.At present,the practical application in the database field,a lot of database management are some problems still exist,resulting in poor database performance.To study the subject for the selection and application of database systems have a certain significance.
出处
《电脑知识与技术(过刊)》
2009年第5X期3614-3615,3618,共3页
Computer Knowledge and Technology