分区表及物化视图技术在查询分析中的应用-计算机应用技术专业论文.docx

11 11 Abstract Wi伽 the development of database technology，more and more indus位y established its own database system. With the continuous expansion of business and continuous improvement of management information，enterprise database always manage a few hundred G or T data. Wi白白e growing amount of database data， database p时formance 阳ning more and more important. Database performance optimization of good or b圳 directly affects 也e response t怕le of 伽eupp配 application and us町 application software on the evaluation of the uppe汇 Partition table technology and materialized view tωhnology are important means of optimizing database p町formance. Partition table can be decomposed into operations on the op缸ation of the various small table ，this method can use parallel processing to improve the qu町y efficiency and resource utilization. In addition to，partition table also help to maintain and νOacc创s balance. Mat町ialized view technology is used for 由oseωmmon queries.Calculated in advance and save the result of time.consuming table joins or aggreg创ionω 由e ma creation of materialized views. Partition table can not r，叩lace materialized view when we are required to save 由e calculate resulte.η由 required the partition table and materialized view technology in combination. The following are summarized in 白is article: (1) Various forms ofthe partition table and their application，such 捕 range p盯tition，hash partition ，list partition，∞mbination partition an so on. (2)ηle difference between global index and local index. (3) The relevant theories， mechanisms and related 0阳刚ons of materialized views and materialized view logs. Finally，this paper give 由e application and 阳fonnance analysis of pa叫tion table and mat创alized view. Keywords: Partition Table; Partition Index; Mat町ialized View; Oracle 第一章引言 第一章引言 1. 1 逃跑背景和意义 随着全球经济进入信息分析时代，信息对企业的生存和发展发挥着越来越重要的作 用。企业不断扩张，企业管理信息也在不断完善，企业数据库往往需要管理几百 G 甚至 几 T 的数据量。随着数据库数据量的不断增大，数据库的性能会越来越差，数据库的访 问会越来越慢，性能低下不仅会危害应