This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4842 IT projects that we have successfully completed with our customers.How can we support you?
Evaluation of patient data
Project duration: 1 month
Brief description
New evaluations of the patient data from an application database are created in MS Excel. The goal is to combine the attributes of the patients with specific laboratory data and thereby to detect any trends. The evaluations are configured on the basis of the patients' blood values, diagnoses, medications, or consanguinity. Also, the application database was migrated from MS SQL Server 6.5 to the 2000 version.
Supplement
The relevant views of the data are created using database views. There is further processing (e.g. manual plausibility check, creation of cross queries) in Microsoft Access. The Excel reports are generated from Access: An online connection with the original SQL Server database is not required. The application database is migrated by creating a backup under MS SQL Server 6.5, which is recovered in SQL Server 2000.
IT project data
- Industries health care
- Specialist tasks laboratory systems, Reporting
- DP tasks Migration
- System environments Client/Server
- Procedure model Waterfall Model
- Programming languages T-SQL (Microsoft)
- Databases MS Access, MS SQL Server
- Operating systems Windows NT
Project period19.04.2005 - 31.05.2005
Customers who trust us
