Solution of Massive Data Update Performance

Abstract

Nowadays, massive data continues to produce, which increases the scale of the database tables, a lot of performance problems come with the procedure of updating massive data tables. In this paper, to solve these problems, we propose new solutions based on Oracle RowID. In this way, we can update tables quickly. On the basis of studying the structure of Oracle data block and the RowID, we choose a flow dataset to test our solutions. The test results show that the new solutions can significantly shorten the execution time, and reduce the occupation of system resources.