LIMS WAREHOUSING Archiving and Migrating of LIMS Data

  • Slides: 10
Download presentation
LIMS WAREHOUSING Archiving and Migrating of LIMS Data Examples: • Annual Product Review and

LIMS WAREHOUSING Archiving and Migrating of LIMS Data Examples: • Annual Product Review and Trending with Beckmann LIMS data • Query for historical specifications

Current Situation LIMS systems n Productive LIMS Systems are storing data in their own

Current Situation LIMS systems n Productive LIMS Systems are storing data in their own data strcuture since 10 + years n Some systems are archiving submission / sample / test data internal n A lot of systems are a on the end of their Life Cycle (no longer supported by the vendor) n l Beckmann Labmanager l Collier / Quasi-P l HP LIMS l QDIS/QM l SQL*LIMS Archiving and Trending of data of 10 years+ is a regualtory requirement (MUST)

Our Solution - LIMS Warehouse n Good News: Most of the data are in

Our Solution - LIMS Warehouse n Good News: Most of the data are in a common format (Oracle, CSV Export, etc. ) n Legacy LIMS Data can be archived in a RDBM database n Potential technology solutions on the market l SAP BI/BO l Oracle Warehouse l SQL Server Parallel Data Warehouse l Native LIMS Databases (Oracle , SQL*Server) l Reporting Software (e. G. SAP Crystal reports, Oracle reports, Impromptu, etc. )

Archive and reporting of Beckmann Labmanager Architecture Beckmann LIMS Oracle 7 database Migration User

Archive and reporting of Beckmann Labmanager Architecture Beckmann LIMS Oracle 7 database Migration User Oracle 11 database Specification_Tests View Specification Head View Crystal Reports

Example: Beckmann LIMS Annual Product Review - Trend analysis User selects: 1. Product number

Example: Beckmann LIMS Annual Product Review - Trend analysis User selects: 1. Product number 2. Time frame From - To

Example: Beckmann LIMS Annual Product Review - Trend report Methods / Values Samples /

Example: Beckmann LIMS Annual Product Review - Trend report Methods / Values Samples / Batches

Example: Beckmann LIMS Annual Product Review - Statistics

Example: Beckmann LIMS Annual Product Review - Statistics

Example: Beckmann LIMS Annual Product Review - Control charts

Example: Beckmann LIMS Annual Product Review - Control charts

Example: Beckmann LIMS Specifications - Historical versions User selects: 1. Product type 2. Product

Example: Beckmann LIMS Specifications - Historical versions User selects: 1. Product type 2. Product number 3. Vendor 4. Type of Analysis 5. Status 6. Version number

Example: Beckmann LIMS Specifications - Historical versions

Example: Beckmann LIMS Specifications - Historical versions