Partitioning of Oracle Application in Structured Electronic Medical Records

Chaundi Pan (Hospital of Wenzhou Medical University)
Jiandong Hu (Hospital of Wenzhou Medical University)
Jian Shi (Hospital of Wenzhou Medical University)

Indonesian Journal of Electrical Engineering and Computer Science
Vol 12, No 7: July 2014

This paper described how to use Oracle partitioning to achieve classified storage of data from structured electronic medical records. Because structured electronic medical records stored massive data, the performance, security and stability of database had been paid more and more attentions. In this paper, table with partition in structured electronic medical records system was presented to solve these problems. In addition, testing of comparing the performance of table with and without partition had been taken to prove it was much faster to retrieve partitioned tables with massive data than not partitioned tables.