组合分区表在广播监测数据存储中的应用

Application of Composite Partitioned Table in Broadcasting Monitoring Data Storage

本文将Oracle数据库的范围-列表组合分区表技术应用于广播监测数据的存储,从而改善了大数据的查询性能和维护管理,文章同时对分区表查询涉及的收缩表段、优化器和执行计划进行了基础性讨论。

In this paper, the composite range-list partitioned table of Oracle technology is applied in broadcasting monitoring data storage, which improves the query performance and maintenance management of big data. The paper discusses on segment shrink, optimizer and execution plan which are all involved in partitioned table query.