Oracle表分区技术在税务纳税申报系统的应用研究

为了调整税务地方业务应用种类繁多、海量历史数据的读写性能,论文讨论了Oracle分区技术原理,并应用表分区、分区索引等相关技术对原有税务地方业务平台实现了数据重组,对重组后的系统进行了压力测试性能和投入正常运行的验证,结果表明采用有效的分区策略管理,能显著提高海量数据的读写性能和可维护性。

Table Division Technology Application in Business Tax Declaration

For tax affairs place service application type many, historical data quantity read-write performance question; The paper uses oracle to the large-scale data sheet district and the district index realization, and to the district table technology, the district management as well as the application example has carried on the introduction. The practice had proven the district table technical application can obviously enhance the magnanimous data the read-write performance and the maintainability.