ABSTRACT
Based on ASP.NET framework, The Intelligent Estimated System for Rational Deployment of Medical Equipment (MERDIS) is designed and developed with SQL Server 2012 database and C# language. The system is used to realize the rational deployment suggestions and evaluation of medical equipment in hospitals. The system input the data of hospital medical equipment and clinical pathway into the database, and then feedback the deployment information to users which are calculated by big data information, so as to achieve the purpose of giving rational deployment of hospital medical equipment.
Subject(s)
Databases, Factual , Equipment Design , HospitalsABSTRACT
The paper preprocesses the data including basic information,admission and discharge record and progress note of diabetes Electronic Medical Records (EMR),implementing decision tree,Artificial Neural Network (ANN),Naive bayesian and K-Nearest Neighbor (KNN) classifications respectively on data that have been processed with Weka 3.9.The result shows that Naive bayesian classification,which is superior to the others in predicting and classifying such data,can provide basis for the classification and prediction of diabetes.
ABSTRACT
Objective To improve the analysis efficiency and interactive experience of the Military Electronic Health Records System(MEHRS)and to realize quick response of ad-hoc queries and statistics in the MEHRS with big data columnar storage and processing technologies.Methods We carried out requirement analysis and functional design of the ad-hoc queries and statistics subsystem of the MEHRS,proposed a three-tier architecture which included the archive storage layer,statistical pretreatment layer and statistical application layer.After the selection and evaluation of big data processing technologies,CarbonData columnar storage was used to store preprocessed data and executed statistics with Spark SQL on the basis of medical business data modeling and preprocessing.Results Five testing tasks were executed on two million archives in the following two subsystems:one with modeless and non-preprocessed MongoDB storage,the other with modeled and preprocessed CarbonData storage.The latter could finish these tasks within seconds and was dozens of times more efficient than the former statistically.Conclusion This study designs and implements a big data technology proposal that satisfies the quick response of ad-hoc queries and statistics in the MEHRS, providing powerful and flexible technical support for big data statistical analysis.
ABSTRACT
The paper designs and implements a digitalized information resources platform for Mongolian medicine based on ASP.NET.The system adopts VS2008 + SQL SERVER2005 and the 3-tier architectural pattern,integrates functional modules such as News Information,Mongolian Medicine,Mongolian Doctors and Q&A,realizes the digitalization of Mongolian medicine resources and establishes a sharing system.Upon testing,the system operates well and achieves the expectations.
ABSTRACT
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.
ABSTRACT
Los numerosos estudios de personas con discapacidad llevados a cabo en el marco del ALBA han demostrado la necesidad de conformar un procedimiento o recurso que permita la obtención rápida de reportes y consultas. Esto ocurre porque no es posible prever, desde la etapa de diseño del sistema de recogida de datos, toda la información que será requerida o utilizada en función social. Los reportes, así como el propio sistema, también varían de un estudio a otro al desarrollarse en diferentes países con diferentes grados de profundidad. Se propone entonces la sistematización de una metodología que fue utilizada con éxito durante la Misión Dr. José Gregorio Hernández en la República Bolivariana de Venezuela. Esta alternativa permite el desarrollo rápido de consultas y reportes en bases de datos típicas para estos estudios. Tiene la ventaja adicional del bajo acoplamiento con el sistema de recogida de datos, lo que posibilita su extensión o modificación sin riesgo de alterar el flujo de trabajo en dicho sistema(AU)
The numerous studies about people with disabilities conducted in the framework of ALBA, have demonstrated the need to obtain a method or resource that allows rapid retrieval of reports and queries. This occurs because it is not possible to anticipate, from the design stage of the data collection system, all the information that will be required or used. These reports, and the system itself, also vary from one study to another since they are carried out with different depth in different countries. Then, here is the proposal of systematization for the methodology that was used successfully on the Mission Dr. José Gregorio Hernández in Bolivarian Republic of Venezuela. This approach allows the fast development of queries and reports typical of such studies databases. It has de additional advantage of very low coupling with the data collect system which makes it expandable and modifiable without risk to alter normal work flow(AU)
Subject(s)
Humans , Male , Female , Disabled Persons , Statistical Databases , Information Technology , Clinical Studies as TopicABSTRACT
This paper utilizes ASP technique and SQL database to design and construct the website of dental laboratory center in stomatology hospital. With basic content,the website consists of foreground display and back management,which shows good interaction and maintainability. The construction of the website is beneficial to the development of dental laboratory center.
ABSTRACT
Objective To calculate workload according to working day and holiday separately.Methods Functions of SQL in Oracle were used to separate working day and holiday.Results The method could accomplish holiday's workload statistics expediently.Conclusions Statistics of holiday's workload are becoming ordinary work,so the separated analysis for them has practical value.
ABSTRACT
Objective To introduce database information query and its printing technology with the Sql Sever 2000 software based on the VC++6.0 software. Methods The data query from the sql Sever 2000 database made use of ADO technology of VC++6.0 and implemented the print and print preview via append document and view frame in the procedure of the dialog box. Results The data query from Sql Sever 2000 database was implemented and the queried data was printed. Conclusion It offers one printing method in the dialog box procedure.
ABSTRACT
Objective To design a mobile device for patient information query.Methods Linux was used as operating system,and embedded SQL was used to access the database.Data transmission was realized by socket programming.Results The correctness of data access and transmission was proved by test,and the validity of the system was also confirmed.Conclusion Embedded system technology meets the need of mobile medical care.
ABSTRACT
When a section is divided into two or more sections in hospital,patients must be assigned to the new section along with all medical data.With SQL commands,data is transferred according to the patient's section division.This method is also fit for the case that the section is divided while the nursing unit is not.
ABSTRACT
To fulfill the performance optimization for database of HIS, the shortest query response time and the highest throughput of database server are realized through the minimization of the network flow, disc I/O and CPU time. The performance optimization should exist throughout the development of HIS, so the requirements of HIS applications, the logical construction and physical structure of data, the balance of conflicting databases should be involved in.