Design And Optimization Of Medicine Monitor System Based On Oracle Database

This thesis studies the design of the medicine monitor system based on ORACLE database,and put out the optimizing schemes for its performance. The medicine is one of the mostindispensable articles in our life, and it is much meaningful for the utilization of a medicinemonitor system to guarantee the safety and health of the public. Such a system contains a largeamount of data and a lot of complicated relationships between operations. When using atraditional way, the system has to call for lots of linkage when the users are searching forinformation. The procedures thus results in spending superfluous time, over-consuming theresources, and slowing down the respond time to the users. Therefore, its performance should beoptimized further in order to achieve the better user experience.Combining the actual situation of the medicine monitor system with the common methodsused in the optimization in ORACLE database, this thesis proposes the optimizing schemes forits performance. First of all, in the phase of database designing, an innovatively hierarchicalsystem is adopted, absorbing the ideas of anti-paradigm and surrogate primary key. Secondly, inthe phase of application level, INDEX partition, partition optimizing and SQL optimizingfacilitated to adjust the performance of the system.This paper focuses on the hierarchical organization of database. In the first layer thefundamental database is designed strictly in accordance with the paradigm requirements in orderto ensure the consistency of underlying data and to secure the convenience of operations, such asinsertion and deletion. In the second layer, the fact database applies the designing ideas ofanti-paradigm, using the NUMBER type as a surrogate primary key. Meanwhile, the searchingspeed is improved by the index partitioning technique which has overcome the weakness of thetraditional design of database.At the end of the paper, some assessment experiments are performed for the efficiency ofdifferent optimizing schemes. The results of assessments show that the optimizing schemeproposed in this thesis can effectively reduce the respond time, and particularly be suitable toimprove the efficiency of SQL sentences that used to respond slowly. Among the scheme, the hierarchical design of database contributes the most obviously to the quick speed of respond timeto users.