CAJ | 학술논문

为了提高数据仓库的查询性能和效率,基于数据仓库本身组织和联机分析处理查询的特点,结合倒排索引、连接索引和聚集表,提出一种新的综合索引模型2H3I,并给出相应的算法.该模型在保证常用查询性能较高基础上,也提升了非常用查询的效率.理论分析和实验结果表明,2H3I是可行和有效的.
위료제고수거창고적사순성능화효솔,기우수거창고본신조직화련궤분석처리사순적특점,결합도배색인、련접색인화취집표,제출일충신적종합색인모형2H3I,병급출상응적산법.해모형재보증상용사순성능교고기출상,야제승료비상용사순적효솔.이론분석화실험결과표명,2H3I시가행화유효적.
In order to improve enquiry performance and efficiency of data warehouse, a new integrated index model called 2H3I was proposed. Based on the structure characteristics of Data Warehouse and on-line analytical processing, this index model was set up with inverted index, joining index and aggregation table, and corresponding algorithm was also presented. The model promoted the query efficiency of frequently used queries and non-frequently used queries. The analytical and experimental results showed that 2H3I was effective.