|
Papers based on the analysis of the actual running of the hospital management information system HIS (Hospital Information System) , through in-depth analysis of the the system foreground and background applications , and combined with the actual operation of the system following optimization strategies : 1, reconfigurable data table increase the redundant column data table based on a database operation , and hospital characteristics query processing , increase the derived column , the vertical split table , horizontal split table , copy table handling , to avoid connection table and to reduce competition for resources , in order to improve system query speed ; 2 , increase the appropriate index , based on the actual hospital management system , created on a different data tables to query the index by shelf life by the amount of time in order to improve query response speed ; 3 in outpatient charges statistics , create the outpatient dispensing Affairs on the stored procedure ; 4 , application optimization application DataStore, network resources to reduce the competition , Dean query module triggers , stored procedures to improve the system query performance , to avoid deadlock place. Thesis from the server performance optimization , database optimization , T- SQL statement optimization , application optimization four aspects of the analysis and design of optimized , these theories and strategies used in the actual running of the HIS system , the completion of the HIS system database of background and foreground application optimization , commissioning , system running situation has reached the expected design requirements . In this paper, the various optimization strategies and methods summary and generalization of the system so that it has a broader applicability .
|