摘要： 提出了一种基于数据访问流进行索引优化的方法，该方法通过集成业务流程模型与数据模型，抽取了流程活动中包含的数据访问操作和流程的控制结构形成数据访问流，分析了数据访问流中数据访问操作的频度，为频繁数据访问操作所对应的数据项创建索引，达到改善数据访问性能的目的。实验结果表明，该方法提高了数据查询的速度。
关键词:
索引优化,
数据访问流,
数据模型,
流程模型
Abstract: A novel method called data-access-flow based index optimization (DAFIO) is proposed to provide automatic index select for database in order to improve the data access performance. By integrating the data model and process model of the IT systems and getting data access flow, the DAFIO method can analyze the data access flow to find those data item which are accessed frequently, and then create indexes for these frequent items. The experiment results show that the novel method is effective to improve the data access performance.
Key words:
Index optimization,
Data access flow,
Data model,
Process model
中图分类号:
傅向华;冯博琴;王小民;王志强. 一种基于数据访问流的数据库索引优化方法[J]. 计算机工程, 2007, 33(12): 99-101.
FU Xianghua; FENG Boqin; WANG Xiaoming; WANG Zhiqiang. Index Optimization for Database Based on Data Access Flow[J]. Computer Engineering, 2007, 33(12): 99-101.