RESUMO
Objective To upgrade No.1 Military Medical Project database from Oracle 8.17 to Oracle 11g so as to solve the problems of server overloading and client terminal failing to connect to the server due to excessive concurrent databases. Methods Exp/Imp and Toad tools of the database were used to generate and modify the upgrade statements as well as to import and export database data,so that the inter-platform and-version database upgrade could be carried out.Results The database was upgraded and the system's operation speed was enhanced greatly.Conclusion The upgrade scheme has easy operation,short time consumed,zero data loss and high reliability,and thus is worthy promoting in medium-and small-scale hospitals.
RESUMO
Objective To explore the migration of Windows operating system to Virtual Linux operation system to solve the problems faced by the main server of No.1 Military Medical Project HIS.Methods The migration was fulfilled with x86 hardware platform,open-source Linux operating system and virtualization technology to meet the performance and reliability requirements of No.1 Military Medical Project System.Results The migration was completed successfully to Virtual Linux system.Conclusion The migration scheme meets the requirements of HIS on performances,reliability,stability and safety,saves the cost for informatization,and is of great practical value.
RESUMO
Objective To solve the problems of hospital high-value consumables during purchase,warehouse-in and-out management,utilization,charging and etc.Methods High-value consumables management was improved based on No.1 Military Medical Project high-value consumables management system and bar code technology.Results Integrated management,whole-course supervision,safe utilization,convenient and accurate charging were realized for high-value consumables.Conclusion Bar code technology contributes to reducing high-value consumables inventory,decreasing hospital cash flow pressure,achieving high value consumables used safely and zero error valuation of financial accounting.It can become an effective management mode of hospital high-value consumables.
RESUMO
Objective To solve the problems of hospital high-value consumables during purchase,warehouse-in and-out management,utilization,charging and etc.Methods High-value consumables management was improved based on No.1 Military Medical Project high-value consumables management system and bar code technology.Results Integrated management,whole-course supervision,safe utilization,convenient and accurate charging were realized for high-value consumables.Conclusion Bar code technology contributes to reducing high-value consumables inventory,decreasing hospital cash flow pressure,achieving high value consumables used safely and zero error valuation of financial accounting.It can become an effective management mode of hospital high-value consumables.
RESUMO
Taking 201 Hospital of PLA as an example, the paper introduces the design of interface betweenNo.1 Military Medical Projectand the New Rural Coadjutant Medical Care ( NRCMC) system from the aspects of interface system constitution and technical design, etc.The system runs smoothly since application, promotes business dealings between hospital and NRCMC center, and it is worth promotion.
RESUMO
To realize rapid inquiry of the dispensing results in prescription dispensing subsystem. SQL statement tracer was used to determine corresponding SQL statement, and the executive plan was analyzed to find the desired table. Proper indexes were established to enhance the efficiency of the inquiry statement. The optimization of SQL statements made the executive efficiency increased greatly without the need for hardware upgrade. The analysis on the executive plan of the dispensing inquiry statements and the indexes on corresponding tables increases the prescription dispensing inquiry speed while decrease the waiting time of the staff.
RESUMO
Objective To upgrade No.1 Military Medical Project from single operation to Oracle RAC to eliminate single failure of the operation system, protect medical data and lay a foundation for the following upgrade and deployment.Methods RAC software and hardware environment was constructed for database upgrade and deployment of Data Guard.Results The database was gifted with high availability and high performances, and database maintenance and upgrade could be carried out with the operation system less ceased than before.Conclusion The database is upgraded from a single-mode rigid architecture to a multi-mode elastic one, with the performances, safety and extendibility enhanced greatly.
RESUMO
Objective: To solve the problem, that the high-cost consumables exists many management blind spots and shortcomings, under the traditional medical high-cost consumables purchase management mode. Methods:Combined with the characteristics of medical high-cost consumables, design a new high-cost consumables purchase management mode. Based on theArmy No.1high-cost consumables management system, using bar code technology, to realize the full closed tracking management of medical high-cost consumables. Results:Realized the unified control of the whole hospital medical high-cost consumables, timely and accurately mastered the material purchase, storage and usage, and to realize the object of the high-cost medical material management and safe usage. Conclusion:The scheme is feasible, and solve many problems, those are high-cost consumables management denominated in error, cost volatility and unseasonal financial processes and so on. It can become the effective means of hospital high-cost consumables management.
RESUMO
Objective:To discuss how to link the “No. 1 Military Medical Project”hospital network system with the local health insurance system.Methods: To analysis the interface demands of the social health insurance system and the rural cooperative health insurance system. Results: To solve the problem by modify the medical insurance interface program of the out-patient registration and charge, the in-patient registration and charge.Conclusion: the function and requirement has been realized by linking.
RESUMO
The Logminer utility has been provided by the latest Oracle 8i version.It can analyze archived log files and online log files.This paper introduces how to install and use this utility,especially how to make the use of the auditing function on key users and key data tables,as well as recover the hostility operation without the shutdown of database.
RESUMO
This paper introduces the safe realization of ″No.1 Military″ database upgrade from ORACLE7.33 to ORACLE8I by import/export tools based on standby server.The establishment of standby server and the process of No.1 Military database upgrade are introduced detailedly in this paper.The database upgrade of other application system adopting ORACLE database system can refer to this paper.
RESUMO
With the wide spread of social health insurance system,Xinqiao hospital,a health insurance unit,interfaces HIS with health insurance system.With the application to Xinqiao Hospital and key features of health insurance system presented,this paper introduces the method for interfacing HIS of ″No.1 Military″ Project with health insurance system,thus can be referenced by other hospitals.
RESUMO
Objective To explore the cause of repeated offline of files in the database of No.1 Military Project and find the method to solve the problem. Methods The abnormal offline of files in database is not by chance,and its document in oracle is not very clear. Using the knowledge from internet,the fault was repeatedly simulated on test machine and the source of the fault was found. Results Solving plans and countermeasures were put forward. Conclusion The database of the No.1 Military Medical Project is the core of military hospital work,so its importance is self-evident. The technical support of No. 1 Military Project is strengthened,the right maintenance direction of the database is pointed out as well as the right solution to deal with the problem.
RESUMO
Objective To explore the solution to the secure problem of EMR based upon No.1 Military Medical Project.Methods The existing EMR system provides medical records service and the EMR are stored and managed in ordinary or established file format in the database server.Based upon above database characters related to EMR and the requirement of EMR security,the MRBACKUP system was developed to resolve EMR backup,recovery and dump.Results The MRBACKUP system safeguarded the security of EMR in the lowest cost,the least system resources and the highest efficiency.Conclusion The new secure solution to EMR can better resolve the security problems in the widely-used EMR in hospitals.
RESUMO
This paper develops the field medical information management system,which realizes the informationiztion and team service management for field medical team.system to field medical team. It also provides interface program with No.1 Military Medical Project,which realizes the linking of medical treatment information about patient in field medical team and rear military hospital.
RESUMO
This paper develops an integration information inquiry and statistics system for Civil Patients with Medical Insurance on the basis of PowerBuilder 9.0.It helps departments of medicare auditing and medicare settlement obtain integration information of patients.
RESUMO
The computerization of medical consumable warehouse-in&out has become a general trend of modern medical consumable management.The medical consumable management software in No.1 Military HIS is modified and improved so as to be integrated with practice for better management of medical consumable.
RESUMO
With the increment of the workload,high stability is required by hospital information system.When the amount of client exceeds the limit,we must reconstruct the Oracle server in order to meet the needs of workload increment.This article describes the principle of shared server and the reconstructed method from dedicated server to multithreaded server.
RESUMO
Objective To realize data structure manual online search of "No.1 Military Medical Project".Methods Access database and ASP technology were adopted.Results Data structure manual online search was realized successfully.Conclusion The system enhances the efficiency of HIS engineers.
RESUMO
Objective Due to redundant valuations and inaccurate quantities and specifications in processing temporary medical orders, expensive medicines, water and cream medications, program patches of electronic prescriptions included in the nurse work station were designed and developed. Methods Based on the software and hardware platforms of No.1 Military Medical Project, it was developed under Powerbuilder 9.0 without more tables and database expenses. Result Paperless prescription was realized. Conclusion The clinician's workload is reduced. Inaccurate patient expenses and drugs data are stopped.