Partitioning of Oracle Application in Structured Electronic Medical Records

Chaundi Pan, Jiandong Hu, Jian Shi

Abstract


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.


Keywords


Oracle;partition tables;structured electronic medical records;VLDB

Full Text:

PDF


DOI: http://doi.org/10.11591/ijeecs.v12.i7.pp5693-5698

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Indonesian Journal of Electrical Engineering and Computer Science (IJEECS)
p-ISSN: 2502-4752, e-ISSN: 2502-4760
This journal is published by the Institute of Advanced Engineering and Science (IAES) in collaboration with Intelektual Pustaka Media Utama (IPMU).

shopify stats IJEECS visitor statistics