系统数据库数据量大时,常常会遇到系统响应时间过长、占用系统资源过多等一系列问题.因此对海量数据查询技术的研究就很必要.文中基于Oracle数据库,采用各种措施和方法来提高响应速度:合理设计数据库结构、使用索引、分区、SQL语句优化等手段优化数据库.另外,分页显示查询结果也能很大地提高查询速度.实验证明,优化后速度明显提高了很多.因此可见,文中采用的优化方法对海量数据的查询优化是正确有效的.%While database has large amount of data, the inquires will have a series of problems like system response time is too long and take up too many system resources. So the query optimization research on the mass of data based on Oracle database is necessary. It uses the various measures and methods to improve the response speed based on Oracle database such as reasonably designing the database structure, the use of the index .partition, SQL optimization method. In addition, pagination display the query results can also greatly improve query speed. Experiments show the optimization obviously improves the speed a lot.
展开▼
