| C/S环境下信息系统优化设计的若干问题 |
| |
| 引用本文： | 张爱华,陈晓苏,余爱国.C/S环境下信息系统优化设计的若干问题[J].华中科技大学学报(自然科学版),1999,27(4):31-33. |
| |
| 作者姓名： | 张爱华 陈晓苏 余爱国 |
| |
| 作者单位： | 1. 华中理工大学计算机科学与技术学院
2. 武汉市国家税务局洪山分局计算中心 |
| |
| 摘 要： | 以数据库ＳＱＬＳＥＲＶＥＲ为例，提出了一些优化Ｃ／Ｓ环境下的信息系统的措施：根据实际情况选择适当的数据库规范级别、合理规划数据库的数据关系及类型、以少量冗余换取系统性能等方法优化数据字典，确定在适当对象上建立索引和选择适当的索引类型等方法优化索引，通过限制查询结果集、减少查询必须连接的表的数目、编写和调用存储过程等方法优化查询，通过缩短事务、编写调用数据库触发器等方法提高系统性能和可靠性
|
| 关 键 词： | 网络 优化 数据库系统 可靠性 性能 |
| 修稿时间： | 1998-11-25. |
On Optimizing the Design of Information System Based on the Client/Server Architecture |
| |
| Zhang Aihua,Chen Xiaosu,Yu Aiguo.On Optimizing the Design of Information System Based on the Client/Server Architecture[J].JOURNAL OF HUAZHONG UNIVERSITY OF SCIENCE AND TECHNOLOGY.NATURE SCIENCE,1999,27(4):31-33. |
| |
| Authors: | Zhang Aihua Chen Xiaosu Yu Aiguo |
| |
| Abstract: | From the development practice, we introduced some methods of optimizing
the design of information system based on the Client/Server architecture to boost the
performance and improve security, with the DBMS SQL Server as an example, of adopting a
proper normal form rank of database and rational relations of data to optimize the logical design
of database, boosting performance in return with a little redundance, selecting proper data
objects for index and proper index types, restricting the row counts of query and the number of
associated tables when requests, writing stored procedures and triggers and confining the
length of transactions, etc. |
| |
| Keywords: | net optimizing DBMS performance security |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
