Menu
This is one of 4432 IT projects that we have successfully completed with our customers.How can we support you?
Data Warehouse for a laboratory information system
Project duration: 1 year
Brief description
Design and development of a data warehouse (DWH) for an Oracle-based laboratory information system (LIS). The DWH separates data preparation and reporting of the LIS and offers third party systems interfaces for their data.
Supplement
Important functions are the data preparation in independent structures concerning LIS, the performanant analysis of these data and the ability of incremental storage of changing data and their history.
Subject description
The system supports an incremental ETL process (extract – transfer – load) und historization of data. It is based on a classical star scheme, build in modules and prepared for coming extensions.
Overview
- Industries pharmaceutical industry
- Specialist tasks historization, laboratory systems, Reporting
- DV tasks Data Warehouse
- System environment Business Intelligence, Client/Server, technical data processing
- Procedure model customer standard
- Development/ test tools Oracle SQL*Plus, PL/SQL-Developer,
Project period04.01.2010 - 31.12.2010
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
