| Oracle查询优化技术在卫星计费系统中的应用研究 |
| |
| 引用本文： | 林学峰,唐艳,窦晓晶.Oracle查询优化技术在卫星计费系统中的应用研究[J].安徽大学学报(自然科学版),2009,33(1). |
| |
| 作者姓名： | 林学峰 唐艳 窦晓晶 |
| |
| 作者单位： | 61081部队,北京,100094
|
| |
| 摘 要： | 在超大容量表数据库中,查询优化尤为重要.通过对卫星计费系统数据库查询特点的分析,提出对超大容量表的"分而治之"的设计策略,探讨如何解决超大容量表查询快速响应的问题,并在卫星计费系统中实现之.结果表明,采用"分而治之"的设计,结合Oracle的优化技术,可以满足用户对查询时间的要求.
|
| 关 键 词： | 超大容量表 数据库 查询优化 卫星计费管理系统 |
Application and research of query optimization in satellite fee system |
| |
| LIN Xue-feng,TANG Yan,DOU Xiao-jing.Application and research of query optimization in satellite fee system[J].Journal of Anhui University(Natural Sciences),2009,33(1). |
| |
| Authors: | LIN Xue-feng TANG Yan DOU Xiao-jing |
| |
| Institution: | 61081部队,北京,100094 |
| |
| Abstract: | Query optimization was very important in database of super contain table.By analyzing the property of query in satellite fee system,the paper designed stratagem of partition,discussed how to solve the question about the response of rapid query of super contain table based on Oracle query optimization,and successfully applied it to the system.The main faces of introduction included that the factor of effect Oracle server performance,specialty of Oracle running,optimization principle of SQL language,and tunin... |
| |
| Keywords: | super contain table database query optimization satellite fee management system |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
