基于存储过程的分段数据存储方式设计

Design of subsection data storage mode based on stored procedure

随着社会对信息化重视程度的不断提高,存储在数据库中的数据规模正在不断的成倍增长,如何以一种有效的方式对数据进行存储,以便高效的对数据进行处理,分析就成为横亘在人们面前的一道难题。基于oracle11g数据库,设计了一种基于存储过程的分段式数据存储方式,有效解决了对于数据量随时间线性增长业务系统数据的存储问题,极大的提高了数据处理的效率。

Along with the importance of information society continued to improve, the data stored in a database of the scale are constantly redoubled. So how to in an effective way of data storage, so efficient data processing, analysising for the people become a big problem. Based on oraclellg database, this paper designs a segmented storage process based on the data stored procedure. This Method effectively resolves the data storage problem for the data quantity of linear growth business system, greatly improves the efficiency of data processing.