Medical Research Based on SQL Server Database
An EEG database system was built based on the SQL Server 2003, configured with an IIS (Internet Information Service) server in order to facilitate the network query. Take the clinical EEG data for example, the database not only stores patient information, but also structuralizes the EEG data and its annotation and standardized the form of the database tables. Its way of storing is much different from that of the commonly used text files and gives full play to the great advantage of a relational database and brings maximum convenience and flexibility for storage, retrieval and analysis of data and reduces errors. At the same time, related database software which integrates a variety of algorithms that can analyze data directly was developed to display EEG. This paper introduces the database design, software development and lists a number of database applications.
Despite the fact that since 1985 the government of Quebec increased by 5.75 % on average the amount of money spent on healthcare per year, little improvement was noted. It is obvious that an optimal use of resources is essential to reduce waiting times and provide safer and faster services to patients. The use of new technology can contribute to improve the healthcare system efficiency. Our study aims to assess the impact of a medication distribution technology on 1) the performance of a health and social services center’s pharmacy, 2) the performance of one care unit in a nursing home and on 3) the medication-use process safety. To measure performance we were inspired by the Lean approach. The results show that medication distribution technology is considered as an effective way to significantly detect medication errors, to allow nurses to focus more on patients and pharmacy to react more rapidly to changes in patient medications.