一种基于数据访问流的数据库索引优化方法该方法通过集成业务流程模型与数据模型，抽取了流程活动中包含的数据访问操作和流程的控制结构形成数据访问流，分析了数据访问流中...

一种基于数据访问流的数据库索引优化方法该方法通过集成业务流程模型与数据模型，抽取了流程活动中包含的数据访问操作和流程的控制结构形成数据访问流，分析了数据访问流中数据访问操作的频度，为频繁数据访问操作所对应的数据项创建索引，达到改善数据访问性能的目的。实验结果表明，该方法提高了数据查询的速度。-A novel method called data-access-flow based index optimization (DAFIO) is proposed to provide automatic index select for databasein order to improve the data access performance. By integrating the data model and process model of the IT systems and getting data access flow, theDAFIO method can analyze the data access flow to find those data item which are accessed frequently, and then create indexes for these frequentitems. The experiment results show that the novel method is effective to improve the data access performance.

数据库索引优化方法database.pdf