摘要
从可用性、维护性以及优化性方面探讨数据库分区机制,详细论述分区索引的内部原理,并结合工程项目中的具体实践应用,分析了分区优化技术在性能和可用性方面发挥的重要作用,对海量数据库管理、性能优化提供一种有效的解决方案。
This paper first discusses the mechanism of database partitioning in terms of its availability, maintainability and optimization resulting from the partitioning technique. Then, it describes in detail the mechanism of index partitioning. Finally,by examples,the paper demonstrates the important role of partitioning technique in enhancing data availability and bringing about optimal performance, and thus proposes an efficient solution to the management of large scale database and its performance optimization.
出处
《指挥信息系统与技术》
2010年第4期51-54,58,共5页
Command Information System and Technology
关键词
查询优化
数据库分区
本地索引
数据库管理
query performance optimization
database partitioning
local index
database man- agement
